Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Create Payables Aging Reports

Example: Create Payables Aging Reports

This example illustrates how to verify the effective date of cancellation of a supplier invoice when you run the Payables Aging financial report for a closed period.
You post a supplier invoice in January. Then you reconcile and close the January accounting period. In February, you find out that you have to cancel the invoice.
  • Security: Reports: Supplier Accounts in the Supplier Accounts functional area.
  • Security: Reports Financial Accounting in the Financial Accounting functional area.
  • Security: Process: Period End in the Common Financial Management functional area.
  • Open the January accounting period.
  1. Access the
    Find Supplier Invoices
     report and find the supplier invoice #A010319 with an invoice date in January.
  2. Run the
    Payables Aging
     financial report for January.
  3. Access the
    Trial Balance
     report and check that the trial balance for January matches the payables aging report summary totals.
  4. Access the
    Mass Update Period Ledger Status
     task and close the period for January, and open February.
  5. Access the
    Find Supplier Invoices
     report, find, and cancel invoice #A010319.
  6. Rerun the
    Payables Aging
     financial report for:
    1. January to verify that the total of the report didn't change.
    2. February to verify that the canceled invoice isn't on the report.
Since the January accounting period is closed, the invoice you canceled (#A010319) posts the
Cancel Accounting Date
 to the first day of the next open accounting period, February 1st. The
Cancel Accounting Date
 is the same date as the
Accounting Date
 of the reversal operational journal. You can view the
Cancel Accounting Date
 when you select
Accounting
View Accounting
 from the related actions menu of the invoice.