Dynamics 365 F&O/AX
Dynamics FO / AX
Organizer:
- Organized by
-
-
Sales order line on D365 total differently than Excel Export
-
Sales order line on D365 total differently than Excel Export
We have found in several sales orders that the total Net line amount is diffent on D365 under Sales totals and column totaling than it is when we export to Excel. Has anyone encountered this issue. We have reviewed source data and there are only 2 decimal positions and qty are whole numbers.
-
3 Replies
-
Maggie,
Is the price unit on the lines something other than 1?
I have not experienced this before, but this is something that might affect the rounding.
-
Sami,
It is 1 for the price unit. We did an end to end review of data and and no $$ has more than two decimal positions and all units have no decimal positions.
-
That is very strange behaviour. I tried to add 30 lines to an order in a MS demo environment and I am not able to replicate. Do you have a customization in place related to the sales lines in the system?
-
-
