You’re offline. This is a read only version of the page.
9,142
Hi
I had a situation at a client recently where a posting interrupted error occurred during an inventory transfer. On investigation I found the following:
IV30200: showed a single header record as expected
IV30300: showed duplicated lines with two different TRXSORCE numbers - one of the numbers was the same as the header table, the other one did not exist in the header.
I deleted the lines that did not have a header and asked the client to run reconcile to correct quantities. All appeared fine, however, the transfer quantities are not showing as having moved.
i.e. 4 items transferred from Site A to Site B
Quantities at Site A still show the 4 and Site B doesn't - despite the fact I can see the transactions to support it.
I investigated further yesterday and found additional incorrect records in IV30500 that I removed. A reconcile was done again last night and it still does not appear to have fixed the quantities.
Anyone know which table or fields I need to verify to get the Inventory Reconcile to pick up the quantities correctly?
Cheers
Heather
*This post is locked for comments
Mahmoud
I hoped you would spot this and reply and as always, you have come up with some gems!
I used the above to compare a correct transfer with my problem one in each table and I have found duplicated records in IV10200 and IV10201
The other two tables are fine.
I am going to delete the duplicated records here. Inventory reconcile will be run again over the weekend so I will get it checked again next week and update.
Thanks very much.
Cheers
Heather
Hello Heather
The reconciliation is not always the solution, lets start by checking the following tables:
Run the following scripts:
Share
Report
All responses (
Answers (
SELECT TRXSORCE ,
DOCNUMBR ,
DOCDATE ,
ITEMNMBR ,
UOFM ,
TRXQTY ,
QTYBSUOM ,
TRXLOCTN ,
TRNSTLOC
FROM dbo.IV30300
WHERE DOCNUMBR = 'TRFNumber#'
SELECT ITEMNMBR ,
TRXLOCTN ,
DATERECD ,
QTYRECVD ,
QTYSOLD ,
UNITCOST ,
RCPTNMBR
FROM dbo.IV10200
WHERE RCPTNMBR = 'TRFNumber#'
SELECT ITEMNMBR ,
TRXLOCTN ,
DOCDATE ,
ORIGINDOCID ,
QTYSOLD ,
UNITCOST
FROM dbo.IV10201
WHERE ORIGINDOCID = 'TRFNumber#'
SELECT ITEMNMBR ,
DOCNUMBR ,
DOCDATE ,
LOCNCODE ,
TRXQTYInBase ,
UNITCOST ,
UOFM ,
EXTDCOST ,
JRNENTRY ,
DEBITAMT ,
CRDTAMNT
FROM dbo.SEE30303
WHERE DOCNUMBR = 'TRFNumber#'
Your feedback is highly appreciated,
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156