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:

  • B2B – Regular supplies to regular and composite dealers.

  • B2C – Regular supplies to unregistered entities.

  • SEZWP – Regular supplies to SEZ entities with tax payment, and total GST in the transaction isn't zero.

  • SEZWOP – Regular supplies to SEZ entities without tax payment, and total GST in the transaction isn't zero.

  • EXPWP – Regular supplies to overseas entities with tax payment, and total GST in the transaction isn't zero.

  • EXPWOP – Regular supplies to overseas entities without tax payment, and total GST in the transaction isn't zero.

    DC – Item fulfillment is supported.

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:

  • This applies to dropship supplies within the same state (Ship From and Ship To are in the same state, but Bill To is a different state).

    If the customer's Bill To state is different from the supplier's Ship From state, but the Ship To state matches the supplier's Ship From state.

    If the subsidiary nexus and Ship To state are the same, but Bill To state is different, set to Y. Example: Sub Nexus – Punjab, Bill To – Delhi, POS – Delhi, Ship From – Punjab, Customer Ship To – Punjab

  • For services, if the supplier's Bill From state and customer's Bill To state are the same but the place of supply is different.

    If the subsidiary nexus and Bill To state are the same, but place of supply is different, set to Y. Example: Sub Nexus – Punjab, Bill To – Punjab, POS – Delhi.

  • For SEZ supplies (always interstate), if the subsidiary nexus and place of supply are the same and the customer is SEZ, set to Y. Example: Sub Nexus – Punjab, Bill To – Punjab, POS – Punjab, SEZ – Yes

  • For all other cases, set to N.

  • These above scenarios only apply to B2B, SEZWP, and SEZWOP.

    For B2C, EXPWP, and EXPWOP, IGSTonIntra is always N.

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.DocPerdDtls.InvStDt

Set to Null

2.2

Document_Period_End_Date

RefDtls.DocPerdDtls.InvEndDt

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.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

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_Of_Supply_State_Code

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_Supporting_Documents

11.1

Additional_Supporting_Documents_ url

AddlDocDtls.Url

Set to Null.

11.2

Additional_Supporting_Documents

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:

  • Road – 1

  • Rail – 2

  • Air – 3

  • Ship – 4

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:

  • If the India tax nature of items is Services, set to Y; otherwise, set to N.

  • If the item type is Billable Time, set to Y.

  • If the item type is Expense or Billable Expense and India tax nature is blank, set to Y.

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.

Related Topics

General Notices