Key Dates

This table describes the significance of two important date fields on the PS_PENDING_ITEM table:

Field	Usage
Accounting Date	Used as a basis for payment term and aging calculations. Using the accounting calendar, the accounting date also determines which fiscal year and accounting period to associate with the pending item. The system uses the fiscal year and accounting period to create accounting entries for journal entries for the general ledger and to update customer history.
As Of Date	Used as a basis for payment term and aging calculations.

Two conversion approaches using these date fields are available:

• When converting only open items:

  • Choose a common conversion date and place this date in the Accounting Date field.

  • Place the invoice date (or accounting date equivalent field) in the As Of Date field, and base payment terms and aging rules on the As Of Date field value.

    This approach records the converted items in one fiscal year and accounting period only, but maintains the original invoice date for terms and aging. The Accounting Date and As Of Date fields on the pending items from billing usually contain the same value if you choose this method.

• When converting open and closed items and developing history data within the PeopleSoft system from the converted activity, use the appropriate date that is associated with the activity in the existing system as the accounting date on the related pending items.

  This approach also establishes an accounting calendar that spans all the possible converted accounting dates and ensures that the open period range in the business unit options table is broad enough to span all accounting periods. Thus, the system records all converted activity in the fiscal year and accounting period in which it occurred.