processgstin customerGSTIN customerName invoiceNo

27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9110000303

27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9110000303
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9110000303
27AABCB1382J1ZQ 32AAEFA8537E1ZR ALBATROSS 9121102923
27AABCB1382J1ZQ RAJKOTIA MEDICARE PVT. LTD. 9121102924
27AABCB1382J1ZQ RUMEX PHARMACEUTICALS 9121102925
27AABCB1382J1ZQ VIDARBHA MEDICAL AGENCIES 9121102926
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9210000585
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9210000585
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9410001222
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9410001222
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9410001223
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9410001223
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9561100207
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9561100207
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9561100207
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9561100208
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9561100208
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9911100006
27AABCB1382J1ZQ TOBINCO PHARMACEUTICALS LTD. 9911100006
invoiceDate invType originalInvoiceNo originalInvoiceDate invoiceValue hsnsac
2/6/2018 E 15,348.00 30043200
2/6/2018 E 10,242.00 30043200
2/6/2018 E 6,720.00 30043200
2/6/2018 R 6,720.00 30049090
2/6/2018 7,440.00 30049090
2/7/2018 6,720.00 30049090
2/7/2018 7,440.00 30049090
2/13/2018 E 0.00 30049049
2/13/2018 E -400.00 30049049
2/1/2018 E 1,080.00 30049099
2/1/2018 E -1,000.00 30049099
2/6/2018 E 540.00 30049099
2/6/2018 E 0.00 30049099
2/6/2018 E 15,348.00 30043200
2/6/2018 E 10,242.00 30043200
2/6/2018 E 6,720.00 30043200
2/13/2018 E 0.00 30049049
2/13/2018 E -400.00 30049049
2/12/2018 E 240.00 30049099
2/12/2018 E -880.00 30049099
ProdDesc quantity uqc taxablevalue igstRate igstAmount
ANOMEX SUPPOSITORIES -1X5 EXPORT 25,580 PAC 127,900.00 12.00 15,348.00
ANOMEX SUPPOSITORIES -1X5 EXPORT 17,070 PAC 85,350.00 12.00 10,242.00
ANOMEX SUPPOSITORIES -1X5 EXPORT 11,200 PAC 56,000.00 12.00 6,720.00
RECTOL-80 SUPP. (SALE PACK) 1X5 - LOCAL 500 PAC 6,000.00 12.00 720.00
RECTOL-80 SUPP. (SALE PACK) 1X5 - LOCAL 500 PAC 6,000.00 0.00 0.00
RECTOL-80 SUPP. (SALE PACK) 1X5 - LOCAL 500 PAC 6,000.00 12.00 720.00
RECTOL-80 SUPP. (SALE PACK) 1X5 - LOCAL 500 PAC 6,000.00 0.00 0.00
BG-GLUTAMIN TABLETS -1X30 TABS. 3,200 PAC 1,600.00 0.00 0.00
BG-GLUTAMIN TABLETS -1X30 TABS. 800 PAC 0.00 0.00 0.00
AMITONE SYRUP (200ML) PLAIN 9,000 BT 9,000.00 12.00 1,080.00
AMITONE SYRUP (200ML) PLAIN 1,000 BT 0.00 12.00 0.00
AMITONE SYRUP (200ML) PLAIN 4,500 BT 4,500.00 12.00 540.00
AMITONE SYRUP (200ML) PLAIN 1,000 BT 0.00 12.00 0.00
ANOMEX SUPPOSITORIES -1X5 EXPORT 25,580 PAC 127,900.00 12.00 15,348.00
ANOMEX SUPPOSITORIES -1X5 EXPORT 17,070 PAC 85,350.00 12.00 10,242.00
ANOMEX SUPPOSITORIES -1X5 EXPORT 11,200 PAC 56,000.00 12.00 6,720.00
BG-GLUTAMIN TABLETS -1X30 TABS. 3,200 PAC 1,600.00 0.00 0.00
BG-GLUTAMIN TABLETS -1X30 TABS. 800 PAC 0.00 0.00 0.00
AMITONE SYRUP (200ML) PLAIN 2,000 BT 2,000.00 12.00 240.00
AMITONE SYRUP (200ML) PLAIN 1,000 BT 0.00 12.00 120.00
cgstRate cgstAmount sgstRate sgstAmount utgstRate utgstAmount cessAmount indsupply
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
6.00 360.00 6.00 360.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
6.00 360.00 6.00 360.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Exempt
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Exempt
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Exempt
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Exempt
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Exempt
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Exempt
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
0.00 0.00 0.00 0.00 0.00 0.00 0.00 Taxable
statecode pos reverseCharge ecommerceGSTIN advanceDocumentNo AdvDate AdvAmt AdvTaxAmt
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
27 MH 27 NO 0.00 0.00
NO 0.00 0.00
27 MH 27 NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
NO 0.00 0.00
AdvCessAmt invCan shippingBillCode shippingBillNo shippingBillDate paymentofGST branchcode
0.00 YES 112222 1235466 2/7/2018 with GST 10MH
0.00 YES 112222 1235466 2/7/2018 with GST 10MH
0.00 YES 112222 1235466 2/7/2018 with GST 10MH
0.00 with GST 10MH
0.00 with GST 10MH
0.00 with GST 10MH
0.00 with GST 10MH
0.00 YES without GST 10MH
0.00 YES without GST 10MH
0.00 112222 with GST 10MH
0.00 112222 with GST 10MH
0.00 112222 4567891 2/7/2018 with GST 10MH
0.00 112222 4567891 2/7/2018 with GST 10MH
0.00 with GST 10MH
0.00 with GST 10MH
0.00 with GST 10MH
0.00 without GST 10MH
0.00 without GST 10MH
0.00 with GST 10MH
0.00 with GST 10MH
erpitemcode Ccode erpdocno erpdocdate Flags Posting Date Exchange Rate as per Invoice Date
17000018 1000 6,145,000
17000018 1000 6,145,000
17000018 1000 6,145,000
17000177 1000 2/6/2018 100,000
17000177 1000 2/6/2018 100,000
17000177 1000 2/7/2018 100,000
17000177 1000 2/7/2018 100,000
17000266 1000 6,145,000
17000266 1000 6,145,000
17000374 1000 6,145,000
17000374 1000 6,145,000
17000374 1000 6,145,000
17000374 1000 6,145,000
17000018 1000 6,145,000
17000018 1000 6,145,000
17000018 1000 6,145,000
17000266 1000 6,145,000
17000266 1000 6,145,000
17000374 1000 6,145,000
17000374 1000 6,145,000
Exchange Rate as per Shipping Bill Date Exchange Rate as per Posting Date
Exchange Rate as per B/L Date FOB Value DC Freight Value DC Insurance Value in DC
127,900.00 0.00 0.00
85,350.00 0.00 0.00
56,000.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
1,600.00 0.00 0.00
400.00 0.00 0.00
9,000.00 0.00 0.00
1,000.00 0.00 0.00
4,500.00 0.00 0.00
0.00 0.00 0.00
127,900.00 0.00 0.00
85,350.00 0.00 0.00
56,000.00 0.00 0.00
1,600.00 0.00 0.00
400.00 0.00 0.00
2,000.00 0.00 0.00
1,000.00 0.00 0.00
Posting Status Currency Type (USD/EUR/INR) Delivery Document No.
E USD 8400002483
E USD 8400002483
E USD 8400002483
C INR 8100003130
C INR 8100003131
C INR 8100003132
C INR 8100003133
E USD
E USD
A USD 8400002481
A USD 8400002481
A USD 8400002482
A USD 8400002482
E USD
E USD
E USD
E USD
E USD
A USD
A USD
Delivery Document Posting Date B/L / AWB Date B/L / AWB NO Consignee Code Customer Code
2/6/2018 4000048 4000048
2/6/2018 4000048 4000048
2/6/2018 4000048 4000048
2/6/2018 1000005 1000005
2/6/2018 1000092 1000092
2/7/2018 1000097 1000097
2/7/2018 1000142 1000142
4000048 4000048
4000048 4000048
9/21/2017 4000048 4000048
9/21/2017 4000048 4000048
2/6/2018 4000048 4000048
2/6/2018 4000048 4000048
4000048 4000048
4000048 4000048
4000048 4000048
4000048 4000048
4000048 4000048
4000048 4000048
4000048 4000048
GSTR -1 Report Development - observations;
1 Report should be displayed in both detailed and consolidated formats
2 Report should be executed- posting date wise
3 Report should be executed Invoice wise
4 Report should be executed by Consignee
5 Invoice Value i.e. Taxable value + amount of GST for all items of the Invoice shouls be displayed in invoiceValue co
6 All values except FOB Value DC, Freight Value DC & Insurance Value in DC columns should be displayed in INR.
7 reverse Charge column field should display result as % of reverse charge i.e. 100 or 0 (zero)
8 Recipient state code should appear in statecode column and repeat for all items of same Invoice; field length for s
9 Billed to address state code should be displayed in pos column and should repeat for all line items of the same invo
10 Exchange Rate as per Shipping Bill Date, Exchange Rate as per Posting Date, Exchange Rate as per B/L Date
11 Invoice Value for Invoice No. 9121102924 9121102926 is not correct.
12 Invoice Value for Invoce No. 9210000585 & 9410001222 - line item No. 2 is negative
13 Supplies against Invoice No. 9210000585 indicated as Exempt whereas they are taxable
14 Simillar supplies against Invoice No. 9410001222 & 9410001223 are once indicated as Taxable & once Exempt
15 In all fields, decimal places should be seperated by '.' (dot) instead of ',' (comma)
16 In case of reversal entries, values and Qty should appear in negative number
17 Kindly map Advance docement (type RP & DA) in the report - printscreen enclosed for reference
18 Exchange rates should be properly displayed (e.g. 61.45, 1.00 etc.)
e displayed in invoiceValue column ans same should repeat for all line items of the same Invoice.
hould be displayed in INR.

ame Invoice; field length for state code is only 2 as per Karvy templet.
all line items of the same invoice.
ange Rate as per B/L Date etc. should be displayed in respective columns and should repeated for each line item of the same Invoice.

as Taxable & once Exempt

tem of the same Invoice.