Bug 2594

Summary:	IN R2 UNIT CGST/SGST & IGST not as per sales in the m/o Aug & Sept-19
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 2020-01-09 14:47:11 IST

DELETE GL_POSTING_DETAILS WHERE COMPANY = 'R3' AND VOUCHER_TYPE = 'I5' AND VOUCHER_DATE BETWEEN '07/09/2019' AND '08/09/2019' AND NARRATION = 'CGST Amount'
AND VOUCHER_NUMBER NOT IN (8,22) ;
UPDATE GL_POSTING_DETAILS SET AMOUNT = AMOUNT * 2
WHERE COMPANY = 'R3' AND VOUCHER_TYPE = 'I5' AND VOUCHER_DATE BETWEEN '07/09/2019' AND '08/09/2019' AND NARRATION = 'SGST Amount'
AND VOUCHER_NUMBER NOT IN (8,22);

Comment 1 Mahender 2020-01-09 14:45:23 IST

DELETE GL_POSTING_DETAILS WHERE COMPANY = 'R3' AND VOUCHER_TYPE = 'I5' AND VOUCHER_DATE BETWEEN '17/08/2019' AND '31/08/2019' AND NARRATION = 'CGST Amount'
AND VOUCHER_NUMBER NOT IN (8,22) ;
UPDATE GL_POSTING_DETAILS SET AMOUNT = AMOUNT * 2
WHERE COMPANY = 'R3' AND VOUCHER_TYPE = 'I5' AND VOUCHER_DATE BETWEEN '17/08/2019' AND '31/08/2019' AND NARRATION = 'SGST Amount'
AND VOUCHER_NUMBER NOT IN (8,22);

Description Rajesh kr singh 2020-01-09 14:31:39 IST

As discussed in R2 unit there are diff. in CGST/SGST and IGST agst. sales for the m/o Aug & Sept-2019

kindly do the needful,