Automatically update Sales Invoice Division

1

Hell All,
I am using the cloud version, and we have a two locations. I just discovered that i could use the division to get separate Profit and Loss Statement. but the problem is that we have more than 1000 invoices. I updated the divisions of each customer so the sales invoices could be updated automatically.
In the Division column on Sales Invoices Page the divisions are updated but didn’t effect the P&L statement, as the sales invoice lines are not updated.
Is there is any way to automatically update the OLD sales invoice lines division according the customer.

image_2024-02-24_154931432
image_2024-02-24_1549314321566×658 32.3 KB

image_2024-02-24_155135277
image_2024-02-24_155135277523×553 8.27 KB

Thanks

2

No, there is no way to automatically update. You need to use the Batch Update function.

3

image_2024-02-24_164633665
image_2024-02-24_1646336651209×601 36.5 KB

I have tried it, but there is no customer name and there is no Division Column !

4

Use Batch Update to get Customer and Sales Invoice data.
Then use VLOOKUP to fill in the Divisions in the Sales Line Item with Customer or Code as the Lookup Value.

image
image1918×387 49.7 KB

Don’t forget to back up your data before you do this.