Small and medium business | Business Central, N...

Change customer in Posted Sales Invoice Header from SQL Server

(0) Share

Report

Posted on by IBKIB

Hello,

Can I change Customer Number , Customer Name for Posted sales invoice through SQL server in BC database ?

like update

Sales invoice Header
Sales Invoice Line
Customer Ledger Entry
Detailed Customer Ledger Entry
G/L Entry
VAT Entry
Value Entry

Just update statement from customer to another customer

Regards

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Tech-Lucky 1,267 Super User 2025 Season 2 on at

Like (1)

Report

Yes, you can but this is not recommended at all if you have selected the wrong customer please try to post the reversal entry as a Sales Credit memo or Sales Return order.

Because there are many other tables as well where the customer No and details flow and you might skip them by doing so it may create issues in the future.

some of the tables I know are, the Sales Shipment header, Sales Shipment Line, and Item Ledger Entries, if any taxes are there then the related taxes ledger entries for VAT or GST accordingly.

Mark my answer as verified if it helps you

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,294 Moderator on at

Like (1)

Report

You should never do such corrections from SQL. In BC/NAV there is an option to reverse your incorrect invoice and process a new invoice with correct details

learn.microsoft.com/.../sales-how-correct-cancel-sales-invoice

Doing such reversals from SQL can seriously hamper your financials in BC/NAV and should never be done, even if it is the last resort. In some countries/localizations this activity is termed as a financial fraud

Was this reply helpful? Yes No
NAV2BC02 178 on at

Like (0)

Report

I agree and data should not be changed via SQL. There are a lot of related tables that if missed can cause record locks, and process issues.

Thanks!

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

I agree with all those here who say you should not do this. Make a correction posting instead.

Even though it is technically possible to change the data through SQL server you will easily end up in a state where you can compromised the integrity of your database.

Or at least consult someone who is very very experienced with Business Central and have them assist you.

There is a procedure in the system for renaming customers. Then all the related data is modified in a controlled manner. That function can be replicated but it requires very good knowledge of the system.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (0)

Report

Also, if you're using the SaaS version, you don't have access to SQL Server at all......Of course, you can also modify it directly via customization, but as the experts mentioned above, never do this.

PS: If you want to modify other data, you can refer to the following solution.

How to extend the Posted Document Update page (A solution for editing Posted Document)
https://yzhums.com/24923/

Thanks.

ZHU

Was this reply helpful? Yes No
Greg Enns 1,106 on at

Like (0)

Report

Zhu--I read your post about customizing this Posted Document Update functionality. That is SCARY what they are opening the system up to for a developer to change. In your example Zhu, you showed we could change Payment Terms. But that will not update the Vendor/Customer Ledger. And that is a minor issue compared to other things users might ask to have changed--like changing CustomerNo as OP has started this conversation with. So many people do not realize all the ledgers and entries that happen behind the scenes during posting. The posted document is just a small final output. Be careful here everyone.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

Doing these kind of changes have always been available for developers. So that is not anything new.

The problem is as you describe that a lot of people working with Business Central and doing development around Business Central does not understand the consequences of what they are doing. In the right hands these tools are handy in some situations - in the wrong hands they can completely ruin your data integrity. Because you can do certain things within Business Central and with the AL language does not mean that it is a smart thing to do it.

Was this reply helpful? Yes No
Greg Enns 1,106 on at

Like (2)

Report

I agree. The concerning thing is that with this functionality that MS has created, it makes this kind of change seem like a normal/okay thing to do. More users will request this type of change, and developers will be less hesitant to make the change since the system provided an OOB process for allowing it.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Yes, and especially when the developers also finds blog post out there telling them how essay it is to change posted data.

My recommendation will always be to not change posted data beyond what the standard functionality allows you to do unless you discuss it with your Business Central partner first. I done my share of modifying posted data over the years, but I have also spent almost every day for the last 30 days working with those tables. So I know those tables better than the map of my home city.

Was this reply helpful? Yes No
Tech-Lucky 1,267 Super User 2025 Season 2 on at

Like (0)

Report

fully agree with you @Greg Enns we should not share such solutions publicly where users are also seeing this and demand their partner for that, and maybe if the solutions go into the wrong hand then they can be a disaster too.

Was this reply helpful? Yes No