Invoice Cut-Off Report
Reports Menu -> Revenue ->
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.
Topic Keyword: RSID42