Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Inventory Record Data in GP

(0) ShareShare
ReportReport
Posted on by

How much data is used by the inventory records in GP?

Trying to understand how much data skus take up and which will help with how we should handle discontinued skus.

*This post is locked for comments

  • RE: Inventory Record Data in GP

    This is very helpful, thank you!!! :)

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Inventory Record Data in GP

    I can give you what ours is for comparison.  We have just under 7600 sku's in the IV00101 (Item Master) table and it's only taking up about 6 MB of space.  Granted, if you are just discontinuing items and they had price lists, item vendor information, item site info, etc, then there'd be more space involved not to mention all the history involved.  Unless you are planning on removing all that.  For example, our IV30300 (Item Transaction History Amounts) is upwards of 38 GB on it's own.

  • RE: Inventory Record Data in GP

    Hi there,

    I am asking in regards to the master item information and how much disk space is taken up. We have brands in GP that we do not sell anymore and wanted to know how beneficial it would be to delete them out of the system.  We are concerned about the future and how much data skus are taking up.  We plan on adding a lot more skus this year.

    Thanks for your feedback!

    Samantha

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Inventory Record Data in GP

    Are you asking for just the master item information and how much disk space that is going to take up or are you asking in general across all the different inventory setups, transactions, history, etc?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans