Customer Invoice Report by Site#

This Invoice Site report prints for a single Customer, by the Site number and name for a selected date range.
It includes the Invoice #, date, with the original amount, paid amount and unpaid amount.
The prompts are:

CUSTOMER #

Enter the customer number or select it from the Accounting Customer Search window.

SITE, "ALL" OR "SEL"

Select one of the following site selection filters:

• Enter All to select all Sites for the customer.
• Enter the specific Site code or select one from the Customer Site Search window.
• Type SEL to select multiple Sites to include in the report as outlined in Selected Sites.

FROM DATE

Accept the starting date, or enter a preferred starting date.

TO DATE

Accept today's date for the ending date, or enter a preferred date.

INVOICE TYPE

Select one of the following invoice selection filters:

• Click Paid to include any fully or partially paid invoices.
• Click Unpaid to only include invoices that have never received any payment against them On Account.
• Click Both to include all invoices whether paid or unpaid.

INCLUDE FINANCE CHARGE

Uncheck this box if the output should not calculate a Finance Charge for over-due invoice amounts.

Check this box to show the Finance Charge amounts that would be charged at the rate defined in Company Information for over-due invoices.

FINANCE CHARGE AS OF

Accept today's date to use for the base for the Finance Charge calculation

F.C. Formula:

First the 'Months' to charge calculation is: Months = (As Of Date - Document Due Date) / 30

Then if the 'Document Balance' or 'Months' is less than zero then Finance Charge will be set to zero, otherwise the formula is:
Finance Charge = Finance Charge % / 100 * Document Balance * Months

If this value is less than the Finance Charge Minimum set in Company Information, the Finance Charge will be set to the Minimum.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click the ACCEPT button to generate the report, or CANCEL to abort.