web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Sales order Total Picked Quantity does not match Sales order Total Quantity UOM Conversion Issue

(0) ShareShare
ReportReport
Posted on by 1,632

I found a similar question in the forum but it was unanswered: https://community.dynamics.com/ax/f/33/p/190719/920991#920991

Summary of the issue:

The sum of Qty at the batch level does not match the Qty at the sales order level.  In other words, due to rounding, I get one total when rounding each batch qty and summing together vs. at the sales order level (Packing slip total/Invoice total) which rounds at the total. 

This makes the packing slip and invoice not only look odd but we end up Invoicing the customer for more than what we shipped almost every time.  This does not make happy cutomers.

Has anyone else experienced this?  Is there a Hotfix (my cursory look at LCS did not turn up any results)? 

*This post is locked for comments

I have the same question (0)
  • Sagar Suman Profile Picture
    6,752 Super User 2026 Season 1 on at

    Hi Ansel Slagle,

    Can you provide an example with numerics and sequence of events.

    It will help us understand  your business scenario better.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Ansel,

    Can this be related to a rounding issue as mentioned in the related thread?

    Have you tested this with a different item that has a different UOM?

    I already checked LCS but have not found a fix that would deal with this issue.

    For that reason, I expect that you have to check and possibly change the UOM / quantities for your items.

    Best regards,

    Ludwig

  • FAC.Ansel Profile Picture
    1,632 on at

    Sagar, See the link in my original question.  This provides an example of the same situation that I'm facing and has Number values as an example.

    Ludwig,  This is EXACTLY the same issue as in the link that I provided.  We have inventory stocked in Feet but sold in Impressions (similar to Each).  Feet UOM precision is set to 2 and Impression UOM precision is set to 0.  Unfortunately I can't change this, so it sounds like this will have to be a customization for the AX Sales order Packing slip and Invoice to use the Inventory transaction level Quantity instead of a summed up value.  Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans