Skip to Content
Former Member
Jan 28, 2011 at 02:47 PM

Exel XML Export Totals Adding Five Zeros



When we are exporting FBL5N to Excel using the Excel XML format the totals are exporting to Excel with an additional five zeros added to the total lines. The line items are exporting correctly it is only effecting the total lines. Please see the below example. I have tried changing my decimal Notation to US domestic standards (1,234,567.89) and this did not change anything. Is anyone else experiencing this and has anyone found a fix for this? Our business users need this report for audit work.

8,130,894.71 exports as 81308947100000