This chapter provides an overview of posting and unposting and discusses how to:
Set groups to post.
Run Receivable Update.
Review posting results.
Correct posting errors.
Unpost groups.
Run the AR Rebate Notification process (AR_REBATE).
The Receivable Update multiprocess job (ARUPDATE) posts items in billing, overdue charge, payment, maintenance, transfer, draft, and direct debits groups. The job does the following for the items in the group:
Updates the item activity.
Updates the item balance and customer balance.
Creates balanced accounting entries for each activity.
The system combines information entered with other control information, such as accounting entry templates to create the balanced entries.
Updates the system-defined customer history elements.
Creates commitment control source transactions and control budget entries if you have enabled commitment control for the general ledger business unit and your organization.
The Receivable Update multiprocess job and online On Demand posting are the only methods that PeopleSoft Receivables uses to update posted information.
The Receivable Update process determines whether the accounting date for the item activity is in an open period for the business unit and transaction type in PeopleSoft Receivables. It also determines whether the accounting date is in the same period for both PeopleSoft Receivables and PeopleSoft General Ledger. If the accounting date is not within an open period for the receivable business unit, the Receivable Update process issues a posting error.
If the accounting date falls in a different period in PeopleSoft General Ledger, it updates the GL_ACCTG_DT field on the Item Distribution table (PS_ITEM_DST) with a date in the general ledger period. The Journal Generator Application Engine process (FS_JGEN) uses the item activity accounting date.
The process checks for ChartField combination edit errors if you enabled combination editing for the business unit on the Receivables Options - General 2 page. Depending on your selection on the Receivables Options - General 2 page, the system either creates an error or warning message in the message log. If it creates an error message, you must correct the error in the error correction components and rerun Receivable Update to post the transactions.
See Also
Setting Up Receivable Update and Pending Group Generator
Defining Additional General Options
Editing ChartField Combinations
Setting Up On-Demand Processing
To post groups:
Select a posting action for the group.
Run Receivable Update.
Check the message log to determine whether there are any warning or error messages.
Review the posting results.
Correct posting errors.
(Optional) Unpost the groups to reverse the activity and the accounting entries, and start over.
Run the Journal Generator process to generate the journal lines.
You must select the accounting entry definition that the system should use when it creates journal lines, such as ARDEFN (receivables definition), ARDIRJRNL (direct journal), or ARREVALUE (revaluation).
Note. You can optionally specify that you want the Journal Generator process to run automatically after the Receivable Update multiprocess job completes in the run control definition.
If you interface vendor rebate claims and claimbacks to PeopleSoft Receivables from PeopleSoft Purchasing and PeopleSoft Order Management, run the AR Rebate Notification Application Engine process (AR_REBATE) to update the claim balances in the claim management workbench based on payment and maintenance activity in PeopleSoft Receivables.
After groups are posted, the items are available for other business processes, such as payment processing or maintenance.
See Also
This section provides an overview of how to set groups to post and lists the pages used to set groups to post.
For all groups except direct debits and drafts, you must select a posting action of Batch Priority or Batch Standard when running Receivable Update as a scheduled multiprocess job. For groups posted using On Demand processing, the groups are automatically set to a posting action of Batch Standard but are posted immediately. For direct debits, change the status to Remitted to enable posting. For drafts, post the groups after every business event. Selecting a posting action is not necessary.
Use inquiry pages to determine whether a group has been set to post or to view the group status.
Groups whose posting action is Batch Standard or Batch Priority can cause a backlog in the system. Use the Groups Set to Post page, Payments Set to Post page, Drafts Set to Post page, and Direct Debits Set to Post page to help you identify either a solution or the scope of the backlog.
See Also
Selecting a Transfer Worksheet Action
Page Name |
Definition Name |
Navigation |
Usage |
GROUP_NOT_POST_BU |
|
View groups whose posting action is Do Not Post. |
|
GROUP_POST_BU |
Accounts Receivable, Pending Items, Review Items, Groups Set To Post, Groups Set To Post |
View item groups that will post the next time that you run the Receivable Update multiprocess job. |
|
PYMT_POST_BU |
Accounts Receivable, Payments, Review Payments, Payments Set to Post, Payments Set to Post |
View payment groups that will post the next time that you run the Receivable Update multiprocess job. |
|
DRAFT_POST_BU |
Accounts Receivable, Drafts, Review Drafts, Drafts Set to Post, Drafts Set to Post |
View draft groups that will post the next time that you run the Receivable Update multiprocess job. |
|
DD_POST_BU |
Accounts Receivable, Direct Debits, Review Direct Debits, Direct Debits Set to Post, Direct Debits Set To Post |
View direct debit groups that will post the next time that you run the Receivable Update multiprocess job. |
|
GROUP_STATUS |
|
View the posting status and posting action of a group. |
Normally, you run the Receivable Update multiprocess job as a scheduled job. You can run the job ad hoc, as needed.
Note. You can also run the job immediately from an Action page for small groups under certain circumstances, such as at the end of the period when you need to update the ledger immediately.
This section provides an overview of how to restart or reset Receivable Update, lists prerequisites, and discusses how to:
View the job message log summary.
Restart the Receivable Update multiprocess job.
Reset the Receivable Update multiprocess job.
See Also
Setting Up Parallel Processing
We recommend that you try to restart the Receivable Update multiprocess job before resetting the process. You can restart a process that has abended as a result of an environmental problem. After you have fixed the COBOL, SQL, or data problems that caused a process to abend, you can restart the process. Not all processes are restartable from this page.
Note. Remember that Receivable Update uses temporary tables. If the temporary tables have been deleted, you cannot restart (resume processing); you must reset and rerun the process from the beginning.
If you are unable to restart a process instance that has abended, you must unlock and reset the process. When a process abends because of SQL, bad data, or a missing COBOL process, some tables with data in the groups set to post under the run control ID become locked when the process instance becomes populated with the current instance.
Unlocking and resetting the process instance to zero in the locked tables unlocks the tables and enables you to rerun the process. The system also automatically deletes the PeopleSoft Enterprise Application Engine run control record from the AERUNCONTROL table.
You should only unlock and reset under certain development circumstances or in expert testing environments:
When you have corrected the problem that caused the process to abend and you want to reprocess the same groups again but do not have access to restart from the server.
When you have not corrected the problem but want to continue processing.
Before you can run the Receivable Update process, you must:
Set up the PeopleSoft Receivables business units (including selection of calendar and aging options).
Define the receivable processing options (system functions and entry types).
Create groups for pending items, payment worksheets, maintenance worksheets, drafts, or direct debits.
Set up system-defined history IDs.
If you want to run Receivable Update immediately from an action page, you must:
Define processing options for your organization on the On Demand Processing page.
Define the processing options for each user on the Define User Preferences - Process Group page.
You must define separate options for each of these source transactions: ARMNTWS (maintenance worksheet), ARITSPLT (item splits), AROPIE (online pending items), ARPAYWS (payment worksheet), ARTRNWS (transfer worksheet), ARUNPOST (unpost transactions).
Your system must also have pending items that are ready to post. These pending items can be entered online, created by a billing interface, or created during payment processing, draft processing, direct-debit processing, overdue charge processing, or during item maintenance activities.
See Also
Defining PeopleSoft Receivables Processing Options
Setting Up On-Demand Processing
Page Name |
Definition Name |
Navigation |
Usage |
POSTING_REQUEST |
Accounts Receivable, Receivables Update, Request Receivables Update, Receivable Update Request |
Enter run parameters for the Receivable Update multiprocess job and run the job. |
|
AR_MSGSUM |
Accounts Receivable, Receivables Update, Job Message Log Summary, Job Message Log Summary |
View a summary of messages generated by individual processes within a multiprocess job, including individual processes run in parallel, such as processes for the Receivable Update, Payment Predictor (ARPREDCT), Aging (ARAGE), and Statements (ARSTMT) multiprocess jobs. |
|
Process List |
PMN_PRCSLIST |
|
Review the multiple processes in a job. |
AR_RESET |
Accounts Receivable, Receivables Update, Reset Process, Process Reset |
Reset the Receivable Update process. Unlock and rerun the process. |
Access the Job Message Log Summary page. (Accounts Receivable, Receivables Update, Job Message Log Summary, Job Message Log Summary.)
Process Instance |
Displays the process instance number for the multiprocess job. |
Process Run Status |
Displays the status of the multiprocess job, such as No Success or Success. |
Instance |
Displays the process instance number for the individual process. For example, the ARUPDATE multiprocess job with a process instance number of 510 will have several instances, such as instance number 511 for the AR_UPDATE process, instance number 512 for the AR_PGG1 process, and instance number 514 for the AR_POST1 process. |
Process |
Displays the name of the individual process within the multiprocess job. For example, for the ARUPDATE multiprocess job, it would display rows for the AR_UPDATE, AR_PGG1, and AR_POST1 processes. |
Access the Process List page. (PeopleTools, Process Scheduler, Process Monitor, Process List.)
Because Receivable Update is a job (a collection of multiple processes), you may need to restart multiple processes. Find the processes that you need to restart.
Details |
Click to access the Process Detail page, and select Restart Request. |
Access the Process Reset page. (Accounts Receivable, Receivables Update, Reset Process, Process Reset.)
Enter your search criteria for the process instance and click Refresh.
In the Not Successful Process Requests grid, select the process instance that you want to reset.
Reset |
Click to unlock and reset the process instance. After the process instance is reset, you can rerun the process. |
This section provides an overview of the posting result inquiry pages and lists the pages used to review posting results.
After you run the Receivable Update multiprocess job, review the posting results for groups. You can review individual item details for the items in the groups, accounting entries, value-added tax (VAT) information, tax information for India, and group control information.
PeopleSoft Receivables provides several components for reviewing posting results. The components all use the same pages, but they have different search records to filter the groups that you select. Some components enable you to view all information for the items and some components do not show the accounting entries, VAT information, and tax information for India. Some components enable you to view all items in a group and others enable you to search for a single item in the group. The following table lists the navigation to each component and the pages in each component.
Note. The pages that display tax information for India are available only if you enabled sales tax and excise duty for a receivable business unit type on the Business Unit Tax Applicability page.
These pages are the same as the pages that you use to enter pending items except that you cannot change any information:
Menu Navigation |
Pages |
Accounts Receivable, Receivables Update, Posting Results - Pending Items, All Items w/ Detail Accounts Receivable, Receivables Update, Posting Results - Pending Items, Single Items w/ Detail |
|
Accounts Receivable, Receivables Update, Posting Results - Updated Items, All Items w/ Detail Accounts Receivable, Receivables Update, Posting Results - Updated Items, Single Items w/ Detail |
|
Accounts Receivable, Receivables Update, Posting Results - Updated Items, All Items Accounts Receivable, Receivables Update, Posting Results - Updated Items, Single Item |
|
Accounts Receivable, Receivables Update, Posting Results - Direct Debits, All Items w/ Detail Accounts Receivable, Receivables Update, Posting Results - Direct Debits, Single Items w/ Detail |
|
Accounts Receivable, Receivables Update, Posting Results - Direct Debits, All Items Accounts Receivable, Receivables Update, Posting Results - Direct Debits, Single Item |
|
Accounts Receivable, Receivables Update, Posting Results - Drafts, All Items w/ Detail Accounts Receivable, Receivables Update, Posting Results - Drafts, Single Items w/ Detail |
|
Accounts Receivable, Receivables Update, Posting Results - Drafts, All Items Accounts Receivable, Receivables Update, Posting Results - Drafts, Single Item |
|
Accounts Receivable, Receivables Update, Posting Results - Payments, Item w/ Accounting Entries Accounts Receivable, Receivables Update, Posting Results - Payments, Items w/ Accounting Entries |
|
Accounts Receivable, Receivables Update, Posting Results - Payments, Payment Group - Single Item Accounts Receivable, Receivables Update, Posting Results - Payments, Payment Group - All Items |
|
See Also
Entering or Updating Pending Items
Page Name |
Definition Name |
Navigation |
Usage |
GROUP_ENTRY1_DSP |
Accounts Receivable, Receivable Updates Then, select the navigation to the appropriate component. |
Review the control totals and group status for the group. |
|
GROUP_ENTRY2_DSP |
Accounts Receivable, Receivable Updates Then, select the navigation to the appropriate component. |
View item information, including amounts, entry type and reason, payment terms, and discount data. |
|
GROUP_ENTRY2B_DSP |
Accounts Receivable, Receivable Updates Then, select the navigation to the appropriate component. |
View assigned support personnel, correspondence information, cash forecasting information, and draft information. |
|
GROUP_ENTRY2C_DSP |
Accounts Receivable, Receivable Updates Then, select the navigation to the appropriate component. |
View user-defined fields. |
|
GRP_ENT_VATHDR_DSP |
Click the VAT Header link on the Pending Item 1 page. |
View VAT header defaults. |
|
GRP_ENT_VAT_LN_DSP |
Click the VAT Line link on the VAT Header page. |
View VAT line defaults, including the VAT amounts. |
|
GROUP_ENTRY3_DSP |
Accounts Receivable, Receivable Updates Then, select the navigation to the appropriate component. |
View accounting entries for each item. |
|
GROUP_ENTRY_TAX_DSP |
Accounts Receivable, Pending Items, Online Items, Group Entry, Group Entry Tax, Group Entry Tax Ds |
(IND) View excise duty and sales tax amounts for India. |
|
GROUP_ENTRY_TAX_DT |
Click the Tax Detail Link on the Group Entry Tax Ds page to view India tax detail information. |
(IND) Display excise duty and sales tax detail information for India. |
When the Receivable Update multiprocess job finds errors, the job updates the Error Code field (AR_ERROR_CD) on the Pending Item table (PS_PENDING_ITEM) with an error code. The job creates and balances your accounting entries before editing occurs. If the process does not create your accounting entries or they are incorrect, the AR_ERROR_CD field contains a value of ACTOB.
Once accounting entries are correct and balanced, the Receivable Update multiprocess job continues with two types of edits. The Receivable Update multiprocess job edits the Pending Item (PS_PENDING_ITEM) table through a series of editing update statements which only edit pending items created by systems external to PeopleSoft Receivables such as PeopleSoft Billing or an external billing system, and then all groups are edited through other specific program logic.
When it detects an error condition on a pending item, it sets a value in the AR_ERROR_CD field on the Pending Item record. After the pending item passes the editing sections, the system checks for additional conditions within the SQL that is executed by the Receivable Update multiprocess job. The system reports only one error condition at a time per pending item, so even if it detects more than one error, it stores only one error code.
Error Correction
You can edit any error detected by Receivable Update using an error correction page. The system reedits the pending item and highlights the fields that are in error for you to correct.
To edit an error:
Click the Error Info (error information) button to view a summary description of the error.
If you need more details, click the Explain button.
For combination edit (combo edit) errors, when you click the Error Info (error information) button, a summary description of the error appears. However, to view more details, you must select the Action page to select the posting action. Then the system validates the combo edits again and the combo edit error details appear in the grid.
After you review an explanation, click OK.
Correct the error for the pending item or correct some aspect of either your setup tables or your interface tables.
In most cases, you must correct your setup.
Use the Action page to select the posting action again.
Note. When you set the posting action, the online combo edit validation occurs, but Receivable Update does not run again as part of this process.
If more than one error exists, then the next error message appears. Otherwise, you return to the Error Correction page.
Error Messages
The edit updates statements that the Receivable Update multiprocess job executes. This table lists the conditions it edits. Use PeopleSoft Enterprise Application Designer to view the Receivable Update edit SQL that identified the error. This table provides a list of the error messages and a description of the action to take:
Value |
Error Code and Long Description |
1GBU |
Pending Item Group Business Unit Invalid Action: Verify that the group business unit used on the pending item has been created in PeopleSoft Receivables and PeopleSoft General Ledger. |
1PBU |
Pending Item Business Unit Invalid Action: Verify that the business unit used on the pending item has been created in PeopleSoft Receivables and PeopleSoft General Ledger. |
1CUST |
Customer does not exist Action: Verify that the customer exists on the General Info page. Verify that the customer's status is Active and the customer level is not set to Prospect. Also verify that the Bill to Customer field is selected on the Bill to Selection page. |
1DISP |
Dispute Reason Invalid Action: Verify the status and effective date of the dispute reason on the Dispute Reason page. |
1COLL |
Collection Code Invalid Action: Verify the status and effective date of the collection code on the Collection Code page. |
2SLS |
Salesperson Invalid Action: Verify that the default support team defined for this customer has a team member defined as a salesperson with a priority greater than zero. |
2CRD |
Credit Analyst Invalid Action: Verify the status and effective date of the credit analyst on the Credit Analyst page. |
2COLL |
Collector Invalid Action: Verify the status and effective date of the collector on the Collector page. |
3PYTR |
Payment Terms Invalid Action: Verify the status and effective date of the payment terms code on the Payment Terms page. |
3DST |
AR Distribution code Invalid Action: Verify the status of the distribution code on the Distribution Code page. |
4ENT |
Entry Type Invalid Action: Verify the status of the entry type on the Entry Type page. |
4ENR |
Entry Reason required Action: This entry type requires an entry reason. Enter an entry reason or deselect the Require Reason check box on the Item Entry Type - Selection page or Automatic Entry Type - Selection page. |
4ERI |
Entry Reason Invalid Action: Verify the status of the entry reason on the Entry Reason page. |
4ETS |
Entry amount Invalid for this Entry Type Action: Verify the entry amount for this entry type. Entry types require either positive or negative amounts based on the entry type. |
5ADIS |
Incorrect Value for Allow Discount Flag Action: The Always Allow Discount check box on Pending Item 1 page has an incorrect value. Please select or deselect the check box. |
5PSTD |
Incorrect Value for Posted Flag Action: This pending item is flagged as having already been posted. Contact Oracle/PeopleSoft Support. |
5SUBC |
SubCustomer Invalid Action: Verify that a subcustomer exists for this customer on the SubCustomer page. |
5SCI |
SubCustomer Use Invalid Action: Verify SubCustomer usage at the installation level setup. Specify that you use one or both subcustomer fields. |
6BCUR |
Customer Options Error Base Currency Invalid for Pending Item. Action: Verify that the base currency of the pending item equals business unit base currency. |
6CURI |
Entry Currency Invalid Action: The entry currency code must be active based on the pending item accounting date. Verify the status and effective date on the Currency Code page. |
6RTI |
Rate Type Invalid Action: Verify the rate type specified is valid for this multicurrency pending item. |
6RMDI |
Exchange Rates Missing Action: The currency exchange rate values RATE_MULT and RATE_DIV are missing on a multicurrency pending item. Contact Oracle/PeopleSoft Support. |
6CCUR |
Entry Currency Invalid Action: Verify that the pending item entry currency equals the group control currency. |
7VENT |
VAT Entity Missing Action: Verify that the VAT entity is populated for a VAT business unit. |
7VATM |
In-Use Cust Action: The customer is unavailable because it is being used by another background process. The process may be running or it may have terminated abnormally. |
8PTAX |
Sales Tax and Excise Duty Action: Verify pending tax information is correct on the pending item Group Entry Tax page. |
ACTPD |
Accounting Period Not Open Action: Verify in PeopleSoft General Ledger that the accounting period is open for the transaction type specified on Group Type page. Refer to the transaction type for the group type being posted. |
ACTOB |
Accounting Entries Out of Balance Action: Verify the accounting entry setup, for example: entry type, reason code definitions, item entry types, and automatic entry types. |
ALTAC |
Alternate Account Error Action: Verify whether the Alternate Account ChartField is missing or invalid for the item on the Correct Posting Errors, Accounting Entries page. |
COMBO |
Item(s) contain Combination Edit Errors Action: Verify the ChartField combination on the accounting lines is a valid combination. Modify the ChartField values online or modify the appropriate distribution code, item entry type or automatic entry type accounting template, or bank accounting entry setup. Alternatively, modify the combination editing rules. |
CRDR |
Entry Amount Error Action: A negative debit or positive credit has been entered. Credits must be less than zero and debits greater than zero. |
CURXI |
Currency Exchange Rate Invalid Action: Verify the pending item exchange rate. Pending item transactions for existing items must match the exchange rate of the original item. |
CUSOM |
Customer Options Missing Action: Verify that customer options have been defined, are active, and are properly effective dated for this customer and accounting date in the Customer - General Information component (CUSTOMER_GENERAL). |
DDPRF |
Direct Debit Profile Missing Action: Pending item has a payment method of direct debit but is missing a direct debit profile. Verify that a profile has been defined on the General Information - Bill To Options page for the customer. |
DOCSQ |
Document Sequencing Error Action: Document Sequencing has been enabled at the installation and general ledger business unit level. The accounting entries for this pending item are missing a document sequencing date. Verify document sequencing setup. |
INHRT |
Chartfield Inheritance Error Action: Verify that ChartField inheritance is setup is on the ChartField Inheritance page for the setIDs being edited. |
ITDUP |
Duplicate Item Action: This pending item is a duplicate of a pending item in another group that is being posted. If the Don't Post Duplicate Entries check box is selected on the Entry Type page, clear it, or delete the duplicate entry on the Pending Item 1 page. |
ITMIU |
In-Use Item Action: The item has been locked by another background process that is processing transactions for the same item. Please try again later after the other application completes. |
IECI |
Entry Currency Invalid Action: Verify that the pending item entry currency is the same as the existing item's balance currency. Any additional pending items for existing items must be entered in the item's balance currency. |
MCSI |
Multiple Entry Currencies for same Item Action: Verify that the pending items (for the same item in different groups) being posted share the same entry currency. |
OOBG |
Group Out of Balance Action: Verify the sum of the entry amounts equals the control amount, the total count of pending items in the group equals the control count, and the group status is balanced on the Group Control page. |
OOBM |
Maintenance Group Out of Balance Action: Verify that the sum of control base amount equals the control amount and the total count of pending items. |
OPITM |
Open Item Key Missing Action: The account in the AR line requires an open item key. Enter the open item key for the line. |
PCBU |
Invalid PC Business Unit for the Distribution Line GL Business Unit Action: Verify the PeopleSoft Project Costing business unit is valid for the general ledger business unit associated with the accounting lines. |
PMTRM |
Payment Terms Invalid Action: Verify status and effective date of payment terms on the Payment Terms page. |
PMTDI |
Default Payment Terms Invalid Action: Verify status and effective date of the default payment terms specified on the business unit and customer on the Payment Terms page. |
SALES |
Default Salesperson not defined Action: Verify that a default support team has been assigned to this customer. If so, verify that the support team has a team member defined as a salesperson with a priority greater than zero. |
VATID |
VAT Registration ID Invalid Action: Verify the VAT registration ID. |
Error Correction Components
PeopleSoft Receivables provides several components for correcting posting errors. The components all use the same pages, but they have a different search record to filter the groups that you select.
This table provides the navigation to each component, lists the pages in the component, and describes the usage for the component. The pages in these components are the same as the pages that you use to enter pending items.
Note. The pages that display tax information for India are
available only if you enabled sales tax and excise duty for a receivable business
unit type on the Business Unit Tax Applicability page.
This table provides the navigation for all the error correction components
and describes how to use them:
Menu Navigation |
Pages |
Usage |
Accounts Receivable, Receivables Update, Correct Posting Errors, Online Items |
|
Use to correct errors in online pending item groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, External Items |
|
Use to correct errors in pending item groups entered in another application. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Overdue Charge Items |
|
Use to correct pending items in overdue charge groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Worksheet |
|
Use to correct errors in maintenance worksheet groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Transfer |
|
Use to correct errors in transfer groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Unpost |
|
Use to correct errors in unpost groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Direct Debit |
|
Use to correct errors in direct debit groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Direct Debit Acctg Entries |
|
Use to correct errors in direct debit groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Draft |
|
Use to correct errors in draft groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Draft Accounting Entries |
|
Use to correct errors in draft groups. |
Accounts Receivable, Receivables Update, Correct Posting Errors, Payment |
|
Use to correct errors in payment worksheet groups. |
See Also
This section provides an overview of unposting and the unpost components, lists a prerequisite, and discusses how to:
Select groups to unpost.
Review group control information.
Specify unpost options.
Select an unpost action.
You can only unpost groups if the Receivable Update multiprocess job has successfully processed them. Unposting creates a new group that is the exact opposite of the original group. The unpost group creates a new unpost item activity and new accounting entries for each item that it is unposting.
If the Receivable Update multiprocess job has not run, groups for which you selected the Batch Standard or Batch Priority posting action are not actually posted. In that case, select the Do Not Post posting action on the Action page to prevent the groups from posting. You do not need to unpost the groups.
Unpost Components
PeopleSoft Receivables provides several components to unpost groups. The components all use the same pages with one exception (the control page for draft groups is different), but they have a different search record to filter the groups that you select based on the type of group. PeopleSoft Receivables also provides a page where you can search for groups based on a combination of group control information, item information, and ChartField values in the distribution lines.
This table provides the navigation to each component that filters groups by the type of group, lists the pages in the component, and describes the usage for the component:
Menu Navigation |
Pages |
Usage |
Accounts Receivable, Receivables Update, Unpost Groups, Online Group |
|
Unpost online pending item groups. |
Accounts Receivable, Receivables Update, Unpost Groups, External Group |
|
Unpost pending item groups from another application. |
Accounts Receivable, Receivables Update, Unpost Groups, Overdue Charge Group |
|
Unpost items in overdue charge groups. |
Accounts Receivable, Receivables Update, Unpost Groups, Maintenance Group |
|
Unpost maintenance groups. |
Accounts Receivable, Receivables Update, Unpost Groups, Transfer Group |
|
Unpost transfer groups. |
Accounts Receivable, Receivables Update, Unpost Groups, Pending Unpost Group |
|
Unpost an unpost group. |
Accounts Receivable, Receivables Update, Unpost Groups, Payment Group |
|
Unpost a payment group. |
Accounts Receivable, Receivables Update, Unpost Groups, Draft Group |
|
Unpost a draft group. |
Before you unpost groups, define reason codes for unpost groups if you want to assign unpost reasons to your unpost groups.
See Also
Setting Up Unpost Reason Codes
Page Name |
Definition Name |
Navigation |
Usage |
UNPOST_QRY |
Accounts Receivables, Receivables Update, Unpost Groups, Group Search for Unpost, UnPost Group Query |
Review groups that are posted based on a combination of search criteria and link to the appropriate unpost page. |
|
Payment Control |
GROUP_ENTRY1_DSP |
|
Review group control information, such as the group type, accounting date, group totals, and posting status. |
GRP_UPST_PNL |
Accounts Receivable, Receivables Update, Unpost Groups, Online Group, Options Several other navigation paths are available for this page. |
Specify a reason for unposting a group or change the accounting date. Define document sequencing options for the unpost group. |
|
UNPOST_ACTION |
Accounts Receivable, Receivables Update, Unpost Groups, Online Group, Action Several other navigation paths are available for this page. |
Select an action for an unpost group. |
|
DR_UNPOST_GRP |
Accounts Receivable, Receivables Update, Unpost Groups, Drafts Group, Draft Control |
Review group control information for a draft for a specific draft event. |
Access the UnPost Group Query page. (Accounts Receivables, Receivables Update, Unpost Groups, Group Search for Unpost, UnPost Group Query.)
Search Criteria
Enter any combination of search criteria to retrieve the groups to unpost, and click Search Groups for Unposting.
Group Unit, Group ID, Type, Origin ID, and Assigned |
Select fields from the group control record to identify groups. |
Date Type, Date Operand, and Date Query Value |
Select a type of date on the group control record. Values are: Accounting Date, Posted Date, and Entry Date. Select an operator to identify the date, such as < (less than) or Between, and enter a specific date or a date range. |
Customer, Item ID, and Entry Type |
Select a value for a customer, item ID, or entry type for the items in the group. |
Chartfield Type and Chartfield Value |
Enter the ChartField type and value to select groups that contain distribution lines for a specific ChartField value. |
Groups
The Groups grid displays the groups that match your search criteria.
|
Click the Show Group Detail button to access pages to view group control information, item details, and distribution lines. |
Unpost |
Click the Unpost link to access the appropriate unpost page for the group type, where you can unpost the group. |
Access the Group Control, Payment Control, or Draft Control page. (Accounts Receivable, Receivables Update, Unpost Groups, Online Group, Group Control, or Accounts Receivable, Receivables Update, Unpost Groups, Payment Group, Payment Control.)
Review the control information and group status.
Access the Options page. (Accounts Receivable, Receivables Update, Unpost Groups, Online Group, Options.)
Keep Original Document Type |
Select to use the document type of the original group. Deselect to use the default document type for the group type. This field is available only if you have enabled document sequencing. |
Unpost Reason |
Select an unpost reason code to indicate your purpose for unposting. Selecting this value is optional unless you selected the Enable Unpost Reason check box on the Installation Options – Receivables page. If you selected this check box, then you must select a reason code for this field. You can select a reason code, for example, to indicate that you are unposting a payment group because a check was returned due to insufficient funds. You can view the reason on the Item Activity and Payment Status pages. |
Edit Accounting Date |
Select if you want to change the Accounting Date field. The new accounting date must be in an open accounting period for the PeopleSoft Receivables business unit. Note. Overriding the accounting date changes the accounting date for the unposted payment. Also, the system issues a warning when you select the Edit Accounting Date check box and enter a date that precedes the original accounting date of the unposted payment group. |
Important! Overriding the accounting date for payment unpost groups uses the specified date for the unpost payment group and changes the accounting date for the payment (PS_PAYMENT.ACCOUNTING_DT) to the selected date. This accounting date is used for the subsequent payment application group.
See Also
Access the Unpost Action page. (Accounts Receivable, Receivables Update, Unpost Groups, Online Group, Action.).
Delete Unpost |
This option is available after you select a posting action. Click to delete the unpost group that you created. |
Action |
Select a posting action for the group and click OK to execute the action. Values are: Do Not Post: Saves the changes for the unpost group, but no posting takes place. Post Now: Runs the Receivable Update multiprocess job immediately. If the user enabled the notification feature, the system displays a message when the job completes. Post Now to GL: Runs the Receivable Update multiprocess job immediately and runs processes to create and post journals to the general ledger. If the user enabled the notification feature, the system displays a message when the job completes. Batch Priority: Runs the Receivable Update multiprocess job the next time a priority scheduled job runs or the next time a standard scheduled job runs, if that occurs first. This option is not intended for large jobs. Batch Standard: Runs the next time a standard scheduled batch jobs runs. This run may occur once a day, depending on how often the organization schedules standard jobs to run. Note. The posting options that are available depend on the options that you select for the user on the Define User Preferences - Process Group page. Use the Post Now and Post Now to GL options only for small groups or when a transaction must be posted immediately. The system issues a message if another user or scheduled process is posting transactions for the same business unit and customer combination at the same time. |
Review Unpost Now |
Click to display a page where you can review the details of the unpost group. This option is available after you select a posting action. |
This section provides an overview of the AR Rebate Notification process and lists the page used to run the Payment Notification process.
If your vendor rebate claims and reversals from PeopleSoft Purchasing or claimbacks from PeopleSoft Order Management interface with your system, you must update the balances for these claims in the claim management workbench in PeopleSoft Purchasing and PeopleSoft Order Management by running the AR Rebate Notification process. The process updates the Claims Incoming Payments staging table (VRBT_CLAIM_PMTI) when one of these activities occurs for claim items whose group type is R (vendor rebates) or C (claimbacks):
WS-01 (Pay an Item).
WS-08 (Create a Deduction).
WS-09 (Write off an Item).
DM-01 (Pay an Item).
DM-06 (Create a Deduction).
DM-07 (Write off an Item).
DD-XX (Any direct debit activity that changes the item's balance).
MT-01 (Create an Offset).
MT-02 (Write off a Credit).
MT-03 (Write off a Debit).
FC-01 (Create an Overdue Charge).
TR-01 (Transfer Item From Customer).
TR-03 (Transfer Item to Doubtful Receivable Account).
The process also updates the Claims Incoming Payments staging table when:
A draft or direct debit activity that paid for a claim item is voided or cancelled.
A payment or offset activity against a claim is unposted.
The process adds the following information to the Claims Incoming Payments staging table for each claim:
Claim setID.
Claim ID (item ID in PeopleSoft Receivables).
Payment date and time (post date for the activity in PeopleSoft Receivables).
Current payment method for the item in PeopleSoft Receivables.
Claim amount (amount of the payment or offset activity).
PeopleSoft Receivables sends the amount in the original currency of the claim item, which is the currency for the rebate agreement or the claimback contract. If a gain or loss occurs due to currency conversion (when the payment is in a different currency than the original claim item currency), the process includes the gain or loss in the amount.
Base amount (amount of the payment or offset activity less the VAT amount).
VAT amount (VAT amount of the payment or offset activity).
Agreement or contract currency code.
Document ID.
This user-defined reference value is entered on the maintenance, payment, or draft worksheet to help identify the claim in the claim management workbench.
The process also sets the Process Flag field to N and the value in the Process Instance field to the process instance that the Process Scheduler assigned to the run of the AR Rebate Notification process.
After the process completes, run the Incoming Payment Reconciliation Application Engine process (PO_CLMRECON) in PeopleSoft Purchasing or PeopleSoft Order Management to load the payment and offset activity in the Claims Incoming Payments staging tables into the claim management workbench.
See Also
PeopleSoft Purchasing and PeopleSoft Order Management Interface
Page Name |
Definition Name |
Navigation |
Usage |
REBATE_RUN_CNTL_AR |
Accounts Receivable, Receivable Update, Request Rebate Process, Receivables Rebate Notification |
Run the AR Rebate Notification process. |