calculate payment discount on invoice.

nrapendra

hi.

i want to calculate the payment discount on the basis of different payment terms.

for example..

if payment is made in advance or the same day then disc. = 3%
else if
payment is made in between 7 days bill date then dis = 2%
else if
payment is made after 7 days then no discount will be granted.


pls suggest how we can set it.i have selected the payment terms in invoice but fulfilling only one condition.i want that while calculating discounts it should check all the conditions and then apply appropriate discount.


thanx


Nrapendra Singh

Mbad

So you basicly want to give a customer more than one payment term? Will be fun when trying to apply payment to invoice since the system only looks for one payment term.
The problem is that you would love the payment discount to be on the sales line beforehand so you dont have to alter how standard Navision work when applying, but by then you wont know when the payment is made...
Alternately you could look at how the payment fields on cust ledg entries work and maybe alter them when you know the date of payment. Anyone done that? Cant see where else those would be used.

nrapendra

when i m applying the payment entry with invoice..it is calculating the discount on the basis of the payment disc term set in invoice.
i want that it should check the appropriate payment discount term on the basis of payment date

Mbad

nrapendra wrote:

when i m applying the payment entry with invoice..it is calculating the discount on the basis of the payment disc term set in invoice.
i want that it should check the appropriate payment discount term on the basis of payment date

First check if the data in the payment fields in Tab21 differs depending on what payment term you post with. If not then just find the right payment term and alter the invoice header.

nrapendra

stil waiting for reply..

Mbad

nrapendra wrote:

stil waiting for reply..

Excuse me but exactly what are you expecting?

Savatage

Mbad wrote:

So you basicly want to give a customer more than one payment term?

here's your answer. read this post. It's NOT standard to have multiple breaks in your terms. This will need to be a customization.

We would love to have 30-60-90 days on an invoice = pay a third of the inv ever 30 days but it's just one of those things you have to keep track of.

nav_nav

You might want to check out the Italian localisation which has some nice features for this one.

veerabhadra25

Hi Nrapendra

Multiple Payment terms for CD calculation can be handled in AX, But in NAV u need to customize to meet your client requirements.