ctcLink Reference CenterFinanceAccounts Receivable Managing Receivables - 20Reviewing Maintenance Worksheet Item Accounting Entries - 20b

Reviewing Maintenance Worksheet Item Accounting Entries - 20b

Purpose:  Review the maintenance worksheet item accounting entries using ctcLink.

Audience:  Accounts Receivable staff.

  • ctcLink enables you to create online accounting entries for maintenance worksheet transactions. You can review these entries on the Accounting Entries page before they are processed.
  • The only accounting entries you can edit online, for items on a worksheet, are those that are user-defined for write-offs. Accounting entries for matched items are system-defined and therefore cannot be edited.
  • Consider this scenario: Your company erroneously issued a credit memo for an item. When the error was discovered, a debit memo was created to offset the credit memo. You have already applied these memo items on a payment worksheet and created accounting entries.
  • In this topic, you will review the accounting entries on the Maintenance Worksheet and balance the worksheet.

Reviewing Maintenance Worksheet Item Accounting Entries

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

  1. Enter the desired information into the Worksheet Business Unit field.
  2. Enter the desired information into the Worksheet ID field. 
  3. Select the Search button.
Update Worksheet Search Page

Use the Worksheet Application page to match or settle open items.

The sum of all credits and debits must be zero for the worksheet to balance.

You can sort the worksheet by the absolute value of the item balance, in descending order. The default order is by Item ID.

  1. Select the Absolute Value Sort button.

 

Notice the Item List has been resorted by item balance, with the highest balance in the first row.

Select the option for Entry Type - Offset an Item

  1. Select the Sel option. Select the option for item.
  2. Select the Refresh button.

Notice that debits do not equal credits. There is a net balance.

  1. Select the Save button.
  2. Select the Refresh button.

This balances the worksheet.

  1. Select the Save button.
  2. Select the Worksheet Action link.
Item List

Use the Worksheet Action page to create or review online accounting entries for maintenance worksheet transactions.

  1. Select the Create/Review Entries button.

Use the Accounting Entries page to review the worksheet accounting entries for a maintenance group before they are posted.

  1. Select the Save button.
Worksheet Action

You have successfully reviewed maintenance worksheet item accounting entries.

End of Procedure.

0 Comments

Add your comment

E-Mail me when someone replies to this comment