Bug 1766 - sales ledger of Sept-19
Summary: sales ledger of 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: 2019-11-02 18:56 IST by Rajesh kr singh
Modified: 2019-11-04 11:50 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 2019-11-04 11:50:14 IST 
this is done
Comment 1 Mahender 2019-11-04 11:49:43 IST 
update gl_posting_details a set SUB_ACCOUNT_CODE = '0037' , AMOUNT = AMOUNT *2 where account_code = '12020' and sub_account_code in ('0038')
and voucher_Date >'01/09/2019'
and voucher_number in (660,661,648,655,656,688,697,672,702,647,683,700,701)  ;
delete gl_posting_details a  where account_code = '12020' and sub_account_code in ('0039')
and voucher_Date >'01/09/2019'
and voucher_number in (660,661,648,655,656,688,697,672,702,647,683,700,701) ;
Description Rajesh kr singh 2019-11-02 18:56:42 IST 
in sales report gst charged ok but in ledger invoice related to central 50% of igst is also added cgst/sgst as per invoices detail attched,


R2-I5-TI19-00660	05/09/2019	202305 	HIREN KUMAR BARAD
R2-I5-TI19-00661	06/09/2019	202306 	AKASH THAKUR
R2-I5-TI19-00648	02/09/2019	201752 	RMZ INFOTECH PVT LTD
R2-I5-TI19-00655	04/09/2019	202301 	HITKARI MULTIFILTERS
R2-I5-TI19-00656	04/09/2019	202300 	HITKARI TRADING CORPORATION
R2-I5-TI19-00688	09/09/2019	202301 	HITKARI MULTIFILTERS
R2-I5-TI19-00697	10/09/2019	202318 	AMAR SINGH BAINS
R2-I5-TI19-00672	08/09/2019	201774 	MUKUND AGRAWAL
R2-I5-TI19-00702	11/09/2019	202320 	ADITYA JHUNJHUNWALA
R2-I5-TI19-00647	02/09/2019	202296 	KARTHIKAY
R2-I5-TI19-00683	09/09/2019	202296 	KARTHIKAY
R2-I5-TI19-00700	11/09/2019	202321 	BRINJA
R2-I5-TI19-00701	11/09/2019	202321 	BRINJA


please check & correct,