ManEx KB

1. A/P Aging

1.1. Prerequisites for A/P Aging

Users MUST have full rights to the "AP Aging, Reports" in Accounting Security . Users with “Accounting Security Supervisor” rights will automatically have access.

1.2. Introduction for A/P Aging

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.

Note: There are three modules which forward into the A/P Aging module. The PO Reconciliation module, Manual A/P Entries & Recurring Payments module and the Debit Memo module.

1.3. Fields & Definitions for A/P Aging

1.3.1. A/P Summary Current-60

A/P Summary Current - 60 Tab

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.
31 – 60	The amount due to the user which is 31 to 60 days past the due date.
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.

1.3.2. A/P Summary-Over 60

A/P Summary-Over 60 tab

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.

91 – 120
The amount due to the user which is 91 to 120 days past the due date.

Over 120
The amount due to the user which is over 120 days past the due date.

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.

1.3.3. A/P Detail Current-60

A/P Detail Current- 60 tab

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.
31-60	Invoices with due dates between 31 and 60 days past the scheduled due date.
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.

1.3.4. A/P Detail-Over 60

A/P Detail – Over 60 tab

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.
91-120	Invoices with due dates between 91 and 120 days past the scheduled due date.
Over 120	Invoices with due dates between 31 and 60 days past the scheduled due date.
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.

1.4. Reports for the A/P Aging

To obtain AP Aging reports, depress the Reports icon. The following reports are available:

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

AP Aging Summary

Select one of the radio buttons for the output you desire; Screen, Printer, XL File, TXT File, or PDF

Highlight the AP Aging Summary report. Depress the Options tab, the following screen will be displayed.

Select the applicable Supplier(S) and depress the > button.If you want all of the Suppliers, depress the >> button.

Complete your selection by clicking on the desired radio button within each section.

Then depress the OK button

The following report will be displayed.

AP Aging Detail

Select one of the radio buttons for the output you desire; Screen, Printer, XL File, TXT File, or PDF

Highlight the AP Aging Detail report. Depress the Options tab, the following screen will be displayed.

Select the applicable Supplier(S) and depress the > button. If you want all of the Suppliers, depress the >> button.

Complete your selection by clicking on the desired radio button within each section.

Then depress the OK button

The following report will be displayed.

AP Aging Detail As of

Select one of the radio buttons for the output you desire; Screen, Printer, XL File, TXT File, or PDF

Highlight the AP Aging Detail As of report. Depress the Options tab, the following screen will be displayed.

Select the applicable Supplier(S) and depress the > button. If you want all of the Suppliers, depress the >> button.

Complete your selection by clicking on the desired radio button within each section.

Then 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.

The following report will be displayed:

AP Transactions

Select one of the radio buttons for the output you desire; Screen, Printer, XL File, TXT File, or PDF

Highlight the AP Transactions report. Depress the Options tab, the following screen will be displayed.

Select the applicable Supplier(S) and depress the > button. If you want all of the Suppliers, depress the >> button.

Complete your selection by clicking on the desired radio button within each section.

Then depress the OK button.

The following report will be displayed:

AP Reconciliation Report