Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Toni Kapp]

In our business we sell produce, and to some retailers we offer a per unit rebate. I have used the invoice discount successfully, however, for one customer the discount is equal to the total number of units sold multiplied by a set amount. I can get the line discount to work as a percentage of the sale, but can not seem to get it to work the way I am needing. Is it possible to do this or is a percentage of sale the only option?
Thanks!

——————————
Toni Kapp
IMG Citrus, Inc.
Vero Beach FL
——————————

[Lewis Rosenberg]

It sounds like you may want a customization.

Invoice Discounts can be different based on minimum sales amounts and you can use line discounts at the item level based on sales volume  (quantities).

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Berlinda Yap]

Like Lewis mentioned it seems you want a customization regarding this.

We have somewhat similar situation wherein we have to give a invoice discount based on the quantity that we shipped out.

We created another table called Discount Allowance under the Customer Card – this table give us more flexibility as to how we give the invoice discount.
We have customer that we have to give invoice discount based on where it was shipped, item, dollar value discount or percentage and off invoice or off payment

This table as the following fields:
Ship to Code 
G/L Account 
Description
Item Number
Discount Calculation – two options: Dollar Per Item being Shipped or Percentage 
Discount Value – either in dollar or percentage
Debit/Credit
Off Invoice – when this is checked – we calculation invoice discount when posting the sales order.
Off Payment

——————————
Berlinda Yap
IT Service Manager
Foremost Groups, Inc.
East Hanover NJ
——————————
——————————————-

[Justin Falconer]

Base NAV does not support this feature.
We have Columbus Food ISV in our database and it does include this feature.

On the Sales Lines we can set Discounts as a Percentage, Per Unit Discount, or Dollar amount for the total Line.

——————————
Justin Falconer
IT Manager
Tender Corporation
Littleton NH
——————————
——————————————-