Suspended Inventory batch

(0) Share

Report

Posted on by Community Member

Hello you all

In a Dynamics SL 2011 SP2 installation, I'm getting a suspended inventory batch taht comes from OM. The message I'm getting is:

Batch '102301' has IN transactions IN with duplicate references

If I check the batch in Ini Mode, I'm shown only one item

Invoice CC00040253 7506036081622 CEDIS 00000

This combination of Invoice nbr, ítem number, site an location is not duplicated on the whole batch.

Does anyone knows how to correct this problema?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Ajit Kannan 1,246 on at

Like (0)

Report

Hello Miguel Maafs,

Please go through the below KB Article.

support.microsoft.com/.../871342

You will get an idea about your questions.I believe the above KB Article may solve your problem.

Thanks,

Ajit Kannan S R

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The screen does not show the duplicate records but the batch does not release because of the records.

Review the records with this SQL statement

select batnbr, invtid, lineref, rlsed, * from intran where batnbr = '102301'

ID the record to delete then prepare the statement to accomplish that. Be careful with the KB article referenced below, deleting by LineRef, which is duplicated in the batch, will delete the good and the bad line.

I find many times the Rlsed column makes it combination unique.

Richard

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Ajit,

The article solved our problema.

Was this reply helpful? Yes No
street9009 130 on at

Like (0)

Report

Hello Ajit,

I am having this problem this morning, but the KB article you linked to no longer loads. Can you send an updated link?

Stephen

Was this reply helpful? Yes No
DavidResendiz 10 on at

Like (0)

Report

i have the same problem right now, but the link doesnt work, exist another link? or how can i resolve this problem.

i apreciate your help

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Once again Microsoft hides/moves all the knowledge base articles that I would like to read. Only time I find KB articles is on non-Microsoft sites. SMH

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

As it turns out, I just resolved this issue for a client earlier today. Using SQL Enterprise Studion Manager, run the following, replacing <batch> with the batch number:

select batnbr, invtid, lineref, lineid, linenbr, recordid from intran where batnbr = '<batch>'

What you'll likely find is that batnbr, invtid, lineref, lineid, and linenbr are all duplicated. However, recordid is unique. Delete one of the recordid lines for each offending duplicate lineref then release the batch.

Was this reply helpful? Yes No