Credit Memo
Refer the following table for field information and NetSuite field mapping logic used in the credit memo template.
SL No. |
Technical Name of Field |
Tags As Per Government |
NetSuite Field Mapping Logic for Credit Memo |
---|---|---|---|
1.0 |
Version |
Version |
This is a static field that contains the schema version—currently, it's 1.1. |
1.1 |
Supply_type_code |
TranDtls.SupTyp |
Set to any of the following based on the type of supply:
|
1.2 |
Document_type_code |
DocDtls.Typ |
Set to CRN for credit memo transactions. |
1.3 |
Document_Num |
DocDtls.No |
Credit Memo Number – Populated with the credit memo transaction number issued to registered recipients from the Reference No field. The format is alphanumeric and you can use slash (/) and dash (-) as special characters. You can use up to 16 characters. |
1.4 |
Document_Date |
DocDtls.Dt |
Credit Memo Date – Populated with the credit memo date in DD/MM/YYYY format from the transaction, irrespective of the date format the system uses. |
1.5 |
Additional_currency_code |
ExpDtls.ForCur |
Set to Null. |
1.6 |
Reverse_charge |
TranDtls.RegRev |
If reverse charge applies, it's set to Y; if not, set to Null. |
1.7 |
IGST_ Applicability_ despite_Supplier_ and_Recipient_ located_in_same_ State/UT |
TranDtls.IgstOnIntra |
The field value depends on these scenarios:
|
2 |
Delivery_or_Invoice_Period |
— |
If there are no details, it's set to refdtl and all related fields are set to Null. |
2.1 |
Document_Period_Start_Date |
RefDtls. |
Set to Null |
2.2 |
Document_Period_End_Date |
RefDtls. |
Set to Null. |
3 |
Order and Sales Order Reference |
— |
If there are no details, it's set to refdtl and all related fields are set to Null. |
3.1 |
Preceding Document Reference |
— |
Repeated based on the number of references. Currently, you can only report one reference from NetSuite. |
3.1.1 |
Preceding_Document_Number |
RefDtls.PrecDoc.InvNo |
If you create a credit memo using the Credit button in an invoice, this field is populated with the invoice number. The invoice number comes from the Created From field link. If you create a standalone credit memo, this field is blank. |
3.1.2 |
Preceding_Document_Date |
RefDtls.PrecDoc.InvDt |
If you create a credit memo using the Credit button in an invoice, this field is populated with the invoice date. The invoice date comes from the Created From field link. If you create a standalone credit memo, this field is blank. |
3.1.3 |
Other_Reference |
RefDtls.PrecDoc.OthRefNo |
Set to Null. |
3.2 |
Receipt/Contract References |
— |
Set to Null. |
3.2.1 |
Receipt_Advice_Reference |
RefDtls. |
|
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 |
You’ll need 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 from the transaction. |
4.2 |
Supplier_trading_name |
SellerDtls.TrdNm |
Populated with the subsidiary name for One World accounts and the company name for Single Instance accounts. |
4.3 |
Supplier_GSTIN |
SellerDtls.Gstin |
Populated with the GST registration number from the transaction, which is the subsidiary’s tax registration number). |
4.4 |
Supplier_Address1 |
SellerDtls.Addr1 |
If the Locations feature is enabled, populated with address1 from the location record. If not, populated with address1 from the subsidiary in the transaction. |
4.5 |
Supplier_Address2 |
SellerDtls.Addr2 |
If the Locations feature is enabled, populated with address2 from the location record. If not, populated with 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 not,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 not, 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 PIN from the location record. If not, populated with the PIN from the subsidiary in the transaction. |
4.9 |
Supplier_Phone |
SellerDtls.Ph |
Populated with the mobile number from the subsidiary in the transaction. |
4.10 |
Supplier_Email |
SellerDtls.Em |
Populated with the responsible person’s email ID from the subsidiary in the transaction. |
5 |
Recipient Information |
— |
— |
5.1 |
Recipient_legal_Name |
BuyerDtls.LglNm |
You’ll need to create a field that captures the subsidiary’s name as per PAN. Currently, if the Name as per PAN 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's tax registration number from the transaction. If the customer’s registration type is Overseas or Unregistered, or if the tax registration number is blank, set it to URP. |
5.4 |
POS |
Place_ |
Populated with the state code for place of supply from the transaction. For export transactions (where the customer is Overseas and place of supply is Other Countries or Other Territory), set to 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, the value is set to 96. |
5.9 |
Recipient_Pincode |
BuyerDtls.Pin |
Populated with PIN code from the billing address in the transaction. For export transactions, the value is set to 999999. |
5.10 |
Country_of_Export |
ExpDtls.CntCode |
Populated with the country code of the exporting country. |
5.11 |
Recipient_Phone |
BuyerDtls.Ph |
Populated with the phone number from the customer record. |
5.12 |
Recipient _email_Id |
BuyerDtls.Em |
Populated with the email ID from the customer record. |
6 |
Payee Information about (Seller Payment Information) |
— |
Set to Null. |
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 the Location feature is enabled, populated with the address. If not, populated with the subsidiary address. |
7.2 |
Ship_To_Details |
Refer A 1.0 |
Populated only if 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 (can be repeated). |
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 |
Set to Null. |
10.3 |
Port_code |
ExpDtls.Port |
Populated with the port code from the Shipping subtab in the transaction. |
10.4 |
Shipping_bill_no |
ExpDtls.ShipBNo |
Populated with the shipping bill number from the Shipping subtab in the transaction. |
10.5 |
Shipping_Bill_Date |
ExpDtls.ShipBDt |
Populated with the shipping bill date from the Shipping subtab in the transaction. |
10.6 |
Export_Duty_Amount |
ExpDtls.ExpDuty |
Set to Null. |
10.7 |
Refund_claim_option |
ExpDtls.RefClm |
Set to Null. |
10.8 |
ECOM_GSTIN |
TranDtls.EcmGstin |
Populated with the e-commerce GSTIN in the transaction. |
11 |
Additional_ |
— |
— |
11.1 |
Additional_ |
AddlDocDtls.Url |
Set to Null. |
11.2 |
Additional_ |
AddlDocDtls.Docs |
|
11.3 |
Additional_Information |
AddlDocDtls.Info |
|
12 |
Eway Bill Details |
— |
This section only applies if the E-Way Bill feature is on and the transaction has E-Way Bill details. If there aren’t any details, set the section name to Null. E-Way Bills aren’t generated for credit notes, debit notes, or service invoices. |
12.1 |
Transporter_ID |
EwbDtls.TransId |
Populated with the transporter ID from the India E-Way Bill Details subtab in the transaction. |
12.2 |
Trans_Mode |
EwbDtls.TransMode |
Populated with the transportation mode from the India E-Way Bill Details subtab in the transaction. Update the values in NetSuite as follows:
|
12.3 |
Trans_Distance |
EwbDtls.Distance |
Populated with the distance in kilometers (KM) from the India E-Way Bill Details subtab in the transaction. If the distance in the transaction is zero, government’s response will show the distance in kilometers 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 from the India E-Way Bill Details subtab in the transaction. |
12.5 |
Trans_Doc_No |
EwbDtls.TrnDocNo |
Populated with the transport document number from the India E-Way Bill Details subtab in the transaction. |
12.6 |
Trans_Doc_Date |
EwbDtls.TrnDocDt |
Populated with the transport date from the India E-Way Bill Details subtab in the transaction. |
12.7 |
Vehicle_No |
EwbDtls.VehNo |
Populated with the vehicle number from the India E-Way Bill Details subtab in the transaction. |
12.8 |
Vehicle_Type |
EwbDtls.VehType |
Populated with the vehicle type from the India E-Way Bill Details subtab: 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's tax registration number in the transaction. If customer registration type is Overseas, Unregistered, or blank, set to 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 with 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 the customer is Overseas and place of supply is Other Countries or Other Territory), set to 96. |
A1.1 |
Dispatch From Details |
— |
This section is optional, but if any field in this section contains data, all the related fields are required. |
A1.1.1 |
Name_of_entity |
DispDtls.Nm |
If the Location feature is enabled, populated with the addressee from the location in the transaction. If not, populated with the subsidiary legal name from the subsidiary in the transaction. |
A1.1.2 |
Address1 |
DispDtls.Addr1 |
If the Location feature is enabled, populated with address1 from the location in the transaction. If not, populated with address1 from the subsidiary in the transaction. |
A1.1.3 |
Address2 |
DispDtls.Addr2 |
If the Location feature is enabled, populated with address2 from the location in the transaction. If not, populated with address2 from the subsidiary in the transaction. |
A1.1.4 |
Place |
DispDtls.Loc |
If the Location feature is enabled, populated with the city from the location in the transaction. If not, populated with the city from the subsidiary in the transaction. |
A1.1.5 |
State_Code |
DispDtls.Stcd |
If the Location feature is enabled, populated with the state from the location in the transaction. If not, populated with the state from the subsidiary in the transaction. |
A1.1.6 |
Pincode |
DispDtls.Pin |
If the Location feature is enabled, populated with the PIN code from the location in the transaction. If not, populated with the PIN code from the subsidiary in the transaction. |
A1.2 |
Item Details |
— |
Each item in the credit memo needs details, and you can repeat them. Item details are derived from the transaction. If you override a transaction, the overridden value is used. |
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 based on the following scenarios:
|
A1.2.4 |
HSN code |
Item.HsnCd |
Populated with the India tax HSN or SAC code for the line item in the transaction. |
A1.2.5 |
Batch |
Refer A1.4 |
— |
A1.2.6 |
Barcode |
Item.Barcde |
Set to Null. |
A1.2.7 |
Quantity |
Item.Qty |
If the line item has a quantity, populated with that value; otherwise, set to Null. |
A1.2.8 |
Free_Qty |
Item.FreeQty |
Set to Null. |
A1.2.9 |
UQC |
Item.Unit |
Based on the item’s UOM, populated with the matching UQC from the UOM record. If not, set to 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 value is calculated using the formula Gross_ Amount / Quantity. |
A1.2.11 |
Gross_Amount |
Item.TotAmt |
Populated with the gross amount for each item, excluding 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's gross amount. If not, set to Null. |
A1.2.14 |
Taxable_value |
Item.AssAmt |
Populated with the positive value of the tax basis in the transaction. |
A1.2.15 |
GST_Rate |
Item.GstRt |
Populated with the GST rate for the item. For intrastate transactions, the combined rate of CGST and SGST is applied. For example, if both are 9%, the GST rate is 18%. For interstate, IGST 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 on the Tax Details subtab. 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 on the Tax Details subtab. The Cess amount is calculated using the Quantity or Percentage + Quantity tax rate rules. |
A1.2.22 |
State_Cess_Rate |
Item.StateCesRt |
Set to Null. |
A1.2.23 |
State_Cess_Ad_Valorem |
Item.StateCesAmt |
Set to Null. |
A1.2.24 |
State_Cess_Non_Ad_Valorem |
Item.StateCesNonAdvlAmt |
Set to Null. |
A1.2.25 |
Other_Charges |
Item.OthChrg |
Set to Null. |
A1.2.26 |
Order_Line_Reference |
Item.OrdLineRef |
Set to Null. |
A1.2.27 |
Item_Total |
Item.TotItemVal |
Populated with the total value for each line item: Tax Basis + Other charges or Expenses + Taxes (GST + Cess + TDS) – Discounts. |
A1.2.28 |
Origin_Country |
Item.OrgCntry |
Set to Null. |
A1.2.29 |
Serial_Number |
Item.PrdSlNo |
If the transaction has serial-numbered items, populated with the serial numbers; if not, set to Null. If multiple serial numbers are tagged to one item, use the first serial number. Don’t select the same item multiple times with different serial numbers. |
A1.2.30 |
Product_Attribute_Details |
Refer A1.5 |
— |
A1.3 |
Document Total Details |
— |
This section pulls information from the Summary popup window in the transaction. |
A1.3.1 |
Taxable_Value |
ValDtls.AssVal |
Populated with the consolidated tax basis for all the items in the transaction. This field lets you round the tax basis 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 or additional Cess. |
A1.3.6 |
State_Cess_Amt |
ValDtls.StCesVal |
Set to Null. |
A1.3.7 |
Discount_Amt_Invoice_Level |
ValDtls.discount |
The discount value entered at the transaction header Discount field is used as the invoice discount. Both posting and non-posting discounts are included |
A1.3.8 |
Other_Charges_Invoice_Level |
ValDtls.othchrg |
If you don’t enter the India tax shipping and handling HSN or SAC code, shipping and handling costs count 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 to two decimals in the subsidiary currency. |
A1.3.11 |
Total_Invoice_Value_FCNR |
ValDtls.TotInvValFc |
Populated only if the transaction currency is different from the subsidiary currency; otherwise, set to Null. This is the total credit memo amount in foreign currency (transaction currency), rounded to two decimals. |
A1.3.12 |
Paid_amount |
PayDtls.PaidAmt |
Set to Null. |
A1.3.13 |
Amount_due_for_payment |
PayDtls.PaymtDue |
Set to Null. |
A1.4 |
Batch Details |
— |
This section only applies to lot-numbered inventory items. If not, set to Null. |
A1.4.1 |
Batch_Name |
Item.BchDtls.Nm |
Populated with the lot number from the transaction. If multiple lot numbers are tagged to one item, use the first lot number. |
A1.4.2 |
Batch_Expiry_Date |
Item.BchDtls.ExpDt |
Populated with the expiry date of the lot number from the transaction. |
A1.4.3 |
Warranty_Date |
Item.BchDtls.WrDt |
Set to Null. |
A1.5 |
Attribute Details Of Item |
— |
This section only applies to matrix items. If not, set to Null. |
A 1.5.1 |
Attribute_Name |
AttribDtls.Nm |
Populated with the matrix item attribute name from the transaction. |
A1.5.2 |
Attribute_Value |
AttribDtls.Val |
Populated with the matrix item attribute value for that attribute. |