Bug 618 - Addition of New CSV Files
Summary: Addition of New CSV Files
Status: RESOLVED FIXED
Alias: None
Product: IMIS SALES
Classification: 01.IMIS
Component: IMIS SALES FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: Normal major
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2019-08-10 15:09 IST by ASHISH KUMAR BANSAL
Modified: 2019-09-04 11:22 IST (History)
1 user (show)

See Also:
Database: DPPC
Module ID: GSTF8005


Attachments
CSV Files Format (2.35 KB, application/x-zip-compressed)
2019-08-10 15:09 IST, ASHISH KUMAR BANSAL
Details
NEW CSV FORMAT_FOR INWARD SUPPLY (RCM) (969 bytes, application/vnd.ms-excel)
2019-08-27 12:56 IST, ASHISH KUMAR BANSAL
Details

Note You need to log in before you can comment on or make changes to this bug.
Comment 12 Mahender 2019-09-04 11:22:34 IST
Please check and confirm
Comment 11 ASHISH KUMAR BANSAL 2019-08-30 13:26:18 IST
1. In CSV_SEZ:
    
    Following heading must be change:-
   
    "GSTIN of Recipient" on Place of "GSTIN/UIN of Recipient"

2. In CSV_RCM:

    In Case of Unregistered Dealer, Data misplaced from one column to other 
    column.

3. IN CSV_B2B 3B:
    Data misplaced from one column to other column.

Kindly Check after download latest CSV from Directory No. 56 (Noida) with all CSV sample sheets provided and do necessary correction in New CSV made by you at your end.
Comment 10 Mahender 2019-08-27 18:11:20 IST
this done
Comment 9 Mahender 2019-08-27 16:49:54 IST
please check & confirm
Comment 8 ASHISH KUMAR BANSAL 2019-08-27 14:47:07 IST
Required Changes in Export & SEZ both CSV:

1. Document Type: Invoice or Debit Note or Credit Note

2. Document Date: DD-MM-YY

3. Central Tax & State/UT Tax Column not required
Comment 7 ASHISH KUMAR BANSAL 2019-08-27 13:20:28 IST
Another Correction Required in B2B_3B.CSV File

1. Document Type: Must Indicate Invoice (or) Debit Note (or) Credit Note

2. Document Date: Must be in DD-MM-YY format

3. Supply Covered Under Sec 7 of IGST Act*: In case of IGST Invoice indicate "Yes" otherwise "No"
Comment 6 ASHISH KUMAR BANSAL 2019-08-27 12:56:42 IST
PENDING
Comment 5 ASHISH KUMAR BANSAL 2019-08-27 12:56:04 IST
Created attachment 205 [details]
NEW CSV FORMAT_FOR INWARD SUPPLY (RCM)

As discussed, In CSV_REV_3H provided by you, we found some necessary corrections:

1. Change of Heading: GSTIN/UIN of Recipient  to  GSTIN/PAN of Supplier*
	
2. Add Column: Supply Type :- Inter-State or Intra-State	

3. Supply Covered Under Sec 7 of IGST Act* :Yes in case of Inter-State and No 
   in Case of Intra-State.	

4. It Includes only transaction related to Inward Supply under reverse charge.

For more details pls. check enclosed csv
Comment 4 Mahender 2019-08-21 15:43:58 IST
Please check its done
Comment 3 ASHISH KUMAR BANSAL 2019-08-17 16:08:55 IST
As required 

Details already provided on mail to Mahender.singh@baba.in. 

Kindly add new CSV file asap.
Comment 2 Mahender 2019-08-12 15:36:41 IST
Please provide Detail with Existing CSV file name wise New column Adding name & Delete column for New CSV file
Comment 1 Mahender 2019-08-10 16:37:15 IST
Please Send attachment : By E-mail Mahender.singh@baba.in
Description ASHISH KUMAR BANSAL 2019-08-10 15:09:18 IST
Created attachment 155 [details]
CSV Files Format

Kindly provide New addition of CSV files in the aforesaid module in addition to old CSV's.

Format of CSV files enclosed for your ready reference. 

Please take it on priority basis for submission the data timely on GST portal.