Vendor Credit or Bill Credit

The following table lists field information and NetSuite field mapping logic used in the vendor credit or bill credit template.

SL No.	Technical Name of Field	Tags As Per Government	NetSuite Field Mapping Logic Used for Vendor Credit or Bill Credit
1.0	Version	Version	This is a static field containing value of schema version. Currently, it is 1.1.
1.1	Supply_type_code	TranDtls.SupTyp	Populated with values based on the supplies made: B2B – Regular supplies made to regular & composite dealers. B2C – Regular supplies made to unregistered entities. SEZWP – Regular supplies made to entities with registration type SEZ and with payment of tax and when total GST in transaction is Non-Zero. SEZWOP – Regular supplies made to entities with registration type SEZ and without payment of tax and when total GST in transaction is Non-Zero. EXPWP – Regular supplies made to entities with registration type Overseas and with payment of tax and when total GST in transaction is Non-Zero. EXPWOP – Regular supplies made to entities with registration type Overseas, without payment of tax, and total GST in transaction is Non-Zero. DC – Item fulfillment is supported.
1.2	Document_type_code	DocDtls.Typ	Populated with the value DBN for vendor credit transactions.
1.3	Document_Num	DocDtls.No	Vendor Credit Number – Populated with the vendor credit transaction number issued to registered recipients. The Reference No field value is considered. If it is blank, the Transaction Number field value the vendor credit transactions is considered. The format is alphanumeric and allows special characters slash(/) and dash(-). The total number of characters allowed is 16.
1.4	Document_Date	DocDtls.Dt	Vendor Credit Date – Populated with the vendor credit date in DD/MM/YYYY format from the transaction. Irrespective of the date format maintained in the system, the accepted date format is DD/MM/YYYY.
1.5	Additional_currency_code	ExpDtls.ForCur	Updated with Null value.
1.6	Reverse_charge	TranDtls.RegRev	Otherwise, populated with the value Null.
1.7	IGST_ Applicability_ despite_Supplier_ and_Recipient_ located_in_same_ State/UT	TranDtls.IgstOnIntra	Based on the following scenarios, the field value is determined: This is applicable for dropship type of supplies when moved within the same state (ship from and ship to are in the same state, but bill to customer state is different). When a customer's bill to state code is different from supplier's ship from state code but customer's ship to location state code and supplier's ship from state code are the same. If subsidiary nexus and ship to states are the same but bill to is different, populated with the value Y. Sub Nexus – Punjab Bill To – Delhi POS – Delhi Ship From – Punjab Customer Ship To – Punjab When supply of services, the supplier bill from state and customer bill to state arein the same state but the place where service is delivered is in a different state. If subsidiary nexus and bill to state are same but place of supply is different, populated with the value Y. Sub Nexus – Punjab Bill To – Punjab POS – Delhi When supplies made by a GST registered located in the same state (SEZ supplies are always considered as interstate supply irrespective of the customer state location). If subsidiary nexus and place of supply are same and customer registration type is SEZ, populated with the value Y. Sub Nexus – Punjab Bill To – Punjab POS – Delhi SEZ – Yes Populate with the value Y for B2B and SEZ customers. For all other cases, populated with the value N. Note: If IGST on intrastate supply is applicable for a transaction, then reverse charge is required.
2	Delivery_or_Invoice_Period	—	If there are no details, populated with refdtl and all relevant fields populated with the value Null.
2.1	Document_Period_Start_Date	RefDtls.DocPerdDtls.InvStDt	Populated with the value Null
2.2	Document_Period_End_Date	RefDtls.DocPerdDtls.InvEndDt	Populated with the value Null.
3	Order and Sales Order Reference	—	If there are no details, populated with refdtl and all relevant fields populated with the value Null.
3.1	Preceding Document Reference	—	Repeated based on the number of references. Currently, only one reference can be reported from NetSuite.
3.1.1	Preceding_Document_Number	RefDtls.PrecDoc.InvNo	If vendor credit is created using the Credit button in bill transaction, then populated with the reference number of the bill against which the bill credit is created. The Reference No is fetched using the link in the Created from field. If unavailable, populated with the Transaction Number. If it is a standalone bill credit then this field is blank.
3.1.2	Preceding_Document_Date	RefDtls.PrecDoc.InvDt	If vendor credit is created using the Credit button in bill transaction, then populated with the reference number of the bill against which the bill credit is created. The Reference No is fetched using the link in the Created from field. If unavailable, populated with the Transaction Number. When a standalone bill credit is created, the field is blank.
3.1.3	Other_Reference	RefDtls.PrecDoc.OthRefNo	Updated with Null value.
3.2	Receipt/Contract References	—	Updated with Null value.
3.2.1	Receipt_Advice_Reference	RefDtls.Contract.RecAdvRefr
3.2.2	Receipt_Advice_Date	RefDtls.Contract.RecAdvDt
3.2.3	Tender_or_Lot_Reference	RefDtls.Contract.TendRefr
3.2.4	Contract_Reference	RefDtls.Contract.TendRefr
3.2.5	External_Reference	RefDtls.Contract.ExtRefr
3.2.6	Project_Reference	RefDtls.Contract.ProjRefr
3.2.7	Ref_Num	RefDtls.Contract.PORefr
3.2.8	Ref_Date	RefDtls.Contract.PORefDt
4	Supplier Information	—	—
4.1	Supplier_Legal_Name	SellerDtls.LglNm	Require to create a field that captures the subsidiary’s name as per PAN. Currently, if the Legal Name field is blank, populated with the subsidiary name in the transaction.
4.2	Supplier_trading_name	SellerDtls.TrdNm	Populated with the subsidiary name for One World accounts and company name for Single Instance accounts.
4.3	Supplier_GSTIN	SellerDtls.Gstin	Populated with the GST registration number in the transaction, which is the subsidiary tax registration number.
4.4	Supplier_Address1	SellerDtls.Addr1	If the Locations feature is enabled, populated with the address1 from the location record. If the Locations feature is not enabled, populated with the address1 from the subsidiary in the transaction.
4.5	Supplier_Address2	SellerDtls.Addr2	If the Locations feature is enabled, populated with the address2 from the location record. If the Locations feature is not enabled, populated with the address2 from the subsidiary in the transaction.
4.6	Supplier_Place	SellerDtls.Loc	If the Locations feature is enabled, populated with the city from the location record. If the Locations feature is not enabled, populated with the city from the subsidiary in the transaction.
4.7	Supplier_State_code	SellerDtls.Stcd	If the Locations feature is enabled, populated with the state code from the location record. If the Locations feature is not enabled, populated with the state code from the subsidiary in the transaction.
4.8	Supplier_Pincode	SellerDtls.Pin	If the Locations feature is enabled, populated with the pincode from the location record. If the Locations feature is not enabled, populated with the pincode from the subsidiary in the transaction.
4.9	Supplier_Phone	SellerDtls.Ph	Populated with mobile number from the subsidiary in the transaction.
4.10	Supplier_Email	SellerDtls.Em	Populated with responsible person’s email ID from the subsidiary in the transaction.
5	Recipient Information	—	—
5.1	Recipient_legal_Name	BuyerDtls.LglNm	Require to create a field that captures the Name as per PAN field value from the customer record. Currently, if this field is blank, populated with the customer’s company name or individual name.
5.2	Recipient_Trade_Name	BuyerDtls.TrdNm	Populated with the customer’s company name or individual name.
5.3	Recipient_GSTIN	BuyerDtls.Gstin	Populated with the customer tax registration number in the transaction. If customer’s registration type is Overseas or Unregistered or the tax registration number is blank, populated with the value URP.
5.4	POS	Place_Of_Supply_State_Code	Populated with the place of supply (only the state code of place of supply) in the transaction. For export transactions (where customer registration type is Overseas and place of supply Other Countries or Other Territory), populated with the value 96.
5.5	Recipient_Address1	BuyerDtls.Addr1	Populated with address 1 from the billing address in the transaction.
5.6	Recipient_Address2	BuyerDtls.Addr2	Populated with address 2 from the billing address in the transaction.
5.7	Recipient_Place	BuyerDtls.Loc	Populated with city from the billing address in the transaction.
5.8	Recipient_State	BuyerDtls.Stcd	Populated with state from the billing address in the transaction. For export transactions, populated with the value 96.
5.9	Recipient_Pincode	BuyerDtls.Pin	Populated with PIN code from the billing address in the transaction. For export transactions, populated with the value 999999.
5.10	Country_of_Export	ExpDtls.CntCode	Populated with country code of the exporting country.
5.11	Recipient_Phone	BuyerDtls.Ph	Populated with phone number from the customer record.
5.12	Recipient _email_Id	BuyerDtls.Em	Populated with email ID from the customer record.
6	Payee Information about (Seller Payment Information)	—	Updated with Null value.
6.1	Payee_Name	PayDtls.Nam
6.2	Payee_Financial_Account	PayDtls.AccDet
6.3	Mode_of_Payment	PayDtls.Mode
6.4	Financial_Institution_Branch	PayDtls.FinInBr
6.5	Payment_Terms	PayDtls.PayTerm
6.6	Payment_Instruction	PayDtls.PayInstr
6.7	Credit_Transfer	PayDtls.CrTrn
6.8	Direct_Debit	PayDtls.DirDr
6.9	Credit_Days	PayDtls.CrDay
7	Delivery_Information	—	—
7.1	Dispatch_From_Details	Refer A 1.1	If location is enabled, populated with the address. If location is disabled, populated with the subsidiary address.
7.2	Ship_To_Details	Refer A 1.0	Populated only if the ship to details are entered in the transaction.
8	Invoice Item Details	—	—
8.1	List {items}	Refer A 1.2	Populated with the items in the transaction that can be repetitive.
9	Document Total	—	—
9.1	Total_Details	Refer A 1.3	Populated with the total details of the transaction.
10	Extra Information	—	—
10.1	Tax_Scheme	TranDtls.TaxSch	This is a static GST field.
10.2	Remarks	RefDtls.InvRm	Updated with Null value.
10.3	Port_code	ExpDtls.Port	Populated with port code from the Shipping subtab in the transaction.
10.4	Shipping_bill_no	ExpDtls.ShipBNo	Populated with shipping bill number from the Shipping subtab in the transaction.
10.5	Shipping_Bill_Date	ExpDtls.ShipBDt	Populated with shipping bill date from the Shipping subtab in the transaction.
10.6	Export_Duty_Amount	ExpDtls.ExpDuty	Updated with Null value.
10.7	Refund_claim_option	ExpDtls.RefClm	Updated with Null value.
10.8	ECOM_GSTIN	TranDtls.EcmGstin	Populated with ecommerce GSTIN in the transaction.
11	Additional_Supporting_Documents	—	—
11.1	Additional_Supporting_Documents_ url	AddlDocDtls.Url	Updated with Null value.
11.2	Additional_Supporting_Documents	AddlDocDtls.Docs
11.3	Additional_Information	AddlDocDtls.Info
12	Eway Bill Details	—	This section is applicable only if the E-Way Bill feature is enabled and the transaction record contains E-Way Bill details. If there are no details, the section name value is populated with Null. E-Way Bill is not generated for credit note, debit note and service invoice transactions.
12.1	Transporter_ID	EwbDtls.TransId	Populated with the transporter ID entered in the India E-Way Bill Details subtab in the transaction.
12.2	Trans_Mode	EwbDtls.TransMode	Populated with the transportation mode entered in the India E-Way Bill Details subtab in the transaction. Updated the following values for their corresponding values in NetSuite: Road -1 Rail -2 Air -3 Ship -4
12.3	Trans_Distance	EwbDtls.Distance	Populated with the distance in kilometers (KM) entered in the India E-Way Bill Details subtab in the transaction. If the distance entered in the transaction is zero, the response from the government contains the distance in kilometers (KM) in the Remarks field. E-Way Bill details updated in the India E-Way Bill Details subtab in the transaction.
12.4	Transporter_Name	EwbDtls.TransName	Populated with the transporter name entered in the India E-Way Bill Details subtab in the transaction.
12.5	Trans_Doc_No	EwbDtls.TrnDocNo	Populated with the transport document number entered in the India E-Way Bill Details subtab in the transaction.
12.6	Trans_Doc_Date	EwbDtls.TrnDocDt	Populated with the transport date entered in the India E-Way Bill Details subtab in the transaction.
12.7	Vehicle_No	EwbDtls.VehNo	Populated with the vehicle number entered in the India E-Way Bill Details subtab in the transaction.
12.8	Vehicle_Type	EwbDtls.VehType	Populated with the vehicle type entered in the India E-Way Bill Details subtab in the transaction, which are as follows: O -ODC R -Regular
A1.0	Ship To Details	—	—
A1.0.1	Shipping_To_Name_Legal	ShipDtls.LglNm	If this field is blank, populated with the customer’s company name or individual name.
A1.0.2	Shipping_To_Trade_Name	ShipDtls.TrdNm	Populated with the customer’s company name or individual name.
A1.0.3	Shipping_To_GSTIN	ShipDtls.Gstin	Populated with the customer tax registration number in the transaction. If customer registration type is Overseas, Unregistered, or blank, populated with the value URP.
A1.0.4	Shipping_To_Address1	ShipDtls.Addr1	Populated with address 1 from the shipping address in the transaction.
A1.0.5	Shipping_To_Address2	ShipDtls.Addr2	Populated with address 2 from the shipping address in the transaction.
A1.0.6	Shipping_To_Place	ShipDtls.Loc	Populated with the city from the shipping address in the transaction.
A1.0.7	Shipping_To_Pincode	ShipDtls.Pin	Populated the PIN code from the shipping address in the transaction.
A1.0.8	Shipping_To_State_Code	ShipDtls.Stcd	Populated with the state from the shipping address in the transaction. For export transactions (where customer registration type is Overseas and place of supply is Other Countries or Other Territory), populated with the value 96.
A1.1	Dispatch From Details	—	This section is optional. However, if any of the fields in this section contain data, the relevant fields are required.
A1.1.1	Name_of_entity	DispDtls.Nm	If location is enabled, populated with the addressee from the location in the transaction. If location is disabled, populated with the subsidiary legal name from the subsidiary in the transaction.
A1.1.2	Address1	DispDtls.Addr1	Populated with the address 1 from the location in the transaction. If location is disabled, populated with address 1 from the subsidiary in the transaction.
A1.1.3	Address2	DispDtls.Addr2	Populated with the address 2 from the location in the transaction. If location is disabled, populated with address 2 from the subsidiary in the transaction.
A1.1.4	Place	DispDtls.Loc	Populated with the city from the location in the transaction. If location is disabled, populated with the city from the subsidiary in the transaction.
A1.1.5	State_Code	DispDtls.Stcd	Populated with the state from the location in the transaction. If location is disabled, populated with the state from the subsidiary in the transaction.
A1.1.6	Pincode	DispDtls.Pin	Populated with the PIN code from the location in the transaction. If location is disabled, populated with the PIN code from the subsidiary in the transaction.
A1.2	Item Details	—	Each item in the vendor credit must contain details and they can be repeated. Item details are derived from the transaction. If a transaction is overridden, the overridden value is considered.
A1.2.1	Sl_No	Item.SlNo	Populated with the serial number of items in the transaction.
A1.2.2	Item_Description	Item.PrdDesc	Populated with the item description in the transaction.
A1.2.3	Is_Service	Item.IsServc	Populated with values corresponding to the following scenarios: If the India tax nature of items is Services, the field value is Y. Otherwise, the value is N. If the item type is Billable Time, the default field value is Y. If the item type is Expense or Billable Expense and India tax nature is blank, the default field value is Y.
A1.2.4	HSN code	Item.HsnCd	Populated with the India tax HSN or SAC code corresponding to a line item in the transaction.
A1.2.5	Batch	Refer A1.4	–-
A1.2.6	Barcode	Item.Barcde	Updated with Null value.
A1.2.7	Quantity	Item.Qty	If the line item has quantity, populated with its value. Otherwise, populated with the value Null.
A1.2.8	Free_Qty	Item.FreeQty	Updated with Null value.
A1.2.9	UQC	Item.Unit	Based on the item’s UOM, populated with the corresponding UQC from the UOM record. Otherwise, populated with the value Null.
A1.2.10	Rate	Item.UnitPrice	Populated with the unit price for each item in the transaction. If the item is Billable Items or Billable Time, the field value is calculated using the formula Gross_ Amount / Quantity.
A1.2.11	Gross_Amount	Item.TotAmt	Populated with the gross amount for each item in the transaction excluding the taxes.
A1.2.12	Discount_Amount	Item.Discount	Populated with the discount amount for each item in the transaction.
A1.2.13	Pre_Tax_Value	Item.PreTaxVal	If the Override Tax box is checked, populated with the item gross amount. Otherwise, populated with the value Null.
A1.2.14	Taxable_value	Item.AssAmt	Populated with the positive value of tax basis in the transaction.
A1.2.15	GST_Rate	Item.GstRt	Populated with the GST rate of an item. For intrastate transactions, the combined rate of CGST and SGST is applied. For example, if the applicable CGST and SGST rate is 9% respectively, the applicable GST rate will be 18%. For interstate, IGST rate is applied.
A1.2.16	IGST_amt	Item.IgstAmt	Populated with the IGST amount for each item in the transaction.
A1.2.17	CGST_amt	Item.CgstAmt	Populated with the CGST amount for each item in the transaction.
A1.2.18	SGST_amt	Item.SgstAmt	Populated with the SGST amount for each item in the transaction.
A1.2.19	Cess_Rate	Item.CesRt	Populated with the cess percentage in the transaction for percentage based tax rate rules.
A1.2.20	Cess_Amt_Ad_Valorem	Item.CessAmt	Populated with the cess amount from the Details field in the Tax Details subtab in the transaction. The cess amount is calculated using the percentage based tax rate rule.
A1.2.21	Cess_Non_Ad_Valorem	Item.CesNonAdvlAmt	Populated with the cess amount from the Details field in the Tax Details subtab in the transaction. The cess amount is calculated using the Quantity and Percentage +Quantity tax rate rules.
A1.2.22	State_Cess_Rate	Item.StateCesRt	Updated with Null value.
A1.2.23	State_Cess_Ad_Valorem	Item.StateCesAmt	Updated with Null value.
A1.2.24	State_Cess_Non_Ad_Valorem	Item.StateCesNonAdvlAmt	Updated with Null value.
A1.2.25	Other_Charges	Item.OthChrg	Updated with Null value.
A1.2.26	Order_Line_Reference	Item.OrdLineRef	Updated with Null value.
A1.2.27	Item_Total	Item.TotItemVal	Populated with the item total value obtained for each line item in the transaction using the following formula: Tax Basis + Other charges or Expenses + Taxes (GST + Cess + TDS) – Discounts).
A1.2.28	Origin_Country	Item.OrgCntry	Updated with Null value.
A1.2.29	Serial_Number	Item.PrdSlNo	If the transaction has serial numbered items, populated with the item serial numbers. Otherwise, populated with the value Null. When multiple serial numbers are tagged to one item as one line item, populated with the first serial number. You should not select the same item multiple times and provide different serial numbers item wise.
A1.2.30	Product_Attribute_Details	Refer A1.5	—
A1.3	Document Total Details	—	The information in this section is derived from the Summary popup window in the transaction.
A1.3.1	Taxable_Value	ValDtls.AssVal	Populated with the consolidated tax basis of all the items in the transaction. The field allows rounding the tax basis up to two decimals.
A1.3.2	IGST_Amt	ValDtls.IgstVal	Populated with the total IGST amount in the transaction.
A1.3.3	CGST_Amt	ValDtls.CgstVal	Populated with the total CGST amount in the transaction.
A1.3.4	SGST_Amt	ValDtls.SgstVal	Populated with the total SGST amount in the transaction.
A1.3.5	CESS_Amt	ValDtls.CesVal	Populated with the total cess amount in the transaction excluding state cess or additional cess.
A1.3.6	State_Cess_Amt	ValDtls.StCesVal	Updated with Null value.
A1.3.7	Discount_Amt_Invoice_Level	ValDtls.discount	The discount value entered at the transaction header Discount field is considered as the discount value for the invoice. Posting and non posting discounts are both considered.
A1.3.8	Other_Charges_Invoice_Level	ValDtls.othchrg	If the India tax shipping and handling HSN or SAC code is not entered in the transaction, then the shipping and handling costs are considered as other charges.
A1.3.9	Round_off_amount	ValDtls.RndOffAmt	Populated with the round off value for the transaction.
A1.3.10	Total_Invoice_Value_INR	ValDtls.TotInvVal	Populated with the total vendor credit amount including GST rounded off to two decimals in subsidiary currency.
A1.3.11	Total_Invoice_Value_FCNR	ValDtls.TotInvValFc	Populated with a value only if the transaction currency is different from the subsidiary currency. Otherwise, populated with the value Null. The value is total vendor credit amount in foreign currency (transaction currency) rounded off to two decimals.
A1.3.12	Paid_amount	PayDtls.PaidAmt	Updated with Null value.
A1.3.13	Amount_due_for_payment	PayDtls.PaymtDue	Updated with Null value.
A1.4	Batch Details	—	This section is applicable for lot numbered inventory item types. Otherwise, populated with the value Null.
A1.4.1	Batch_Name	Item.BchDtls.Nm	Populated with the lot number in the transaction. When multiple lot numbers are tagged to one item as one line item, populated with the first lot number.
A1.4.2	Batch_Expiry_Date	Item.BchDtls.ExpDt	Populated with the expiry date of lot number in the transaction.
A1.4.3	Warranty_Date	Item.BchDtls.WrDt	Updated with Null value.
A1.5	Attribute Details Of Item	—	This section is applicable only for matrix items. Otherwise, populated with the value Null.
A 1.5.1	Attribute_Name	AttribDtls.Nm	Populated with the matrix item attribute name in the transaction.
A1.5.2	Attribute_Value	AttribDtls.Val	Populated with the matrix item attribute value against the attribute.

SL No.

Technical Name of Field

Tags As Per Government

NetSuite Field Mapping Logic Used for Vendor Credit or Bill Credit

1.0

Version

This is a static field containing value of schema version. Currently, it is 1.1.

1.1

Supply_type_code

TranDtls.SupTyp

Populated with values based on the supplies made:

B2B – Regular supplies made to regular & composite dealers.
B2C – Regular supplies made to unregistered entities.
SEZWP – Regular supplies made to entities with registration type SEZ and with payment of tax and when total GST in transaction is Non-Zero.
SEZWOP – Regular supplies made to entities with registration type SEZ and without payment of tax and when total GST in transaction is Non-Zero.
EXPWP – Regular supplies made to entities with registration type Overseas and with payment of tax and when total GST in transaction is Non-Zero.
EXPWOP – Regular supplies made to entities with registration type Overseas, without payment of tax, and total GST in transaction is Non-Zero.

DC – Item fulfillment is supported.

1.2

Document_type_code

DocDtls.Typ

Populated with the value DBN for vendor credit transactions.

1.3

Document_Num

DocDtls.No

Vendor Credit Number – Populated with the vendor credit transaction number issued to registered recipients.

The Reference No field value is considered. If it is blank, the Transaction Number field value the vendor credit transactions is considered.

