Notifications
Announcements
No record found.
I create new item in product masters but i don't See my Item in InventSum Table.
Any suggestion what i do now because i need BOMUnitId field from inventSum Table
I don't think you'll see an item in InventSum if you never used the item. For example, receive some items to a warehouse. Also, make sure you've released the product to a company before trying to use it.
In addition to what Martin said, InventSum doesn't have field "BOMUnitId". It is present in InventTable though.
If you can't see a record in InventTable, you need to release the product to the company where you are looking to use it.
Sorry my mistake i need "AvailPhysical" field from InventSum table and i already release the product
Gunjan Bhattachayya
Actually i am looking for a "AvailPhysical" Field from InventSum Table. And i create New Item and also release the product But i can't see the product that i created in InventSum Table
If the item doesn't exist in InventSum at all, then there surely isn't any quantity physically available.
Hi Hanzu,
Try creating a purchase order with this item in the purchase order lines. Confirm the purchase order and do a product receipt. This should create a record in InventSum for you to test with.
Martin what i do to get AvailPhysical of my item
Nothing. You already know that the item doesn't even exist in InventSum (because it's never been used), therefore its available quantity is zero.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 420 Most Valuable Professional
BillurSamdancioglu 241 Most Valuable Professional
