Invoice Discount

gamit031979

In Customer table id 18, Field Invoice discount Code has Table relation of Customer Table instead of Customer Invoice Discount ( Table Id 19).

Please tell me if it is correct, if yes, then what is the relavance of Look up in Customer Table

If we want to make the Customer Invoice Discount % for a particular Sales Order for Customer at the rate other than defined in Cutsomer Master - Sales - Invoice discounts. Can we do ..........

garak

it's standard. NAV mean, that you can set the code to the code of some customer.

From the online help (F1 when you are on the field):

Invoice Disc. Code Field
The Customer Table


This field displays the customer's invoice discount code. You can enter a maximum of 20 characters, both numbers and letters.

When you set up a new customer card, the number from the No. field is automatically copied to this field.

You then have two possibilities in this field:

If you want the customer to have an individual invoice discount, don't change the contents of this field, but set up terms for this invoice discount code in the Cust. Invoice Disc. window. To see the window, click the Sales button on the Customer Card window, and select Invoice Discount.

If you want several customers to have the same invoice discount, you can replace the default code with another one. This can be a code that has previously been set up, or it can be a new one. If you enter a new code, you must set up invoice discount terms for it in the Cust. Invoice Disc. window. After this, enter the new code in the Invoice Disc. Code field for each customer that you want to have the same invoice discount.

Use codes that are easy to remember and describe the invoice discount terms. For example:

20000 (the customer must buy at least LCY 20,000 worth of merchandise before the invoice discount is granted).

The invoice discount can be allowed/disallowed in the Price Groups window.

Regards

gamit031979

What will happen if we change the look up of Invoice Discount Code in Customer card from Customer table to Customer Invoice Discount Code

garak

Take a look behind the code how navision find the Inv. Discount and how Nav this handle.
The code field on form is only a "information" to get the data from table 19.

So in table 19, you can store for one Code many inv. discounts.

If you doesn't like the Navision way, with the "Invoice Discount" field on Customer table (relation to customer table) ,you can also create your own table like 50000 "Customer Inv. Discounts" (Code 10, Description 30) and set the table relation from Customer field to the new table (also on table 19 field 1, so a rename in table 50000 work correct).

regards