Error Message "Physical updating quantity in the inventory unit Kg must be other than zero"

(0) Share

Report

Posted on by Maroof Ibrahim

I have receive this error "Physical updating quantity in the inventory unit Kg must be other than zero" at the time of Picking List Posting. and have also UOM and decimal oriented Item in my Ax. Kindly help to resolve this error. I shall be very thankful to your kind assistance.

Regards,

Maroof Ibrahim

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (1)

Report

Hi Maroof,

Is the quantity on the line zero? If so, enter the correct quantity or remove the line from the journal before posting.

Was this reply helpful? Yes No
Maroof Ibrahim 91 on at

Like (0)

Report

No, The Quantity on the line is not zero, But in Decimal.

Actually, The case is that i am posting Picking List in Grams, but my Item's Inventory is manage in Kg, with define Unit conversion on Items.

Thanks,

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

Like (1)

Report

Hi Maroof,

I would never suggest someone to define an inventory unit in KG where the consumption is in Grams. Possibly you have e.g. 4 grams. Rounded to the inventory unit it is zero. Indeed, you cannot post this. When having the inventory unit in grams, you can still view it on on-hand forms in KG.

Was this reply helpful? Yes No
Suggested answer

AhmedHafez on at

Like (1)

Report

Hi Muhammad,

try increase the decimal precision of the KG unit , because the default is 2 decimal.

Was this reply helpful? Yes No
Maroof Ibrahim 91 on at

Like (0)

Report

Yes! I tried this first. but not true action performed.

Thanks :)

Was this reply helpful? Yes No
Verified answer

Prashant Singh 8,802 on at

Like (0)

Report

Dear Muhammad Maroof Ibrahim,

You can try below steps.

1. Can you please check your UOM conversion. Make sure you have a valid UOM conversion in case you have PO UOM and inventory UOM different.

2. Make item registration before receiving.

Last option is to delete line and recreate and try step no. 2 before receiving.

Regards,

Prashant Kumar

Was this reply helpful? Yes No
AX2012 hassan 20 on at

Like (0)

Report

I have the same problem kindly advise

Was this reply helpful? Yes No
Maroof Ibrahim 91 on at

Like (0)

Report

Please explain what you have facing in this issue?

Thanks,

Was this reply helpful? Yes No
Suggested answer

Maroof Ibrahim 91 on at

Like (1)

Report

I can changed UOM on inventory Unit after applied the following queries by remove inventory trans to resolve the issues.

DELETE from INVENTTRANSORIGIN WHERE REFERENCEID = 'JRN-000001' AND ITEMID = '134340600**'

DELETE from INVENTTRANS WHERE INVENTTRANSORIGIN = 56371584**

select * from INVENTITEMPRICEACTIVE WHERE ITEMID = '134340600**'

DELETE INVENTITEMPRICE WHERE ITEMID = '134340600**'

DELETE from INVENTTRANSORIGIN WHERE REFERENCEID = 'JRN-003027' AND ITEMID = '134340600**'

"DELETE FROM INVENTTRANS WHERE INVENTTRANSORIGIN IN ('5637241017','5637241018')"

after this, we can able to change UOM but we have no any invent trans, also This solution is recommended when we have just initial transactions stage for the Item's.

Was this reply helpful? Yes No
Suggested answer

Maroof Ibrahim 91 on at

Like (1)

Report

Resolved!

This has occurred due to wrongly define UOM on Item and containing long decimal value. hence, Inventory On Hand consider on 2 decimal "0.00" figures,

This issue has been resolved by correction of UOM on Item level as we can consider both practices are as follow;

01 Resolution: Create another Same Item and configure right UOM and Process for updating inventory Opening and closed previous one with reference (Best to do)

02 Resolution:

I can changed UOM on inventory Unit after applied the following queries on Database sql by remove inventory trans to resolve the issues, because we cannot perform change UOM on inventory level due Transactions availability. we can perform some queries to remove inventory transaction if we have just initials trans:

DELETE from INVENTTRANSORIGIN WHERE REFERENCEID = 'JRN-000001' AND ITEMID = '134340600**'

DELETE from INVENTTRANS WHERE INVENTTRANSORIGIN = 56371584**

select * from INVENTITEMPRICEACTIVE WHERE ITEMID = '134340600**'

DELETE INVENTITEMPRICE WHERE ITEMID = '134340600**'

DELETE from INVENTTRANSORIGIN WHERE REFERENCEID = 'JRN-003027' AND ITEMID = '134340600**'

"DELETE FROM INVENTTRANS WHERE INVENTTRANSORIGIN IN ('5637241017','5637241018')"

After this, we can able to change UOM but we have no any invent trans, also This solution is recommended when we have just initial transactions stage for the Item's.

Thanks

Was this reply helpful? Yes No