Posting and Unposting Groups

This chapter provides an overview of posting and unposting and discusses how to:

Click to jump to parent topicUnderstanding Posting and Unposting

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:

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

Click to jump to top of pageClick to jump to parent topicPosting Process Flow

To post groups:

  1. Select a posting action for the group.

  2. Run Receivable Update.

    Check the message log to determine whether there are any warning or error messages.

  3. Review the posting results.

  4. Correct posting errors.

  5. (Optional) Unpost the groups to reverse the activity and the accounting entries, and start over.

  6. 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.

  7. 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

Generating Journal Entries

Click to jump to parent topicSetting Groups to Post

This section provides an overview of how to set groups to post and lists the pages used to set groups to post.

Click to jump to top of pageClick to jump to parent topicUnderstanding How 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 Group Action

Choosing a Worksheet Action

Selecting a Transfer Worksheet Action

Click to jump to top of pageClick to jump to parent topicPages Used to Set Groups to Post

Page Name

Definition Name

Navigation

Usage

Groups Not Set to Post

GROUP_NOT_POST_BU

  • Accounts Receivable, Pending Items, Review Items, Group Not Set To Post, Groups Not Set to Post

  • Accounts Receivable, Direct Debits, Review Direct Debits, Groups Not Set To Post, Groups Not Set to Post

  • Accounts Receivable, Drafts, Review Drafts, Groups Not Set To Post, Groups Not Set to Post

View groups whose posting action is Do Not Post.

Groups Set To 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.

Payments Set to Post

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.

Drafts Set to Post

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.

Direct Debits Set To Post

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

GROUP_STATUS

  • Accounts Receivable, Pending Items, Review Items, Group Status, Group Status

  • Accounts Receivable, Direct Debits, Review Direct Debits, Group Status, Group Status

  • Accounts Receivable, Drafts, Review Drafts, Group Status, Group Status

View the posting status and posting action of a group.

Click to jump to parent topicRunning Receivable Update

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:

See Also

Setting Up Parallel Processing

Click to jump to top of pageClick to jump to parent topicUnderstanding How to Restart or Reset Receivable Update

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 Application Engine run control record from the AERUNCONTROL table.

You should only unlock and reset under certain development circumstances or in expert testing environments:

Click to jump to top of pageClick to jump to parent topicPrerequisites

Before you can run the Receivable Update process, you must:

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 General Options

Defining PeopleSoft Receivables Processing Options

Setting Up History and Aging

Setting Up On-Demand Processing

Click to jump to top of pageClick to jump to parent topicPages Used to Run Receivable Update

Page Name

Definition Name

Navigation

Usage

Receivable Update Request

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.

See Setting Up Run Controls for Receivable Update.

Job Message Log Summary

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

  • PeopleTools, Process Scheduler, Process Monitor, Process List

  • Click Process Monitor on the Receivable Update Request page.

Review the multiple processes in a job.

Process Reset

AR_RESET

Accounts Receivable, Receivables Update, Reset Process, Process Reset

Reset the Receivable Update process. Unlock and rerun the process.

Click to jump to top of pageClick to jump to parent topicViewing the Job Message Log Summary

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.

Click to jump to top of pageClick to jump to parent topicRestarting the Receivable Update Multiprocess Job

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.

Click to jump to top of pageClick to jump to parent topicResetting the Receivable Update Multiprocess Job

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.

Click to jump to parent topicReviewing Posting Results

This section provides an overview of the posting result inquiry pages and lists the pages used to review posting results.

Click to jump to top of pageClick to jump to parent topicUnderstanding Posting Result Inquiry Pages

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

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • VAT Header

  • VAT Detail

  • (IND) Group Entry Tax Ds

  • Accounting Entries

Accounts Receivable, Receivables Update, Posting Results - Updated Items, All Items w/ Detail

Accounts Receivable, Receivables Update, Posting Results - Updated Items, Single Items w/ Detail

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • VAT Header

  • VAT Detail

  • Accounting Entries

Accounts Receivable, Receivables Update, Posting Results - Updated Items, All Items

