While working on ERPNext, I ran into a situation where I needed to edit a field on a submitted Sales Invoice — but the only way ERPNext allows it is through cancel → amend, which feels like a heavy process just for a small change. I started wondering if other ERP systems handle this differently, so I did some research — and found that SAP actually allows certain fields to be edited after posting without reversing the document. That got me curious about whether something similar is possible in ERPNext too. Sharing my findings and would love to hear the community’s thoughts!
Thank you for your update.
in sales order doctype i enable Allow on submit but when chage the qty and try to update it’s show me
”Not allowed to change Total Quantity after submission from 5.0 to 10.0”
I dont think system will allow you to change these fields which are linked and domino effect on other docs. Even in SAP my gut feeling tells me it can really cause chaos in the links.
Try to create a custom field (e.g. Internal memo number) and Allow on submit … it should work there
I tried with other field too like allow Submit on customer but get same error “Not Allowed to change ‘‘field-name after submission from old-value to new-value“
@asieftejani , Thank you for your efforts, i also did this and it allow the chages thoes fied where we set allow_submit but, it not us to allow edit or change the value on item table field like qty or rate.
Okay interesting…
Lets leave it as its standard field and I think there are system checks in place as this can have major impact on other reports/doctypes/links if modified after submission
In Sales Order, you can use the Update Items button at the top of the document.
This allows you to update the item quantity and other fields without cancelling and amending the document.
Yes, that option works initially. However, once the Delivery Note is created, the Sales Order can no longer be updated using the Update Items button.
What i need is the ability to update the quantity or rate in the Sales Order even after the Sales Invoice is submitted, without cancelling or amending the document.