9.2 Using Worksheet Application

Purpose:  Use this document as a reference for using the Worksheet application in ctcLink.

Audience:  Accounts Receivable staff.

You must have at least one of these local college managed security roles:

  • ZZ AR Item Entry

You must also set these User Preference Definitions:

If you need assistance with the above security roles or User Preference Definitions, please contact your local college supervisor or IT Admin to request role access.

Use the worksheet application to apply payments to an item on the payment worksheet and to select posting options for the payment. Adjustments, prepayments and deductions can be created as needed to balance the worksheet.

Using Worksheet Application

Navigation: Accounts Receivable > Receivables Maintenance > Maintenance Worksheet > Create Worksheet

  1. On the Create Worksheet search page, select the Add a New Value tab.
  2. Select the Worksheet Business Unit field and enter desired information.
  3. Select the Add button.  The Create Worksheet page will display.
Create Worksheet Add a New Value tab
  1. Use the Worksheet Selection tab to build a new worksheet or to modify an existing one.
  2. Select the Customer Criteria from the drop-down list to select the type of customer to be included in the worksheet.  The choices include:
    • Corporate Items
    • Customer Items
    • None
    • Remit From Items
  3. Select the Customer ID field.
  4. Select Build to create a new worksheet or add items that meet your selection criteria to an existing worksheet.
Worksheet Selection tab
  1. Use the Worksheet Application page to select the items to which payments will be applied.
  2. Select the Add Item button to select an Item.
  3. Use the Sel option to select the items that will be matched to the payment.
  4. Select the Sel option.
  5. You can view 8 rows at a time using the grid navigation, or select the View All link to view all rows on one page.
  6. Select the row for the items.
  7. Choose the Sel option.  Upon selecting the row, the Item Balance becomes available for change, and the Balance fields are updated.
  8. Scroll to the right to review remaining information.  Notice the net balance between the selected debit and credit.  In order to close items, we can make changes to the worksheet. 
  9. Select the Refresh button.
  10. Select the Save button.
Worksheet Application page
  1. Process complete.


Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.