Product Information
e-Invoice in India
E-Invoice or E-Bill in India was introduced in SAP Business One FP2102 and described in the Note 2902401 and in How_to_Work_with_Electronic_Billing. This blog is about what values from marketing document contain different fields of JSON file.
JSON schema can be found on National Informatics Centre: Goods And Services Tax and its version 1.03 has several blocks and fields. What value, from what field of SAP Business One is taken for every tag is described in this article.
So, file have several blocks:
- Header Details: this section contains tax scheme, version and invoice reference no.
- Transaction Details: this section is about transaction details.
- Document Details: this section has the document details like date, number, date.
- Seller Details: this section contains seller details like GSTIN, tradename, address etc.
- Buyer Details: this section is about buyer details like GSTIN, tradename, address etc.
- Dispatch Details: this section contains dispatch details like GSTIN, tradename, address etc. This is optional block and not mapped in SAP Business One.
- Ship To Details: this section has Sip to details again like GSTIN, tradename, address etc.
- Item Details: this section contains details of Line Items and is repetitive.
- Batch Details: this is an optional block and not mapped in SAP Business One
- Document Total: the name of this section tells what about it, 😉: tax totals, line totals etc. can be found here.
- Payment Details (format C&D) – this and further sections are not mapped in SAP Business One.
- Reference Details (format C&D).
- Document Period Details (format C&D).
- Preceding Document Reference (format C&D).
- Contract Reference Number (format C&D).
- Additional Supporting Document details (format C&D).
- Export Details.
- E way bill Details.
Let’s now describe every block and attribute that is filled by SAP Business One.
- Header Details has only one attribute Version and has fixed value 1
- Transactions Details (TranDtls)
has following attributes and mapping in SAP Business One:
JSON Element Valid Values And Mapping 2.1 TaxSch Tax Scheme has fixed value GST 2.2 SupType Type of Supply or Transaction Category and can have following values: - B2B – Business to Business,
- SEZWP – SEZ with payment,
- SEZWOP – SEZ without payment,
- EXPWP – Export with Payment,
- EXPWOP – Export without payment,
- DEXP – Deemed Export
SAP Business One takes the value according setup of the Export field and the Duty Status in the Tax tab of the marketing document:
- B2B – in case the Export check box is not ticked;
- SEZWP – Export checkbox ticked on and its value is SEZ Developer or SEZ Unit and Duty Status value is With Payment of Duty
- SEZWOP – Export checkbox ticked on and its value is SEZ Developer or SEZ Unit and Duty Status value is Without Payment of Duty
- EXPWP – Export checkbox ticked on and its value is Imports/Exports and Duty Status value is With Payment of Duty
- EXPWOP – Export checkbox ticked on and its value is Imports/Exports and Duty Status value is Without Payment of Duty
- DEXP – Export checkbox ticked on and value is Deemed Imports/Exports
2.3 RegRev Reverse Charge with values Y – Yes/N – No.
SAP Business One takes value Y if any used tax code in the marketing document includes the tax type that “Reverse Charge %” has value:
SAP Business One takes value N In case A/R Invoice has Export checkbox is ticked on and the value selected in dropdown is Import/Export or Deemed Import/Export
Attributes TranDtls.EcmGstin and TranDtls.IgstOnIntra are optional and are not mapped in SAP Business One.
- Document Details (DocDtls) has following attributes and mapping in SAP Business One:
JSON Element Valid Values And Mapping 3.1 Typ Document Type and can have following values:
INV – AR Invoice (Transaction Type as GST Tax Invoice);
CRN – AR Credit Memo (Transaction Type as GST Tax Invoice);
DBN – AR Invoice (Transaction Type as GST Debit Memo):3.2 No Document Number (no prefix and suffix, marketing document No.): 3.3 Dt - Seller Details (SellerDtls) has following attributes and mapping in SAP Business One:
JSON Element Valid Values And Mapping 4.1 Gstin 4.2 LglNm 4.3 TrdNm Trade Name – this is the same as Legal Name 4.4 Addr1 Address 1 – this information is taken from Company Details -> General Tab -> Address. Value is limited to 100 characters. 4.5 Loc 4.6 Pin PIN – this value corresponds to the ZIP Code in Location – Setup from document line. 4.7 Stcd Attributes SellerDtls.Ph and SellerDtls.Em are optional and are not mapped in SAP Business One.
-
Buyer Details (BuyerDtls) has following attributes and mapping in SAP Business One:
5.1 Gstin GSTIN – following values are possible: 2) URP if no GSTIN is provided or in case of EXWP or EXWOP as SupRtype (see 2.2)
5.2 LglNm Legal Name – this is a BP name from marketing document header. It is simple, isn’t it, 😊? 5.3 TrdNm Trade Name – the same as Legal Name from above 5.4 Pos Place of Supply – following values are possible: 2) 96 in case of EXWP or EXWOP as SupRtype (see 2.2)
5.5 Addr1 Address 1 – and again 1 of 2 values are possible and is cut to 100 symbols : - Ship To address from marketing document.
- But, If the Use Bill to Address to Determine Tax checkbox is ticked on then Bill To address.
5.6 Loc Location – corresponds to City from Ship To or Bill To address. The logic of choice is the same as for Addr1 (5.5) attribute. 5.7 Pin Pin – this time 1 of 3 values are possible: - Zip Code from Ship To address or
- Or Zip Code from Bill To address – guess when?, yes – when the Use Bill to Address to Determine Tax checkbox is ticked
- And 999999 for case of EXWP or EXWOP as SupRtype (see 2.2)
5.8 Stcd State Code – value is very similar to one used for Pos (5.4) attribute, BUT! In case the Use Bill to Address to Determine Tax checkbox is ticked then State from Bill To is used. However, for case of EXWP or EXWOP as SupRtype (see 2.2) value 96 is used! Attributes BuyerDtls.Ph and BuyerDtls.Em are optional and are not mapped in SAP Business One.
- Ship To Details (ShipDtls) – this block is reported by SAP Business One only in case the Use Bill to Address to Determine Tax checkbox is ticked on:
7.1 Gstin It is the same as BuyersDtls.Gstin from 5.1 in SAP Business One 7.2 LglNm 7.3 TrdNm Trade Name duplicates the Legal Name 7.4 Addr1 Address takes value of Ship To address in the marketing document 7.5 Loc Location – corresponds to City from Ship To address from marketing document 7.6 Pin Pin – corresponds to Zip Code from Ship To address. However, for case of EXWP or EXWOP as SupType (see 2.2) the value is 999999 7.7 Stcd State Code – repeats value BuyerDtls.Stcd (5.8) but from Ship To address only Attribute ShipDtls.Add2 is not mapped in SAP Business One.
- Item List (ItemList)
8.1 SlNo SL no – order number 8.2 IsServc Is Service can have values Y or N.
In case marketing document is of Service type, then value for all lines is Y. Also this value used for Freight expenses, for other cases (items) value is N.
8.3 HsnCd 8.4 Qty Quantity: value from marketing document line. For service items this value is 1. 8.5 Unit 8.6 UnitPrice Unit price is calculated value for non service items as
(marketing document line tax base amount +marketing document line freight tax base amount (with same GST tax code)) / quantity
For service items this value is net total in local currency.
8.7 TotAmt Total Amount is calculated for non-service items as
(marketing document line tax base amount +marketing document line freight tax base amount (with same GST tax code))
Total Amount for service items is the same value as UnitPrice (8.6) attribute.8.8 AssAmt Assessable Amount repeats value of TotAmt (8.7) attribute. 8.9 GstRt GST Rate: this rate is a sum of GST tax types rates.
However, when Without Payment of Duty is set in the Duty Status field this rate is set to 0 with exception of the freight expenses for the document. Also for the case of EXWP SupType (2.2) and Tax Code is Reverse Tax Code ( see pic. for 2.3) the rate is reported as 0 as well.
8.10 IgstAmt Tax Amount for IGST. This amount includes row also line freight IGST amount.
However, again, when Without Payment of Duty is set in the Duty Status field this rate is set to 0 with exception of the freight expenses for the document. Also for the case of EXWP SupType (2.2) and Tax Code is Reverse Tax Code ( see pic. for 2.3) the rate is reported as 0 as well.
8.11 CgstAmt Tax Amount for CGST. This amount includes row also line freight CGST amount.
However, again, 😊, when Without Payment of Duty is set in the Duty Status field this rate is set to 0 with exception of the freight expenses for the document. Also for the case of EXWP SupType (2.2) and Tax Code is Reverse Tax Code ( see pic. for 2.3) the rate is reported as 0 as well.
8.12 SgstAmt Tax Amount for SGST and UTGST. This amount includes row also line freight CGST and UTGST amount.
And again, 😊, when Without Payment of Duty is set in the Duty Status field this rate is set to 0 with exception of the freight expenses for the document. Also for the case of EXWP SupType (2.2) and Tax Code is Reverse Tax Code ( see pic. for 2.3) the rate is reported as 0 as well.
8.13 CesRt This is GST Cess rate.
Sorry for annoying, but when Without Payment of Duty is set in the Duty Status field this rate is set to 0 with exception of the freight expenses for the document. Also for the case of EXWP SupType (2.2) and Tax Code is Reverse Tax Code ( see pic. for 2.3) the rate is reported as 0 as well.
Cess tax should not be used for the document freight.8.14 CesAmt Tax Amount for Cess tax. This amount includes row also line freight Cess amount.
The same However as in 8.13, 😊
8.15 StateCesRt State Cess tax Rate
This s the same as 8.13 in SAP Buisness One
8.16 StateCesAmt Tax amount for State Cess Tax types, in SAP Business One it is the same as 8.14. 8.17 OthChrg Other Charges
We put here all no GST amounts, freights with no GST taxes.
8.18 TotItemVal Total Item Value.
The value is calculated as Taxable Amount + IGST Amount + CGST Amount + Cess Amount + Other charges.
Following attributes Free Quantity, UQC, Discount, PreTax Value, Cess Non Advol Amount, State Cess Non Advol, Order line Referencee, Origin Country, Serial Number, Attribute Name and Attribute value are not mapped in SAP Business One.
- Document Total (ValDtls)
10.1 AssVal Assessable Value of all Items. This is the sum of ItemList.TotAmt (values from 8.8) 10.2 CgstVal Total CGST Values of all items. This is the sum of Tax Amount in local currency for CGST (values from 8.11) 10.3 SgstVal Total SGST Values of all items. This is the sum of Tax Amount in local currency for SGST and UTGST (values from 8.12) 10.4 IgstVal Total IGST Values of all items. This is the sum of Tax Amount in local currency for IGST (values from 8.10) 10.5 CesVal Total Cess Values of all items. This is the sum of Tax Amount in local currency for Cess (values from 8.14) 10.6 StCesVal Total Cess Values of all items. This is the sum of Tax Amount in local currency for Cess (values from 8.14) 10.7 Discount Invoice Discount
This value is calculated as sum of ItemList.TotItemVal (8.18) for each line, ValDtls.OthChrg (10.8) + ValDtls.RndOffAmt (10.9) – B1 Document Total – downpayment.
10.8 OthChrg Invoice other charges
This amount is include document freight and TCS amount or negative result of calculated amount for Discount in 10.7 😉
10.9 RndOffAmt 10.10 TotInvVal In case down payment used then this amount also includes down payment amount with taxes (Attention! This amount is not equal to the value of Total Down Payment field that you can see in this picture).
This amount should be equal to the sum of ItemList.TotItemVal (8.18) for each line + ValDtls.OthChrg (10.8) + ValDtls.RndOffAmt (10.9) – ValDtls.Discount (10.7).Attribute Final Invoice Value in Additional Currency is not mapped, so all values are reported in the local currency for all blocks.
In case you need other blocks or attributes to be reported in the E-Invoice you need to create a query and save it under the E-Billing category (the same you used when saved SAP Business One queries under the Note Notes 2902401) and using EFM tool (Generating Electronic Reports ) update mapping.
I would like to invite you to provide feedback or ask clarifying questions regarding the topic in the comments section. It is also possible to submit the improvement requests for this feature (and others as well!) on the Customer Influence site: https://influence.sap.com/SAPBusinessOne
Hi Ganna Hrivnakova
Great explanation, please let me know how to download e invoice from FI side (print preview), which t code we need to use.
Regards
Vinod
Hi Vinod,
So far the creation of the e Invoice in SAP Business One is not fully integrated with GST portal, :(. Please, contact your local product expert for more information.
Regards,
Ganna