You’re offline. This is a read only version of the page.
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
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
You can try Rebooting your AOS servers.
Do you have any customization around this function?
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
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.
Dear Daxer,
could you please explain the above solution indetail please.
Regards
Sayed
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
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.
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,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (