Delivery address information on a report and in an entry layout

You add extra information about the delivery address using the path Financial / Debtor / Debtor, properties, Delivery addresses tab. One piece of such information is, for example, the Contact department field in the delivery address.

This additional information is processed in Profit as follows:

If you add a delivery address for a debtor, it is recorded in two separate tables in the database. These are the tables:

  1. Addresses: the address and the description of the delivery address are recorded here.
  2. Contact: the address and all extra information is recorded here as a contact. All other information such as contact department, explanations, etc. is recorded in this table.

Contact details not on report

In the reports, you can retrieve data from the address table, but not from the contact table. This is because there is no automatic link with the latter table. A conscious choice is made not to retrieve this information. If we should retrieve all the delivery address information then this would have the following consequences:

  • Infinite information For the delivery address, you should then be able to retrieve all information (comments, custom fields etc.).
  • If you are able to retrieve everything and, for example, use the delivery address in the order, the delivery address can no longer be deleted from the debtor information. This is now possible because Profit retrieves the address from the Addresses table. Thus, you can now manage which could not otherwise be done. If we change this then it will also happen for other data such as contact persons.

The information from the preferred delivery address works because this is a separate table.

Nevertheless, delivery address information on report:

You can retrieve the Delivery address description field from the data collection of the report under the heading Packing Slip/Delivery. This is the Contact department field in the delivery address. This does display the correct information.

You can find this filter via the path Order Management / Output / Management / Report, Properties report /action Properties / screen Available fields: / heading Packing Slip/Delivery.

In addition, you can use a sub-report to establish a link to the Contact data collection, which allows you to link the Contact delivery address.

See also