Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Work Order Material Is...
Microsoft Dynamics SL (Archived)

Work Order Material Issue - System Message 6908

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

I am having issues determining how to correct this problem. I have a couple of work order that will not allow us to issue materials, giving the message above.  This trouble is similar to other posts I have found regarding PO's.

The cause of the error is that a duplicate LineRef is being created for new entries. For example, when I profile the transaction, I can see the system is trying to use LineRef '00235' for the WOMatlReq table, however, '00235' already exists for the previous item added to this work order.

Does anyone know how/where I can look to increment this value so that the system will use LineRef '000236' for a new item?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Work Order Material Issue - System Message 6908

    There are no custom triggers, and I have tried this in Standard mode in the past (along with just now as well). There is no change.

    What I can't determine is where the systems look to determine the next 'LineRef'. In the case I am working on, I clearly see lineref 00166 and 00167 are used in the WOMatlReq table, however, adding new items to the BOM results in a query (found in a Trace) that tries to use lineref 00166 again.

    If this query would only run with lineref 00168, then all would be well, but it insists on trying to use 00166, despite it being in use.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Work Order Material Issue - System Message 6908

    Do you have customizations in Work Order?  Have you tried to make a Work Order entry while in standard mode?  This may move you beyond the LineRef 00235.  If you still encounter an error when entering/issuing material for a Work Order in standard mode, than I would recommend looking for custom triggers.  Disable the custom triggers related to Work Order and try making a new entry.  Or you could try running a SQL trace and see if a trigger is creating the problem, you will need to add the object name and object type to a standard trace template to capture the information.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans