| Summary: | SALE INVOICE FROM R2 WRONG GST CHARGES | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS SALES | Reporter: | Rajesh kr singh <rajesh.singh> |
| Component: | IMIS SALES FORMS AND REPORTS | Assignee: | Mahender <mahender.singh> |
| Status: | RESOLVED USER TO VERIFY | ||
| Severity: | normal | CC: | sharad.sharma |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Database: | Module ID: | ||
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);
SAME PROBLEM IN R2 INVOICE NOS. GST CHARGED ON LOCAL BASIS WHEREAS INVOICES OF CENTAL , R2-I5-TI19-00797 01/10/2019 202357 SANJANA SETH 09 R2-I5-TI19-00799 02/10/2019 200133 ASHOK JAUNAPURIA 06 R2-I5-TI19-00813 08/10/2019 202363 "WINDOW MAGIC INDIA PRIVATE LIMITED " 06 |
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);