Discussions – Dynamics F/SCM – Dynamics Communities

Sales order line on D365 total differently than Excel Export

Dynamics F/SCM

Sales order line on D365 total differently than Excel Export

Posted by Maggie Dominguez on May 10, 2023 at 10:36 am
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.
Sales-order-lines-differences.docx 238 KB Word Document - Click to view

Options

Copy Download Link
Sami Mattson replied 2 years, 7 months ago 2 Members · 3 Replies
3 Replies

Sami Mattson

Member
May 10, 2023 at 6:32 pm

Up
0
Down
::
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.
- Maggie Dominguez
  
  Member
  May 11, 2023 at 6:44 pm
  Up
  0
  Down
  ::
  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.
  Sales-order-lines-differences-v1.docx 717 KB Word Document - Click to view
  
  Options
  
  Copy Download Link
  - Sami Mattson
    
    Member
    May 12, 2023 at 11:55 am
    
    Up
    0
    Down
    ::
    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?

The discussion ‘Sales order line on D365 total differently than Excel Export’ is closed to new replies.