Invoice Cut-Off Report

This report can list invoices in a selected Customer range, a selected division, and selected date range, above or below the specified dollar amount, in ascending or descending order.
The invoice #, division, customer #, date, and the Sale and Rental product details are listed, and the spreadsheet output also includes the customer Salesman. Each invoice is identified as Cash or On Account.

To generate a report of only credit invoices, select the desired division, and date range, and accept the default selections.
All invoices in History for that division, with a value of less than zero will be included on the report.

The prompts to generate the report are:

DIVISION, "ALL" OR "SEL"

• Type ALL to include all divisions in the report.
• To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type SEL to select an inventory region or a range of inventory divisions to include in the report, as outlined in Division Select By Region.

The division selection is restricted by the Divisional Restricted Views assigned to the operator.

ALL CUSTOMERS

Check this box to include all customers.

Uncheck this box to select a customer range.

FROM CUSTOMER #

Enter a starting customer number, or select one by from the Accounting Customer Search window.

TO CUSTOMER #

Enter an ending customer number, or select one by from the window.

FROM DATE

Accept the current month start date, or enter a starting date for the invoice selection.

TO DATE

Accept the current month end date, or enter an ending date for the invoice selection.

CUT-OFF OPTIONS

Select one of the following options:

• Select Above to list only Invoices higher than the Cut-Off Dollar Value.
• Select Below to list only Invoices below the specified Cut-Off Dollar Value.

CUT-OFF DOLLAR VALUE

Enter the cut-off dollar amount for invoices to be included on the report.

If this field is left blank and Below is selected for the Cut-Off Option, then only credit invoices will print.
Conversely if this field is left blank and Above is selected for the Cut-Off Option, then only positive value invoices will print.

SORT ORDER

Select one of the following sort options:

• Select Ascending to list the invoices in increasing dollar sequence.
• Select Descending to list the invoices in decreasing dollar sequence.

REPORT TYPE

Select one of the following reporting options:

• Select Summary to generate the summarized report listing only one line per invoice listing the Invoice #, Division, Name, Account flag, and the totals for Sales, Rentals, Services and Taxes.
• Select Detail to generate the detailed report listing each item on each invoice in the selected range.

INVOICE LOCATION

Select one of the following invoice options:

• Select Current for unposted invoices that still have a Current status.
• Select Batch for invoices in Batch status that are part way through the Daily Close. These are the invoices that have passed though Daily Close 1 in a DBR.
• Select History for invoices posted though Daily Close 2 and are now in History.
• Select All to include all invoices in the range, regardless of status.

SITE, "ALL" OR "SEL"

• Type ALL to include all Customer and Global Sites in the report.
• To print the report for a single Site code enter the Site number, or select it from the Site Search - Customer or Global window.
• Type SEL to select multiple Sites to include in the report as outlined in Selected Sites.

Note: The site numbers are only printed on the spreadsheet output.

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 begin printing the report, or CANCEL to abort.