Announcements
No record found.
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
Hi,
Ideally the item accounts will be in IV00101. For the account descriptions, kindly refer to Victoria Yudin's blog : victoriayudin.com/.../inventory-tables .
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.