UPDATE SALE_INVOICE SET IGST_AMOUNT = CGST_AMOUNT *2
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (6159);
UPDATE SALE_INVOICE SET CGST_AMOUNT = 0, SGST_AMOUNT = 0
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (6159);

UPDATE INVOICE_ITEMS SET IGST_AMOUNT = CGST_AMOUNT * 2, IGST_RATE = CGST_RATE * 2
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN  (6159);
UPDATE INVOICE_ITEMS SET CGST_AMOUNT = 0 , SGST_AMOUNT  = 0 , CGST_RATE = 0 , SGST_RATE = 0
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN  (6159);


UPDATE GL_POSTING_DETAILS A SET SUB_ACCOUNT_CODE = '0037' , AMOUNT = AMOUNT *2
WHERE ACCOUNT_CODE = '12020'  AND COMPANY = 'R2' AND VOUCHER_TYPE = 'I5'
AND SUB_ACCOUNT_CODE IN ('0038')
AND VOUCHER_DATE >'01/10/2019'
AND VOUCHER_NUMBER IN  (6159);

DELETE GL_POSTING_DETAILS A  WHERE ACCOUNT_CODE = '12020' AND SUB_ACCOUNT_CODE IN ('0039')
AND VOUCHER_DATE >'01/10/2019'  AND COMPANY = 'R2'  AND VOUCHER_TYPE = 'I5'
AND VOUCHER_NUMBER IN  (6159);

UPDATE SALE_INVOICE SET IGST_AMOUNT = CGST_AMOUNT *2
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (6134,6132, 6148);
UPDATE SALE_INVOICE SET CGST_AMOUNT = 0, SGST_AMOUNT = 0
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (6134,6132, 6148);

UPDATE INVOICE_ITEMS SET IGST_AMOUNT = CGST_AMOUNT * 2, IGST_RATE = CGST_RATE * 2
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN  (6134,6132, 6148);
UPDATE INVOICE_ITEMS SET CGST_AMOUNT = 0 , SGST_AMOUNT  = 0 , CGST_RATE = 0 , SGST_RATE = 0
WHERE INVOICE_DATE >= to_date('01-10-2019','DD-MM-YYYY') and (COMPANY='R2')
and (STATUS='Y') and ( UPPER(INVOICE_TYPE) = 'I5' and (INVOICE_TYPE LIKE 'i5I' or INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN  (6134,6132, 6148);


UPDATE GL_POSTING_DETAILS A SET SUB_ACCOUNT_CODE = '0037' , AMOUNT = AMOUNT *2
WHERE ACCOUNT_CODE = '12020'  AND COMPANY = 'R2' AND VOUCHER_TYPE = 'I5'
AND SUB_ACCOUNT_CODE IN ('0038')
AND VOUCHER_DATE >'01/10/2019'
AND VOUCHER_NUMBER IN  (6134,6132, 6148);

DELETE GL_POSTING_DETAILS A  WHERE ACCOUNT_CODE = '12020' AND SUB_ACCOUNT_CODE IN ('0039')
AND VOUCHER_DATE >'01/10/2019'  AND COMPANY = 'R2'  AND VOUCHER_TYPE = 'I5'
AND VOUCHER_NUMBER IN  (6134,6132, 6148);