From a customer: "This report creates a positive margin for Credit Notes. It should be negative. As a result the Total margin will be incorrect."
The database view is RV_C_InvoiceLine.
I suspect that the margin and discount amounts should be multiplied by the 'multiplier' field. I have highlighted the proposed changes to the Postgres view in red.
Before proposed fix:
After proposed fix:
Is it possible to edit or delete this issue? I accidentally posted the information in the environment tag.
Hi , not need delete, just correct it. i help you in this issue.
it's simple, just click pencill in each field or click edit button for edit many field at one.
Hi Hiep, Thank you very much for helping to correct my issue. It is very much appreciated I can't see the pencil icon in the Description field, but I can see it now in the comments, so it is great - sorted
I committed a fix, added the multiplier for marginamt, and fixed the wrong parenthesis in linediscountamt and lineoverlimitamt.
I didn't change the discount% and margin% as I think these values are correct - the percentages are not intended to be summed.