Creating Using and Posting a Transfer Worksheet Concept

Creating, Using, and Posting a Transfer Worksheet Concept

Creating, Using, and Posting a Transfer Worksheet

Creating, Using, and Posting a Transfer Worksheet Step 1 Begin by navigating to the Transfer Selection page. Click the vertical scrollbar.

Creating, Using, and Posting a Transfer Worksheet Step 2 Click the Accounts Receivable menu.

Creating, Using, and Posting a Transfer Worksheet Step 3 Click the Receivables Maintenance menu.

Creating, Using, and Posting a Transfer Worksheet Step 4 Click the Transfer Worksheet menu.

Creating, Using, and Posting a Transfer Worksheet Step 5 Click the Create Worksheet menu.

Creating, Using, and Posting a Transfer Worksheet Step 6 Click the Add a New Value tab.

Creating, Using, and Posting a Transfer Worksheet Step 7 Enter the desired information into the Transfer Business Unit field. Enter "US 003".

Creating, Using, and Posting a Transfer Worksheet Step 8 Click the Add button.

Creating, Using, and Posting a Transfer Worksheet Step 9 Use the Transfer Selection page to create a new worksheet or add items to a transfer worksheet.

Creating, Using, and Posting a Transfer Worksheet Step 10 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. Click the Customer Criteria list.

Creating, Using, and Posting a Transfer Worksheet Step 11 Click the Customer Items list item.

Creating, Using, and Posting a Transfer Worksheet Step 12 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 Sub. Customer Qualifier 1 and Sub. Customer Qualifier 2 pages, enter the qualifiers to narrow the results of the worksheet. Click in the Cust ID field.

Creating, Using, and Posting a Transfer Worksheet Step 13 Enter the desired information into the Cust ID field. Enter "USA 03".

Creating, Using, and Posting a Transfer Worksheet Step 14 Click in the Business Unit field.

Creating, Using, and Posting a Transfer Worksheet Step 15 Enter the desired information into the Business Unit field. Enter "US 003".

Creating, Using, and Posting a Transfer Worksheet Step 16 From the Reference Criteria list, select an option to restrict reference criteria to search for only a Range of References, Specific Values, or None. If you decide to enter only reference options, the worksheet contains items matching the references. Click the Reference Criteria list.

Creating, Using, and Posting a Transfer Worksheet Step 17 Click the Specific Value list item.

Creating, Using, and Posting a Transfer Worksheet Step 18 From the Restrict to list, select All Customers, Corporate Cust Only, Customer Only, or Remit Cust Only. Accept All Customers.

Creating, Using, and Posting a Transfer Worksheet Step 19 If you selected Specific Value or Range of References in the Reference Criteria list, specify the match type for the item information in the Match Rule list. Values are Exact Match or 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 x 24 x. Accept the Exact Match list item.

Creating, Using, and Posting a Transfer Worksheet Step 20 In the Item Inclusion Options section, you can select an option to indicate the type of items to include in the worksheet.

Creating, Using, and Posting a Transfer Worksheet Step 21 Click the Advanced Inclusion Options link.

Creating, Using, and Posting a Transfer Worksheet Step 22 On the Filter Items page, you can create, edit, and save selection criteria for items to include in the worksheet. Filter by owner type, reference data, item type, balances, and dates.

Creating, Using, and Posting a Transfer Worksheet Step 23 Click the vertical scrollbar.

Creating, Using, and Posting a Transfer Worksheet Step 24 Click the Cancel button.

Creating, Using, and Posting a Transfer Worksheet Step 25 Click the Build button to build a worksheet that transfers items to another customer or business unit. Click the Build button.

Creating, Using, and Posting a Transfer Worksheet Step 26 Use the Worksheet 1 page to indicate the transfer to customer or business unit that receives the items.

Creating, Using, and Posting a Transfer Worksheet Step 27 Enter the business unit and customer ID for the transfer to customer. If the customer has subcustomers, the system displays information about Sub. Customer 1 and Sub. Customer 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 Sub. Customer 1 and Sub. Customer 2 qualifiers. Click in the Business Unit field.

Creating, Using, and Posting a Transfer Worksheet Step 28 Enter the Transfer to business unit. Enter the desired information into the Business Unit field. Enter "US 003".

Creating, Using, and Posting a Transfer Worksheet Step 29 Click in the Customer field.

Creating, Using, and Posting a Transfer Worksheet Step 30 Enter the Transfer to customer. Enter the desired information into the Customer field. Enter "USA 10".

Creating, Using, and Posting a Transfer Worksheet Step 31 To select items, you can use the Range Select field to select multiple rows. Enter a range of items, such as items 4 to 7 and click the Go button.

Creating, Using, and Posting a Transfer Worksheet Step 32 You can also use the Display list to select a value to limit the display of items in the list, such as All Items, Selected, or Unselected.

Creating, Using, and Posting a Transfer Worksheet Step 33 The Remit Seq sequence 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.

Creating, Using, and Posting a Transfer Worksheet Step 34 Click the View All link.

Creating, Using, and Posting a Transfer Worksheet Step 35 Click the vertical scrollbar.

Creating, Using, and Posting a Transfer Worksheet Step 36 Click the Sel option.

Creating, Using, and Posting a Transfer Worksheet Step 37 Click the Save button.

Creating, Using, and Posting a Transfer Worksheet Step 38 Click the Worksheet Action link.

Creating, Using, and Posting a Transfer Worksheet Step 39 Use the Finalize Worksheet page to select a posting action for a worksheet. Also use this page to delete a worksheet, create accounting entries online for the worksheets, or to delete accounting entries.

Creating, Using, and Posting a Transfer Worksheet Step 40 Select a posting action for the group and click OK to execute 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. • Post Now: Runs the Receivable Update process immediately. If the user enabled the notification feature, the system displays a message when the process completes. • 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 completes.

Creating, Using, and Posting a Transfer Worksheet Step 41 Select a posting action for the group and click OK to execute the action. Values are: • 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.

Creating, Using, and Posting a Transfer Worksheet Step 42 Click the Action list.

Creating, Using, and Posting a Transfer Worksheet Step 43 Click the Post Now list item.

Creating, Using, and Posting a Transfer Worksheet Step 44 Click the OK button if you selected Post Now or Post Now to GL to run the batch processes. Click the OK button.

Creating, Using, and Posting a Transfer Worksheet Step 45 You have used the Post Now posting action, which runs Receivables Update processing immediately. To finish processing posting actions other than Post Now or Post Now to GL, you must navigate to the Receivable Update Request page to run the Receivable Update process for business unit US 003.

Creating, Using, and Posting a Transfer Worksheet Step 46 You have successfully created, used, and posted a transfer worksheet. End of Procedure.