web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Which table contains the inventory item accounts info?

(0) ShareShare
ReportReport
Posted on by

Hello,

Which table contains the inventory item accounts info such as inventory offset, sles, COGS, etc...?  Also, what is the field name for the accounts?

Thanks

*This post is locked for comments

I have the same question (0)
  • Peter Muchira Profile Picture
    1,912 on at

    Hi,

    Ideally the item accounts will be in IV00101.  For the account descriptions, kindly refer to Victoria Yudin's blog : victoriayudin.com/.../inventory-tables .

  • Suggested answer
    Lyn Barr Profile Picture
    1 on at

    Peter is correct, the item posting accounts are in the IV00101. However, this table only holds the account indexes for these. You'll need to join either the GL00105 or the GL00100  to get the actual account numbers.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans