Click the Document Sequencing button to select the sequencing value for documents that you create online.

If working with multiple currencies, click the Disp Curr Conversion Worksheet (display currency conversion worksheet) button to change the display currency and specify whether to use today's date, the accounting date, or the date that you specify to determine which exchange rate to use.

Click the View Related Links button to view additional links.

Transfer Selection

TRN_IDENTIFY

Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Create Worksheet, Worksheet Selection

Build a customer business unit or transfer worksheet.

Worksheet1

TRN_WORKSHEET1

• Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Update Worksheet, Worksheet 1

• Click the Build button on the Transfer Selection page.

Indicate the to customer or business unit that receives the items.

Currency Conversion

EU_CUR_CNV_WS_SEC

Click the Disp Curr Conversion Worksheet(Display Currency Conversion Worksheet) button on the Worksheet1 page.

Select the currency code, rate, and date of conversion for the display currency on the worksheet.

Control Distribution ID

AR_TRN_DST_CTL_SEC

Click the Control Distribution ID link on the Worksheet1 page.

Override the control distribution code that defines the control accounts receivable (AR) account.

Worksheet2

TRN_WORKSHEET2

• Click the Build button on the Transfer Selection page.

• Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Update Worksheet, Worksheet 2 tab.

Review or modify information about the items that you are transferring.

Additional Item Information

TRN_WRKSHT_EXT

Click the View Related Links button on the Worksheet1 page or the Worksheet2 page.

Display additional information for an item.

Item Activity Detail

ITEM_ACTIVTY_DRILL

Click the View Related Links button on the Worksheet1 page or the Worksheet2 page.

View item activities.

Items in Other Groups

ITEM_GROUP_SEC

Click the Related Links button on the Worksheet1 page or the Worksheet2 page.

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

Conversations

CONVER_DATA1_SS

Click the Related Links button on the Worksheet1 page or the Worksheet2 page.

Update or add conversation entries for the item.

Additional Customer Information

CUST_INFO_SEC

Click the Related Links button on the Worksheet1 page or the Worksheet2 page.

Display customer information for an item.

Transfer Action

TRN_ACTION

Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Finalize Worksheet, Transfer Action

Select a posting action for a worksheet. Also use this page to delete a worksheet, create accounting entries online for the worksheets, or delete accounting entries.

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.

Note. Remember that the GL account and ChartFields assigned to the Transfer Control Distribution code must exist in this from business unit.

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 what type of items to include in the worksheet. If you select All Items, you can select one or more of these check boxes to exclude those item types from the worksheet: Exclude Deduction Items, Exclude Collection Items, and Exclude Dispute Items.

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.

Note. Remember that the GL account and ChartFields assigned to the Transfer Control Distribution code must exist in this transfer from business unit.

Range Select

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

Note. If you select an item that is in use, you may receive an error message. A field on the Installation Options - Receivables page, No Mult Pending Item Selection, determines whether the system checks groups to verify that an unposted pending item exists for the item that you selected or that the item has been selected in another group. To verify where the item is in use, select Items in Other Groups using the related links button for the item.

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 Disp Curr Conversion Worksheet (display currency conversion worksheet) button 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.

Note. To add all of another customers' open items to the scroll, as opposed to a single item, click the Worksheet Selection link to add a customer ID to the customer reference and rebuild the worksheet.

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.

Analyst, Sales, Collector, and AR Specialist

If the To customer has different support personnel assigned, enter the code for the credit analyst, sales person, collector, or AR specialist.

Dist ID AR (distribution ID receivables)

Enter a new AR distribution code to use different ChartField values for the AR line from the values for the original transfer from item. Otherwise, the system uses the same ChartField values as the original transaction.

Family

If the To customer is assigned to a different family of inventory items, enter the new family.

Broker ID, Ship To, Sold To, or Location

If the bill to customer for the from customer is associated with a different broker, ship to customer, location, or sold to customer from the to customer, enter the correct values for the to customer.

Delete Worksheet

Click to delete the entire worksheet, plus any accounting entries that were created for the worksheet.

Delete Transfer Group

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

Action

Select a posting action for the group, and click OK to perform the action. Values are:

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

Note. When you select Do Not Post, the Business Unit and the Customer fields become available for entry on the Transfer Worksheet, Worksheet 1 page.

Post Now: Runs the Receivable Update process immediately. If the user enabled the notification feature, the system displays a message when the process finishes.

Post Now to GL: Runs the Receivable Update process 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 process finishes.

Batch Priority: Runs the Receivable Update process 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 job runs. This may occur once a day depending on how often the organization schedules standard jobs.

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

Important! When you select the Post Now, Post Now to GL, Batch Priority, and Batch Standard values in the Action field, the Business Unit and Customer fields on the Transfer Worksheet, Worksheet 1 page are no longer available for entry.

When you select the Do Not Post value, the Business Unit and Customer fields become available for entry on the Worksheet 1 page.

See Receivable Update Processing Options.

OK

Click if you selected Post Now or Post Now to GL to run the batch processes.

Create/Review Entries

Click to create or review accounting entries. Use this option only if you need to review the accounting entries before posting.

Worksheet Selection

TRN_IDENTIFY

Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Create Worksheet, Worksheet Selection

Create a new worksheet or add items to a transfer worksheet.

Worksheet1

TRN_WORKSHEET1

Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Update Worksheet, Worksheet1

Select the items to transfer.

Control Distribution ID

AR_TRN_DST_CTL_SEC

Click the Control Distribution ID link on the Worksheet1 page.

Override the control distribution code that defines the control AR account.

Worksheet2

TRN_WORKSHEET2

Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Update Worksheet, Worksheet2

Override the default doubtful receivable distribution code.

Transfer Action

TRN_ACTION

Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Finalize Worksheet, Transfer Action

Select a posting action for a worksheet. Also use this page to delete a worksheet, create accounting entries online for the worksheets, or delete accounting entries.

Build Doubtful

Click to build a worksheet that transfers a doubtful item to a Doubtful Receivables account.

Sel (select)

Select the items to transfer to a doubtful account within the same customer ID and business unit.

Click the Customer Hold button to place a customer on hold. When you click this button, you automatically access the Messages page, where you can create a customer message using a hold code.

Dist ID AR (receivables distribution code)

Override the default distribution code for doubtful receivables that was assigned to the business unit, if necessary. Otherwise, the system uses the same ChartField values as the original transaction.

Transfer Control

GROUP_ENTRY1_DSP

• Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Update Accounting Entries, Transfer Control

• Accounts Receivable, Receivables Update, Correct Posting Errors, Transfer, Transfer Control

Review control totals for a transfer group.

Accounting Entries

GROUP_ENTRY3_DSP

• Accounts Receivable, Receivables Maintenance, Transfer Worksheet, Update Accounting Entries, Accounting Entries

• Accounts Receivable, Receivables Update, Correct Posting Errors, Transfer, Accounting Entries

Review and correct errors for accounting entries in a maintenance group.

See Creating and Reviewing Accounting Entries Online.