Discounts showing as positive in Tax Reconciliation Report
Hi,
Recently we made some changes in our accounting and now we have started to track how much amount went into discounts by creating a new account (3732) for discounts. We are on 11.5.10 and we achieved this by inserting rows in ra_interface_distributions_all table and then the AutoInvoice creates the transaction with required accounting for discounts.
We are now however facing an issue in our Tax Reconciliation report. The report shows for the revenue account of discounts (3732) the taxable amount as a positive amount. The discounts however as per the users should be shown as a negative amount. Right now since its a positive amount it effects the total sum and the discount amount is added instead of being subtracted.