Item Serial Number shows in stock when it was taken out

(0) Share

Report

Posted on by Community Member 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

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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 9,142 on at

Like (0)

Report

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 22,647 on at

Like (0)

Report

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.