The format is alphanumeric and allows special characters slash(/) and dash(-).

The total number of characters allowed is 16.

1.4

Document_Date

DocDtls.Dt

Vendor Credit Date – Populated with the vendor credit date in DD/MM/YYYY format from the transaction. Irrespective of the date format maintained in the system, the accepted date format is DD/MM/YYYY.

1.5

Additional_currency_code

ExpDtls.ForCur

Updated with Null value.

1.6

Reverse_charge

TranDtls.RegRev

Otherwise, populated with the value Null.

1.7

IGST_ Applicability_ despite_Supplier_ and_Recipient_ located_in_same_ State/UT

TranDtls.IgstOnIntra

Based on the following scenarios, the field value is determined:

This is applicable for dropship type of supplies when moved within the same state (ship from and ship to are in the same state, but bill to customer state is different).

When a customer's bill to state code is different from supplier's ship from state code but customer's ship to location state code and supplier's ship from state code are the same.

If subsidiary nexus and ship to states are the same but bill to is different, populated with the value Y.

Sub Nexus – Punjab

Bill To – Delhi

POS – Delhi

Ship From – Punjab

Customer Ship To – Punjab
When supply of services, the supplier bill from state and customer bill to state arein the same state but the place where service is delivered is in a different state. If subsidiary nexus and bill to state are same but place of supply is different, populated with the value Y.

Sub Nexus – Punjab

Bill To – Punjab

POS – Delhi
When supplies made by a GST registered located in the same state (SEZ supplies are always considered as interstate supply irrespective of the customer state location). If subsidiary nexus and place of supply are same and customer registration type is SEZ, populated with the value Y.

Sub Nexus – Punjab

Bill To – Punjab

POS – Delhi

SEZ – Yes
Populate with the value Y for B2B and SEZ customers.
For all other cases, populated with the value N.

Note:
If IGST on intrastate supply is applicable for a transaction, then reverse charge is required.

Delivery_or_Invoice_Period

—

If there are no details, populated with refdtl and all relevant fields populated with the value Null.

2.1

Document_Period_Start_Date

RefDtls.DocPerdDtls.InvStDt

Populated with the value Null

2.2

Document_Period_End_Date

RefDtls.DocPerdDtls.InvEndDt

Populated with the value Null.

Order and Sales Order Reference

—

If there are no details, populated with refdtl and all relevant fields populated with the value Null.

3.1

Preceding Document Reference

—

Repeated based on the number of references.

Currently, only one reference can be reported from NetSuite.

3.1.1

Preceding_Document_Number

RefDtls.PrecDoc.InvNo

If vendor credit is created using the Credit button in bill transaction, then populated with the reference number of the bill against which the bill credit is created.

