Creating Credit Card Payments Using the Credit Card Worksheet

Page Name

Definition Name

Usage

Credit Card Worksheet Selection Page

PAYMENT_IDENT_IC

Create a new worksheet, modify an existing one, and select items to include in the worksheet.

Change Deposit Unit Page

AR_CHANGEBU_SEC

Change the deposit unit for the credit card worksheet.

See the Credit Card Worksheet Selection Page.

Credit Card Details Page

AR_CRCARD_DETAILS

View or modify the customer's credit card details and settle a credit card transaction.

See the Credit Card Worksheet Selection Page.

Exchange Rate Detail Page

AR_EXCH_RT_DTL

View or modify the exchange rate.

See the Credit Card Worksheet Selection Page.

Document Sequence Page

AR_DOC_SEQ_SEC

Enter a document sequence number if the document type is set up for manual numbering. Also, change the document type for document sequencing.

See the Credit Card Worksheet Selection Page.

Detail Reference Information Page

PAYMENT_REF_DET2

Create deductions, pay or write off all or part of an item, and create on-account or prepayments without first building the worksheet.

See the Credit Card Worksheet Selection Page.

Items NOT open on ITEM table Page

PAYMENT_REF_DET3

Display items that are not open in the Item table (PS_ITEM). List items that are selected on the Detail Reference page but were already paid or do not exist in the Item table to determine whether to delete items on the Detail Reference Information page.

See the Credit Card Worksheet Selection Page.

Filter Items Page

WS_ITEMSRCH_SEC

Enter advanced selection criteria for items to include in the worksheet.

See the Credit Card Worksheet Selection Page.

Credit Card Worksheet Application Page

PAYMENT_WS_IC

Select items for payment by credit card.

Currency Conversion Page

EU_CUR_CNV_WS_SEC

Select the currency code, rate, and date of conversion for the display currency on the worksheet. The values you enter determine the currency and amount for the Conversion Amount - Currency field.

See theCredit Card Worksheet Application Page.

Worksheet Application Detail View Page

PAYMENT_WS_IC_DTL

View or update details about a selected item on a worksheet or copy, write off, or edit items.

Currency Exchange Aid Page

CURR_EXCHG_AID_SEC

Use as an aid in converting the payment amount to the currency of a selected item making a partial payment.

See the Worksheet Application Detail View Page.

VAT Header Page

PAYM_ITEM_VAT_HDR

View VAT header defaults, and manually override values, if applicable.

See the Worksheet Application Detail View Page.

VAT Detail Page

PAYM_ITEM_VAT_LN

View VAT line defaults, including VAT amounts. Manually override values if applicable. If the VAT declaration is at the accounting date, then the user cannot modify it.

Item Activity Detail Page

ITEM_ACTIVITY_DRILL

View all activities for an item.

See the Worksheet Application Detail View Page.

Item in Other Groups Page

ITEM_PGROUP_SEC

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

See the Worksheet Application Detail View Page.

Additional Customer Information Page

CUST_INFO_SEC

View additional customer information.

See the Worksheet Application Detail View Page.

Credit Card Worksheet Action Page

PAYMENT_ACTION_IC

Select posting options for the payment applied on the credit card worksheet, including entry events.

Credit card worksheets enable you to select existing PeopleSoft Receivables items and pay them by credit card. Credit card worksheets are created during credit card batch processing, when items are paid by credit card from inquiries and when they are built directly through the credit card worksheet pages.

Credit card worksheets populate the same tables as payment worksheets.

The credit card worksheet components behave differently depending on whether or not the credit card payment has been authorized and settled. Before settlement, use the credit card worksheet to select items that make up the amount to be authorized and settled. After the credit card payment has been settled, unposting the payment enables you to use the credit card worksheet to apply the payment to items in the same way you would use a payment worksheet.

Working with a credit card worksheet consists of these high-level steps:

  1. Use the Credit Card Worksheet Selection page to select the items that you want to work with and build the worksheet.

    If you add items to an existing worksheet, the system adds the new items that you selected and does not delete any selected items that are already on the worksheet.

  2. Use the Credit Card Worksheet Application page to select items to pay by credit card.

  3. Use the Credit Card Worksheet Action page to select a posting action for the worksheet or to create accounting entries online.

    You can also delete the worksheet, that is, remove the items from the worksheet, or you can save your work and complete the worksheet later.

