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
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.
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
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
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
Thank you Ajit,
The article solved our problema.
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
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
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (