SageForum for UK versions of Sage 50- Help and support.

Hi
I have created customer accounts and set a default department code on each account.
When creating a Invoice I sometimes have to change the default department.
When printing the Invoice the department code is not changing on the hard copy of the Invoice however if I then go back on to Sage and edit the Invoice there is no need as it has changed - its just not showing that change on the hard copy when you print it off!! Any ideas how I get it to change on the hard copy as well as on Sage?
Thanks

There are multiple department numbers associated with the invoice and you can choose which one to use!

There is one associated with the customer, this is in the sales_ledger table.
There is one in the Global details section in the Invoice Table
There is one in the Carriage section in the Invoice Table
There is one on the product code in the Stock table
There is one on the line item in the inv_item table

You just need to use the right one in the right place.

Thanks.
So, Lets say on the Sales Ledger account the default is set at Department 1.

I raise an Invoice and have to change the line item department code to 7. (There is only ever one line item per invoice).

When I print the Invoice, I need the department code at the bottom of the Invoice to say 7. I guess I have to change that on the account settings before I raise the Invoice each time?

Thanks

INVOICE_ITEM.DEPT_NUMBER if printed in the footer will give you the department of the last item on the invoice.