I want to know how to update an entry of a field in a table of SQL where the previous entry is wrong and I want to replace with new one.
We have created invoice (OINV) with wrong profit center code but the invoice has been paid and using SDK code we have created journal entry that debited sales revenue and credited sales service. Please give advice.
I am using SAP B1 2005A SP 01 PL 29
The previous answers are correct. you must also develop SDK code to make the journal entry autoreverse and linked to your SDK code, so that if there were something wrong in the closed invoice can be corrected by creating new one.
Updating can possibly make the database corrupt. Try to ask the SAP support if they can help.