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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (10)

Answers (0)

siesclar1 10 on at

Like (0)

Report

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

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.
Suggested answer

Shyam Mani 331 on at

Like (0)

Report

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

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
ScorpioDax 331 on at

Like (0)

Report

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

You can try Rebooting your AOS servers.
Community Member Microsoft Employee on at

Like (0)

Report

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

Do you have any customization around this function?
Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report

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

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
Daxer Persson 3,005 on at

Like (0)

Report

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

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.
Guy Terry 28,626 Super User 2024 Season 2 on at

Like (0)

Report

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

Hi Transfer order,

Are you posting the invoice in Batch?
Community Member Microsoft Employee on at

Like (0)

Report

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

Dear Daxer,

could you please explain the above solution indetail please.

Regards

Sayed
Community Member Microsoft Employee on at

Like (0)

Report

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

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
Daxer Persson 3,005 on at

Like (0)

Report

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

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.