Bug 7732

Summary: Sale report for GST
Product: [01.IMIS] IMIS SALES Reporter: Rajesh kr singh <rajesh.singh>
Component: IMIS SALES FORMS AND REPORTSAssignee: anushree.pandey
Status: RESOLVED USER TO VERIFY    
Severity: normal CC: mahender.singh, sharad.sharma
Priority: Normal    
Version: unspecified   
Hardware: PC   
OS: Windows   
Database: Module ID:
Attachments: Sale Working sheet

Comment 6 anushree.pandey 2022-01-11 13:05:51 IST
Rights Given..
Comment 4 Rajesh kr singh 2022-01-07 18:42:44 IST
Dear sharad , GST CSV File is ok, except in sales return (CRNOTE_GSTN_NOT_NULL & CRNOTE_GSTN_NULL) there is some column need to be added, 

new column  for , item, HSN Code, Qty, and IGST, CGST, SGST

format as given :- 

UR Type	
Note/Refund Voucher Number	
Note/Refund Voucher date	
Document Type	
Invoice/Advance Receipt Number	
Invoice/Advance Receipt date	
Reason For Issuing document	
Place Of Supply	
ITEM                                    to be added 	
HSN CODE                                to be added	
QTY                                     to be added	
Note/Refund Voucher Value	
Rate	
Taxable Value	
IGST                                    to be added	
CGST                                    to be added	
SGST                                    to be added	
Cess Amount	
Pre GST
Comment 3 Sharad 2022-01-06 10:46:07 IST
Dear Mr. Rajesh,

I have made the new form by this name: "GSTF8006-IPOS GST Return CSV file generator".

Please find the list of CSV files that will be generated through this above mentioned form ::- 

1. B2B
2. B2B 3B
3. B2C 3A
4. SEZ
5. Export
6. Rev 3H
7. B2C Less 250000
8. B2C Greater 250000
9. Invoice Export 
10. HSN Code Wise
11. HSN Code Wise & Rate
12. HSN Code Wise Sale Return & Rate
13. Document Issued 
14. CRNOTE GSTN NOT NULL
15. CRNOTE GSTN NULL

Please check & verify data.
IPOS test server has been already given to you.

It will be implemented on Live server after your confirmation.
Description Rajesh kr singh 2021-12-16 16:55:20 IST
Created attachment 2399 [details]
Sale Working sheet

Dear Sharad As discussed please find enclosed sales report , sales Return & HSN code wise sale detail .

1- Sale working sheet 
2- Sale Return Working Sheet
3- HSN code wise sale working,

kindly do the needful as discussed,