2
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
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
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.
Please explain what you have facing in this issue?
Thanks,
I have the same problem kindly advise
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
Yes! I tried this first. but not true action performed.
Thanks :)
Hi Muhammad,
try increase the decimal precision of the KG unit , because the default is 2 decimal.
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.
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,
Hi Maroof,
Is the quantity on the line zero? If so, enter the correct quantity or remove the line from the journal before posting.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (