Discount issues occur when Sales Order is re-opened

gadzilla1

The following discount issue exists in our system.

We have a boolean value 'Volume Discount' that exists on the Invoicing tab of the Customer Card. This discount is activated by a codeunit when the order is released.

Orders have to be reopened and re-released due to additional items being added. Having the volume discount on the Customer Card has caused issues with pricing. A solution was proposed to add the volume discount boolean field to the Sales Order subform.

My questions are:

-Is is it advisable to add this boolean field to the Sales Line table?

-Has anyone had any similar issues where sales order revisions caused any discount issues (line, invoice, volume, etc.) and what were your solutions?

Thank you very much for any help in this matter.

CDM (newer to NAV)

nunomaia

Yes, you can insert volume discounts in lines. If discount it’s based in all invoice amount it should be a single line. You cold for example erase discount every time you reopen invoice.

In Sales Header you have 2 fields: Invoice Discount Value and Invoice Discount Amount. You should look at them.

gadzilla1

Thanks for the reply Nuno.

I've also looked at the two fields in the Sales Header table as well.

Could you please elaborate on "erase discount every time" you reopen the invoice?

Take care - CDM