Bug 2594 - IN R2 UNIT CGST/SGST & IGST not as per sales in the m/o Aug & Sept-19
Summary: IN R2 UNIT CGST/SGST & IGST not as per sales in the m/o Aug & Sept-19
Status: RESOLVED USER TO VERIFY
Alias: None
Product: IMIS SALES
Classification: 01.IMIS
Component: IMIS SALES FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: All All
: Normal normal
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2020-01-09 14:31 IST by Rajesh kr singh
Modified: 2020-01-10 10:40 IST (History)
1 user (show)

See Also:
Database:
Module ID:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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,