Enabled Write-Off Functionality on the Credit Card Worksheet

  • If you enable Write Off (WO) in the system and the credit card worksheet contains line amounts with a Payment Type of PY (payment) and one with WO (write off) and the write off requires approval, then this enables the Submit to Workflow link on the Action page and disables the Pay by Credit Card link. Once the write off is approved, this enables the Pay by Credit Card link on the Action page and disables the Posting Action field. After the credit card is settled, this enables the Posting Action field.

  • If you enable Write Off (WO) in the system and the credit card worksheet contains a line amount with the Payment Type of PY and no write off amount, this enables the Pay by Credit Card Link field on the Action page and disables the Posting Action field. Once the credit card is settled, this enables the Posting Action field.

This documentation discusses how to:

  • Build a credit card worksheet.

  • Use the credit card worksheet to select items to pay by credit card.

  • View and update item details.

  • Select a credit card worksheet action.

Use the Credit Card Worksheet Selection page (PAYMENT_IDENT_IC) to create a new worksheet, modify an existing one, and select items to include in the worksheet.

Navigation:

Accounts Receivable > Credit Cards > Credit Cards Worksheet > Credit Card Worksheet Selection

This example illustrates the fields and controls on the Credit Card Worksheet Selection page. You can find definitions for the fields and controls later on this page.

Credit Card Worksheet Selection page

Field or Control

Description

Change Unit

Click to change the deposit unit. This button is only visible if no payment items exist.

Credit Card Details

Click to access the Credit Card Details page.

Exchange Rate Detail

Click to access the Exchange Rate Detail page. You can change this information if no payment items exist and the currencies are different.

Customer Criteria and Reference Criteria

The information that you enter about customers and items determines the information that appears on the worksheet. The more information you provide, the more focused your worksheet will be. For example:

  • If you enter only customer information, the worksheet will list all open items for the customer.

  • If you enter only item information, the worksheet will list all open items that match your item criteria for all customers.

  • If you enter both customer and item information, the worksheet will list all the open items that match the customer and item criteria that you select.

Note: If you enter no customer or item information, the system will create a blank worksheet.

Customer Criteria

Field or Control

Description

Customer Criteria

Select the type of customer that you want to include in the worksheet from these values: Corporate Items, Customer Items, or Remit From Items. If you select None, the system creates a worksheet based on other selection criteria, and it does not limit items to specific customers. You can also select None and enter a customer ID and business unit. In this case, the system uses the customer reference criteria in conjunction with the item reference criteria to select only items that match both criteria.

Customer ID and Business Unit

Enter the customer ID and business unit.

Note: If you select Corporate Items or Remit From Items in the Customer Criteria field, you must enter a business unit. The system needs a business unit to determine the SetID of corporate customers and remit-from customers. The resulting worksheet displays all open items with the specified corporate or remit-from customer across all business units, not just the business unit that you select.

Reference Criteria

Field or Control

Description

Reference Criteria

Specify whether you will use a Specific Value, None, or a Range of References. If you select either Range of References or Specific Value, you enter information in the Item Reference fields.

If you click the Detail Reference link to enter reference information, the Reference Criteria field displays Detailed References.

Restrict to

Select to qualify items by customer. Values are All Customers, Corporate Cust Only, Customer Only, and Remit Cust Only.

Match Rule

If you select Specific Value in the Reference Criteria field, specify whether the item information is an Exact Match or a Like Match. A Like Match enables you to use a percent (%) wildcard to identify the reference, as long as you provide the beginning letters or numbers. For example, if you enter a purchase order number of 24% and select Like Match, the worksheet will contain all items with purchase order numbers beginning with 24xx, but it will not include a purchase order number of x24x.

Note: Like Match is not available for reference qualifiers that equate to numeric fields, such as statement IDs, and accept giro numbers.

Reference and To Reference

Enter one of the following:

  • If you selected Specific Value in the Reference Criteria field, enter the specific item reference.

  • If you selected Range of References, enter the starting and ending values for the range of references.

    The values that you enter are case-sensitive.

Qual Code (qualifier code)

Enter the type of reference, such as documents, items, purchase orders, or any other criteria that you set up on the Reference Qualifier page.

Detail Reference

Click to access the Detail Reference Information page, where you enter a list of items to which you are applying the credit card payment. This page works like a worksheet, enabling you to enter items quickly and specify the payment amount and enter some of the available entry types for processing the items.

Item Inclusion Options

Field or Control

Description

All Items , Deduction Items Only, or Items in Dispute Only

Select one of these options to indicate the type of items to include in the worksheet.

Exclude Deduction Items, Exclude Collection Items , and Exclude Dispute Items

If you select All Items, you can also select one or more of the check boxes to exclude collection, deduction, and dispute items.

Advanced Inclusion Options

Click this link to access the Filter Items secondary page (WS_ITEMSRCH_SEC), where you can create, edit, and save selection criteria for items to include in the worksheet. You can filter items using values in the following categories:

  • Item Selection Criteria - Enter the owner value by type, such as AR Specialist, Credit Analyst, Broker ID, Collector, and Sales Person.

  • Reference Data - Enter order-to-cash reference values, such as Item ID, Item Entry Type, Entry Reason, Invoice, Order Number, Document ID, Proof of Delivery, Bill of Lading, Purchase Order, PO Line, Claim Number, Contract, Promotion Code, Service Purchase ID, Sold To Customer, and Ship To Customer.

  • Item Type - Enter values including Collection Code, Deduction Reason and Date, and Dispute Reason and Date.

  • Balances - Select the Balance Currency.

  • Dates - Select items for the worksheet based on Accounting or Due Dates.

Worksheet Action

Field or Control

Description

Build

Click to create a new worksheet or to add items meeting your selection criteria to an existing worksheet.

Clear

Click to remove all items from an existing worksheet.

Use the Credit Card Worksheet Application page (PAYMENT_WS_IC) to select items for payment by credit card.

Navigation:

Accounts Receivable > Credit Cards > Update Credit Card Worksheet > Credit Card Worksheet Application

This example illustrates the fields and controls on the Credit Card Worksheet Application page. You can find definitions for the fields and controls later on this page.

Credit Card Worksheet Application page

To use the credit card worksheet, follow these high-level steps:

  1. Use the item display or sort controls to adjust the view.

  2. Select the items to pay.

  3. Manage underpayments and discounts.

    Overpayments are not allowed on credit card worksheets that have not been authorized and settled.

  4. Check the information in the Credit Card Paymentgroup box to verify the amount of the credit card payment based on the selected items.

Field or Control

Description

Payment Accounting Date

Displays the accounting date for the payment activity.

Item Action

The Item Action group box enables you to select a specific entry type and entry reason to apply to the items that appear in the Item List grid.

Field or Control

Description

Entry Type and Reason

Select the entry type for the activity that you want to perform for the selected items. You must enter a valid entry reason in the Reason field if you specified that entry reasons are required when you set up the entry type that you entered in the Entry Type field.

Note: If you select an item that is in use, you get an error message. To see where the item is used, select Items in Other Groups on the Worksheet Application Detail View page for the item.

Row Selection

Use the Row Selection group box fields to determine whether the Sel (select) check box is selected or not selected in the Item Display grid based on a selected Choice.

Field or Control

Description

Choice

Select one of these values to select or deselect the Sel (select) check box for the rows that appear in the Item List grid.

  • De-Select All Discounts

    Select this value to clear the Sel (select) check box for all rows with discounts in the Item List grid.

  • De-Select All Items

    Select this value to clear the Sel (select) check box for all item rows in the Item List grid.

  • De-Select Range of Discounts

    Select this value to clear the Sel (select) check box for a range of discount rows in the Item List grid that you enter in the Range field.

  • De-Select Range of Items

    Select this value to clear the Sel (select) check box for a range of item rows in the Item List grid that you enter in the Range field.

  • Select All Discounts

    Select this value to add a check mark in the Sel (select) check box for all rows with discounts in the Item List grid.

  • Select All Items

    Select this value to add a check mark in the Sel (select) check box for all item rows in the Item List grid.

  • Select Range of Discounts

    Select this value to add a check mark in the Sel (select) check box for a range of discount rows in the Item List grid that you enter in the Range field.

  • Select Range of Items

    Select this value to add a check mark in the Sel (select) check box for a range of item rows in the Item List grid that you enter in the Range field.

Go

Click this button to apply your selection to the Item List grid and to update worksheet balances.

Item Display Control

Use the fields in the Item Display Control group box to adjust the view and contents of the Item List grid.

Field or Control

Description

Display

Select one of these values to display all of the items in the Item List grid or to modify the appearance of items in the Item List grid:

  • All Items

    Displays all items in the Item List grid.

  • Blank

    Displays a blank row in the Item List grid.

  • New Items

    Displays only new items in the Item List grid.

  • Other

    Displays items that are not new in the Item List grid.

  • Selected

    Displays items for which the Sel check box is selected in the Item List grid.

  • Unselected

    Displays items for which the Sel check box is not selected.

Go

Click to refresh the list of items in the grid.

Display Currency Conversion Worksheet icon

Click the Display Currency Conversion Worksheet icon to access the Currency Conversion page, where you select a display currency for the Conversion Amount - Currency column and specify whether to use today's date, the accounting date for the item, or a date that you specify to determine the exchange rate to use.

Row Sorting

Use the Row Sorting group box to sort the rows that appear in the Item List grid based on the value that you specify. This feature sorts all items in the worksheet, not just the items that appear in the scroll area.

Click the arrows to view different chunks of data. For better performance, you can limit the number of rows that appear in the scroll area on the Installation Options - Receivables page. Oracle recommends a maximum chunk size of 100 rows, although larger chunks may perform satisfactorily.

Field or Control

Description

Sort All By

Click the drop-down arrow to select one of these sort values:

  • Clear Highlights

    Select this value and click the Go button.

    The system removes the red highlights from the rows. The display order that you saw when the Highlight Duplicate option was selected does not change when you clear the highlighting.

  • Due Date

    Select this value and click the Go button.

    All items in the payment worksheet are sorted based on their due date.

  • Highlight Duplicate

    Select this value and click the Go button.

    The system checks for any changes that occurred to the worksheet since the last time it was saved. If changes were made, the system issues an error message, which requests the user to save the worksheet. If the system locates duplicate items, the system highlights the duplicate items in red.

    The system also considers the option that you selected in the Item Display Control group box. For example, you select Selected from the Display drop-down list, select Highlight Duplicate from the Sort By drop-down list, and click the Go button. The system checks for duplicates on the worksheet based on the selected item, highlights the duplicate rows in red, and ignores the unselected items.

    Before highlighting the duplicate rows, the system compares these fields on the worksheet:

    • Pay Amt (payment amount)

    • Cur (currency)

    • Item ID

    • Item Line

    • Unit

    • Customer

    • Type

    • Reason

    • Event

    • Disc Amt (discount amount)

  • Item

    Select this value and click the Go button.

    The system sorts all of the items on the payment worksheet based on the order that you enter the items on the Payment Worksheet page.

Item Summary Information

Use the Customize link to sort by column and to reorder, hide, and freeze columns. This functionality enables you to put the key fields that you want to review on the Detail 1 tab and sort your data.

The Item List summary information detail tabs are identical to the Item List grid summary information detail tabs described in the topics about applying payments.

See Reviewing Item List Detail 1 Summary Information.

Field or Control

Description

View Detail icon

Click the View Detail icon to view or update details for a selected item on a worksheet and to copy or write off the item.

Add with Detail

Click to add an item to handle underpayments and write-offs. If a new item was created in error, clear the item by clearing the Sel (select) column or delete the item.

Revenue Distribution

Click to manually distribute amounts for control budgets across multiple revenue lines if you are making a partial payment. This link is available only if you have enabled commitment control processing and you have enabled input of multiple revenue lines for the business unit.

Credit Card Details

Click this link to access the Credit Card Details page.

See Credit Card Details Page.

Add Conversation

Click this link to access Accounts Receivable > Conversations > View/Update Conversations and add a new conversation or update a conversation to associate with this payment.

See Reviewing Conversations and Promises.

View/Update Conversations

Click this link to view or update an existing conversation.

Reviewing Credit Card Payment or Balance Information

As you select open items, you need to check the information in the Credit Card Payment group box. The system updates the amounts whenever you click the Refresh button.

The Credit Card Payment group box is renamed to Balance after you authorize and settle the credit card transaction. The region then behaves in the same manner as the Balance region of the Payment worksheet.

Handling Exact Payments

Select items that you want to pay for by credit card. If a customer has no items in the worksheet, you can still put a payment on account or treat it as a prepayment.

Handling Underpayments

