How can I prevent a negative cash discount?

[Former Member]

The logic being used to determine a cash discount for an invoice billing document is: Total Cost of Materials u2013 Total Freight Cost - Base Value. Base Value x Cash Discount % = Calculated Cash Discount. Base Value u2013 Calculated Cash Discount = Total Due if Paid w/ in cash discount period. We have invoices where the Total Freight Cost is > Total Cost of Materials. When this occurs the Base Value and Calculated Cash Discount become a negative number. When the final calculation is executed to determine the Total Due if Paid w/ in cash discount period, rather than being subtracted from the Base Value, the Calculated Cash Discount amount is added.

I'm looking to find out if there is a non-customized way to set the Calculated Cash Discount to zero if the Base Value is a negative number.

[Former Member · Accepted solution]

Look into Condition Exclusion.

CDST (Cash discount) and ZDST (Zero Discount)

ZDST will always be 0, Create an exclusion such that if CDST is < ZDST to ignore CDST and take ZDST instead.

That's one way through straight IMG config