details: https://code.openbravo.com/erp/devel/pi/rev/d991f91e1a2f
changeset: 30634:d991f91e1a2f
user: Mark <markmm82 <at> gmail.com>
date: Mon Nov 07 16:43:46 2016 -0500
summary: Fixes issue 34392: Avoid duplicated taxes in voided Sales Invoices
if discounts
When taxes of the reversed invoice are created only manual taxes are taken into
account (reacalculate flag set as Y).
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 9 ++-------
1 files changed, 2 insertions(+), 7 deletions(-)
diffs (21 lines):
diff -r ac6861ecdd85 -r d991f91e1a2f
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Wed Nov 09
12:24:38 2016 -0500
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Mon Nov 07
16:43:46 2016 -0500
@@ -775,15 +775,10 @@
-- Check if there is any manually added tax
FOR Cur_InvoiceTax IN
- (SELECT c_tax_id, ad_client_id, ad_org_id, isactive,
- taxbaseamt, taxamt, recalculate
+ (SELECT c_tax_id, ad_client_id, ad_org_id, isactive, taxbaseamt,
taxamt, recalculate
FROM c_invoicetax
WHERE c_invoice_id = v_Record_ID
- MINUS
- SELECT c_tax_id, ad_client_id, ad_org_id, isactive,
- -taxbaseamt, -taxamt, recalculate
- FROM c_invoicetax
- WHERE c_invoice_id = v_RInvoice_ID)
+ AND RECALCULATE = 'N')
LOOP
SELECT MAX(line) + 10 INTO v_LineMax FROM c_invoicetax WHERE
c_invoice_id = v_RInvoice_ID;
INSERT INTO c_invoicetax(c_tax_id, c_invoice_id, ad_client_id,
ad_org_id, isactive, created, createdby, updated, updatedby,
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
