We had a receipt that some how posted twice so we made an adjustment to
remove the extra quantities added by the duplicate receipt. We found out
later that only one of the recipts hit the historical inventory trial balance
table (SEE30303), so the historical inventory was too low.
My ideas are to either:
A) Add the duplicate receipt to the HITB table (using a different DOCNUMBR).
B) Delete the adjustment from the HITB table.
What's the best way to correct this?
What should I do if we have a receipt double post again?
FOLLOW UP (I had to use Chrome to get my post to show up finally):
I had to do something for month end, so I added the duplicate receipt to SEE30303. Does anyone know how this table works? It is keyed off of ITEMNMBR, SEQNUMBR, DOCDATE, & RCTSEQNM, but then it's indices basically set up ITEMNMBR & SEQNUMBR to be unique, so does anyone know hoe SEQNUMBR works? Is it just sequential per item? Is there some other mechanism I'll throw off by adding the next sequence number in?
Thanks.
*This post is locked for comments
I have the same question (0)
215
Share
Report
All responses (
Answers (
