Understanding Messages Initiated by Pension Administration
Messages from Pension Administration to Receivables include the following:
-
Create Open Item
Pension Administration sends a message to create open invoices in AR to track the payment of lump sum or installment payments for the cost of the Service Purchase. One message will be sent for each open item to be created.
-
Service Purchase Canceled
Pension Administration sends a message to create credit items in Receivables. This kind of message can be used for two purposes:
-
To change the Tax Type (Pre-tax/Post-tax) of a Service Purchase item.
-
To cancel the entire Service Purchase transaction. In this case, the system creates credit items to match all the Service Purchase items still open in Receivables.
See Canceling or Refunding Payments for Service Purchase Items.
-
-
Service Purchase Refund Requested
Pension Administration sends a message to Receivables indicating that a refund of all payments to date has been requested due to cancellation of a service purchase transaction.
Messages from Receivables to Pension Administration include the following:
-
Response to Creating Open Items, Refund, or Cancellation
Receivables sends a message to Pension Administration to indicate success or that an error occurred when creating pending items, credits for refund, or credits for cancellation. This message occurs soon after the validation step. The validation step happens automatically when Receivables receives the Integration Broker message.
When the groups of pending items or the groups of credit items are posted, Receivables sends another message communicating this action as well.
-
Payments
Receivables sends a message to Pension Administration to indicate payment has been applied to an open item in AR.
-
Goal Balance Reached
Receivables sends a message to Pension Administration to indicate that all open items have been closed. This message is generated when the last open Service Purchase Item has been paid.
-
Reversal
Receivables sends a message to Pension Administration to indicate an open item has been reopened due to failure of payment at the bank. Pension Administration will perform a reversal of that payment. This may also be sent if a payment is unposted in Receivables.
The following table lists the fields that compose the messages:
| Field | Message Description |
|---|---|
|
5 - Business Unit |
The Receivables Business Unit in which the items will be created. Because Pension Administration is a U.S.-only application, the business unit must be a U.S. business unit. |
|
1 - Emplid |
Information received from Pension Administration. Customer ID has a hidden field that contains the Emplid. The emplid of the message should match the emplid of the customer. |
|
3 - Benefit Plan |
Information received from Pension Administration. Used by Pension Administration for tracking. |
|
2 - Customer ID |
The Pension Administration employee should be previously established as a customer in the financials database. The SetID for this customer will be determined in Receivables by Table Set Control. |
|
8 - Due Date |
Pension Administration must provide a Due Date. |
|
9 - Entry Type |
Pension Administration must provide an Entry Type. The Entry Type together with the Entry Reason contains the account and Chartfields that should be used for accounting in Receivables. When the request is to create a Debit Pending Item, proper Entry Type for Debit should be provided. When the request is to create Credit Items for Cancellation of Refund, Entry Type for Credit should be provided. The SetID for the Entry Type will be determined in Receivables by Table Set Control. |
|
10 - Entry Reason |
In combination with the Entry Type, an Entry Reason is needed to determine Account and Chartfields information. |
|
12 - Amount |
The invoice amount. Even for Credit items, a positive amount should be provided in this field. |
|
13 - Currency |
Pension Administration is a U.S.-only product, which means that the currency is USD. The business unit is also a U.S. BU. |
|
14 - Accounting Date |
Pension Administration provides the accounting date. |
|
6 - Installment Number |
Number of the installment sent by Pension Administration. When Receivables send IB messages to communicate payments and cancellations over a service purchase item, the installment number of this item is always included in the message. When Pension Administration sends Cancellation messages to cancel a specific Service Purchase item, this field can be populated with the installment number of the item intended to be canceled. However no validation is done in Receivables to assure that credits and debits are matched only when they have corresponding Installment Numbers. |
|
11 - Tax Type |
This value indicates whether this is a pre-tax or a post-tax amount. Pension Administration sends the appropriate Entry Type and Entry Reason to enable accounting entries to be added to the appropriate Pre-Tax or Post-Tax accounts. |
|
4 - Service Purchase ID |
Pension Administration assigns the Service Purchase ID (SP_ID). The SP_ID is assigned to the set of invoices that will be created by the set of messages triggered from Pension Administration. The SP_ID will also be stamped in the Credit Items created from messages coming from Pension Administration. |
|
7 - Message Number from Pension |
Pension Administration creates a message number that is populated for each message that Pension sends to Receivables requesting the creation of a Debit or Credit Memo. When Receivables replies to this message regarding Validation errors, successful creation of the pending item groups, successful posting of pending item groups, or any other activity that Receivables communicates regarding Service Purchase items, this Message Number should be populated with the same value originally sent by Pension. Pension Administration uses this field, together with the Installment number, to track the items created in Receivables. If a validation error occurred, Pension will send another IB message after fixing the issue; the new message will have the same Message Number as the original one that failed. |
|
15 - Source System |
AR - PeopleSoft Receivables sends message to PeopleSoft Pension Administration PA - PeopleSoft Pension Administration sends message to PeopleSoft Receivables |
|
16 - Request Code |
CRT - Create Open Item PAY – Pay an Item CNL - Cancel Item RFD – Refund REV - Reversal of Payment GBA – Goal Balance Attained |
|
17 - Request Status |
01 – Request 02 - Success - Pending 03 - Success - Item 04 - Error 05 – Resend 06 – Applied |
|
18 - Message Code for the Validation Error found |
Receivables will create the pending item only after it validates all the fields to ensure that Receivables Update will not find any error during posting. If an error is detected, the message code is populated in this field so that Pension Administration will know what is wrong in the setup and will be able to fix it or to communicate with the Receivables person to have it fixed. |
|
CF SubRecord |
This field will be present in the message record in the HCM database. It will not be present in the FSCM database because Receivables does not use any account or CF SubRecord received by Pension. Rather, this information comes from the Entry Type/Entry Reason and current Receivables setup. Pension Administration can use CF SubRecord to integrate with third-party Receivables systems outside of PeopleSoft. |
This table describes how the Request Code and the Request Status determine integration actions:
| Action | Sent By | Request Code | Request Status |
|---|---|---|---|
|
Request creation of Debit Memo |
Pension Administration |
CRT |
01 - Request |
|
Receivables validation ok |
Receivables |
CRT |
02 - Success-Pending |
|
Receivables validation failed |
Receivables |
CRT |
04 - Error |
|
Pension Administration resends a message |
Pension Administration |
CRT |
05 - Resend |
|
Receivables posts pending item with success |
Receivables |
CRT |
03 - Success-Item |
|
Payment Received |
Receivables |
PAY |
06 – Applied |
|
Unpost |
Receivables |
REV |
06 – Applied |
|
Request creation of Credit Memo for Refund |
Pension |
RFD |
01 - Request |
|
Receivables validation of Credit Memo for Refund is ok |
Receivables |
RFD |
02 - Success-Pending |
|
Receivables validation of Credit Memo for Refund failed |
Receivables |
RFD |
04 - Error |
|
Pension Administration sends or resends a message for creation of Credit Memo for Refund |
Pension Administration |
RFD |
05 - Resend |
|
Receivables posts the Credit Memo for Refund |
Receivables |
RFD |
03 - Success-Item |
|
Credit Memo has been refunded and posted successfully |
Receivables |
RFD |
06 – Applied |
|
Request creation of Credit Memo for Cancellation |
Pension Administration |
CNL |
01 - Request |
|
Receivables validation for Credit Memo for Cancellation is ok |
Receivables |
CNL |
02 - Success-Pending |
|
Receivables validation for Credit Memo for Cancellation failed |
Receivables |
CNL |
04 - Error |
|
Pension Administration resends a message for creation of Credit Memo for Cancellation |
Pension |
CNL |
05 - Resend |
|
Receivables posts the Credit Memo for Cancellation |
Receivables |
CNL |
03 - Success-Item |
|
Credit Memo has been used for Cancel Open Items and has been successfully posted |
Receivables |
CNL |
06 - Applied |
|
Open Items have been matched against the Credit Memo for cancellation. |
Receivables |
CNL |
06 - Applied |
|
Goal Balance attained. |
Receivables |
GBA |
06 - Applied |