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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Incorrect Inventory Setup
Microsoft Dynamics GP (Archived)

Incorrect Inventory Setup

(0) ShareShare
ReportReport
Posted on by Heather Roggeveen 9,146

Hi

Hopefully a simple answer on this one.  I have a client who only uses the cards for Service items to aid with quicker data entry in SOP - so everything is essentially non-Inventory.  However, they set up an inventory item as Sales Inventory (the first one they set up).  They had also set the Class up to not maintain history.

They have done one billing from the item so therefore inventory on hand shows as -1.

I was going to do an inventory adjustment to bring it back to zero and then change the type etc in the back end.  But if history has not been maintained I was thinking that I could just manually update the On Hand quantity in SQL.  Would that work and is there a wider impact I should be aware of?

Cheers

Heather

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Should be fine Heather.  Make sure you hit IV00102, IV10200 and SEE30303 with your script and then run Checklinks.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Another option here would be to use Tools->Utilities->Inventory->Remove Transaction History and then run Tools->Utilities->Inventory->Reconcile to bring the Qty on Hand down to down. One question I would have is what about the posting from this sale? What GL accounts got hit and do you need to reverse that entry? How about doing an SOP Return to bring the qty back to zero? Will they ever do an inquiry by sales item and need to look a the history of this part? From an auditing standpoint it would be better to do transactions and leave notes to explain what was done. They must have done an OE Override to get this part invoiced so now there is a record sitting in the IV10200 table waiting for a receipt. Doing it all within GP is the preferred way and once you have the qty back to zero then flip the item type to service using SSMS. If you want to make sure get it all download a sql script that searches for text in all tables. When you run it enter this part number to find all the tables that were affected. http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Hello Heather

    Technically speaking, both options are doable and correct, they can simply achieve the desired results.

    Option One - Back End

    When an inventory-related transaction is posted, several inventory tables are considered. In your case, the IV30300 is not one of them since the item is setup not to maintain transaction history. Therefore, consider the following:

    • IV00200 | two balance records (one summary with Record type =1 , and one specific balance record for the location). Both are to be "deleted"
    • IV10200 | Override virtual cost layer (in other words, dummy cost layer waiting for the next receipt in order to be replenished)
    • IV10201 | Sales document record linked to the above dummy cost layer
    • SEE30303 | Sales document is recorded with an override flag. This is linked with the General Ledger
    • GL20000 | In case your transaction posting is to (Post to and Post through), there is a journal entry to be considered in GL20000, including the following accounts:
      • COGS
      • SALES
      • Inventory
      • AR

    The above are the primary tables to consider, there are other tables (secondary tables, which are not part of the inventory processing) . Additional tables are considered depending on the type of item (such as lot or serial tracking options).

    In this essence, having the option (maintain history) unchecked would simply affect only the IV30300 records. Nothing else at all is affected as the overall inventory process related to cost layers is recorded as supposed to. Therefore, remove history would result with nothing, since it primarily deletes the inventory records from IV30300 (which already don't exist).

    Option Two - Application Level

    Simply follow the following steps in order to have your item well reset

    • Inventory adjustment (In), to bring the balance down to zero
    • Update IV00101 for the item type, make it service item
    • Enjoy

    Option one will encounter more suspense, while option two is straight forward and simple. Therefore, pick up the option you prefer by taking into consideration the associated points.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans