Handyman sends discount as an amount and not as a % to Uniconta to get an accurate calculation of customer price on the order line.
Where the customer has an invoice template that shows discount in percent, an adjustment must be made so that the % discount is displayed based on the amount in addition to the usual display of discount %.
This is done as shown in the images below:
1. Find the report template and start editing:
2. Find the column and update the formula (Expression):
The content of the formula (Expression) should be as follows:
| IIF([Discount]>0,FormatString('{0:0.00%}', [Discount]/[Sales price (Invoice)]),IIF([Discount pct]>0,FormatString('{0:0.00}%', [Discount pct]),'')) |