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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Exactly what is inventory?

(0) ShareShare
ReportReport
Posted on by

I am a non-accountant GP newbie going live  with a new install of GP 2010 tomorrow (APril 1, how appropriate) and I have discovered that our understanding of exactly what we should consider to be inventory is severely wanting.

Part of our problem is 30+ years of misapplication of GAP and no GAP throughout the business, and so many of us are tunnel-vision focused on maintaining a poor implementation.

We are a small manufacturer of medical devices and sell them to whomever: end users, distributors, etc. We don't buy someone else's products and put them on a shelf. To confuse the issue, we have two classes of products: a custom-made version and an off-the-shelf version. The custom-made versions (61 actual items) are carried in GP as services item types since they are manufactured on the fly per order and are unique as shipped. The off-the-shelf versions (~200 items) are made as needed and put on a shelf for demand to catch up with them. We have these as Sales Inventory in GP. In our minds these are very different situations, but I am thinking they are really not.

We also have the many items (~500) of raw materials that go into the items we make. These are listed in GP as Sales Inventory also.

Thursday and Friday we did our annual inventory and tonight I worked on integrating the quantities and costs into GP by means of an Inventory Transaction integration. I cannot get it to work. Lots of problems with UOM's. I successfully integrated a small number but can see that none of the quantities and costs show up in Item Maintenance. I'm wondering if we've got this all wrong, and that we really don't have any Sales Inventory items. Reactions.

Would very much appreciate hearing reactions.

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    OK, here is the Reader's Digest condensed version of inventory.

    1) Sales Inventory Type items are tangible goods

    2) Service type items are non-tangible items like hours of labor.

    3) You can also build things through bill of materials(BOMP)

    4) Sales inventory type items come into GP through either purchase order receipt entry, inventory adjustment or BOMP. In order to see costs on items or their stock quantity you must do some entry and then post these entries. In your integration you must have an item number, UofM, and quantity. The UofM must match whatever you have on the item card. The integration is also creating an inventory adjustment transaction entry that you will post.

    5) As far as those things you make, BOMP may be a way to handle this. A Bill can be comprised of both tanglible and non-tangible items. The key is to move inventory value from raw materials to finished goods. The net is your overall value is the same but now you have goods to sell as the quantity of your finished goods goes up as your value of raw materials goes down.

    6) If your items are service type items you will not see any quantities. Only sales type items have quantities.

    7) You must also set the GL accounts per item so as you buy and sell the items the appropriate GL accounts get hit.

    There is so much more to inventory than this but this should get you started. I am sure you will be getting other thouughts.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Super User 2025 Season 2 on at

    I would just add to Richard's response that those 61 items that you're carrying as Service Type items are not - they should be Sales Type items.  And you absolutely must get the Units of Measure correct to make the transactions work.  You would do well to invest in a knowledgeable adviser to help you straighten this out and put you on a path to better utilization of your system.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans