Transferring Items to Another Customer or Business Unit

Customer Criteria

Select the type of customer items that you want to display on the worksheet. Values are:

Corporate Items: Displays corporate items only.

Customer Items: Displays all customer items only.

Remit From Items: Displays remit from items only.

None: The system creates a blank worksheet.

Cust ID (customer ID), Business Unit, SubCustomer 1, and SubCustomer 2

Enter the customer's ID and the business unit to construct a worksheet for a specific customer. If the customer has subcustomers that were set up on the SubCustomer Qualifier 1 and SubCustomer Qualifier 2 pages, enter the qualifiers to narrow the worksheet display even further.

Reference Criteria

Select an option to restrict reference criteria to search for only a Range of References, Specific Values, or no values (None). If you decide to enter only reference options, the worksheet contains items matching the references.

Restrict to

Select All Customers, Corporate Cust Only, Customer Only, or Remit Cust Only.

Match Rule

If you selected Specific Value or Range of References in the Reference Criteria field, specify the match type for the item information. Values are Exact Match and Like Match. A like match enables you to use a specific reference and range for reference values to identify the reference, as long as you provide the beginning letters or numbers, not characters from the middle. For example, if you enter a purchase order (PO) number of 24%, and select Like Match, the worksheet contains all items with PO numbers beginning with 24, but does not catch a PO number of x24x.

Reference and Range for Reference Value

If you selected Specific Value in the Reference Criteria field, enter the reference value in the Reference field.

If you selected Range of References in the Reference Criteria field, enter from and to values, with the to value always greater than the from value.

The values that you enter are case-sensitive.

Qual Code (qualifier code)

Select from the reference criteria that were set up on the Reference Qualifier page. Items can be identified by any reference such as PO, item ID, or document number.

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 Collection Items, Exclude Deduction 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.

Build

Click to build a worksheet that transfers items to another customer or business unit.

Clear

Click to clear all items from the existing worksheet.

Business Unit and Customer

Enter the business unit and customer ID of the transfer to customer. If the customer has subcustomers, the system displays information about subcustomer 1 and subcustomer 2 in the remaining two fields. If you selected the Subcustomer Qualifier option for the system and have set them up for the customer, you can perform intracustomer transfers by changing the subcustomer 1 and subcustomer 2 qualifiers.

Range Select

Enter a range of items, such as items 4 to 7, to select multiple rows, and click Go.

Display

Select a value to limit the display of items in the list, such as All Items, Selected, or Unselected, and click Go.

Click the Currency Conversion Panel 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 which exchange rate to use.

Sort All

Select an option to sort all the items in the worksheet, not just the items that appear in the scroll area. Sort items by due date or item ID.

The page displays the selected rows that currently appear in the list. 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. You should use a maximum chunk size of 100 rows, although larger chunks might perform satisfactorily.

These fields and buttons are not available if the number of rows does not exceed the maximum chunk size.

Remit Seq (remit sequence)

This number relates to the order in which the items were entered on the Worksheet Selection page. Initially, the items appear in this order. If you sort the worksheet based on the value in another column, the number stays with the item, but the grid order changes. Use this column to sort the worksheet in the original order.

Sel (select)

Select the items to transfer.

Add Item

Click to add a new item to the worksheet and specify the business unit, customer ID, and item ID.

Beg Amount (beginning amount), Beg Count (beginning count), Rem Amount (remaining amount), Rem Count (remaining count), Sel Amount (selected amount), and Sel Count (selected count)

Displays balance information, which is updated whenever you select an item and save or refresh the worksheet.