Cannot edit a record in Sales order - update table (SalesParmTable)

(0) Share

Report

Posted on by Community Member

Dear All,

While posting the sales order invoice we are getting the below mentioned issue:

Cannot edit a record in Sales order - update table (SalesParmTable).
An update conflict occurred due to another user process deleting the record or changing one or more fields in the record"

Can any give the root cause and solution for this issue.

Thanks in advance for your reply at the earliest.

Best Regards

Syed

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Daxer Persson 3,005 on at

Like (0)

Report

Not sure but does the sales order update have lines that already have been invoice updated and furthermore referenced purchase order lines (either in local company or intercompany) ?

If yes, go to each line and update (correct) accounting distribution (from Financials ) and see if works then.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Daxer,

Thanks for your mail,

we are able to post the same sales order invoice in TEST with out doing any changes.

Regards

Sayed

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Daxer,

could you please explain the above solution indetail please.

Regards

Sayed

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Transfer order,

Are you posting the invoice in Batch?

Was this reply helpful? Yes No
Daxer Persson 3,005 on at

Like (0)

Report

For each of the sales lines with reference to a purchase order:

Go to the purchase order line, select Financials > Distribute amounts and Correct (or Reset) the distribution.

Possibly need of confirming the puchase order again.

and try again with update of Sales order.

Was this reply helpful? Yes No
Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report

try this

The resolution to this would be by changing the “OCC enabled” table property on “SalesParmTable” table to “No”.

further details about issue is here

community.dynamics.com/.../38993.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Do you have any customization around this function?

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

You can try Rebooting your AOS servers.

Was this reply helpful? Yes No
Suggested answer

Shyam Mani 331 on at

Like (0)

Report

Hi,

Usually such issues arise when some records have been left out for long time in buffer and now they have been changed in actual.

You can try below query to find out such related records,

select * from SALESPARMSUBTABLE where SALESPARMSUBTABLE.PARMID

in (select SALESPARMSUBLINE.PARMID from SALESPARMSUBLINE where SALESPARMSUBLINE.DATAAREAID = 'xyzx')

and SALESPARMSUBTABLE.DATAAREAID = 'xyzx'

If you delete these related records, you will not get errors during invoicing SOs.

Thanks,

SM

Was this reply helpful? Yes No
siesclar1 10 on at

Like (0)

Report

This change caused several issues with the packing slip and invoicing processes and did not fixed the main incidence, at least this is our experience.

Was this reply helpful? Yes No