You’re offline. This is a read only version of the page.
1,080
Hi,
I've client having problem in the Item Stock Inquiry window, the transfer document number create a duplicate and the duplicate record have a negative balance.
During posting the batch using the inventory series posting window they encountered error "A save operation on table 'IV_TRX_HIST_HDR' has created a duplicate key". When they inquire the item in the Item Stock Inquiry window they find out that transfer document has a duplicate record and the duplicate record was negative balance. Please see below screenshot.
As of now I don't know how to fix the error. Please advice.
*This post is locked for comments
Hi Frank & Ronie,
We are having the same issue now. And we could note that, the transactions are duplicated in below tables.
IV10201, IV30300, IV30301 - Contains duplicates.
IV10200, IV30200 - Proper with out duplicates.
Do we need to check any other tables apart from these? And which tables should we delete the duplicates from? Please could you advise.
Which table(s) did you make the original fix to? You need to affect the Transaction History tables (IV30200, IV30300, IV30301, and if using Multi Bin, IV30302) and the Item Quantity Master (IV00102). Further, if you're using Lot or Serial numbers, then you'd have to affect the adjustments in IV00200 (Serial Number Master) or IV00300 (Lot Number Master) and IV30400 (Item Serial and Lot Number History).
Hope this helps,
Hi,
After I data fix the duplicate documents and looks all fine in the Item Stock Inquiry window. However when we rerun the reconcile for the item then check the item in the Item Stock Inquiry window the balance was recompute and almost of the balance amount are negative. What I did is revert back what I did in data fixing. My problem now is how/where can I delete the duplicate document, is there specific table where should I check?
Run Checklinks on the Inventory Transaction tables and then the Reconcile Utility on that item number. If that doesn't fix it, you'll have to fix it directly in the tables.
Hope this helps,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (