Customer Offset— Key Exercises

Basic Data Setup

Define a Write-off Code

Purpose: The purpose of this exercise is to show you how to set up the basic data required for this particular functionality. For the Automatic Offset exercise, you will need to define a write-off code and to set up posting control for it.

1. Enter a write-off code.
2. Set up a posting control for the new write-off code.

General exercise for Create a Write-off Code  

General exercise for Posting Control for Write-Off Codes

Required Data

Enter Customer Invoices

Purpose: The purpose of this exercise is to show you how to enter customer invoices, both debit and credit, to be used in the exercises below. For the Automatic Offset exercise, make sure that debits equal credits for each customer, i.e., the customer balance should be zero.

Windows:
Customer Invoice

1. Enter several customer invoices, both debits and credits.

2. Save your changes.

General exercise for Manual Customer Invoice

Enter Customer Payment on Account

Purpose:  The purpose of this exercise is to show you how to enter customer payments on account to be used in the exercises below. For the Automatic Offset exercise, make sure that debits equal credits for each customer, i.e., the customer balance should be zero.

Windows:
Customer Payment

1. Enter customer payments on account.

General exercise for Manual Customer Payment 

Main Exercise

Customer Offset

Purpose: The purpose of this exercise is to show you how to make offsets between customer debit and credit invoices/installments as well as between payments on account and invoices/installments. Parked payments can also be offset. The offset function does not cause any cash flow, and the total amount must always be zero (0).

Manual Customer Offset

Purpose: The purpose of this exercise is to show you how to offset a customer credit invoice/installment and a payment on account against a customer invoice/installment.

Windows:
Customer Offset

1. Open the Customer Offset window.
2. Click the General tab, and create a new record.
3. Enter the payment currency, i.e., the currency of all items included in the offset.
4. Click the Transactions tab, and create a new record. Enter the series ID in the Series ID field, the number in the No. field, and the installment ID in the Inst ID field of the credit invoice, or select these values from the List of Values.
5. Create a new record and enter the series ID in the Series ID field and the number of the payment on account in the No. field, or select these values from the List of Values.
6. Create a new record and enter the series ID in the Series ID field, the number in the No. field, and the installment ID in the Inst ID field of the debit invoice, or select these values from the List of Values.
7. Save your changes. A window appears with payment information.
8. Click OK to close the window.

Note: Instead of entering the three lines manually, you can right-click and click Select Batch to open a window that you can populate with all open ledger items. Select the three items that should be offset, and click OK. The items will are automatically copied to the Customer Offset window.

Automatic Customer Offset

Purpose: The purpose of this exercise is to show you how to offset a customer credit invoice and a payment on account against a customer invoice.

Windows:
Customer Offset Proposals

1. Open the Customer Offset Proposals window.
2. Right-click and then click Create Proposal.
3. Enter the selection criteria shown in the table below.

4. Click OK. A new proposal appears in the Customer Offset Proposals window.
5. Right-click and then click Details to view the included ledger items.
6. Close the window, right-click, and then click Approve Offset. An window appears with payment parameters.
7. Click OK to confirm. A window appears with voucher information.
8. Click OK to confirm.