The Accounts Payable Aging selection provides on screen and printed reports to assist the tracking and payment of outstanding payables.  Note:  the user cannot schedule for payment until such time as the Invoice to be paid appears in the A/P Aging.  AP Prepayments are NOT considered outstanding payables so they will NOT be displayed on the AP Aging screen

A/P Summary Current - 60 tab field Defintions

	In the column below, the name of the supplier. The user may sort alpha by depressing the button.
	In the column below, the net due to the user for that supplier.T he user may sort on highest to lowest by depressing the button.
Current	The amount due to the user which is not past the due date.
1 – 30	The amount due to the user which is 1 to 30 days past the due date.    The Ranges for the Aging screens must be setup within the Purch A/P Setup module.
31 – 60	The amount due to the user which is 31 to 60 days past the due date.  The Ranges for the Aging screens must be setup within the Purch A/P Setup module
Totals	The totals line will display the totals for each column, Balance, Current, 1-30 and 31-60.
Past Due All	The grand net total for all of the suppliers for amounts past the scheduled due date.

 

A/P Summary-Over 60 tab field Definitions

	In the column below, the name of the supplier.The user may sort alpha by depressing the button.
	In the column below, the net due to the user for that supplier.The user may sort on highest to lowest by depressing the button.
61 - 90	The amount due to the user which is 61 to 90 days past the due date.   The Ranges for the Aging screens must be setup within the Purch A/P Setup module
91 – 120	The amount due to the user which is 91 to 120 days past the due date.   The Ranges for the Aging screens must be setup within the Purch A/P Setup module
Over 120	The amount due to the user which is over 120 days past the due date.   The Ranges for the Aging screens must be setup within the Purch A/P Setup module
Totals	The totals line will display the totals for each column, Balance, 61-90, 91-120, Over 120.
Past Due All	The grand net total for all of the suppliers for amounts past the scheduled due date.

Highlight the Supplier of interest.To view the detail, select the appropriate tab – A/P Detail Current – 60 or A/P Detail – Over 60.The detail for that Supplier will display.

A/P Detail Current-60 tab field Defintions

Supplier	The name of the Supplier being displayed.
Credit Status	The status the supplier has with the user, Approved, On Probation, Disqualified, etc.
Credit Terms	These are the payment terms the supplier has for the user.
Credit Limit	This is the limit of credit that the supplier extends to the user.
Credit Available	This is the amount of credit still available to the user after consideration of all of the open invoices.
	The supplier’s number for their invoice. To sort by invoice number, depress that button.
	The date of the invoice.To sort by invoice date, depress that button.
	The date the payment is due to the supplier. To sort by Due Date, depress that button.
Invoice Amt	The $ amount of the invoice.
Current	Invoices with scheduled due dates later than the current date.
1-30	Invoices with due dates between 1 and 30 days past the scheduled due date.  The Ranges for the Aging screens must be setup within the Purch A/P Setup module
31-60	Invoices with due dates between 31 and 60 days past the scheduled due date.  The Ranges for the Aging screens must be setup within the Purch A/P Setup module
Totals	The total of the Invoice Amount, Current, 1-30 and 31-60 columns.

To view another Supplier, depress on the down arrow next to the Supplier field.  A list of Suppliers with open Invoices will display:

Select the Supplier of choice.

A/P Detail Over- 60 tab field Definitions

Supplier	The name of the Supplier being displayed.
Credit Status	The status the supplier has with the user, Approved, On Probation, Disqualified, etc.
Credit Terms	These are the payment terms the supplier has for the user.
Credit Limit	This is the limit of credit that the supplier extends to the user.
Credit Available	This is the amount of credit still available to the user after consideration of all of the open invoices.
	The supplier’s number for their invoice. To sort by invoice number, depress that button.
	The date of the supplier’s invoice.To sort by invoice date, depress that button.
	The date the payment is due to the supplier. To sort by Due Date, depress that button.
Invoice Amt	The $ amount of the invoice.
61-90	Invoices with due dates between 61 and 90 days past the scheduled due date.   The Ranges for the Aging screens must be setup within the Purch A/P Setup module
91-120	Invoices with due dates between 91 and 120 days past the scheduled due date.  The Ranges for the Aging screens must be setup within the Purch A/P Setup module
Over 120	Invoices with due dates between 31 and 60 days past the scheduled due date.   The Ranges for the Aging screens must be setup within the Purch A/P Setup module
Totals	The total of the Invoice Amount, 61-90, 91-120 and over 120 columns.

To view another Supplier, depress on the down arrow next to the Supplier field.A list of Suppliers with open Invoices will display:

Select the Supplier of choice.

Note:  The Invoice must be displaying in A/P Aging before it can be selected for payment.

 

To obtain the AP Aging Reports within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.

Note: In order to access the Reports within the Web the Company Root URL must be setup within the System Appearance module and user must be linked to web within the System Security Module.   

 

 

 

Select the Report Type:  AP AGING - A List of Reports will be displayed that are available on the Web for AP AGING

To obtain the AP Aging Reports within the desktop, select the Print button from the ManEx action buttons at the top of the screen.

 

The following reports screen will display a list of reports that are available on the ManEx Desktop:  

 

 

 

Note:  All of the AP Aging Reports account for Prepayments which are not accounted for in the AP Aging screen.

Highlight the report.  Depress the OK button.

 

Select the Report Aged On: Invoice Date or Due Date;  Select the Supplier(s) of interest and depress the > button.  If you want all of the Suppliers, depress the >> button.       Depress the OK button

The following report will be Printed:

AP Aging Detail

 

Select the Report Aged On:  Invoice Date or Due Date;  Select the Desired Sort Order within Supplier:  Invoice Date,  Due Date,  or Transaction Date. Select the Supplier(s) of interest and depress the > button.  If you want all of the Suppliers, depress the >> button.  Depress the OK button

 

Enter a specific Date mm/dd/yyyy or Fiscal Year and Period.   Note:  Check the "Set to Null" box for the fields not being used in order for the report to print. Select the Report Aged On:  Invoice Date or Due Date  Number  Select the Desired Sort Order within Supplier:  Invoice Date or Due Date Depress the OK button     Note:   You want to be sure that all invoices have been released and posted to the GL.  The AP Aging Detail As Of report does NOT list invoices that have NOT been released/posted to the GL yet.  This report IS intended to match the GL account information NOT the AP Aging screen.    Note:  If this report is still not matching the GL account information after all transactions have been released and posted to the GL then it may be due to Posted Journal Entries against the AP GL account.  These JE's will not be accounted for on the AS OF report yet will affect the GL Account balance and could explain why you are seeing a difference between the two.     Also, if the users are in the habit for changing the Invoice dates to way out in the future. In this scenario they would see the invoice on the aging screen but it will not display on the report until it reaches that date.

The following report will be displayed:

 

 

 

Enter a "Start of Range" Date in format "yyyy-mm-dd" or check the "No Lower Value" box.  Enter a "End of Range" Date in format "yyyy-mm'dd" or check the "No Lower Value" box. Note: User must enter either a Start or End of Range date or both in order for report to print. Select the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button.       Depress the OK button