Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Item Serial Number shows in stock when it was taken out

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We had an inventory batch suspend during a system crash.  The inventory transactions seemed to have posted but the batches were not deleted in Inventory.  The GL batch is sitting in GL to be posted.  We have to delete the batches left behind or we'll duplicate the transactions and get Duplicate Key errors.  That seems fine but the problem is an Item Inquiry shows the serials in stock and available.  We have run Inventory Reconcile and Check Links multiple times.  I try removing the serial numbers from IV00200 and IV30400 but reconcile adds them back with an arbitrary serial number.  When I review Adjust Cost screens I see the buckets add up to a quantity available that includes the serials that were adjusted out by the suspended batch.  Am I missing a table where these transactions could be orphaned?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Serial Number shows in stock when it was taken out

    Thanks everyone for your responses.  I have been cleaning up suspended batches for years in GP and had never been stumped like this before.  I think because I've only had a few instances with serials being used in inventory.  Anyhow, I was able to resolve it without too much back end clean up of the tables.  Typically when I approach data issues like this I'll run check links (and Inventory Reconcile in this case) numerous times and in different order as I clean up the data to let the system try to fix itself.  Each time changing status or cleaning or adding data.  All of this, of course, in a mirror copy of the database in a TEST company.  I went back through my scenarios and identified one approach I hadn't taken and it panned out.  Reconcile adjusted the quantities correctly and didn't add back phantom serials and all quantities on hand and allocated matched the buckets and associated inventory decreases.  The solution ended up being the deleting data from within the GP interface, correcting data in the tables and running check links and inventory reconcile in a specific order to get it all to present correctly.  All that while confirming check links or reconcile didn't change it incorrectly or for that matter at all.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Item Serial Number shows in stock when it was taken out

    Hi

    I am not entirely sure of all the tables, but based on similar issues (not linked to serial numbers), these are tables that I have had to look at in the past:

    IV10200

    IV10201

    IV30100

    IV30200

    IV30300

    IV30301

    IV30500

    SEE30303

    SY00500 - funny looking batches (i.e. stuck with transaction posting) can cause issues

    Some of the issues I have had are related to duplicate records in history.

    It really is a bit of a minefield to try and isolate all the records.

    Hope that helps a little.

    Cheers

    Heather

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Item Serial Number shows in stock when it was taken out

    Have you deleted the batches?  First trust you are working with a Test Database - if not, would be strongly recommended.  Regardless.

    If you have not removed the batches, each time you run the reconcile it will simple see the batch, see the data, take that into account and move on - thereby restoring the same values.

    As to the tables that might hold all the points of touch, I am not sure, but there is likely someone in our community that will have that for you.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans