Field reference
Sales Invoice
How to use Sales Invoice in Customer Billing: access, working steps, fields, related records and troubleshooting.
Purpose and access
Create sales invoices from the applicable sales or delivery records, review taxes and due dates, and submit after checking. Allocate payments through Payment Entry and inspect the receivable reports for the remaining balance.
This page is a record page in Finance & Accounting → Customer Billing. Use the link above to open the configured destination; permissions are checked by the destination service.
ERP links open in a new tab. Sign in with your own account; record visibility, actions and approval authority follow your assigned permissions. Screens can differ by company and configuration.
Before you start
Prepare the required information: Company, Series, Customer, Posting Date, Currency, Exchange Rate, Price List, Price List Exchange Rate, Items, Debit To.
Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.
Working steps
- Open Sales Invoice from Finance & Accounting → Customer Billing, or use ERP Search.
- Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
- Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
- Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- When the draft is complete and you are authorized, submit it through the available approval process. Submission can create operational or accounting effects. Use the permitted cancellation/amendment process for later corrections.
Field reference
These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.
| Field | Type / behavior | How to use it |
|---|---|---|
Companycompany | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Company |
Company Tax IDcompany_tax_id | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Seriesnaming_series | Select Required | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Customercustomer | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Customer |
Customer Namecustomer_name | Small Text Optional · Read-only | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
Tax Idtax_id | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Posting Dateposting_date | Date Required | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Posting Timeposting_time | Time Optional | Record the time in the format accepted by the field. |
Edit Posting Date and Timeset_posting_time | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Payment Due Datedue_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Include Payment (POS)is_pos | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
POS Profilepos_profile | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: POS Profile |
Is Consolidatedis_consolidated | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Is Return (Credit Note)is_return | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Return Againstreturn_against | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Sales Invoice |
Update Outstanding for Selfupdate_outstanding_for_self | Check Optional | Credit Note will update it's own outstanding amount, even if 'Return Against' is specified. |
Update Billed Amount in Sales Orderupdate_billed_amount_in_sales_order | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Update Billed Amount in Delivery Noteupdate_billed_amount_in_delivery_note | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Is Rate Adjustment Entry (Debit Note)is_debit_note | Check Optional | Issue a debit note against an existing Sales Invoice to adjust the rate. The quantity will be retained from the original invoice. |
Consider for Tax Withholdingapply_tds | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Amended Fromamended_from | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Sales Invoice |
Cost Centercost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Projectproject | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Project |
Currencycurrency | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Currency |
Exchange Rateconversion_rate | Float Required | Rate at which Customer Currency is converted to customer's base currency |
Price Listselling_price_list | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Price List |
Price List Currencyprice_list_currency | Link Required · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Currency |
Price List Exchange Rateplc_conversion_rate | Float Required | Rate at which Price list currency is converted to customer's base currency |
Ignore Pricing Ruleignore_pricing_rule | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Scan Barcodescan_barcode | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Last Scanned Warehouselast_scanned_warehouse | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Update Stockupdate_stock | Check Optional | If checked, updates inventory; stock and accounting entries are created together. Leave unchecked if a Delivery Note is created separately. |
Source Warehouseset_warehouse | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Warehouse |
Set Target Warehouseset_target_warehouse | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Warehouse |
Itemsitems | Table Required | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Sales Invoice Item |
Total Quantitytotal_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Total Net Weighttotal_net_weight | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Total (Company Currency)base_total | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Net Total (Company Currency)base_net_total | Currency Required · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Totaltotal | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Net Totalnet_total | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Is customer exempted from sales tax?exempt_from_sales_tax | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Tax Categorytax_category | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Tax Category |
Sales Taxes and Charges Templatetaxes_and_charges | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Sales Taxes and Charges Template |
Shipping Ruleshipping_rule | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Shipping Rule |
Incotermincoterm | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Incoterm |
Named Placenamed_place | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Sales Taxes and Chargestaxes | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Sales Taxes and Charges |
Total Taxes and Charges (Company Currency)base_total_taxes_and_charges | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Total Taxes and Chargestotal_taxes_and_charges | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Use Company default Cost Center for Round offuse_company_roundoff_cost_center | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Grand Totalgrand_total | Currency Required · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
In Wordsin_words | Small Text Optional · Read-only | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
Disable Rounded Totaldisable_rounded_total | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Rounding Adjustmentrounding_adjustment | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Rounded Totalrounded_total | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Grand Total (Company Currencybase_grand_total | Currency Required · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
In Wordsbase_in_words | Small Text Optional · Read-only | In Words will be visible once you save the Sales Invoice. |
Rounding Adjustmentbase_rounding_adjustment | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Rounded Totalbase_rounded_total | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Total Advancetotal_advance | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Outstanding Amountoutstanding_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Tax Withholding Grouptax_withholding_group | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Tax Withholding Group |
Ignore Tax Withholding Thresholdignore_tax_withholding_threshold | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Edit Tax Withholding Entriesoverride_tax_withholding_entries | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Tax Withholding Entriestax_withholding_entries | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Tax Withholding Entry |
Apply Additional Discount Onapply_discount_on | Select Optional | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Additional Discount Amount (Company Currency)base_discount_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Coupon Codecoupon_code | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Coupon Code |
Additional Discount Percentageadditional_discount_percentage | Float Optional | Enter a numeric value using the required unit and precision. |
Additional Discount Amountdiscount_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Is Cash or Non Trade Discountis_cash_or_non_trade_discount | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Taxes and Charges Calculationother_charges_calculation | Text Editor Optional · Read-only | Maintain formatted content for the record; review any public-facing output before publishing. |
Pricing Rule Detailpricing_rules | Table Optional · Read-only | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Pricing Rule Detail |
Packed Itemspacked_items | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Packed Item |
Time Sheetstimesheets | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Sales Invoice Timesheet |
Total Billing Hourstotal_billing_hours | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Total Billing Amounttotal_billing_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Sales Invoice Paymentpayments | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Sales Invoice Payment |
Paid Amount (Company Currency)base_paid_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Paid Amountpaid_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Base Change Amount (Company Currency)base_change_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Change Amountchange_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Account for Change Amountaccount_for_change_amount | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Allocate Advances Automatically (FIFO)allocate_advances_automatically | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Only Include Allocated Paymentsonly_include_allocated_payments | Check Optional | Advance payments allocated against orders will only be fetched |
Advancesadvances | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Sales Invoice Advance |
Write Off Amountwrite_off_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Write Off Amount (Company Currency)base_write_off_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Write Off Outstanding Amountwrite_off_outstanding_amount_automatically | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Write Off Accountwrite_off_account | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Write Off Cost Centerwrite_off_cost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Redeem Loyalty Pointsredeem_loyalty_points | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Loyalty Pointsloyalty_points | Int Optional | Enter a whole-number value. |
Loyalty Amountloyalty_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Loyalty Programloyalty_program | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Loyalty Program |
Don't Create Loyalty Pointsdont_create_loyalty_points | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Redemption Accountloyalty_redemption_account | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Redemption Cost Centerloyalty_redemption_cost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Customer Addresscustomer_address | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Address |
Addressaddress_display | Text Editor Optional · Read-only | Maintain formatted content for the record; review any public-facing output before publishing. |
Contact Personcontact_person | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Contact |
Contactcontact_display | Small Text Optional · Read-only | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
Territoryterritory | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Territory |
Shipping Address Nameshipping_address_name | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Address |
Shipping Addressshipping_address | Text Editor Optional · Read-only | Maintain formatted content for the record; review any public-facing output before publishing. |
Dispatch Address Namedispatch_address_name | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Address |
Dispatch Addressdispatch_address | Text Editor Optional · Read-only | Maintain formatted content for the record; review any public-facing output before publishing. |
Company Address Namecompany_address | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Address |
Company Addresscompany_address_display | Text Editor Optional · Read-only | Maintain formatted content for the record; review any public-facing output before publishing. |
Company Contact Personcompany_contact_person | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Contact |
Payment Terms Templatepayment_terms_template | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Payment Terms Template |
Payment Schedulepayment_schedule | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Payment Schedule |
Termstc_name | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Terms and Conditions |
Terms and Conditions Detailsterms | Text Editor Optional | Maintain formatted content for the record; review any public-facing output before publishing. |
Customer's Purchase Orderpo_no | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Customer's Purchase Order Datepo_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Debit Todebit_to | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Unrealized Profit / Loss Accountunrealized_profit_loss_account | Link Optional | Unrealized Profit / Loss account for intra-company transfers Linked record: Account |
Sales Partnersales_partner | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Sales Partner |
Amount Eligible for Commissionamount_eligible_for_commission | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Commission Rate (%)commission_rate | Float Optional | Enter a numeric value using the required unit and precision. |
Total Commissiontotal_commission | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Sales Contributions and Incentivessales_team | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Sales Team |
Letter Headletter_head | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Letter Head |
Group same itemsgroup_same_items | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Print Headingselect_print_heading | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Print Heading |
Print Languagelanguage | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Language |
Subscriptionsubscription | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Subscription |
From Datefrom_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
To Dateto_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Auto Repeatauto_repeat | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Auto Repeat |
Sourceutm_source | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UTM Source |
Mediumutm_medium | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UTM Medium |
Campaignutm_campaign | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UTM Campaign |
Contentutm_content | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Statusstatus | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Remarksremarks | Small Text Optional | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
Titletitle | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Is Internal Customeris_internal_customer | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Represents Companyrepresents_company | Link Optional · Read-only | Company which internal customer represents Linked record: Company |
Inter Company Invoice Referenceinter_company_invoice_reference | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Purchase Invoice |
Is Discountedis_discounted | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Child tables
Items — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Barcodebarcode | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Has Item Scannedhas_item_scanned | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Itemitem_code | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Item |
Item Nameitem_name | Data Required | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Descriptiondescription | Text Editor Optional | Maintain formatted content for the record; review any public-facing output before publishing. |
Image Viewimage_view | Image Optional | Complete the value according to the field label and the record’s validation rules. |
Quantityqty | Float Optional | Enter a numeric value using the required unit and precision. |
Stock UOMstock_uom | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UOM |
UOMuom | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UOM |
UOM Conversion Factorconversion_factor | Float Required | Enter a numeric value using the required unit and precision. |
Qty as per Stock UOMstock_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Price List Rateprice_list_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Price List Rate (Company Currency)base_price_list_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Margin Typemargin_type | Select Optional | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Margin Rate or Amountmargin_rate_or_amount | Float Optional | Enter a numeric value using the required unit and precision. |
Rate With Marginrate_with_margin | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Discount (%) on Price List Rate with Margindiscount_percentage | Percent Optional | Enter the percentage expected by the calculation and verify the resulting amount. |
Discount Amountdiscount_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Distributed Discount Amountdistributed_discount_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Rate With Margin (Company Currency)base_rate_with_margin | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Raterate | Currency Required | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Amountamount | Currency Required · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Item Tax Templateitem_tax_template | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Item Tax Template |
Tax Withholding Categorytax_withholding_category | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Tax Withholding Category |
Rate (Company Currency)base_rate | Currency Required · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Amount (Company Currency)base_amount | Currency Required · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Rate of Stock UOMstock_uom_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Is Free Itemis_free_item | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Consider for Tax Withholdingapply_tds | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Grant Commissiongrant_commission | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Allow Zero Valuation Rateallow_zero_valuation_rate | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Net Ratenet_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Net Amountnet_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Net Rate (Company Currency)base_net_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Net Amount (Company Currency)base_net_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Delivered By Supplierdelivered_by_supplier | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Income Accountincome_account | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Assetasset | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Asset |
Finance Bookfinance_book | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Finance Book |
Expense Accountexpense_account | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Deferred Revenue Accountdeferred_revenue_account | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Service Stop Dateservice_stop_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Enable Deferred Revenueenable_deferred_revenue | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Service Start Dateservice_start_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Service End Dateservice_end_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Weight Per Unitweight_per_unit | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Total Weighttotal_weight | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Weight UOMweight_uom | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UOM |
Warehousewarehouse | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Warehouse |
Quality Inspectionquality_inspection | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Quality Inspection |
Serial and Batch Bundleserial_and_batch_bundle | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Serial and Batch Bundle |
Use Serial No / Batch Fieldsuse_serial_batch_fields | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Incoming Rate (Costing)incoming_rate | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Available Batch Qty at Warehouseactual_batch_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Serial Noserial_no | Text Optional | Provide the required record description or content. Keep operational instructions clear and applicable. |
Batch Nobatch_no | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Batch |
Qty (Warehouse)actual_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Qty (Company)company_total_stock | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Sales Ordersales_order | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Sales Order |
Sales Invoice Itemsales_invoice_item | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Delivery Notedelivery_note | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Delivery Note |
Delivered Qtydelivered_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
POS Invoicepos_invoice | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: POS Invoice |
POS Invoice Itempos_invoice_item | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Purchase Orderpurchase_order | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Purchase Order |
Purchase Order Itempurchase_order_item | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Cost Centercost_center | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Projectproject | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Project |
Page Breakpage_break | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Sales Taxes and Charges — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Typecharge_type | Select Required | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Reference Row #row_id | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Account Headaccount_head | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Descriptiondescription | Small Text Required | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
Is this Tax included in Basic Rate?included_in_print_rate | Check Optional | If checked, the tax amount will be considered as already included in the Print Rate / Print Amount |
Considered In Paid Amountincluded_in_paid_amount | Check Optional | If checked, the tax amount will be considered as already included in the Paid Amount in Payment Entry |
Is Tax Withholding Accountis_tax_withholding_account | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Cost Centercost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Projectproject | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Project |
Tax Raterate | Float Optional | Enter a numeric value using the required unit and precision. |
Account Currencyaccount_currency | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Currency |
Net Amountnet_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Amounttax_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Totaltotal | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Tax Amount After Discount Amounttax_amount_after_discount_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Net Amount (Company Currency)base_net_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Amount (Company Currency)base_tax_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Total (Company Currency)base_total | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Tax Amount After Discount Amount (Company Currency)base_tax_amount_after_discount_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Tax Withholding Entries — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Companycompany | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Company |
Party Typeparty_type | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Partyparty | Dynamic Link Optional · Read-only | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Tax IDtax_id | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Tax Withholding Categorytax_withholding_category | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Tax Withholding Category |
Tax Withholding Grouptax_withholding_group | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Tax Withholding Group |
Base Taxable Amounttaxable_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Tax Ratetax_rate | Percent Optional | Enter the percentage expected by the calculation and verify the resulting amount. |
Base Tax Withheldwithholding_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Taxable Document Typetaxable_doctype | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Taxable Document Nametaxable_name | Dynamic Link Optional | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Taxable Datetaxable_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Currencycurrency | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Currency |
Exchange Rateconversion_rate | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Under Withheld Reasonunder_withheld_reason | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Lower Deduction Certificatelower_deduction_certificate | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Lower Deduction Certificate |
Withholding Document Typewithholding_doctype | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Withholding Document Namewithholding_name | Dynamic Link Optional | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Withholding Datewithholding_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Statusstatus | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Pricing Rule Detail — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Pricing Rulepricing_rule | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Pricing Rule |
Item Codeitem_code | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Rule Appliedrule_applied | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Packed Items — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Parent Itemparent_item | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Item |
Item Codeitem_code | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Item |
Item Nameitem_name | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Supplier delivers to Customerdelivered_by_supplier | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Descriptiondescription | Text Editor Optional | Maintain formatted content for the record; review any public-facing output before publishing. |
From Warehousewarehouse | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Warehouse |
To Warehouse (Optional)target_warehouse | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Warehouse |
Conversion Factorconversion_factor | Float Optional | Enter a numeric value using the required unit and precision. |
Qtyqty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Raterate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
UOMuom | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UOM |
Use Serial No / Batch Fieldsuse_serial_batch_fields | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Serial and Batch Bundleserial_and_batch_bundle | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Serial and Batch Bundle |
Serial Noserial_no | Text Optional | Provide the required record description or content. Keep operational instructions clear and applicable. |
Batch Nobatch_no | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Batch |
Actual Batch Quantityactual_batch_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Actual Qtyactual_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Projected Qtyprojected_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Ordered Qtyordered_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Packed Qtypacked_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Requested Qtyrequested_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Incoming Rateincoming_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Picked Qtypicked_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Page Breakpage_break | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Time Sheets — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Activity Typeactivity_type | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Activity Type |
Descriptiondescription | Small Text Optional · Read-only | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
From Timefrom_time | Datetime Optional | Record the date and time in the configured system/user time zone. |
To Timeto_time | Datetime Optional | Record the date and time in the configured system/user time zone. |
Billing Hoursbilling_hours | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Billing Amountbilling_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Time Sheettime_sheet | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Timesheet |
Project Nameproject_name | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Sales Invoice Payment — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Mode of Paymentmode_of_payment | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Mode of Payment |
Amountamount | Currency Required | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Reference Noreference_no | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Accountaccount | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Typetype | Read Only Optional | System-provided value; correct its source record or calculation rather than overwriting the displayed result. |
Base Amount (Company Currency)base_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Clearance Dateclearance_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Advances — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Reference Typereference_type | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Reference Namereference_name | Dynamic Link Optional · Read-only | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Remarksremarks | Text Optional · Read-only | Provide the required record description or content. Keep operational instructions clear and applicable. |
Advance amountadvance_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Allocated amountallocated_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Exchange Gain/Lossexchange_gain_loss | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Reference Exchange Rateref_exchange_rate | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Difference Posting Datedifference_posting_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Payment Schedule — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Payment Termpayment_term | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Payment Term |
Descriptiondescription | Small Text Optional | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
Due Datedue_date | Date Required | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Invoice Portioninvoice_portion | Percent Optional | Enter the percentage expected by the calculation and verify the resulting amount. |
Mode of Paymentmode_of_payment | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Mode of Payment |
Due Date Based Ondue_date_based_on | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Credit Dayscredit_days | Int Optional · Read-only | Enter a whole-number value. |
Credit Monthscredit_months | Int Optional · Read-only | Enter a whole-number value. |
Discount Datediscount_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Discountdiscount | Float Optional | Enter a numeric value using the required unit and precision. |
Discount Typediscount_type | Select Optional | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Discount Validity Based Ondiscount_validity_based_on | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Discount Validitydiscount_validity | Int Optional · Read-only | Enter a whole-number value. |
Payment Amountpayment_amount | Currency Required | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Outstandingoutstanding | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Paid Amountpaid_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Discounted Amountdiscounted_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Payment Amount (Company Currency)base_payment_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Outstanding (Company Currency)base_outstanding | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Paid Amount (Company Currency)base_paid_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Sales Contributions and Incentives — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Sales Personsales_person | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Sales Person |
Contribution (%)allocated_percentage | Float Optional | Enter a numeric value using the required unit and precision. |
Contribution to Net Totalallocated_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Commission Ratecommission_rate | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Incentivesincentives | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Troubleshooting
- Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
- Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
- Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
- Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.