Using Worksheet Application

In this topic, you will learn how to use the worksheet application.

Steps:

1. Begin by navigating to the Worksheet Selection page.

    

   Click the Scroll Down arrow.

   Step 1

2. Click the Accounts Receivable menu.

   Step 2

3. Click the Receivables Maintenance menu.

   Step 3

4. Click the Maintenance Worksheet menu.

   Step 4

5. Click the Create Worksheet menu.

   Step 5

6. Click the Add a New Value tab.

   Step 6

7. Click in the Worksheet Business Unit field.

   Step 7

8. Enter the desired information into the Worksheet Business Unit field.

    

   Enter "US003".

   Step 8

9. Click the Add button.

   Step 9

10. Use the Worksheet Selection page to build a new worksheet or to modify an existing one.

    Step 10

11. 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.

    Step 11

12. Click in the Cust ID field.

    Step 12

13. Enter the desired information into the Cust ID field.

     

    Enter "USA06".

    Step 13

14. Use the scrollbar to view additional information on the page.

    Step 14

15. 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.

    Step 15

16. Use the Worksheet Application page to select the items to which payments will be applied.

    Step 16

17. 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.00. When you refresh, after selecting these two items, the net value is -284.90.

    Step 17

18. Click the Sel option.

    Step 18

19. Use the scrollbar to view additional information on the page.

    Step 19

20. 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.

    Step 20

21. Click the Last link.

    Step 21

22. Use the scrollbar to view additional information on the page.

    Step 22

23. Select the row for item PR-1.

     

    Click the Sel option.

    Step 23

24. Upon selecting the row, the Item Balance becomes available for changes, and the Balance fields are updated.

    Step 24

25. Use the scrollbar to view additional information on the page.

    Step 25

26. Notice that the net balance between the selected debit and credit is -284.90.

    Step 26

27. 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.

    Step 27

28. Click in the Item Balance field.

    Step 28

29. Enter the desired information into the Item Balance field.

     

    Enter "-3515.00".

    Step 29

30. Click the Refresh button.

    Step 30

31. 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

    Step 31

32. Note that the Net balance between the selected debit and credit is zero.

    Step 32

33. Click the Save button.

    Step 33

Congratulations, you have successfully learned how to use the Worksheet Application page to match received payments with existing open items.

Table of Contents  Start Topic