Transaction Detail for Items

For converting open items, evaluate whether to bring in only the current balance on the item or to also include transaction detail that may be in the balance.

For example, suppose in your existing system you have an invoice with an open balance. The balance is a result of the original invoice, minus a credit memo that is applied against it. With PeopleSoft Receivables, you can convert the item with its current balance or bring in both the original invoice and the credit memo.

To bring in the balance only, the conversion interface program creates one pending item. When you bring in both the invoice and the credit memo, you create two pending items, each containing the same business unit, customer ID, and item ID. You assign an appropriate entry type to each item as well as an amount and a number of other values. The Receivables Update process creates one row in the Item Table (PS_ITEM) for the item and two rows in the Item Activity table (PS_ITEM_ACTIVITY), one for each pending item. That is, after you post both pending items, PS_ITEM contains the balance for the item, and PS_ITEM_ACTIVITY contains all rows that affected the balance.

For converting closed items, create two pending items with the same amount: one to open the item and the other to close it. PeopleSoft Receivables does not support the direct entry of a closed item; a pending item cannot have an amount of zero.