Receivables Update Process

The posting process in PeopleSoft Receivables is known as Receivables Update. The Receivables Update process occurs throughout the system as you post pending items. These pending items can be entered online, created by your billing interface, or created during payment processing, draft processing, direct-debit processing, or overdue charge processing, or during item maintenance activities.

When you post items in PeopleSoft Receivables, the system processes groups of pending items to update a customer's balance, system-defined history elements, and item balances. During processing, the system creates balanced, valid accounting entries. The Journal Generator Application Engine process (FS_JGEN) then summarizes the accounting entry information in general ledger journal format. The General Ledger Posting Application Engine process (GL_JP) updates the ledger balances.

Receivables Update processes records in these transaction tables:

  • Group Control (PS_GROUP_CONTROL) - Contains header information for the transaction group.

  • Pending Item (PS_PENDING_ITEM) - Contains the transaction type and transaction detail.

  • Pending Distribution (PS_PENDING_DST) - Contains accounting entries.

  • Pending VAT (PS_PENDING_VAT) - Contains value-added tax (VAT) transaction type and transaction detail.

  • Pending Tax (PS_PENDING_TAX) - Contains India excise duty tax and sales tax entries from a billing system.

  • Pending Tax Details (PS_PENDING_TAX_DTL) - Contains India excise duty tax and sales tax details.

The process updates six master tables:

  • Item (PS_ITEM) - Contains detailed information about the receivable.

  • Item Activity (PS_ITEM_ACTIVITY) - Describes the action taken on the receivable item.

  • Item Distribution (PS_ITEM_DST) - Contains the accounting entries for the item activity.

  • Item VAT (PS_ITEM_ACT_VAT) - Contains the VAT transactions for the item activity.

  • Item Tax (PS_ITEM_ACTTAX) - Contains tax information for India for the item activity.

  • Item Tax Details (PS_ACTTAX_DTL) - Contains tax line information for India for the item activity.

Note:

If you enabled the options for processing entry events selected at the installation level and on the Receivable Update Request - Options page, the Receivables Update process calls the Entry Events Generator Application Engine process (FS_EVENTGEN), which updates the Entry Event Accounting Lines table (PS_EE_ITM_ACCTG_LN) with the supplemental accounting entries.

This graphic shows the flow of data for the Receivables Update process. The transaction tables (GROUP_CONTROL, PENDING_ITEM, PENDING_DST, PENDING_VAT, PENDING_TAX, PENDING_TAX_DTL) are processed using Receivables Update and updated in the master tables (ITEM, ITEM_ACTIVITY, ITEM_DST, ITEM_ACT_VAT, ITEM_ACT_TAX, ITEM_ACT_TAX_DTL).

Flow of data for the Receivables Update process. The transaction tables (GROUP_CONTROL, PENDING_ITEM, PENDING_DST, PENDING_VAT, PENDING_TAX, PENDING_TAX_DTL) are processed using Receivables Update and updated in the master tables (ITEM, ITEM_ACTIVITY, ITEM_DST, ITEM_ACT_VAT, ITEM_ACT_TAX, ITEM_ACT_TAX_DTL)

Receivable Update process updates transaction tables to master tables

The Receivables Update process also updates the system-defined customer history elements.

Related Topics