Using Worksheet Application Concept Using Worksheet Application Using

  • Slides: 32
Download presentation
Using Worksheet Application Concept

Using Worksheet Application Concept

Using Worksheet Application

Using Worksheet Application

Using Worksheet Application Step 1 Begin by navigating to the Worksheet Selection page. Click

Using Worksheet Application Step 1 Begin by navigating to the Worksheet Selection page. Click the Scroll Down arrow.

Using Worksheet Application Step 2 Click the Accounts Receivable menu.

Using Worksheet Application Step 2 Click the Accounts Receivable menu.

Using Worksheet Application Step 3 Click the Receivables Maintenance menu.

Using Worksheet Application Step 3 Click the Receivables Maintenance menu.

Using Worksheet Application Step 4 Click the Maintenance Worksheet menu.

Using Worksheet Application Step 4 Click the Maintenance Worksheet menu.

Using Worksheet Application Step 5 Click the Create Worksheet menu.

Using Worksheet Application Step 5 Click the Create Worksheet menu.

Using Worksheet Application Step 6 Click the Add a New Value tab.

Using Worksheet Application Step 6 Click the Add a New Value tab.

Using Worksheet Application Step 7 Enter the desired information into the Worksheet Business Unit

Using Worksheet Application Step 7 Enter the desired information into the Worksheet Business Unit field. Enter "US 003".

Using Worksheet Application Step 8 Click the Add button.

Using Worksheet Application Step 8 Click the Add button.

Using Worksheet Application Step 9 Use the Worksheet Selection page to build a new

Using Worksheet Application Step 9 Use the Worksheet Selection page to build a new worksheet or to modify an existing one.

Using Worksheet Application Step 10 Use the Customer Criteria field to select the type

Using Worksheet Application Step 10 Use the Customer Criteria field to select the type of customer that you want to include in your worksheet. For this scenario, keep the default value.

Using Worksheet Application Step 11 Click in the Cust ID field.

Using Worksheet Application Step 11 Click in the Cust ID field.

Using Worksheet Application Step 12 Enter the desired information into the Cust ID field.

Using Worksheet Application Step 12 Enter the desired information into the Cust ID field. Enter "USA 06".

Using Worksheet Application Step 13 Click the vertical scrollbar.

Using Worksheet Application Step 13 Click the vertical scrollbar.

Using Worksheet Application Step 14 Use the Build button to create a new worksheet

Using Worksheet Application Step 14 Use the Build button to create a new worksheet or add items that meet your selection criteria to an existing worksheet. Click the Build button.

Using Worksheet Application Step 15 Use the Worksheet Application page to select the items

Using Worksheet Application Step 15 Use the Worksheet Application page to select the items to which payments will be applied.

Using Worksheet Application Step 16 Use the Sel option to select the items that

Using Worksheet Application Step 16 Use the Sel option to select the items that will be matched to the payment. In this example, to close open items, we are matching two payments with existing items having item balances of 3515. 10 and -3800. When you refresh, after selecting these two items, the net value is -284. 90. Click the Sel option.

Using Worksheet Application Step 17 Click the horizontal scrollbar.

Using Worksheet Application Step 17 Click the horizontal scrollbar.

Using Worksheet Application Step 18 You can view 8 rows at a time using

Using Worksheet Application Step 18 You can view 8 rows at a time using the grid navigation, or click the View All link to view all rows on one page. In this example, we want to view the last 8 rows. Click the Last link.

Using Worksheet Application Step 19 Click the horizontal scrollbar.

Using Worksheet Application Step 19 Click the horizontal scrollbar.

Using Worksheet Application Step 20 Select the row for item PR-1. Click the Sel

Using Worksheet Application Step 20 Select the row for item PR-1. Click the Sel option.

Using Worksheet Application Step 21 Upon selecting the row, the Item Balance becomes available

Using Worksheet Application Step 21 Upon selecting the row, the Item Balance becomes available for changes, and the Balance fields are updated.

Using Worksheet Application Step 22 Click the vertical scrollbar.

Using Worksheet Application Step 22 Click the vertical scrollbar.

Using Worksheet Application Step 23 Notice that the net balance between the selected debit

Using Worksheet Application Step 23 Notice that the net balance between the selected debit and credit is -284. 90.

Using Worksheet Application Step 24 In order to close items, we can make changes

Using Worksheet Application Step 24 In order to close items, we can make changes to the worksheet. Hence, we replace the value of item PR-1 with a new value and refresh it again to validate.

Using Worksheet Application Step 25 Enter the desired information into the Item Balance field.

Using Worksheet Application Step 25 Enter the desired information into the Item Balance field. Enter "-3515. 00".

Using Worksheet Application Step 26 Click the Refresh button.

Using Worksheet Application Step 26 Click the Refresh button.

Using Worksheet Application Step 27 Note that the system adds a new row, which

Using Worksheet Application Step 27 Note that the system adds a new row, which shows the difference between the two item balances: 3, 515. 10 - 3, 800. 00 = -284. 90

Using Worksheet Application Step 28 Note that the net balance between the selected debit

Using Worksheet Application Step 28 Note that the net balance between the selected debit and credit is zero.

Using Worksheet Application Step 29 Click the Save button.

Using Worksheet Application Step 29 Click the Save button.

Using Worksheet Application Step 30 You have successfully used the Worksheet Application page to

Using Worksheet Application Step 30 You have successfully used the Worksheet Application page to match received payments with existing open items. End of Procedure.