calculate payment discount on invoice.

nrapendra · 2006-12-18

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 · 2006-12-18

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 · 2006-12-18

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 · 2006-12-18

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 · 2006-12-18

stil waiting for reply..

Mbad · 2006-12-18

nrapendra wrote:

stil waiting for reply..

Excuse me but exactly what are you expecting?

Savatage · 2006-12-18

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 · 2006-12-18

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

veerabhadra25 · 2006-12-22

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.

Howdy, Stranger!

Quick Links

Categories

calculate payment discount on invoice.

Comments