Hi all,
Can someone explain the use of qtyinuse and bgngqty in IV00102 table ?
Thanks.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,556 Super User 2024 Season 2
Martin Dráb 228,625 Most Valuable Professional
nmaenpaa 101,148