Hi, I am also facing the same problem with one of my customer .. after posting purchase receipt, items are duplicating in the inventory (IV30300 / IV30301 / IV10200. tables) Dynamics GP version 10 (10.00.0903), for the duplicated line items we noticed the lnseqnbr value are incremented by 16384, 16385.. Any idea..
Thanks
Biju
*This post is locked for comments
Hi
I can add to this - Mahmoud helped me with a similar issue via this forum not so long ago, but it wasn't 100% there so I was going to come back to ask for further advice. Here is a summary of the situation:
Inventory transfer duplicates on posting. I found duplicated transaction records in the following places that needed to be cleared:
IV10200
IV10201
IV30100
IV30200 (showed the single correct transfer header - I used TRXSORCE to isolate other transactions in other tables)
IV30300
IV30301
IV30500
SEE30303
After I removed all related incorrect records, we ran an inventory reconcile and this fixed inventory quantities on the receiving site - but not on the sending site.
Is there a manual update that also needs to happen to the inventory quantities table somehow?
Cheers
Heather
Biju,
For the benefit of other community members - you can attach a screenshot if you select to 'Use rich formatting'. Those words are in blue just below the reply window that you were typing in. Others are having this problem, your resolution would most likely help them too.
If you do take it offline, Mahmoud would you please post the resolution?
Question, are you importing the receipt records?
Kind regards,
Leslie
Sorry, it seems some issue in attaching the file here. can you please provide me your email address ? I am send it to you directly..
Regards /Biju
Hello Samuel
Nothing is shown above ..
Dear Mahmoud,
Thanks for the reply, I am attaching a screen short which is generated from the GP SQL server for a particular document.
Regards / Biju
Hello Biju
The line sequence number is normally increased by 16384, it is the basis for this calculation. You should not encounter any record with 16385
Therefore, to set the case back on the track, please provide a sample for one specific document as posted in IV30300, IV10200, IV10201 and SEE30303
SELECT * FROM IV30300 WHERE DOCNUMBR = '' SELECT * FROM dbo.IV10200 WHERE RCPTNMBR = '' SELECT * FROM dbo.IV10201 WHERE ORIGINDOCID = '' SELECT * FROM dbo.SEE30303 WHERE DOCNUMBR = ''
A transfer document will be recorded in all of the above, while the "Out" transaction will not have any record in IV10200. Meanwhile, an "In" transaction will not have any record in IV10201
Pick a document as a sample and lets see how analysis shall proceed
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
