Announcements
Hi all,
Can someone explain the use of qtyinuse and bgngqty in IV00102 table ?
Thanks.
Hi,
The IV00102 is the Quantity/Sites table. The QTYINUSE field is a field that represents quantities that have been either transferred into the "in Use" bucket or when returned in Sales Order processing into "in Use" instead of "on Hand".
The BGNGQTY is the beginning quantity field and the Inventory year end closing updates the amount in the item's Beginning Quantity field to the Quantity on Hand field at each site.
Let me know if you have questions.
Thank you for using Microsoft Dynamics Communities,
Angela Ebensteiner
SR Technical Advisor
Microsoft Dynamics GP
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156