The Reference No is fetched using the link in the Created from field. If unavailable, populated with the Transaction Number.

If it is a standalone bill credit then this field is blank.

3.1.2

Preceding_Document_Date

RefDtls.PrecDoc.InvDt

If vendor credit is created using the Credit button in bill transaction, then populated with the reference number of the bill against which the bill credit is created.

The Reference No is fetched using the link in the Created from field. If unavailable, populated with the Transaction Number.

When a standalone bill credit is created, the field is blank.

3.1.3

Other_Reference

RefDtls.PrecDoc.OthRefNo

Updated with Null value.

3.2

Receipt/Contract References

—

Updated with Null value.

3.2.1

Receipt_Advice_Reference

RefDtls.Contract.RecAdvRefr

3.2.2

Receipt_Advice_Date

RefDtls.Contract.RecAdvDt

3.2.3

Tender_or_Lot_Reference

RefDtls.Contract.TendRefr

3.2.4

Contract_Reference

RefDtls.Contract.TendRefr

3.2.5

External_Reference

RefDtls.Contract.ExtRefr

3.2.6

Project_Reference

RefDtls.Contract.ProjRefr

3.2.7

Ref_Num

RefDtls.Contract.PORefr

3.2.8

Ref_Date

RefDtls.Contract.PORefDt

Supplier Information

—

4.1

Supplier_Legal_Name

SellerDtls.LglNm

Require to create a field that captures the subsidiary’s name as per PAN.

Currently, if the Legal Name field is blank, populated with the subsidiary name in the transaction.

4.2

Supplier_trading_name

SellerDtls.TrdNm

Populated with the subsidiary name for One World accounts and company name for Single Instance accounts.

4.3

Supplier_GSTIN

SellerDtls.Gstin

Populated with the GST registration number in the transaction, which is the subsidiary tax registration number.

4.4

Supplier_Address1

SellerDtls.Addr1

If the Locations feature is enabled, populated with the address1 from the location record. If the Locations feature is not enabled, populated with the address1 from the subsidiary in the transaction.

4.5

Supplier_Address2

SellerDtls.Addr2

If the Locations feature is enabled, populated with the address2 from the location record. If the Locations feature is not enabled, populated with the address2 from the subsidiary in the transaction.

4.6

Supplier_Place

SellerDtls.Loc

If the Locations feature is enabled, populated with the city from the location record. If the Locations feature is not enabled, populated with the city from the subsidiary in the transaction.

4.7

Supplier_State_code

SellerDtls.Stcd

If the Locations feature is enabled, populated with the state code from the location record. If the Locations feature is not enabled, populated with the state code from the subsidiary in the transaction.

4.8

Supplier_Pincode

SellerDtls.Pin

If the Locations feature is enabled, populated with the pincode from the location record. If the Locations feature is not enabled, populated with the pincode from the subsidiary in the transaction.

4.9

Supplier_Phone

SellerDtls.Ph

Populated with mobile number from the subsidiary in the transaction.

4.10

Supplier_Email

SellerDtls.Em

Populated with responsible person’s email ID from the subsidiary in the transaction.

Recipient Information

—

5.1

Recipient_legal_Name

BuyerDtls.LglNm

Require to create a field that captures the Name as per PAN field value from the customer record.

Currently, if this field is blank, populated with the customer’s company name or individual name.

5.2

Recipient_Trade_Name

BuyerDtls.TrdNm

Populated with the customer’s company name or individual name.

5.3

Recipient_GSTIN

BuyerDtls.Gstin

Populated with the customer tax registration number in the transaction.

If customer’s registration type is Overseas or Unregistered or the tax registration number is blank, populated with the value URP.

5.4

POS

Place_Of_Supply_State_Code

Populated with the place of supply (only the state code of place of supply) in the transaction.

For export transactions (where customer registration type is Overseas and place of supply Other Countries or Other Territory), populated with the value 96.

5.5

Recipient_Address1

BuyerDtls.Addr1

Populated with address 1 from the billing address in the transaction.

5.6

Recipient_Address2

BuyerDtls.Addr2

Populated with address 2 from the billing address in the transaction.

5.7

Recipient_Place

BuyerDtls.Loc

Populated with city from the billing address in the transaction.

5.8

Recipient_State

BuyerDtls.Stcd

Populated with state from the billing address in the transaction.

For export transactions, populated with the value 96.

5.9

Recipient_Pincode

BuyerDtls.Pin

Populated with PIN code from the billing address in the transaction.

For export transactions, populated with the value 999999.

5.10

Country_of_Export

ExpDtls.CntCode

Populated with country code of the exporting country.

5.11

Recipient_Phone

BuyerDtls.Ph

Populated with phone number from the customer record.

5.12

Recipient _email_Id

BuyerDtls.Em

Populated with email ID from the customer record.

Payee Information about (Seller Payment Information)

—

Updated with Null value.

6.1

Payee_Name

PayDtls.Nam

6.2

Payee_Financial_Account

PayDtls.AccDet

6.3

Mode_of_Payment

PayDtls.Mode

6.4

Financial_Institution_Branch

PayDtls.FinInBr

6.5

Payment_Terms

PayDtls.PayTerm

6.6

Payment_Instruction

PayDtls.PayInstr

6.7

Credit_Transfer

PayDtls.CrTrn

6.8

Direct_Debit

PayDtls.DirDr

6.9

Credit_Days

PayDtls.CrDay

Delivery_Information

—

7.1

Dispatch_From_Details

Refer A 1.1

If location is enabled, populated with the address.

If location is disabled, populated with the subsidiary address.

7.2

Ship_To_Details

Refer A 1.0

Populated only if the ship to details are entered in the transaction.

Invoice Item Details

—

8.1

List {items}

Refer A 1.2

Populated with the items in the transaction that can be repetitive.

Document Total

—

9.1

Total_Details

Refer A 1.3

Populated with the total details of the transaction.

Extra Information

—

10.1

Tax_Scheme

TranDtls.TaxSch

This is a static GST field.

10.2

Remarks

RefDtls.InvRm

Updated with Null value.

10.3

Port_code

ExpDtls.Port

Populated with port code from the Shipping subtab in the transaction.

10.4

Shipping_bill_no

ExpDtls.ShipBNo

Populated with shipping bill number from the Shipping subtab in the transaction.

10.5

Shipping_Bill_Date

ExpDtls.ShipBDt

Populated with shipping bill date from the Shipping subtab in the transaction.

10.6

Export_Duty_Amount

ExpDtls.ExpDuty

Updated with Null value.

10.7

Refund_claim_option

ExpDtls.RefClm

Updated with Null value.

10.8

ECOM_GSTIN

TranDtls.EcmGstin

Populated with ecommerce GSTIN in the transaction.

Additional_Supporting_Documents

—

11.1

Additional_Supporting_Documents_ url

AddlDocDtls.Url

Updated with Null value.

11.2

Additional_Supporting_Documents

AddlDocDtls.Docs

11.3

Additional_Information

AddlDocDtls.Info

Eway Bill Details

—

This section is applicable only if the E-Way Bill feature is enabled and the transaction record contains E-Way Bill details.

If there are no details, the section name value is populated with Null.

E-Way Bill is not generated for credit note, debit note and service invoice transactions.

