AP Aging

Shows all accounts receivable with open balances and aging.

Search Criteria:

As Of Date

Shows all accounts payable aging with amount open and days old. The "As Of" date always uses the Posting Date from the Vendor Invoice or Payment. The selection of Using: Invoice Date, Due Date, or Posting Date is used to decide how to place the amounts into your defined aging buckets. The As Of: Date will act as if no transactions exist after this date. So if you are running the report as of a past date, keep in mind you may see transactions that have already been accounted for after that date.

Using

This allows you to select how you wish to view the different aging buckets. Though the Age Receivable date selected above is always going to show you transactions as of the posting date, this allows you to view your aging buckets using one of the following date fields; Invoice Date, Due Date, or Posting Date.

Vendor

Limits the results to a specific vendor.

Company

Appears if you have GL Companies enabled. Limits results to open transactions for that GL Company

AP Account

Limits results based on transactions for that AP Account.

Currency

Appears only if you have Multicurrency enabled. Limits results based on transactions for that Currency.  

Find date of last balance

This can used for the system to try and locate the last date your AP tied out. Please contact support@workamajig.com if you have questions about this feature.

Display Options

Posted Transactions Only

Limits the results to only show transactions that have been Posted to the GL.

Include Unapplied Payments

If checked, Unapplied Payments not applied to a vendor invoice will be included.  

AE View

Groups the results by the Account Manager of the Project linked in the header of the invoice. If no project is listed in the header for the invoice, then its grouped under No Account Manager.

AE View Page Break

Same as above, yet does a page break before each AEs name when you export to PDF only.

Summary View

If checked, the report will be made into One Line Per Vendor.

Group By Office

Groups the results by Office if set on the invoice and project.

Periods:    User adjustable to only return data that is older than X days from the As Of date at the top of the search options.

First Period (days)

User adjustable, typical use is 30 Days.

Second Period (days)

User adjustable, typical use is 60 Days.

Third Period (days)

User adjustable, typical use is 90 Days.