Export to CSV vs Export to Excel, the CSV currency Amount fields are rounded.

debbisue-kimbler

In GLTransactionDetail and GeneralLedgerTransaction we have added personalization to add two currency fields as we have entities in different currencies.  Fields added are

ReportCurrencyAmount.ReportAmount1.EnteredCurrencyAmount

ReportCurrencyAmount.FunctionalAmount.EnteredCurrencyAmount

When we query data the form in Infor (Finance Transaction and Finance Transaction Detail) displays the amount values with the decimal places.  We export to CSV format the values in the two currency amount fields are rounded.  We export to Excel format the values in the two currency amount fields are NOT rounded and we see the whole value.

Have any other clients noticed this?  I have reported this to support, and they advise they cannot duplicate however we can duplicate at will.  Our Currencies are all set up as 2 decimal places.   We have hundreds of accountants, and some prefer CSV and others EXCEL format.  I would expect the results to be the same regardless of the format we specify.

Example

Display of records on GeneralLedgerTransaction

 

Export of the records to Excel format for GeneralLedgerTransaction

 

Export of the records to CSV format for GeneralLedgerTransaction

 

ryan-schumacher

What version of Excel are you using, and if you open the CSV file in Notepad instead of Excel, do you see the same results? Additionally, if you click on one of the rounded values in the Excel CSV, does the formula bar display a different value? I'm curious if this is related more to Excel data types and formatting than truly different values being exported from FSM.