Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

qtyinuse in IV00102 table purpose

(0) ShareShare
ReportReport
Posted on by 323

Hi all, 

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

Thanks.

Categories:
  • 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans