You’re offline. This is a read only version of the page.
20
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.
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.
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
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.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (