Inventory Line item duplications (after posting from Purchase receipt)

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (0)

Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Inventory Line item duplications (after posting from Purchase receipt)

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Inventory Line item duplications (after posting from Purchase receipt)

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Line item duplications (after posting from Purchase receipt)

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

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Inventory Line item duplications (after posting from Purchase receipt)

Hello Samuel

Nothing is shown above ..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Line item duplications (after posting from Purchase receipt)

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

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Inventory Line item duplications (after posting from Purchase receipt)

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,

Was this reply helpful? Yes No