12.1

Transporter_ID

EwbDtls.TransId

Populated with the transporter ID entered in the India E-Way Bill Details subtab in the transaction.

12.2

Trans_Mode

EwbDtls.TransMode

Populated with the transportation mode entered in the India E-Way Bill Details subtab in the transaction.

Updated the following values for their corresponding values in NetSuite:

Road -1
Rail -2
Air -3
Ship -4

12.3

Trans_Distance

EwbDtls.Distance

Populated with the distance in kilometers (KM) entered in the India E-Way Bill Details subtab in the transaction.

If the distance entered in the transaction is zero, the response from the government contains the distance in kilometers (KM) in the Remarks field.

E-Way Bill details updated in the India E-Way Bill Details subtab in the transaction.

12.4

Transporter_Name

EwbDtls.TransName

Populated with the transporter name entered in the India E-Way Bill Details subtab in the transaction.

12.5

Trans_Doc_No

EwbDtls.TrnDocNo

Populated with the transport document number entered in the India E-Way Bill Details subtab in the transaction.

12.6

Trans_Doc_Date

EwbDtls.TrnDocDt

Populated with the transport date entered in the India E-Way Bill Details subtab in the transaction.

12.7

Vehicle_No

EwbDtls.VehNo

Populated with the vehicle number entered in the India E-Way Bill Details subtab in the transaction.

12.8

Vehicle_Type

EwbDtls.VehType

Populated with the vehicle type entered in the India E-Way Bill Details subtab in the transaction, which are as follows:

O -ODC
R -Regular

A1.0

Ship To Details

—

A1.0.1

Shipping_To_Name_Legal

ShipDtls.LglNm

If this field is blank, populated with the customer’s company name or individual name.

A1.0.2

Shipping_To_Trade_Name

ShipDtls.TrdNm

Populated with the customer’s company name or individual name.

A1.0.3

Shipping_To_GSTIN

ShipDtls.Gstin

Populated with the customer tax registration number in the transaction.

If customer registration type is Overseas, Unregistered, or blank, populated with the value URP.

A1.0.4

Shipping_To_Address1

ShipDtls.Addr1

Populated with address 1 from the shipping address in the transaction.

A1.0.5

Shipping_To_Address2

ShipDtls.Addr2

Populated with address 2 from the shipping address in the transaction.

A1.0.6

Shipping_To_Place

ShipDtls.Loc

Populated with the city from the shipping address in the transaction.

A1.0.7

Shipping_To_Pincode

ShipDtls.Pin

Populated the PIN code from the shipping address in the transaction.

A1.0.8

Shipping_To_State_Code

ShipDtls.Stcd

Populated with the state from the shipping address in the transaction.

For export transactions (where customer registration type is Overseas and place of supply is Other Countries or Other Territory), populated with the value 96.

A1.1

Dispatch From Details

—

This section is optional. However, if any of the fields in this section contain data, the relevant fields are required.

A1.1.1

Name_of_entity

DispDtls.Nm

If location is enabled, populated with the addressee from the location in the transaction.

If location is disabled, populated with the subsidiary legal name from the subsidiary in the transaction.

A1.1.2

Address1

DispDtls.Addr1

Populated with the address 1 from the location in the transaction.

If location is disabled, populated with address 1 from the subsidiary in the transaction.

A1.1.3

Address2

DispDtls.Addr2

Populated with the address 2 from the location in the transaction.

If location is disabled, populated with address 2 from the subsidiary in the transaction.

A1.1.4

Place

DispDtls.Loc

Populated with the city from the location in the transaction.

If location is disabled, populated with the city from the subsidiary in the transaction.

A1.1.5

State_Code

DispDtls.Stcd

Populated with the state from the location in the transaction.

If location is disabled, populated with the state from the subsidiary in the transaction.

A1.1.6

Pincode

DispDtls.Pin

Populated with the PIN code from the location in the transaction.

If location is disabled, populated with the PIN code from the subsidiary in the transaction.

A1.2

Item Details

—

Each item in the vendor credit must contain details and they can be repeated.

Item details are derived from the transaction.

If a transaction is overridden, the overridden value is considered.

A1.2.1

Sl_No

Item.SlNo

Populated with the serial number of items in the transaction.

A1.2.2

Item_Description

Item.PrdDesc

Populated with the item description in the transaction.

A1.2.3

Is_Service

Item.IsServc

Populated with values corresponding to the following scenarios:

If the India tax nature of items is Services, the field value is Y. Otherwise, the value is N.
If the item type is Billable Time, the default field value is Y.
If the item type is Expense or Billable Expense and India tax nature is blank, the default field value is Y.

A1.2.4

HSN code

Item.HsnCd

Populated with the India tax HSN or SAC code corresponding to a line item in the transaction.

A1.2.5

Batch

Refer A1.4

–-

A1.2.6

Barcode

Item.Barcde

Updated with Null value.

A1.2.7

Quantity

Item.Qty

If the line item has quantity, populated with its value. Otherwise, populated with the value Null.

A1.2.8

Free_Qty

Item.FreeQty

Updated with Null value.

A1.2.9

UQC

Item.Unit

Based on the item’s UOM, populated with the corresponding UQC from the UOM record.

Otherwise, populated with the value Null.

A1.2.10

Rate

Item.UnitPrice

Populated with the unit price for each item in the transaction.

If the item is Billable Items or Billable Time, the field value is calculated using the formula Gross_ Amount / Quantity.

A1.2.11

Gross_Amount

Item.TotAmt

Populated with the gross amount for each item in the transaction excluding the taxes.

A1.2.12

Discount_Amount

Item.Discount

