Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

qtyinuse in IV00102 table purpose

Posted on by 323

Hi all, 

Can someone explain the use of qtyinuse and bgngqty in IV00102 table ?

Thanks.

  • Verified answer
    RE: qtyinuse in IV00102 table purpose

    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

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.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans