Deductions—Key Exercises

IMPORTANT
It is extremely important that you set up and work within your own company and with your own customer to maintain your data integrity. If you work with any other objects, your exercises will not function as intended and the data of other students might be affected. Predictable exercise results require that your data must be isolated in your own company.

Basic Data Setup


Deduction Rules

Purpose: The purpose of this exercise is to show you how to set up the basic data required for running this particular functionality.

Windows:
Deduction Rules

  1. Open the Deduction Rules window.
  2. Add the three deduction rules shown in the table below.
Deduction Rule Deduction Rule Type Description Value Tax Reduction
PG5 Gross Amount Percent 5% on Gross Amount 5 Unchecked
PN5 Net Amount Percent 5% on Net Amount 5 Unchecked
A100 Absolute Amount 100 in invoice currency 100 Unchecked


Deduction Group

Purpose: The purpose of this exercise is to show you how to set up the basic data required for running this particular functionality.

Windows:
Deduction Groups

  1. Add a new deduction Group, DG1.
  2. Select the line, right-click, and then click Details. Enter the sequence of rules shown in the table below.
Sequence Number Deduction Rule Description Deduction Rule Type Value Tax Reduction
1 PG5 5% on Gross Amount Gross Amount Percent 5 Unchecked
2 PN5 5% on Net Amount Net Amount Percent 5 Unchecked
3 A100 100 in invoice currency Absolute Amount 100 Unchecked


Customer Basic Data

Purpose: The purpose of this exercise is to show you how to set up the basic data required for running this particular functionality.

Windows:
Customer

  1. Open the Customer window.
  2. Query for your customer.
  3. Click the Payment tab and then the Misc Payment Info tab.
  4. Under Payer Info, enter Deduction Group DG1.
  5. Save your changes.

Required Data


Create Customer Invoice

Purpose: The purpose of this exercise is to show you how to enter the data required for the exercises below.

  1. Enter an invoice for the customer to whom you have connected a deduction group.

Note: On the General tab, you will see the payer and deduction group. When you have entered an invoice line with an amount, you will also see the calculated deduction amount on the General tab. 

General exercise for Manual Customer Invoices

Main Exercise


Customer Payments Including Deductions

Purpose: The purpose of this lesson is to show you how to enter a customer payment, including a deduction, in the Mixed Payment window.

Windows:
Mixed Payment

  1. Open the Mixed Payment window, and create a new record (F5).
  2. Select the cash account where the cash was received.
  3. Select a balance method.
  4. Click the Transactions tab, and create a new record. This tab has many columns that are used for different transaction types, but only a few are used for entering a customer payment. Enter the information from the table below.
Transaction

Type

Customer/

Supplier

Amount
Enter Customer Payment Enter the ID of your customer. Enter the amount of the payment (the invoice gross amount minus the deduction).
  1. Save the record (F12).
  2. Select the transaction line, right-click, and then click Match Payment. Two windows appear: the Matching window and then the Select Batch of Invoices window.
  3. In the Select Batch of Invoices window, select your invoice/installment, and click OK. The invoice/installment is copied to the Matching window.
  4. Check the amounts on the invoice/installment line in the Matching window. The remaining amount should be zero if the entered paid amount matches the invoice/installment amount minus deductions. The deduction amount also appears on the line.

Note: By highlighting the invoice/installment line and clicking Deductions, you can see how the deductions were calculated. In this Deductions Details window, you can also add, change, or remove deduction details if necessary for this payment. By highlighting the invoice/installment line in the Matching window and clicking Withdrawals, you can see all withdrawals that will reduce the necessary payment amount for this invoice/installment, discount, write-off, and deductions.

  1. Click OK to close the Matching window.
  2. In the header portion of the Mixed Payment window, right-click and then click Approve. A window appears with payment voucher information.
  3. Click OK. A window appears showing the payment and voucher number that were created.
  4. Click OK to close the window.