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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (21)

Answers (0)

Community Member on at

Like (0)

Report

can you check your inventory unit and its sign, it seems posting unit is not in correct sign as expected in DAX.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

Hi Hans,

Can you verify which BOM items are used and if they probably have a negative inventory value? You can look at the on-hand form to see the current values.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André,

There is only one item on the BOM and the only negative transaction in the on-hand screen is the Physical Cost Amount.

Was this reply helpful? Yes No
Fredrik Sætre 12,644 on at

Like (0)

Report

When did you last Close your inventory?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Inventory is closed at the end of every month!

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (1)

Report

Hi Hans,

I'm quite sure the negative physical value is causing your problem. I don't know which transactions are related to this situation. Can you check the transaction and see if there is something weird? Probably in a test environment you can play around by adding new on-hand to increase the current physical value. Then see if yu are able to post.

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

The negative value in physical should be adjusted when closing, so something isn't right.

Suggest you do as André said. Get your physical value above 0.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello. I'm having the same problem, even with my items being positive financial cost.

How I solved this error?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Unfortunately we had some consultants look at this issue for us and I'm sure they did the dirty database fixes that they are all famous for when they cant figure out the root cause.

Sorry but I have no more information to share on this subject or I would have shared the info.

However if we ever run into this again and figure out the root cause I will come back and share the root cause with the AX community! Good luck all and thanks again for the suggestions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I understand.

Thank you!

Was this reply helpful? Yes No