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
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156