Bug 7732 - Sale report for GST
Summary: Sale report for GST
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: PC Windows
: Normal normal
Assignee: anushree.pandey
URL:
Depends on:
Blocks:
 
Reported: 2021-12-16 16:55 IST by Rajesh kr singh
Modified: 2022-01-11 13:05 IST (History)
2 users (show)

See Also:
Database:
Module ID:


Attachments
Sale Working sheet (76.40 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-12-16 16:55 IST, Rajesh kr singh
Details

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