When running the new Daily Sales Invoice Report, the "Customer" column is currently being populated with the information from the Customer Name field. This is incorrect. The column should be populated with the Customer ID information.
For example, in the Test Site database ( in the google cloud account ) there is a Customer named "JOHNSON SUBARU" and in that customer record they have a Customer ID of "JOHS"
When this customer appears on a sales invoice, their customer id of JOHS should be used to populate the "Customer" column of this report.
The output of this report is being use as the import source to an external accounting program. The external accounting program can only recognize Customer Id. It has no understanding of the full customer name.
When running the new Daily Sales Invoice Report, the "Customer" column is currently being populated with the information from the Customer Name field. This is incorrect. The column should be populated with the Customer ID information.
For example, in the Test Site database ( in the google cloud account ) there is a Customer named "JOHNSON SUBARU" and in that customer record they have a Customer ID of "JOHS" When this customer appears on a sales invoice, their customer id of JOHS should be used to populate the "Customer" column of this report.
The output of this report is being use as the import source to an external accounting program. The external accounting program can only recognize Customer Id. It has no understanding of the full customer name.