Show delivery address for invoice account on the invoice report (Accounts receivable/Reports/Invoices)
To see the delivery address for the invoice account on the invoice report, you need to create a few calculated fields.
You do this under Tools/Calculated fields
First, select the directory (table) you want to create a field on.
NOTE: If you do not know the name of the file (table), you can stand on the screen, in this case the invoice report, and click the F12 key. Here you can read the name of the file, in this case "DebtorInvoiceLocal", which you must use to create the new fields.
Select Tools/Calculated fields to create the fields
On calculated fields, select the "DebtorInvoiceClient" folder and click "Calculated fields"
Note: If you have two folders, one called "DebtorInvoiceClient" and one called "DebtorInvoiceClientUser", this means that you have created a custom field on that folder. If you want to use this custom field in your calculation, you must select "DebtorInvoiceClientUser", otherwise "DebtorInvoiceClient" is sufficient.
Click "Add field" to add a field to the selected directory.
Name the field, this can only contain alphanumeric characters and only from A to Z, 0-9 and no spaces
The caption is filled in with a short description for the field on the view page.
The type must be String, as in this case we need to retrieve an address.
To retrieve the delivery address fields from the invoice account, you need the following fields:
rec.DeliveryDebtor.DeliveryAdress1
rec.DeliveryDebtor.DeliveryAdress2
rec.DeliveryDebtor.DeliveryAdress3
rec.DeliveryDebtor.DeliveryZipCode
rec.DeliveryDebtor.DeliveryCity
Below is an example of the delivery address from the invoice account being retrieved.
Select Tools/Calculated fields to create the fields
On calculated fields, select the "DebtorInvoiceClient" folder and click "Calculated fields"
Note: If you have two folders, one called "DebtorInvoiceClient" and one called "DebtorInvoiceClientUser", this means that you have created a custom field on that folder. If you want to use this custom field in your calculation, you must select "DebtorInvoiceClientUser", otherwise "DebtorInvoiceClient" is sufficient.
Click "Add field" to add a field to the selected directory.
Name the field, this can only contain alphanumeric characters and only from A to Z, 0-9 and no spaces
The caption is filled in with a short description for the field on the view page.
The type must be String, as in this case we need to retrieve an address.
To retrieve the delivery address fields from the invoice account, you need the following fields:
rec.DeliveryDebtor.DeliveryAdress1
rec.DeliveryDebtor.DeliveryAdress2
rec.DeliveryDebtor.DeliveryAdress3
rec.DeliveryDebtor.DeliveryZipCode
rec.DeliveryDebtor.DeliveryCity
Below is an example of the delivery address from the invoice account being retrieved.