Another process has already added the Detail item. The system will automatically Cancel your changes.

(0) Share

Report

Posted on by Community Member

Screen: 04.250.00 (Purchase Order)

System Message 6908:
Another process has already added the Detail item. The system will automatically Cancel your changes.

Scenario:

In a Purchase Order there are already details and I want to add a new detail then I get the system message 6908.
I cannot add anything. I found a workaround by deleting all the purchase order details, save the PO then add everything again. But this workaround is difficult if there are more than 10 records per PO.

Any help please.

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Ram Peru 2,830 on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

Hello ZaiZai,

Could you please mention the version SL that you are getting this error?

If you are using Solomon 5.0 version, please go through the below knowledge Base article.

support.microsoft.com/.../877219

Thanks,

Perumalsamy

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

Thanks Perumalsamy!

Version: MSDYnamics SL FP1

Was this reply helpful? Yes No
Ram Peru 2,830 on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

Hello ZaiZai,

Is Purchase Order screen (04.250.00) customized in your environment?

As I have tried to add the Po line in existing Purchase Order in Dynamics SL 2011 Fp1 environment. It does not show any error in my environment.It seems working fine in my environment.

If Purchase order screen is customized, please look into the customization VBA code to fix the issue.

Thanks,

Perumalsamy R

This posting is provided 'AS IS' with no warranties, and confers no rights

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

The screen is customized but only with additional columns and hiding other fields. There are not customization as to uniqueness of records or such that will cause this error. This screen even with the customization has been working for so long and just got this message now.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

I found out the error by doing a profiler.

Triggered by unique key violation for PurchOrddet0 index key.

The new line is inserted with an assigned lineref (example 20) but lineref 20 already exist.

I think this was also cause by a bulk insert in the table using another tool created by the developers.

Was this reply helpful? Yes No
Ram Peru 2,830 on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

Hi ZaiZai,

Thanks for the information. I want to know that is there any Trigger functions during the PurOrdDet table insertion.

Thanks,

Perumalsamy.R

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

Hi Perumalsamy,

There is no trigger function during insertion but a violation of inserting a record that already exist through the index key PurchOrddet0 (ponbr, linenbr).

Luanne

Was this reply helpful? Yes No
Ram Peru 2,830 on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

Hi ZaiZai,

Thanks again!

Now the issue has been resolved right.

Thanks,

Perumalsamy.R

Was this reply helpful? Yes No
Edward McGovern 340 on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

Too late to help you but this may help someone in the future.

There is a field in PurchOrd called LineCntr, if it is less than the number of rows for the po in purorddet for that given po then it will gen this error by trying to assign the wrong linenbr and line ids to it.

so run:

update PurchOrd set LineCntr = isnull((select count(*) from purorddet where purchord.ponbr = purchord.ponbr), 0)

and that should clear it up

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Another process has already added the Detail item. The system will automatically Cancel your changes.

A quick correction to Edward's SQL script which fixes the bulk insert related issue:

update PurchOrd set LineCntr = isnull((select count(*) from purorddet where purorddet.ponbr = purchord.ponbr), 0)

Was this reply helpful? Yes No