Using Worksheet Application - 20b

Purpose:  To learn to the Worksheet application in ctcLink.

Audience:  Accounts Receivable staff.

You use the procedure of worksheet application to apply payments to an item on the payment worksheet and to select posting options for the payment. You can also create adjustments, prepayments, and deductions, as needed to balance the worksheet.

Consider this scenario: You have received two payments from a customer. Your goal is to build a worksheet and match these payments with existing items to close open items.

Using Worksheet Application

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

You have now navigated to the Worksheet Selection page.

  1. Select the Add a New Value tab.
  2. Select the Worksheet Business Unit field and enter desired information.
  3. Select the Add button.

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

Use the Customer Criteria field to select the type of customer that you want to include in your worksheet. Your choices are:

  • Corporate Items
  • Customer Items
  • None
  • Remit From Items
  1. Select the Customer ID field and enter the desired information.

Use the Build button to create a new worksheet or add items that meet your selection criteria to an existing worksheet.

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

  1. Select the Add Item button to select an Item.

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.

  1. Select the Sel option.

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.

  1. Choose the Sel option.

Upon selecting the row, the Item Balance becomes available for changes, 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. 

  1. Select the Refresh button.


Note the net balance between the selected debit and credit.

  1. Select the Save button.

You have successfully used the Worksheet Application page to match items.

End of Procedure.


Add your comment

E-Mail me when someone replies to this comment