Cust. Invoice Disc. Table
You can use the Cust. Invoice Disc. table to define the rules for discounts and service charges for different customers. You can define the conditions for customer invoice discounts in LCY for domestic customers and in foreign currency for foreign customers.
The program calculates a customer invoice discount according to a set of terms that includes a minimum amount, discount percentages and service charges. You set up a code for the discount in the Invoice Disc. Code field on the customer card. To set up the terms, on the customer card, click Related Information, point to Sales, and then click Invoice Discounts.
After you have set up the code and the associated terms, the program can calculate the invoice discount when you invoice the customer. The total amount of the sale determines whether or not the customer will receive an invoice discount or a service charge according to the terms you define in the Cust. Invoice Disc. table. The currency code on the invoice header is used to find the invoice discount terms in the corresponding currency.
The invoice discount is calculated when, on an order or an invoice, on the Actions menu, you point to Functions, and then click Calculate Invoice Discount. If there is a check mark in the Calc. Inv. Discount field in the Sales & Receivables Setup window, the amount is calculated automatically. Click here to learn when the automatic calculation will occur.
You must first set up the invoice discount code. There are two ways to do this:
The code will be created automatically when you set up a new customer. The program uses the customer number as a default by copying the contents of the No. field to the Invoice Disc. Code field. This method is good if you want each customer to receive a different invoice discount.
You can replace the default code by entering a code that you have defined yourself. This is the code that you will enter in the Invoice Disc. Code field for each customer that you want to receive the same invoice discount.
Each time either you or the program creates a new code, you must set up the terms for it in the Cust. Invoice Disc. table. If you enter an existing invoice discount code on a new customer card, the terms that you have already set up for the code will apply to the new customer.
You can access the Cust. Invoice Disc. table from the customer card by clicking Related Information, pointing to Sales, and then clicking Invoice Discounts. In the table you can define:
The currency for which the invoice discount terms on the line are defined. If you do not define invoice discount terms in a specified currency, the program will convert the LCY terms to foreign currency and use these terms.
The minimum amount that an invoice must total for the particular invoice discount and/or service charge to come into effect.
The invoice discount percentage.
A service charge.
Here is an example of how you can fill in the Cust. Invoice Disc. table:
| Currency Code | Minimum Amount | Discount % | Service Charge |
|---|---|---|---|
LCY |
0 |
0 |
50 |
LCY |
5,000 |
5 |
0 |
DEM |
13,000 |
4 |
0 |
In this case, the customer receives a service charge of LCY 50 on a purchase of less than LCY 5,000. On a purchase of LCY 5,000 or more, the customer pays no service charge and receives a 5% discount. On a purchase of DEM 13,000 or more, the customer pays no service charge and receives a 4% discount.
The terms associated with the code for a particular customer are displayed when you click Related Information, point to Sales, and then click Invoice Discounts from the customer's card.
List of Fields in the Table
| Field | Location |
|---|---|
| Minimum Amount Field, Cust. Invoice Disc. Table | Sales and Receivables |
| Code Field, Cust. Invoice Disc. Table | Sales and Receivables |
| Discount % Field, Cust. Invoice Disc. Table | Sales and Receivables |
| Service Charge Field, Cust. Invoice Disc. Table | Sales and Receivables |
| Currency Code Field, Cust. Invoice Disc. Table | Sales and Receivables |