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 Maintenance Worksheet
- On the Create Worksheet search page, select the Add a New Value tab.
- Select the Worksheet Business Unit field and enter desired information.
- Select the Add button. The Create Worksheet page will display.
- Use the Worksheet Selection tab to build a new worksheet or to modify an existing one.
- 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
- Select the Customer ID field and enter applicable ID.
- Select Build to create a new worksheet or add items that meet your selection criteria to an existing worksheet. The Worksheet Application page will display.
- Use the Worksheet Application page to select the items to which payments will be applied.
- Select the Add Item button to select an Item.
- Use the Sel option to select the items that will be matched to the payment.
- 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. Select the row for the items.
- Choose the Sel option. Upon selecting the row, the Item Balance becomes available for change, and the Balance fields are updated.
- 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.
- Select the Refresh button.
- Select the Save button.
Video Tutorial
The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.
Video Tutorial
View the external link to Using Worksheet Application. This link will open in a new tab/window.
0 Comments
Add your comment