Featured Post

Microsoft Dynamics GP 2018 R2 has been released

As promised, It has been recently announced that Microsoft Dynamics GP 2018 R2 is released with lots of new features. The GP team at Mic...

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