Managing Accounts Using a Maintenance Worksheet


In this topic, you will learn how to manage accounts using a maintenance worksheet.


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 "US001".

    Step 8

  9. Click the Add button.

    Step 9

  10. Use the Worksheet Selection page to specify customer and item information that should appear on the worksheet. PeopleSoft uses criteria information to retrieve all items matching the selection criteria when the worksheet is built.

    Step 10

  11. You can specify Customer Criteria, reference criteria, or a combination of customer and reference criteria. You can select a range of item IDs and a single customer ID as your search criteria. You can also select all items for a customer without narrowing your search to the selected item IDs.

    Step 11

  12. Click in the Cust ID field.

    Step 12

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

     

    Enter "USA03".

    Step 13

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

    Step 14

  15. Click the Build button.

    Step 15

  16. Use the Worksheet Application page to offset items, create write-offs, or make adjustments to posted items.

    Step 16

  17. The default order displayed in the worksheet is by Item ID.  Click the Absolute Value Sort button to sort the worksheet by the absolute value of the item balance, in descending order.

    Step 17

Congratulations, you have successfully learned how create a maintenance worksheet.

Table of Contents  Start Topic