Average Collection Time
This window titled Average Collection Time Selections is used to define the selection criteria to be used when generating this Average Collection Time report. This report will list all of the customers with the total amount collected for the selected period and the average time between the date billed and the date paid for each file included on the report. This report is useful to identify those customers who are slow to pay their bills.
Include Billing Dates: / To *: Enter the range of billings dates to be included in this report. The report will only include entries with billing dates that fall within this selected range of dates. NOTE: Press the [?] to the right of each of these fields to activate a pop-up calendar which can be used to select the date. Once a date has been selected, the up/down arrows to the right of each field can be used to move the date up or down one day at a time. These are required fields.
A/R Account: If you wish to include all A/R Accounts, then enter a zero ("0") in this field. To include only one A/R Account, enter that A/R Account. The name of the A/R Account will be displayed to the right of this field. Press the {? } to the right of this field to open a window titled Select A/R Account which displays a listing of the existing A/R Accounts.
Branch: If you wish to include all Branches, then enter a zero ("0") in this field. To include only one Branch, enter the number of that Branch in this field. The name of the selected Branch will be displayed to the right of this field. Press the {?} to the right of this field to open a window titled Select Company Branch which displays a list of the current branches.
Bill To (Customer): If you wish to include all Customers, then enter a zero ("0") in this field. To limit this report to one Customer only, enter that Customer's number in this field. The customer's name will be displayed to the right of this field. Press the { ? } to the right of this field to open a window titled Select an IBS Customer which displays a list of the current Customers or to set up a new Customer.
Account: If you wish to include all Accounts, then enter a zero ("0") in this field. If you wish to limit this report to one Account only, the enter that Account number in this field. The Account's name will be displayed to the right of this field. Press the {?} to the right of this field to open a window titled Select an Account which displays a list of the current Accounts or to set up a new Account. NOTE: Accounts and Customers share the same file in the IBS database.
Sales Agent: If you wish to include all Sales Agents, then enter a zero ("0") in this field. If you wish to limit this report to one Sales Agent only, then enter that Sales Agent's number (as found in the Commission Agent File) in this field. The Agent's name will be displayed to the right of this field. Press the {?} to the right of this field to open a window titled Select Commission Agent which displays a listing of all existing Commission Agents.
Driver: If you wish to include all Drivers, then enter a zero ("0") in this field. If you wish to limit this report to one Driver only, enter that Driver's number (as found in the Commission Agent File) in this field. The Driver's name will be displayed to the right of this field. Press the {?} to the right of this field to open a window titled Select Driver which displays all of the existing Commission Agents.
Shipment Source: If you wish to include all Shipment Sources, then leave this field blank. If you wish to limit this report to one Shipment Source only, then enter that Shipment Source. The description of the Shipment Source will be displayed to the right of this field. Press the {?} to the right of this field to open a window titled Select Choice which displays a listing of the existing Shipment Sources.
Shipment Type: If you wish to include all Shipment Type, then leave this field blank. If you wish to limit this report to one Shipment Type only, then enter that Shipment Type. The description of the Shipment Type will be displayed to the right of this field. Press the {?} to the right of this field to open a window titled Select Choice which displays a listing of the existing Shipment Types.
Shipment Sub-Type: If you wish to include all Shipment Sub-Types, then leave this field blank. If you wish to limit this report to one Shipment Sub-Type, then enter that Shipment Sub-Type. The description of the Shipment Sub-Type will be displayed to the right of this field. Press the {?} to the right of this field to open a window titled Select Choice which displays a listing of the existing Shipment Sub-Types.
[ OK ] Press this button to generate this report based on the criteria selected on this window.
[ Cancel ] Press this button to close this window and return to the previous window.
[ Help ] Press this button (if available) or the F1 key to view the Help text for this window.
