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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error Message "Ph...
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by Maroof Ibrahim 91

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)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,691 Super User 2026 Season 1 on at

    Hi Maroof,

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

  • Maroof Ibrahim Profile Picture
    Maroof Ibrahim 91 on at

    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,

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,691 Super User 2026 Season 1 on at

    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.

  • Suggested answer
    AhmedHafez Profile Picture
    AhmedHafez Microsoft Employee on at

    Hi Muhammad,

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

  • Maroof Ibrahim Profile Picture
    Maroof Ibrahim 91 on at

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

    Thanks :)

  • Verified answer
    Prashant Singh Profile Picture
    Prashant Singh 8,802 on at

    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

  • AX2012 hassan Profile Picture
    AX2012 hassan 20 on at

    I have the same problem kindly advise

  • Maroof Ibrahim Profile Picture
    Maroof Ibrahim 91 on at

    Please explain what you have facing in this issue?

    Thanks,

  • Suggested answer
    Maroof Ibrahim Profile Picture
    Maroof Ibrahim 91 on at

    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.

  • Suggested answer
    Maroof Ibrahim Profile Picture
    Maroof Ibrahim 91 on at

    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

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans