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
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.
Martin what i do to get AvailPhysical of my item
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.
If the item doesn't exist in InventSum at all, then there surely isn't any quantity physically available.
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
Sorry my mistake i need "AvailPhysical" field from InventSum table and i already release the product
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.
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.
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 Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,370
André Arnaud de Cal... 848 Super User 2025 Season 2
Sohaib Cheema 675 User Group Leader