Accounts Receivable, Receivables Update, Posting Results - Updated Items, Single Item

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

Accounts Receivable, Receivables Update, Posting Results - Direct Debits, All Items w/ Detail

Accounts Receivable, Receivables Update, Posting Results - Direct Debits, Single Items w/ Detail

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

Accounts Receivable, Receivables Update, Posting Results - Direct Debits, All Items

Accounts Receivable, Receivables Update, Posting Results - Direct Debits, Single Item

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

Accounts Receivable, Receivables Update, Posting Results - Drafts, All Items w/ Detail

Accounts Receivable, Receivables Update, Posting Results - Drafts, Single Items w/ Detail

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

Accounts Receivable, Receivables Update, Posting Results - Drafts, All Items

Accounts Receivable, Receivables Update, Posting Results - Drafts, Single Item

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

Accounts Receivable, Receivables Update, Posting Results - Payments, Item w/ Accounting Entries

Accounts Receivable, Receivables Update, Posting Results - Payments, Items w/ Accounting Entries

  • Payment Control

  • Payment 1

  • Payment 2

  • Payment 3

  • VAT Header

  • VAT Detail

  • Accounting Entries

Accounts Receivable, Receivables Update, Posting Results - Payments, Payment Group - Single Item

Accounts Receivable, Receivables Update, Posting Results - Payments, Payment Group - All Items

  • Payment Control

  • Payment 1

  • Payment 2

  • Payment 3

See Also

Entering or Updating Pending Items

Click to jump to top of pageClick to jump to parent topicPages Used to Review Posting Results

Page Name

Definition Name

Navigation

Usage

Control

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.

Pending Item 1 or Payment 1

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.

Pending Item 2 or Payment 2

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.

Pending Item 3 or Payment 3

GROUP_ENTRY2C_DSP

Accounts Receivable, Receivable Updates

Then, select the navigation to the appropriate component.

View user-defined fields.

VAT Header

GRP_ENT_VATHDR_DSP

Click the VAT Header link on the Pending Item 1 page.

View VAT header defaults.

VAT Detail

GRP_ENT_VAT_LN_DSP

Click the VAT Line link on the VAT Header page.

View VAT line defaults, including the VAT amounts.

Accounting Entries

GROUP_ENTRY3_DSP

Accounts Receivable, Receivable Updates

Then, select the navigation to the appropriate component.

View accounting entries for each item.

Group Entry Tax Ds

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.

Tax Detail

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.

Click to jump to parent topicCorrecting Posting Errors

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:

  1. Click the Error Info (error information) button to view a summary description of the error.

  2. 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.

  3. After you review an explanation, click OK.

  4. 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.

  5. 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 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.

CFINH

ChartField Inheritance Error

Action: Verify Chartfields marked as inherited do not have the same value across lines or do not match chart field values for existing lines for the same Item.

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.

DDPRM

Direct Debit Profile Invalid Error

ACTION: Pending Item has a payment method of direct debit but the direct debit profile indicated is invalid. Either add this direct debit profile to the direct debit profile table or change the indicated direct debit profile to a valid value. INACC - Inactive Account

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.

INACC

Inactive Account Error

Action: Change the inactive account by an active one or activate the inactive account.

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

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Group Entry Tax

  • VAT Header

  • VAT Detail

  • Accounting Entries

  • Group Action

Use to correct errors in online pending item groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, External Items

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Group Entry Tax

  • VAT Header

  • VAT Detail

  • Accounting Entries

  • Group Action

Use to correct errors in pending item groups entered in another application.

Accounts Receivable, Receivables Update, Correct Posting Errors, Overdue Charge Items

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

  • Group Action

Use to correct pending items in overdue charge groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Worksheet

  • Worksheet Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

  • Group Action

Use to correct errors in maintenance worksheet groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Transfer

  • Transfer Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

  • Group Action

Use to correct errors in transfer groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Unpost

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

  • Group Action

Use to correct errors in unpost groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Direct Debit

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

  • Group Action

Use to correct errors in direct debit groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Direct Debit Acctg Entries

  • Worksheet Control

  • Accounting Entries

Use to correct errors in direct debit groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Draft

  • Group Control

  • Pending Item 1

  • Pending Item 2

  • Pending Item 3

  • Accounting Entries

  • Group Action

Use to correct errors in draft groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Draft Accounting Entries

  • Worksheet Control

  • Accounting Entries

Use to correct errors in draft groups.

Accounts Receivable, Receivables Update, Correct Posting Errors, Payment

  • Payment Control

  • Payment 1

  • Payment 2

  • Payment 3

  • Accounting Entries

  • Payment Action

Use to correct errors in payment worksheet groups.

See Also

Entering Pending Items

Click to jump to parent topicUnposting Groups

This section provides an overview of unposting and the unpost components, lists a prerequisite, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Unposting and the Unpost Components

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

  • Group Control

  • Options

  • Action

Unpost online pending item groups.

Accounts Receivable, Receivables Update, Unpost Groups, External Group

  • Group Control

  • Options

  • Action

Unpost pending item groups from another application.

Accounts Receivable, Receivables Update, Unpost Groups, Overdue Charge Group

  • Group Control

  • Options

  • Action

Unpost items in overdue charge groups.

Accounts Receivable, Receivables Update, Unpost Groups, Maintenance Group

  • Group Control

  • Options

  • Action

Unpost maintenance groups.

Accounts Receivable, Receivables Update, Unpost Groups, Transfer Group

  • Group Control

  • Options

  • Action

Unpost transfer groups.

Accounts Receivable, Receivables Update, Unpost Groups, Pending Unpost Group

  • Group Control

  • Action

Unpost an unpost group.

Accounts Receivable, Receivables Update, Unpost Groups, Payment Group

  • Payment Control

  • Options

  • Action

Unpost a payment group.

Accounts Receivable, Receivables Update, Unpost Groups, Draft Group

  • Draft Control

  • Options

  • Action

Unpost a draft group.

Click to jump to top of pageClick to jump to parent topicPrerequisite

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

Click to jump to top of pageClick to jump to parent topicPages Used to Unpost Groups

Page Name

Definition Name

Navigation

Usage

UnPost Group Query

UNPOST_QRY

Accounts Receivable, 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.

Group Control,

Payment Control

GROUP_ENTRY1_DSP

  • Accounts Receivable, Receivables Update, Unpost Groups, Online Group, Group Control

  • Accounts Receivable, Receivables Update, Unpost Groups, Payment Group, Payment Control

  • Several other navigation paths are available for the Group Control page.

Review group control information, such as the group type, accounting date, group totals, and posting status.

Options

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

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.

Draft Control

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.

Click to jump to top of pageClick to jump to parent topicSelecting Groups to Unpost

Access the UnPost Group Query page (Accounts Receivable, 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.

Click to jump to top of pageClick to jump to parent topicReviewing Group Control Information

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.

Click to jump to top of pageClick to jump to parent topicSpecifying Unpost Options

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

Defining Document Types

Click to jump to top of pageClick to jump to parent topicSelecting an Unpost Action

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.

See Receivable Update Processing Options.

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.

Click to jump to parent topicRunning the AR Rebate Notification Process

This section provides an overview of the AR Rebate Notification process and lists the page used to run the Payment Notification process.

Click to jump to top of pageClick to jump to parent topicUnderstanding the AR Rebate 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):

The process also updates the Claims Incoming Payments staging table when:

The process adds the following information to the Claims Incoming Payments staging table for each claim:

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

Defining Entry Reasons

Understanding Vendor Rebates

Working with Claimbacks

Click to jump to top of pageClick to jump to parent topicPage Used to Run the AR Rebate Notification Process

Page Name

Definition Name

Navigation

Usage

Receivables Rebate Notification

REBATE_RUN_CNTL_AR

Accounts Receivable, Receivable Update, Request Rebate Process, Receivables Rebate Notification

Run the AR Rebate Notification process.