cancel
Showing results for 
Search instead for 
Did you mean: 

update

Former Member
0 Kudos

Hi All,

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

Rajh

Accepted Solutions (1)

Accepted Solutions (1)

former_member186095
Active Contributor
0 Kudos

Rajh,

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.

Rgds,

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Raj,

Go to the journal entry that is passed because of the invoice and you can choose or modify the profit centre in the Journal Entry.

Regards,

Sridharan T

Former Member
0 Kudos

Dear

Once an invoice is created, the row level information cannot be updated.

best regards,

xiaodan an