Customer discount

jfrey

:?: Hi

In Navision I can give discount to a customer group for all items. Is it also possible to add for example 30 % to all items for a customer group?
Thanks

Jörg
:roll:

RobertMo

:?: where is the differnce between:
- discount for customer group for all items
- discount for all items for customer group

which version of Navision are you using ?

jfrey

Hi RobertMo

We use Navision 3.7

The difference is

I know how to give 30 % discount, but I don't know how to add 30 %.

Regards

Jörg
:roll:

Caz

Hi there

If you are using ver 3.70 could you use the Sales Price Worksheet (in periodic activities in S&R). You can adjust prices by 30% for Customer Groups here (use adjustment factor of 1.3 to increase prices by 30%).

RobertMo

The prices were not mentioned, but mybe that was on jfrey's mind ?

jfrey

Thanks to all, I will try it.

Regards.

Jörg

RobertMo

oh, another idea crossed my mind. You want to increase price (using discount) instead of decreasing ?
Try with negative percentage discount ?

jfrey

Hi RobertMo

That was exactly, what I wanted. But you cannot use negative percentage.

Regards

Jörg

mans.akerlund

One suggestion:
The minimum value of the field Line Discount % of the table Sales Line Discount (7004) is set to 0, you can change that using the object designer to for example -100. After that you van enter a negative.

As always when modifying settings in system tables be careful and first test it in a test database. Also remember to document the change as when an upgrade comes along all old "mods" needs to be confirmed again.

RobertMo

I never changed the limits on field in "Sales Line Discount". I only used negative disconts directly on sales lines and it worked Ok (mathematicaly), but I haven't done a lot of testing.

one thing to test is for sure, if your discounts are posted separatelly, then the discount amount is negative and how this influences posting routines and the resulting entries...

if possible, then rather increase price instead ? or add additional sales line if you want to charge some extra costs to customer....