Use AR Invoices Upcoming Due to create an AR Invoices Upcoming Due or an Expiring Discounts report. AR Invoices Upcoming Due will list all AR Invoices that have future due dates. An Expiring Discounts report will list all Invoices with Items offering a discount if the invoice is paid in full prior to the due date. Both reports feature account subtotals and a report total.
| Access |
| Grant permission to User Profiles in Access User Profiles > select a User Profile > Menu Security > Reports module > Main Menu > Customers. |
| Grant permission to the individual report > Customers > AR Invoices Upcoming Due |
Create Your Report
Select a Report Type of either
- Upcoming Due - View all upcoming due invoices based on the Due Date Range selected.
- Expiring Discounts - View all AR Discounts that will expire prior to the Due Date Range End Date.
Choose Order By of either Customer ID or Customer Name.
Enter an Amount Due to set a parameter for the report then select an operator 
to indicate how the amount should be used by clicking on it. Select
- Greater than or equal to
- Less than or equal to
- Equal to
- Not equal to
Customer Filter- All customers are selected by default. Select a Customer Filter to focus on certain customers. See Using a Customer Filter for more information.
All IDs selected by default in ID Range. Remove the checkmark and enter
- From- A Starting Customer ID number
- To- An Ending Customer ID number.
Create a Due Date Range by entering a
- Start Date- Enter a Start Date
- End Date- Enter an End Date
Select Preview to view the report onscreen.
Select Print to send the report directly to the default printer.
View a sample AR Invoices Upcoming Due report here.
Understanding Your Report
AR Invoices Upcoming Due
Customer includes the Customer ID and Name.
The Invoice #, Invoice number and Invoice Type indicates the type of Invoice.
Inv Date indicates the Invoice Date and Due Date is Due Date of the Invoice.
If a Delayed Terms program has been applied to the invoice, it will be indicated in the Delay Terms column.
The Amount of the Invoice is listed.
Each Account Subtotal shows the upcoming Due for the account.
A Report Total- Total of the Amount column.
View a sample AR Expiring Discount Invoices report here.
AR Expiring Discount Invoices
The AR Expiring Discount Invoices report shares most fields with the AR Upcoming Due report.
Disc Date- The Date the invoice needs to be paid in full to receive the discount. This date is determined by the information provided in the Discounts Allowed Date found in Access Parameters, AR tab in MerchantAg FIN.
Discount- The amount of discount available on the invoice.