Populated with the discount amount for each item in the transaction.

A1.2.13

Pre_Tax_Value

Item.PreTaxVal

If the Override Tax box is checked, populated with the item gross amount.

Otherwise, populated with the value Null.

A1.2.14

Taxable_value

Item.AssAmt

Populated with the positive value of tax basis in the transaction.

A1.2.15

GST_Rate

Item.GstRt

Populated with the GST rate of an item.

For intrastate transactions, the combined rate of CGST and SGST is applied. For example, if the applicable CGST and SGST rate is 9% respectively, the applicable GST rate will be 18%.

For interstate, IGST rate is applied.

A1.2.16

IGST_amt

Item.IgstAmt

Populated with the IGST amount for each item in the transaction.

A1.2.17

CGST_amt

Item.CgstAmt

Populated with the CGST amount for each item in the transaction.

A1.2.18

SGST_amt

Item.SgstAmt

Populated with the SGST amount for each item in the transaction.

A1.2.19

Cess_Rate

Item.CesRt

Populated with the cess percentage in the transaction for percentage based tax rate rules.

A1.2.20

Cess_Amt_Ad_Valorem

Item.CessAmt

Populated with the cess amount from the Details field in the Tax Details subtab in the transaction.

The cess amount is calculated using the percentage based tax rate rule.

A1.2.21

Cess_Non_Ad_Valorem

Item.CesNonAdvlAmt

Populated with the cess amount from the Details field in the Tax Details subtab in the transaction.

The cess amount is calculated using the Quantity and Percentage +Quantity tax rate rules.

A1.2.22

State_Cess_Rate

Item.StateCesRt

Updated with Null value.

A1.2.23

State_Cess_Ad_Valorem

Item.StateCesAmt

Updated with Null value.

A1.2.24

State_Cess_Non_Ad_Valorem

Item.StateCesNonAdvlAmt

Updated with Null value.

A1.2.25

Other_Charges

Item.OthChrg

Updated with Null value.

A1.2.26

Order_Line_Reference

Item.OrdLineRef

Updated with Null value.

A1.2.27

Item_Total

Item.TotItemVal

Populated with the item total value obtained for each line item in the transaction using the following formula:

Tax Basis + Other charges or Expenses + Taxes (GST + Cess + TDS) – Discounts).

A1.2.28

Origin_Country

Item.OrgCntry

Updated with Null value.

A1.2.29

Serial_Number

Item.PrdSlNo

If the transaction has serial numbered items, populated with the item serial numbers. Otherwise, populated with the value Null.

When multiple serial numbers are tagged to one item as one line item, populated with the first serial number.

You should not select the same item multiple times and provide different serial numbers item wise.

A1.2.30

Product_Attribute_Details

Refer A1.5

—

A1.3

Document Total Details

—

The information in this section is derived from the Summary popup window in the transaction.

A1.3.1

Taxable_Value

ValDtls.AssVal

Populated with the consolidated tax basis of all the items in the transaction.

The field allows rounding the tax basis up to two decimals.

A1.3.2

IGST_Amt

ValDtls.IgstVal

Populated with the total IGST amount in the transaction.

A1.3.3

CGST_Amt

ValDtls.CgstVal

Populated with the total CGST amount in the transaction.

A1.3.4

SGST_Amt

ValDtls.SgstVal

Populated with the total SGST amount in the transaction.

A1.3.5

CESS_Amt

ValDtls.CesVal

Populated with the total cess amount in the transaction excluding state cess or additional cess.

A1.3.6

State_Cess_Amt

ValDtls.StCesVal

Updated with Null value.

A1.3.7

Discount_Amt_Invoice_Level

ValDtls.discount

The discount value entered at the transaction header Discount field is considered as the discount value for the invoice.

Posting and non posting discounts are both considered.

A1.3.8

Other_Charges_Invoice_Level

ValDtls.othchrg

If the India tax shipping and handling HSN or SAC code is not entered in the transaction, then the shipping and handling costs are considered as other charges.

A1.3.9

Round_off_amount

ValDtls.RndOffAmt

Populated with the round off value for the transaction.

A1.3.10

Total_Invoice_Value_INR

ValDtls.TotInvVal

Populated with the total vendor credit amount including GST rounded off to two decimals in subsidiary currency.

A1.3.11

Total_Invoice_Value_FCNR

ValDtls.TotInvValFc

Populated with a value only if the transaction currency is different from the subsidiary currency. Otherwise, populated with the value Null.

The value is total vendor credit amount in foreign currency (transaction currency) rounded off to two decimals.

A1.3.12

Paid_amount

PayDtls.PaidAmt

Updated with Null value.

A1.3.13

Amount_due_for_payment

PayDtls.PaymtDue

Updated with Null value.

A1.4

Batch Details

—

This section is applicable for lot numbered inventory item types.

Otherwise, populated with the value Null.

A1.4.1

Batch_Name

Item.BchDtls.Nm

Populated with the lot number in the transaction.

When multiple lot numbers are tagged to one item as one line item, populated with the first lot number.

A1.4.2

Batch_Expiry_Date

Item.BchDtls.ExpDt

Populated with the expiry date of lot number in the transaction.

A1.4.3

Warranty_Date

Item.BchDtls.WrDt

Updated with Null value.

A1.5

Attribute Details Of Item

—

This section is applicable only for matrix items.

Otherwise, populated with the value Null.

A 1.5.1

Attribute_Name

AttribDtls.Nm

Populated with the matrix item attribute name in the transaction.

A1.5.2

Attribute_Value

AttribDtls.Val

Populated with the matrix item attribute value against the attribute.

Related Topics