Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Essentials Series

Rule of Thumb Series (Quick Notes and Fixes)
Analytical Accounting Essentials Series 
HITB Essentials Series (Historical Inventory Trial Balance)

 Macro Generator Essentials Series

Data Cleansing Essentials Series

Best Regards, 
Mahmoud M. AlSaadi

1 comment:

  1. Hi All,

    GP2016-620(R2) I am having similar issues in Samrtlist designer where most of the columns are changed into the different type of data after exporting to Excel where in smartlist it is ok, once exported to excel all the data is shared and codify in a strange manner below are few examples:
    =DATE(2018,1,1),(suppose to be doc date )
    #NAME? (suppose to be Account Description)
    #NAME? (suppose to be TaxDetail Id)
    0.00000 (suppose to be A Negative number) (-9000.00)

    to mention there is no special character used anywhere in data

    apart from this smart list is not sorting the data column by clicking on a column heading a usual practice, any idea what is going on