Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Financial updating quantity must have same sign in the posting unit and the inventory unit.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I keep running into this error for one of my part numbers and have no idea where or whats going wrong for this to occur. Any ideas as to where I can look to narrow this error down?

This error only appears when trying to "End" a Production order. "Please see the attached screenshot"

Thanks in advance!

5751.Untitled.jpg

 

*This post is locked for comments

  • Richard Wehmeyer Profile Picture
    Richard Wehmeyer 1,002 on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    We had this same issue and found that one of the BOM item transactions was set to 'Sold' while all others were 'Deducted'

    We reset the production order to Created status and reprocessed.

    All BOM transactions were reversed except for the closed transaction and when we re-processed that item was consumed again.

  • mehmetyunus27 Profile Picture
    mehmetyunus27 57 on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    The root cause is "Rounding (Decimal) Accuracy" on Stock Unit. If decimal is zero, system rounds numbers  below zero to zero. Increase the value of "Decimal" on Units form.

    4721.2017_2D00_11_2D00_30_5F00_12_2D00_18_2D00_19.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    Thank you for your advice.

    In my case, when I do on Test, I already change the Active cost of FG to equal to Calculated cost in Production order, then I can did End this PO.

    But when I did the same steps in Live, I still got above error message. Then, I checked and found that the WH man already released this quantity of Production to Sales order (we are using WMS). Technical is helping me to debug this

    I create another Production order for this FG and Ended without error, the Cost calculation is lower than Cost of above error PO

  • Suggested answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    nglehang

    If you use allow physical the cost will not be adjusted as part of the inventory close UNTIL your stock is positive, so you need to bring the stock above zero, run the close and then end production.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    Hi All,

    After some serious testing on many different levels and looking into all the possibilities that the AX Community has laid out for me I was able to fix this error when it popped up on us again today when trying to END a production job!

    This issue seems to be very sporadic in nature because sometimes the error is thrown and sometimes it isn't even when repeating the same behavior with other production jobs.

    Now to explain how we are creating the issue and how to go about fixing it if your working in this same manner.

    1. Job is created for a specific quantity and that quantity gets changed for the production order.
    2. We will edit the BOM (Bill of Materials) to match the change in the overall production quantity so costing is correct.

    However; ***Making these changes to the BOM at this point in the work flow causes this error for us***

    To fix this error it helps to know what changes you have made to BOM and set them back to the original status and estimate the job again. ( I believe this error is caused because active cost being generated for the product/item is lower than the total cost of the raw material ) Correct me if I'm wrong!!

    After doing this the job ENDS without issue.

    Hope this helps some of you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    Hello, I got same error when trying to end Production order.

    We are using "standard cost" and allow physical negative inventory.

    Have you found the solution for this issue? Please share with me

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,820 Super User 2024 Season 2 on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    Hi Dagiele,

    Without details and being able to investigate in your transactions it is impossible to tell you what is wrong and what needs to be done. I would suggest to find a very experienced consultant who knows how to troubleshoot inventory costing issues at your location.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    Yes.

    Financial stocks of finished product and raw material are positive.

    This makes it difficult to find the root cause of the error.

  • Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    But you still get this issue?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial updating quantity must have same sign in the posting unit and the inventory unit.

    Hello,

    We don't work with negative stock

    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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,820 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans