Maintaining and Reviewing Item Information

This chapter discusses how to:

Click to jump to parent topicChanging and Reviewing Item Information

This section provides an overview of item maintenance and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Item Maintenance

In PeopleSoft Receivables, maintenance items can be credit or debit memos, invoices, deductions, adjustments (generated when you process payments), on-account payments, or prepayments. The PeopleSoft Receivables item maintenance feature enables you to change open or closed items once they have been posted and does not create a group of pending items or change the customer's balance. The changes take effect immediately. You do not need to run the Receivable Update Application Engine process (ARUPDATE).

The View/Update Item Details component (ITEM_MAINTAIN) provides a central point to change details for individual items and to review all activities, all accounting entries, and all VAT lines for an item. You can also view and assign actions to an item.

See Also

Working with Actions on the Item Action List

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

If you want to track and review changes to fields on items on the Item Audit History page, select the fields on the Audit Control page.

See Also

Setting Up Item Audit Options

Click to jump to top of pageClick to jump to parent topicCommon Elements Used in This Section

Add a Conversation

Click to access the Conversations page, where you can enter a new conversation entry for the customer. The system populates the reference information with the item information.

Customer

Click the customer ID to access the General Info page for the customer.

View/Update Conversations

Click to access the Conversations page, where you can view or update an existing conversation entry for the item.

Click to jump to top of pageClick to jump to parent topicPages Used to Change and Review Item Information

Page Name

Object Name

Navigation

Usage

View/Update Item Details - Detail 1

ITEM_MAINTAIN

  • Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Detail 1

  • You also access this page from several pages by clicking a button or link for an item.

Change discount, payment, and draft options for an item. Put an item in dispute or collections, mark an item as a deduction, and assign item owners. Set the revaluation flag and make an item available for AR/AP netting.

View/Update Item Details - Detail 2

ITEM_MAINTAIN_2

Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Detail 2

Update item references and contact, shipping, and product information. Update information for the Receivables Due from Public report. View and change the memo status for the U.S. government.

AR Billing Inquiry

AR_BI_INQUIRY_B

  • Click the Detail link on the Detail 1 or Detail 2 page.

  • Accounts Receivable, Customer Accounts, Item Information, Item Billing Data, AR Billing Inquiry

Review details for an invoice in PeopleSoft Billing. The amounts are in the base currency. This page contains data only if you use PeopleSoft Billing.

Use the Go To field to access a page in the Bill Inquiry component (BI_INQUIRY) in PeopleSoft Billing.

AR BI Inq (EURO) (receivables billing inquiry)

AR_BI_INQUIRY_E

  • Click the Detail link on the Detail 1 or Detail 2 page and then click View in Euro Currency.

  • Accounts Receivable, Customer Accounts, Item Information, Item Billing Data, AR Billing Inquiry, and then click View in Euro Currency.

Review details for an invoice in PeopleSoft Billing. The amounts are in the euro currency. This page contains data only if you use PeopleSoft Billing.

Use the Go To field to access a page in the Bill Inquiry component in PeopleSoft Billing.

Bill Header - Note

AR_BI_HDR_NOTE_INQ

Click the Bill Header Notes link on the AR Billing Inquiry page or AR BI Inq (EURO) page.

View notes attached to the bill header for an invoice.

Bill Header - Bill To Address

AR_BI_HDR_ADDR_INQ

Click the Bill To Address link on the AR Billing Inquiry page or the AR BI Inq (EURO) page.

View address information for the customer and information about how the invoice was sent.

Bill Header - Projects Information

AR_BI_HDR_PC_INQ

Click the Bill Header - Project Info link on the AR Billing Inquiry page or the AR BI Inq (EURO) page.

View the PeopleSoft Project Costing transaction information on the bill header associated with the item line, including the source PeopleSoft Contracts information, the purchase order reference information, reimbursable agreement ID for contracts, and the start and end dates for the project activity.

View/Update Item Details - Detail 3

ITEM_MAINTAIN_3

Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Detail 3

Update user-defined fields.

Item Activity

ITEM_DATA2

  • Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Item Activity

  • You can also access this page by clicking a link on several pages.

Review all activity records for an item.

Item Activity From A Match Group

ITEM_SUB_GROUP

  • Click the link for the match group ID on the Item Activity page.

  • Accounts Receivable, Customer Accounts, Item Information, Match Group Activities, Item Activity From A Match Group

View all matched items in a match group from the maintenance worksheet or the Automatic Maintenance Application Engine process (AR_AUTOMNT) as well as the amounts matched.

Item VAT Entries

ITEM_DATA_VAT

Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Item VAT Entries

Review the VAT lines for an item. This page is available only if the item has VAT lines.

Item Accounting Entries

ITEM_DATA3

Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Item Accounting Entries

View the accounting entries for each item activity.

Item Audit History

ITEM_AUDIT

Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Item Audit History

View maintenance changes to items.

Click to jump to top of pageClick to jump to parent topicChanging Discount, Payment, and Draft Options and Customer Relationship Information

Access the View/Update Item Details - Detail 1 page.

You can change only field values that do not change the customer balance. The fields at the top of the page display information to identify the type of item and the item balance. If the item was entered in a currency that differs from the business unit base currency, the system displays the base currency amount and the rate type and exchange rate used for conversion.

Detail

Click to access the AR Billing Inquiry page, where you view the original invoice information. This link is available only if there is a valid PeopleSoft Billing business unit for the item which is associated with a valid invoice in PeopleSoft Billing.

Balance and Base

Displays the open amount for the item in the entry currency and the base currency. The base amount appears only if the balance differs from the base currency for the business unit.

Exchange Rate Detail

Click to view the information used in converting the item amount.

Original Amount

Displays the original amount of the item in the entry currency. This is the amount of the item before any payments, adjustments, or splits.

Discount Options

Due Date

Enter the date on which the item is due.

Terms

Select a payment term that defines the due date, discount days, and discount amount. If this field is blank, you can manually define the terms by entering values in the due and discount fields. If the item has payment terms, the Discount Amount and Date fields are unavailable.

Due Days

Enter the number of days beyond the due date during which the payment is still considered on time.

Discount Days (discount days)

Enter the number of days beyond the discount date during which the customer is still eligible to receive a discount.

Discount Amount, Date, Discount Amount 1, and Date 1

Enter user-defined amounts for discounts and dates from which to start counting the discount due date. The customer must pay by the discount due date to take an earned discount.

Always Allow Discount

Select to allow the discount on this item to be earned regardless of when the item is paid.

As of Date

Enter the date used to age the item.

Payment/Draft Options

Payment Method

Select a payment method from these values:

  • CHK (check)

  • DR (draft)

  • CC (credit card)

  • DD (direct debit)

  • EFT (electronic funds transfer)

  • GE (giro - EFT)

If you select draft, the draft fields become available. If you select direct debit, the Profile ID field becomes available.

If the payment method is direct debit, you cannot change the payment method if the item is selected on a direct debit worksheet, unless you do the following:

  1. Remit the direct debit.

  2. Run the Receivable Update process.

  3. Cancel the direct debit.

  4. Run the Receivable Update process.

Pay by Credit Card

Click to access the Credit Card Details page to begin credit card processing.

See Managing Credit Card Payments.

Draft Type

Select one of the draft types that you defined on the Draft Types page, which determines the draft processing options and what accounting entries to generate for the draft item.

Preapproved?

Select if the customer's drafts do not need to be sent to the customer for individual approval.

Create Document?

Select to include the item in the draft document prepared for the customer.

One Item Per Draft?

Select to have a separate draft for the item.

Direct Debit Profile ID

Enter the direct debit profile ID used to determine the direct debit processing rules for the item. The default value comes from the entry type for the item.

Customer Relations

Dispute, Reason, Date, and Dispute Amount

To put an item into dispute, select the Dispute check box and enter a dispute reason code, the date on which you put it in dispute, and the disputed amount. The default dispute date is the current date and the default amount is the item amount.

Deduction, Reason, and Date

To mark an item as a deduction, select the Deduction check box and enter the deduction reason and the date that you marked it as a deduction. If you created a deduction, using the payment or draft worksheet, the Deduction check box is unavailable.

Warning! If you mark an item as a deduction using the Deduction check box rather than creating a deduction (WS-08 item) using the payment worksheet, you do not generate any accounting entries or close the original item and create a new deduction item. Once you select this check box and save the page, you cannot clear your selection.

Doubtful

This check box is selected if you transferred the item to a Doubtful Receivables account using the transfer worksheet.

(USF) DMS Information (Debt Management Services information)

Click to access the Debt Management Services Information page, where you enter information for the debt management system.

See (USF) Referring Delinquent Items to the DMS.

Collection, Code, and Date

To put an item into collection, select the Collection check box and enter a collection code and the date you put it in collection. To put the entire customer into collection, use the Credit Profile page for the customer.

Analyst

Select the credit analyst who you want to manage this item. If you set up conditions for collection and exception processing to assign items to the credit analyst, this person is notified of actions that he or she must perform.

Collector

Select the collector who you want to manage this item. If you set up conditions for collection and exception processing to assign items to the collector, this person is notified of actions that he or she must perform.

Sales Person

Select the primary salesperson for the item. Salespeople are support team members whose support team type is Sales.

AR Specialist (receivables specialist)

Select the individual responsible for managing deductions and items in dispute. If you select the Dispute or Deduction check box, the system automatically populates this value with the specialist assigned to either the customer, deduction or dispute reason, or business unit.

Other Options

Revaluation Flag

Select to enable the Revaluation Application Engine process (AR_REVAL) to revalue the item. Clear the check box if you do not want the item to be revalued.

Available for Netting

By default, all items are available for netting—a process that offsets open items and vouchers, if you have PeopleSoft Payables and PeopleSoft Cash Management on your system. You must set up a participant agreement between the vendors and customers to net their items and vouchers. If you do not want an item to be selected in the netting process, clear the check box.

(USF) Transfer to IPAC Transactions (transfer to Intergovernmental Payment and Collection System transactions)

Click to access the IPAC Information page, where you enter information for the IPAC interface.

See (USF) Submitting Transactions Between Agencies Using the IPAC System.

Item Action

Click to access the Item Action page, where you view or add all actions associated with the item, assign action owners, and drill down to perform the action.

See Working with Actions on the Item Action List.

Click to jump to top of pageClick to jump to parent topicUpdating Reference, Contact, and Shipping Information

Access the View/Update Item Details - Detail 2 page.

Reference Information

Related Unit, Related Invoice, and Related Invoice Date

Enter the number of the related invoice associated with the item and the business unit associated with the invoice. Click Detail to access the AR Billing Inquiry page, where you view details about the invoice and PeopleSoft Project Costing Information. This link is available only if there is an invoice number in the Related Invoice field and the business unit and invoice number are a valid business unit and invoice in PeopleSoft Billing.

If you enter a value that matches an existing item ID, the system automatically populates the following fields with values associated with the item when you save the page: Bill of Lading, Order Number, Purchase Order, Contract Number, Promotion, Claim Number, Sold To, Ship To, and User.

Note. The Related Invoice field for a deduction created on the payment or draft worksheet is blank if the value in the Document field does not match the item ID for another item in PeopleSoft Receivables. If it does match, it contains the item ID for the original item.

Document

Displays the document ID that you entered when you created the item. Override the value if needed.

Note. If this is a deduction created using the payment or draft worksheet, it is the item ID of the original invoice for which the customer took the deduction.

OM Business Unit and Order Number

Enter the number of the sales order associated with the item and the business unit associated with the order. Click Detail to access the Order Summary page, where you view details about the order. This link is available only if there is an order number in the Order Number field and a business unit in the OM Unit field, and if you have installed PeopleSoft Order Management.

Claim Number and Claim Date

Enter the debit memo number that the customer sent you for a deduction and the date on which the customer created it.

Purchase Order and Contract

Enter the purchase order number and contract number associated with the original invoice.

Click the Detail link for a contract to access the Contract Summary page, where you see summarized details for a contract and drill down to contract details. This link is available only if there is a valid contract number and you have installed PeopleSoft Contracts on your system.

Note. If this is a deduction created on the payment or draft worksheet, it is the purchase order and contract number associated with the original invoice for which the customer took the deduction.

You can change only the order number, purchase order number, and contract number for debit and credit (IT-01 and IT-02) items, if you enabled entry on the Receivables Options - General 2 page.

Promotion Code and Merchandising Type

Select the identifiers that you assigned to the promotion deal and for the merchandising activity for the promotion in your promotion application. Associate the codes with an invoice in your billing application. If you use PeopleSoft Promotions Management, set up customer promotions and assign a merchandising type using the Customer Promotions component (TD_PROMO_MAINT). If you manually write off a deduction for a promotion instead of matching it to a credit memo for the promotion, you must enter the promotion code and merchandising activity for the deduction, so that you can track activity for the promotion in PeopleSoft Promotions Management.

Click Detail to access the Promotional Activity component (TD_PROMO_STATUS) in PeopleSoft Promotions Management, where you can view all activity against a promotion, including payments made, invoices, shipments, credit memos created, and deductions written off. The link is available only if you have installed PeopleSoft Promotions Management on your system and if you have a valid promotion code.

See Viewing Promotional Activity.

Letter of Credit (letter of credit ID)

Displays the letter of credit ID for the item.

Reference Reason

Enter an additional entry reason assigned for the item. The reason is used for custom reports and inquiries. It does not generate accounting entries.

(USF) Entity Code and Receivable Type

Select the information required for the Receivables Due from the Public report.

See (USF) Generating the Receivables Due From the Public Report.

(NLD) AG Number (acceptgiro reference number)

Displays the acceptgiro reference number assigned to the item or invoice when you ran the Statements process (AR_STMTS) or the AR Dunning process (AR_DUNNING) for business units enabled for acceptgiro processing. It also displays the acceptgiro reference number assigned to the invoice when you printed the invoice in PeopleSoft Billing.

Note. Each time that you run the Statements process or the AR Dunning process, the system overwrites the reference number if the item is included on a new statement or dunning letter. So, it is possible that the bank could pay for the item using a different reference number.

Contacts and Shipping Information

Sales Person 2

Enter the code for the secondary sales person associated with the item.

Broker

Enter the code for the individual who negotiated a promotion deal. A broker is a customer to whom you assigned the broker role on the General Info page.

Ship From Site

Enter the original business unit for the sales order. If you have PeopleSoft Enterprise Inventory, enter an inventory business unit. The business unit should represent a warehouse.

Sold To Customer and Ship To Customer

Enter the ship to and sold to customer IDs.

Carrier ID

Enter the unique identifier for the shipping carrier. Enter one of the values that you defined on the Carrier ID page.

Proof of Delivery

Enter a proof of delivery slip number.

Bill of Lading

Enter the bill of lading number for the shipment.

(USF) Memo Status Code

Click the Detail link to enter the current memo status or view historical status changes on the Memo Status Changes page. This option is available only if you enabled it on the Installation Options - Receivables page.

Product Information

Family

Select an identifier that defines inventory items at a high level. Examples include computer items and office furniture.

Class

Enter a code for a group of customers in a trade, such as grocers or mass merchandisers.

Trade

Enter the type of industry market, such as groceries, hardware, or appliances.

Division

Enter a geographic area within an organization.

See Also

(USF) Tracking Memo Status Changes

Click to jump to top of pageClick to jump to parent topicUpdating User-Defined Information

Access the View/Update Item Details - Detail 3 page.

PeopleSoft Receivables provides 22 fields in the Item table (PS_ITEM) that you can use to track company- or industry-specific information that is not predefined in the Item table, such as shipment date. You define the value to use for each of the fields, and you can specify what to use for the field label.

Click to jump to top of pageClick to jump to parent topicReviewing Item Activity

Access the Item Activity page.

Each time that you perform an action to an item, such as transferring it to another customer, applying a payment, or unposting it, the Receivable Update process updates the Item Activity table (PS_ITEM_ACTIVITY). The Item Activities scroll area displays each activity record in the table.

Refund Detail

Click to access the Refund Status page, where you view information for a refund voucher that was created by PeopleSoft Payables. This field is not available if you have not refunded the item and created a voucher in PeopleSoft Payables.

Entry Type and Reason

Displays the type of activity. The system uses the entry type and reason to generate accounting entries.

Worksheet Reason

Displays an additional reason assigned to all items in a maintenance group to further identify the reason for the activity. This reason does not generate accounting entries. You define maintenance reasons on the Worksheet Reason page.

Unpost Reason

Displays the reason code that you specified for unposting the item's group. You define unpost reason codes on the Unpost Reason page.

Group Unit and Group ID

Displays the business unit for the group, the group ID, and the type of group—billing, payment, maintenance, transfer, overdue charge, unpost, direct debit, draft, vendor rebate, or claimback.

Click the link for the group to open the Item Activity From A Group page, where you view the activities for all items in the group.

Match Group ID

Displays the identifier for a match group on the maintenance worksheet or that the Automatic Maintenance process assigned. A match group is a group of items that you are matching where the total of the debits equals the total of the credits.

Click the link for the match group to open the Item Activity for a Match Group page, where you view all of the items in the match group associated with the item activity record.

Deposit Unit, Deposit ID, and Payment ID

Displays the identifier for a deposit and payment and the deposit business unit for a payment activity.

Click the link for the payment to open the Item Activity for a Payment page, where you view items that were paid by a single payment after the payment was processed by the Receivable Update process.

Draft Unit and Draft ID

Displays the identifier for a draft and the draft business unit for a draft activity.

Direct Debit Business Unit and Direct Debit ID

Displays the identifier for a direct debit and the business unit for a direct debit activity.

Click to jump to top of pageClick to jump to parent topicReviewing Item Activity for a Match Group

Access the Item Activity From A Match Group page.

The Item Activities grid displays all of the items in the match group for a specific maintenance activity.

Display Amount Switch

Specify whether you want to view amounts in the entry currency or the base currency.

Item ID

Click the link to access the View/Update Item Details component, where you view detailed information about the item.

Entry Type and Entry Reason

Identifies the type of activity and reason associated with each item. These determine the accounting entries that were generated. The entry types are always MT (maintenance), MD (new debit), MC (new credit), WO (write-off debit), or WOC (write-off credit).

Entry Amount and Entry Currency

Displays the amount and currency of the item that was matched.

Click to jump to top of pageClick to jump to parent topicReviewing VAT Entries

Access the Item VAT Entries page.

The Item Activity scroll area displays the VAT information for the item for each activity. The Entry Type field identifies the type of activity. The VAT Lines grid displays the VAT information for each item line.

Intermediate VAT

Displays the VAT amounts for a future declaration point. These amounts are not reported to the government.

Final VAT

Displays the VAT amounts ready to be reported to the government.

VAT Basis

Displays the amount of the item on which the VAT is calculated.

Error Flag

Appears if the discrepancy between the invoice and the amount the system calculates exceeds the tolerance level defined by the Percent and VAT amount.

Click to jump to top of pageClick to jump to parent topicReviewing Item Accounting Entries

Access the Item Accounting Entries page.

The Item Activity scroll area displays all of the accounting entries for each activity for the item. The Entry Type field identifies the type of activity. The Accounting Lines grid displays the ChartField values for each line.

Accounting Line Display

Specify which accounting entries to display, and then click Display. Values are: Standard, Supplemental (Entry Event), or Both. Supplemental accounting entries are available only if you entered an entry event code for the pending item, payment item, or maintenance item. These options are available only if you enable the entry event feature for PeopleSoft Receivables on the Installation Options - Entry Event page.

Debit Amount and Credit Amount

The item amount appears unless you enabled the Display Separate Debit/Credit in Subsystem option on the User Preferences - Overall page. Otherwise, the debit and credit amount and currency appear for each accounting line.

See Also

Creating and Reviewing Accounting Entries Online

Click to jump to top of pageClick to jump to parent topicReviewing Audit History for an Item

Access the Item Audit History page.

The page displays one row for each change to the item.

Field Changed, Previous Value, and Updated Value

Displays the name of the field, the original value, and the new value after the change.

User ID

Displays the individual who made the change. If the Mass Change Application Engine process (AR_MASS_CHANGE) made the change, the field displays the user ID of the person who created the run control request.

Source of Change

Displays the source of the change. Values are:

Item Maintenance: A change entered using the View/Update Item Details component.

Multi-item Update: A change entered online using the Multi-item Update option on the Item List page.

Batch Mass Change: A change generated by the Mass Change process.

Click to jump to parent topicSplitting Exception Items

This section provides an overview of item splitting and discusses how to split an item.

Click to jump to top of pageClick to jump to parent topicUnderstanding Item Splitting

You can split a deduction item or a disputed item into multiple items. This function is useful when a customer is disputing only part of an invoice, or when a customer has taken a deduction for multiple reasons and you want to track the reasons separately. If you use PeopleSoft Promotions Management, you must create a separate deduction for each merchandising type for the promotion. Use the split feature to split the deduction and assign a separate merchandising type to each item.

When you split an item, the system creates a new item using either the Create a Debit (MT-04) or Create a Credit (MT-05) automatic entry type for the split item in the Pending Item table (PS_PENDING_ITEM). The new item uses the original item ID and the next available line number. The system creates a maintenance group, containing the original item and the new split item, that is set to post. You must run the Receivable Update process to create the new line for split items and reduce the balance for the original line item. You can choose to run the process immediately from the Item Split page or in a scheduled job.

Note. We recommend that you create a unique entry reason for the Create a Debit and Create a Credit entry types to easily identify split items.

Click to jump to top of pageClick to jump to parent topicPages Used to Split Items

Page Name

Object Name

Navigation

Usage

Item Split

ITEM_SPLIT

  • Accounts Receivable, Customer Accounts, Item Information, Item Split, Item Split

  • Click the Split link of the Detail 1 page.

Split an exception item into multiple lines.

Item in Other Groups

ITEM_MGROUP_SEC

Click the Item in Other Groups link on the Item Split page.

View other worksheet groups that have the item selected or any pending item groups that are not posted that include the item.

Click to jump to top of pageClick to jump to parent topicSplitting an Item

Access the Item Split page.

Current Item Balance

Displays the open amount of the item before you split it.

The Original and Split Item(s) grid displays all of the lines for the item, including the original line item.

Add

Click to add a new row for a split item and enter the amount of the split item.

Item ID

Displays the original item ID.

Item Line

Each time that you click the Add button, the system adds a new line for the split item and assigns the next available line number.

The system also populates the other fields with the values for the previous item in the list. You can change all of these values except the currency. The system assigns today's date for the accounting date and the as of date.

Open Amount

Enter the amount that you want to split.

The system adjusts the open amount of the original line each time that you add a new line. For example, if you are splitting a 1,000.00 deduction and the new deduction will be 200.00, the open amount of the original deduction line changes to 800.00.

Entry Reason

Enter a new value, if you want a different entry reason on the split item for reporting purposes or to generate different accounting entries.

Due Date

Enter the date on which the split item becomes past due.

Deduction Reason

For a deduction, enter the reason for the split item.

Dispute Reason

For an item in dispute, enter the reason that the item is in dispute.

Promotion Code and Merchandising Type

Enter the merchandising type and promotion code associated with a promotion deal for a deduction. This ensures that the promotion fund is updated properly when you offset a deduction.

AR Specialist

Enter a new value, if you want a different AR specialist to manage and track the item.

Action

Select a posting action for the split items, and then click OK.

Do Not Post: Saves the changes to the group, but no posting occurs. Select this option to change the posting option for a group set to Batch Standard, if the group has not been processed yet.

Post Now: Runs the Receivable Update process immediately, updates the item balances, and creates the accounting entries.

Batch Standard: Runs the Receivable Update process the next time that a standard scheduled batch jobs runs.

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 option only for small groups or when there is an immediate need to post the transaction. 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. If you run the processes immediately and have enabled the notification feature for the user, the system displays a message when the process completes.

Worksheet Business Unit and Worksheet ID

Displays the business unit for the maintenance group and the maintenance worksheet ID that the system assigns to the group. These values appear after you select an action and click OK.

Items in Other Groups

Click to open the Items in Other Groups page, where you view worksheet groups that contain the item or any pending item groups that contain the item that are not posted. This link is available only if the item is selected in a worksheet or is in a pending item group. To split an item in another group, you must clear the item selection in the worksheet.

Click to jump to parent topicUpdating Multiple Items

This section provides an overview of the multiple-item update options and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Multiple-Item Update Options

PeopleSoft Receivables provides two methods for changing field values on multiple items simultaneously:

This feature is useful, for example, when an AR specialist leaves the organization or moves to a new position within the organization and you need to reassign all of the AR specialist's deductions and disputed items to another person.

You can change field values for the following fields for selected items on the Item List page, or you can change these field values in the Pending Item table (PS_PENDING_ITEM) or Item table (PS_ITEM) when you run the Mass Change process. When you run the Mass Change process, you limit the items whose field values you are changing to a specific business unit, customer group, or customer:

When you run the Mass Change process, you can also:

You can change field values only for open items (items with an open balance). If you have enabled audit history for these fields, the system updates the Audit History table (PS_ITEM_AUDIT).

Click to jump to top of pageClick to jump to parent topicPages Used to Update Multiple Items

Page Name

Object Name

Navigation

Usage

Item List

ITEM_LIST

Accounts Receivable, Customer Accounts, Item Information, Item List, Item List

Select the items whose field values you want to change.

Multi-item Update

AR_MASS_CHNG_SEC

Select Multi-Item Update in the Item Action group box, on the Item List page and then click Go.

Select the fields whose values you want to change, and enter the new values.

Mass Change

MASS_CHANGE_RUN

Accounts Receivable, Customer Accounts, Item Information, Mass Change Process, Mass Change

Enter run parameters for the Mass Change process, select the fields whose values you want to change, enter new values, and select the tables to update from PeopleSoft Receivables, PeopleSoft Billing, and customer tables.

Click to jump to top of pageClick to jump to parent topicChanging Field Values for Selected Items

Access the Item List page.

To change field values for action owners, collection reasons (codes), exception reasons, due date, payment method, and payment terms for selected items:

  1. Enter search criteria to populate the item list.

  2. Select the items whose field values you want to change.

  3. Select Multi-item Update in the Item Action group box and click Go to access the Multi-item Update page.

  4. Select the fields whose values you want to change for the selected items.

  5. Enter the new value for each selected field in the To field.

See Also

Reviewing Item Information

Click to jump to top of pageClick to jump to parent topicRunning the Mass Change Process

Access the Mass Change page.

Run Request Parameters

Specify whether you want to limit fields to items associated with a specific business unit, customer group, and customer ID.

Fields to Update

Select the fields whose values you want to change.

From

Enter the current field value.

To

Enter the new field value.

Data To Update

Open AR Posted Items

Select to update the fields for open items in the Item table.

Unposted AR Items

Select to update the fields for items in the Pending Item table, if the Posted Flag field is N or if the Posted Flag is Y and the item status in the Item table is Open.

Bill To Customer Options

Select to update records in the Customer Options table.

PeopleSoft Billing

Select to update records in the Billing Header table, if the bill status is not INV, FNL, or CAN.

Count Only

Select to run the process without updating any records. A count of the number of records to be updated appears in the message log.

Click to jump to parent topicAdding a Reference Reason to a Posted Item

If you want to associate additional reference reasons with an item for reporting or inquiry purposes, you can add additional codes after you post the item.

This section discusses hot to add a reference reason to an item.

Click to jump to top of pageClick to jump to parent topicPage Used to Add an Reference Reason to a Posted Item

Page Name

Object Name

Navigation

Usage

Reason Maintenance

REF_REASON_CHNG

Accounts Receivable, Customer Accounts, Item Information, Update Reference Reason, Reason Maintenance

Assign an additional reference reason to posted items, including items that the system creates for on-account payments, adjustments, and deductions on payment worksheets.

Click to jump to top of pageClick to jump to parent topicAdding a Reference Reason to an Item

Access the Reason Maintenance page.

Enter search criteria for the items that you want to display on the page, and enter your sort criteria.

Add a Conversation

Click to add a conversation entry for the customer.

Search

Click to display items matching your search criteria and to sort the item list.

Ref Reason (reference reason)

Enter the additional reference reason for each item.

View

Click to access the Item Activity page and view activity for the item.