| Summary: | SALE INVOICE 00040, 41 & 42 | ||
|---|---|---|---|
| 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: | ||
|
Comment 2
Mahender
2019-11-06 15:10:57 IST
UPDATE SALE_INVOICE SET IGST_AMOUNT = CGST_AMOUNT *2
WHERE INVOICE_DATE >= TO_DATE('01-10-2019','DD-MM-YYYY') AND (COMPANY='R3')
AND (STATUS='O') AND ( UPPER(INVOICE_TYPE) = 'I5' AND (INVOICE_TYPE LIKE 'I5I' OR INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (485,484,483);
UPDATE SALE_INVOICE SET CGST_AMOUNT = 0, SGST_AMOUNT = 0
WHERE INVOICE_DATE >= TO_DATE('01-10-2019','DD-MM-YYYY') AND (COMPANY='R3')
AND (STATUS='O') AND ( UPPER(INVOICE_TYPE) = 'I5' AND (INVOICE_TYPE LIKE 'I5I' OR INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (485,484,483) ;
UPDATE GL_POSTING_DETAILS A SET SUB_ACCOUNT_CODE = '0037' , AMOUNT = AMOUNT *2
WHERE ACCOUNT_CODE = '12020' AND COMPANY = 'R3' AND VOUCHER_TYPE = 'I5'
AND SUB_ACCOUNT_CODE IN ('0038')
AND VOUCHER_DATE >'01/10/2019'
AND VOUCHER_NUMBER IN (485,484,483) ;
DELETE GL_POSTING_DETAILS A WHERE ACCOUNT_CODE = '12020' AND SUB_ACCOUNT_CODE IN ('0039')
AND VOUCHER_DATE >'01/10/2019' AND COMPANY = 'R3' AND VOUCHER_TYPE = 'I5'
AND VOUCHER_NUMBER IN (485,484,483) ;
IN SALE INVOICE FROM R3, GST CHARGED IN LOCAL BASIS INSTEAD OF CENTRAL , KINDLY CHECK & CORRECT, R3-I5-TI19-00040 07/10/2019 R30014 AJAY BIJLI R3-I5-TI19-00041 09/10/2019 200563 ARJUN JUNEJA R3-I5-TI19-00041 09/10/2019 200563 ARJUN JUNEJA R3-I5-TI19-00042 10/10/2019 201293 AMIT JAIN |