To create an underpayment, do one of the following:

  • Treat the entire amount as a partial payment against an item, and then change the amount for the item to the amount of the credit card payment.

  • Pay off the item and create an adjustment or a deduction item for the difference between the item amount and the payment amount by creating a new item and entering a positive amount for the difference.

    For deductions, enter the item ID of the paid item as the document ID for the new deduction on the Worksheet Application Detail View page. This action ties the purchase order number, bill of lading, and document information for the referenced item to the new deduction. Regular deductions create new items in the system. The Deduction Due Date field on the Receivables Options - Payment Options page, enables you to determine whether the due date of the new item is the payment accounting date or the due date of an existing item. If you specify that the due date is from an existing item, you must enter the item ID of the existing item as the document ID on the Worksheet Application Detail View page. After the Receivables Update process runs, the new deduction appears in the system.

  • Place the entire amount on account (without referencing any items) by creating a new item and entering a negative amount for the amount of the payment.

    Do not use the same item ID for the on account item as an existing item. If you want the on account item to be associated with an existing item, either add a prefix or suffix to the ID, or use the same item ID with a different line number.

  • Partially pay for an item and write off the remaining item balance by selecting the split item and changing the entry type to WO.

    Important! If the item is a rebate claim that originated in PeopleSoft Purchasing or a claimback that originated in PeopleSoft Order Management, do not write off the remaining balance. Use the Claims Management Workbench in PeopleSoft Purchasing or PeopleSoft Order Management to handle write-offs so that the system can determine whether the write-offs meet the write-off tolerances for claim processing.

    See Understanding Vendor Rebates.

    See Understanding PeopleSoft Claimbacks.

Use the Worksheet Application Detail View page (PAYMENT_WS_IC_DTL) to view or update details about a selected item on a worksheet or copy, write off, or edit items.

Navigation:

Click the View Detail button on the Credit Card Worksheet Application page.

This example illustrates the fields and controls on the Worksheet Application Detail View page. You can find definitions for the fields and controls later on this page.

Worksheet Application Detail View page accessed from the Credit Cards component

View item details to identify an item or change the details.

Field or Control

Description

Deduction Reason

If you are creating a new deduction, enter the reason why the customer took the deduction. You define reason codes on the Deduction Reason page.

AR Specialist (accounts receivable specialist)

The system populates the AR Specialist field for deduction items based on the default specialist that you assigned to the business unit. If you overrode the default specialist for the deduction reason or customer, the system uses that value.

Document

If you enter a value that matches an existing item ID, the system automatically populates the Bill of Lading, Order No (order number), PO Ref (purchase order reference), Contract # (contract number), Letter of Credit ID, and Due Date fields with the value for the existing item when you save or refresh the page. If you receive different information for these fields with the payment, override those values.

If you are creating a payment for a vendor rebate claim item or claimback item that you interfaced from PeopleSoft Purchasing or PeopleSoft Order Management, you must enter a reference ID. When you run the Rebate Notification process, it sends the reference ID to PeopleSoft Purchasing and PeopleSoft Order Management for use in reconciling the claims on the claims management workbench.

This field is available for entering existing items only if you enter entry reasons on the AR Integration page.

Location

Enter the address sequence number for new items. You must enter a value in this field to include the item in correspondence if you selected the Item Address option for the correspondence customer on the Correspondence Options page.

Copy

Click to copy the item and add a new row to the worksheet. You must add the amount and entry type to the new row.

Write Off

For a new item, click to write off an underpayment amount.

Dispute

Click to access the Dispute Status Tracking page and view dispute status information for an item.

This link appears only when dispute tracking data exists for the item.

Note: To save your changes on this page, return to the Worksheet Application page.

Dispute Status Tracking Page

Use the Dispute Status Tracking page (ITEM_DISP_T) to view dispute status information for an item.

This example illustrates the fields and controls on the Dispute Status Tracking page.

Dispute Status Tracking page

Use the Credit Card Worksheet Action page (PAYMENT_ACTION_IC) to select posting options for the payment applied on the credit card worksheet, including entry events.

Navigation:

Accounts Receivable > Credit Cards > Finalize Credit Card Worksheet > Credit Card Worksheet Action

Click the Worksheet Action link on the Credit Card Worksheet Selection page or the Worksheet Application page.

Field or Control

Description

Delete Worksheet

Click to delete the entire worksheet, plus any accounting entries created for the worksheet. If the associated credit card transaction has not been settled, the entire payment is deleted, releasing any items selected on the worksheet. If the associated credit card transaction has been settled, the payment is not deleted, but items selected on the worksheet are released. The settled payment must be unposted before the Delete Worksheet button becomes available.

Delete Payment Group

Click to delete the accounting entries that you create but leave the worksheet intact.

Pay by Credit Card

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

Action

Select a posting action for the group and click OK to execute the action.

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 the 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 Receivables Update Processing Options.

See Understanding Credit Card Processing.

Create/Review Entries

Click to create or review accounting entries. Use this option only if you need to review or modify the accounting entries. Otherwise, use one of the posting actions to create the accounting entries.

Note: If the worksheet does not have a zero balance but you need to stop working with the worksheet, save your work and select Do Not Post for the posting action.