Fields
Make the following menu selections to display this page:
eFinancials—Reports—AR Reports—Aged Open Billings
Use this page to print an Accounts Receivable Aged Open Billings report.
Select PropertyCompany
Click to select PropertiesCompanies from the Select PropertiesCompanies tab. The report runs for all selected PropertiesCompanies.
Aging Date
This field defaults to the current Login Date. To change the date, use the electronic calendar to select a date. The system compares the Aging Date to transaction due dates to determine the number of days the billing has been open. The Aging Date works in conjunction with the Cutoff Date you enter, if any.
Cutoff Date
Use the electronic calendar to select a date. The Cutoff Date is used by the system to select the date range of billing items, based on the billing accounting date, i.e., the transaction Date of Record value. The transaction Date of Record is the posting date.
Sort By
Select a sort option for the report: Customer ID (default), Job, Customer/Job, and Job/Customer.
NOTE that
options
other than by Customer
ID are only shown if the current Property'sCompany's default
NOTE that for any of the Sort By options other than Sort By - Customer ID, the following additional From / Thru fields appear: Job, Phase and Cost. Field descriptions for these additional fields appear below.
The report will print and have totals based on the sort chosen, or by Customer if not using Jobs.
From Customer ID / Thru Customer ID
To run the report for a specific Customer or Customer
ID range, click the Lookup icon
to display a pop-up and then
select a starting Customer ID. Repeat the process to select an ending
Customer ID.
From Customer Type / Thru Customer Type
To run the report for a specific range of values
for the user code Customer Type,
click the Lookup icon to display the pop-up
and then
select a starting value. Repeat the process to select an ending value.
Entries appearing on this list are established in AR Setup for User Codes.
From Cycle / Thru Cycle
To run the report for a specific range of values
for the user code Cycle, click
the Lookup icon to display the pop-up
and then select a starting value. Repeat the process to select an ending
value.
Entries appearing on this list are established in AR Setup for User Codes.
From Location / Thru Location
To run the report for a specific range of values
for the user code Location, click
the Lookup icon to display the pop-up
and then select a starting value. Repeat the process to select an ending
value.
Entries appearing on this list are established in AR Setup for User Codes.
From Priority / Thru Priority
To run the report for a specific range of values
for the user code Priority, click
the Lookup icon to display the pop-up
and then select a starting value. Repeat the process to select an ending
value.
From Salesperson / Thru Salesperson
To run the report for a specific range of values
for the user code Sales Person,
click the Lookup icon to display the pop-up
and then
select a starting value. Repeat the process to select an ending value.
Entries appearing on this list are established in AR Setup for User Codes.
From Service Type / Thru Service Type
To run the report for a specific range of values
for the user code Service Type,
click the Lookup icon to display the pop-up
and then select a starting value. Repeat the process to select an ending
value.
Entries appearing on this list are established in AR Setup for User Codes.
From Job / Thru Job
To run the report for a specific Job range, click
the Lookup icon to display the Select Job pop-up and then
select a starting Job ID. Repeat the process to select an ending Job ID.
This field appears only when a Sort By option other than Sort By - Customer ID is selected.
Entries appearing on this list are established in Jobs Setup.
From Phase / Thru Phase
To run the report for a specific phase range,
click the Lookup icon to display the Select Phase pop-up
and then select a starting Phase No. Repeat the process to select an ending
Phase No.
This field appears only when a Sort By option other than Sort By - Customer ID is selected.
Entries appearing on this list are established as part of Cost Activity Setup.
From Cost / Thru Cost
To run the report for a specific Cost range, click
the Lookup icon to display the Select Cost pop-up and then
select a starting Cost No. Repeat the process to select an ending Cost
No.
This field appears only when a Sort By option other than Sort By - Customer ID is selected.
Entries appearing on this list are established in Cost Activity Setup.
Include Unapproved (check box)
Select this check box to include transactions from unapproved batches on the report. On the report, the amount for an unapproved item appears in the appropriate aging column and the balance due is 0.00. Amount totals for unapproved items are included in the Unapproved and Unauthorized Total line at the end of the report (they are not included in the Authorized and Approved Total line).
Print by PropertyCompany (check box)
If Print by PropertyCompany is not selected (default), the report prints for all selected PropertiesCompanies, and a list of selected PropertiesCompanies prints at the end of the report.
If Print by PropertyCompany is selected, the report prints grouped by PropertyCompany and has a total for each selected PropertyCompany.
Report Type
Select an option:
Summary (default): Select this option to print the summary version of the report.
Detail: Select this option to print the report with line item detail.
When you select Detail, the Include Customers with Retainage Balance Only option appears.
Report Format
PDF Format (default): Select this option to print the report in PDF format.
Create Spreadsheet: Select this option to print the report in an Excel spreadsheet.
Click to print the report.
This report lists those billings that have no payments. For each item, the report shows the balance, and indicates aging based on the setup in Global Policies.
The report prints and has totals based on the Sort by option chosen, or by Customer if not using Jobs.
The From and Thru ranges limit the data based on selections.
Billing data is grouped by Billing ID.
If Print by PropertyCompany
is selected, the report prints grouped by PropertyCompany and has a total for each selected PropertyCompany.
If Print by PropertyCompany
is not selected, the report prints for all selected PropertiesCompanies,
and a list of selected PropertiesCompanies
prints at the end of the report
The four aging ranges are based on the global policy setting for the AR tab:
The report total prints at the end of the report for all data reported.
for each field to enter ranges. Refer to the Fields list
for help.
See Also
Copyright © 2018 Infor. All rights reserved. www.infor.com.