Change account code for Supplier.

[Former Member]

Hi,

I have recently uploaded supplier balances in the database.

Later I realised that the account code tagged to one of the vendor was wrong.

Since the balances were already uploaded i could no change the Account code.

Is there any way i can change the account code now using SQL.

Regards,

Jyoti

[K_Pauquet · Accepted solution]

Hi Jyoti,

please note that SAP will no longer be able to support you if you manually update tables, be it a direct manipulation of the tables or update queries.

Since there are already journal entries linked to the existing BP you will not be able to change the account.

To rectify the error please balance the existing BP, let the company accountant decide which off-setting account to use & then set this BP to 'On Hold' from the day you balanced the account to a date in the far future. To prevent users from erroneously picking this BP in marketing documents, you could also put him into a separate group & amend the choose from lists accordingly.

Then create a new BP with the correct account & repost the opening balance.

All the best,

Kerstin