NexCommand AINexCom Knowledge Base
Field reference

Sales Order

How to use Sales Order in Quotations & Sales Orders: access, working steps, fields, related records and troubleshooting.

Purpose and access

Build a quotation from the agreed items, prices and terms, then create the sales order after confirmation. Review currency, dates, taxes, warehouse and fulfillment information before submission.

This page is a record page in Sales & Marketing → Quotations & Sales Orders. 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, Order Type, Date, Currency, Exchange Rate, Price List, Price List Exchange Rate, Items.

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

  1. Open Sales Order from Sales & Marketing → Quotations & Sales Orders, or use ERP Search.
  2. Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
  3. 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.
  4. Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
  5. Save the record and address validation messages. Reload and verify the saved values and relationships.
  6. 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.

FieldType / behaviorHow to use it
CompanycompanyLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Company

Seriesnaming_seriesSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • SAL-ORD-.YYYY.-
CustomercustomerLink
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_nameData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Order Typeorder_typeSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Sales
  • Maintenance
  • Shopping Cart
Datetransaction_dateDate
Required
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Timetransaction_timeTime
Optional
Record the time in the format accepted by the field.
Delivery Datedelivery_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Tax Idtax_idData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Skip Delivery Noteskip_delivery_noteCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Is Subcontractedis_subcontractedCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Cost Centercost_centerLink
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

ProjectprojectLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Project

CurrencycurrencyLink
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_rateFloat
Required
Rate at which customer's currency is converted to company's base currency
Price Listselling_price_listLink
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_currencyLink
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_rateFloat
Required
Rate at which Price list currency is converted to company's base currency
Ignore Pricing Ruleignore_pricing_ruleCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Scan Barcodescan_barcodeData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Last Scanned Warehouselast_scanned_warehouseData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Set Source Warehouseset_warehouseLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Warehouse

Reserve Stockreserve_stockCheck
Optional
If checked, Stock will be reserved on Submit
ItemsitemsTable
Required
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Sales Order Item

Total Quantitytotal_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Total Net Weighttotal_net_weightFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Total (Company Currency)base_totalCurrency
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_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
TotaltotalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Net Totalnet_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Tax Categorytax_categoryLink
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_chargesLink
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

Is customer exempted from sales tax?exempt_from_sales_taxCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Shipping Ruleshipping_ruleLink
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

IncotermincotermLink
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_placeData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Sales Taxes and ChargestaxesTable
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_chargesCurrency
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_chargesCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Grand Totalgrand_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
In Wordsin_wordsData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Disable Rounded Totaldisable_rounded_totalCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Rounding Adjustmentrounding_adjustmentCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Rounded Totalrounded_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Grand Totalbase_grand_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
In Wordsbase_in_wordsData
Optional · Read-only
In Words will be visible once you save the Sales Order.
Rounding Adjustmentbase_rounding_adjustmentCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Rounded Totalbase_rounded_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Advance Paidadvance_paidCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Apply Additional Discount Onapply_discount_onSelect
Optional
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Grand Total
  • Net Total
Additional Discount Amountbase_discount_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Coupon Codecoupon_codeLink
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_percentageFloat
Optional
Enter a numeric value using the required unit and precision.
Additional Discount Amountdiscount_amountCurrency
Optional
Applying a Discount Amount? When this Sales Order is partially fulfilled through multiple Delivery Notes and Sales Invoices, the Discount Amount is allocated on a FIFO basis. The earlier transactions receive a larger share of the discount. To spread the discount proportionally across item prices, use Additional Discount Percentage instead.
Taxes and Charges Calculationother_charges_calculationText Editor
Optional · Read-only
Maintain formatted content for the record; review any public-facing output before publishing.
Packed Itemspacked_itemsTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Packed Item

Pricing Rule Detailpricing_rulesTable
Optional · Read-only
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Pricing Rule Detail

Customer Addresscustomer_addressLink
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_displayText Editor
Optional · Read-only
Maintain formatted content for the record; review any public-facing output before publishing.
TerritoryterritoryLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Territory

Contact Personcontact_personLink
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_displaySmall Text
Optional · Read-only
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
Phonecontact_phoneData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Mobile Nocontact_mobileSmall Text
Optional · Read-only
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
Shipping Address Nameshipping_address_nameLink
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_addressText Editor
Optional · Read-only
Maintain formatted content for the record; review any public-facing output before publishing.
Dispatch Address Namedispatch_address_nameLink
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_addressText Editor
Optional · Read-only
Maintain formatted content for the record; review any public-facing output before publishing.
Company Address Namecompany_addressLink
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_displayText Editor
Optional · Read-only
Maintain formatted content for the record; review any public-facing output before publishing.
Company Contact Personcompany_contact_personLink
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_templateLink
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_scheduleTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Payment Schedule

Termstc_nameLink
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 DetailstermsText Editor
Optional
Maintain formatted content for the record; review any public-facing output before publishing.
StatusstatusSelect
Required · Read-only
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Draft
  • On Hold
  • To Pay
  • To Deliver and Bill
  • To Bill
  • To Deliver
  • Completed
  • Cancelled
  • Closed
% Deliveredper_deliveredPercent
Optional · Read-only
% of materials delivered against this Sales Order
% Amount Billedper_billedPercent
Optional · Read-only
% of materials billed against this Sales Order
% Pickedper_pickedPercent
Optional · Read-only
Enter the percentage expected by the calculation and verify the resulting amount.
Sales Partnersales_partnerLink
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_commissionCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Commission Ratecommission_rateFloat
Optional
Enter a numeric value using the required unit and precision.
Total Commissiontotal_commissionCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Sales Teamsales_teamTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Sales Team

From Datefrom_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
To Dateto_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Auto Repeatauto_repeatLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Auto Repeat

Letter Headletter_headLink
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_itemsCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Print Headingselect_print_headingLink
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 LanguagelanguageLink
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

Sourceutm_sourceLink
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_mediumLink
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_campaignLink
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_contentData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Is Internal Customeris_internal_customerCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Customer's Purchase Orderpo_noData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Customer's Purchase Order Datepo_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Represents Companyrepresents_companyLink
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: Company

TitletitleData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Inter Company Order Referenceinter_company_order_referenceLink
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

Child tables

Items — child-row fields
FieldType / behaviorHow to use it
Finished Goodfg_itemLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Item

Finished Good Qtyfg_item_qtyFloat
Optional
Enter a numeric value using the required unit and precision.
Item Codeitem_codeLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Item

Ensure Delivery Based on Produced Serial Noensure_delivery_based_on_produced_serial_noCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Reserve Stockreserve_stockCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Delivery Datedelivery_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Item Nameitem_nameData
Required
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
DescriptiondescriptionText Editor
Optional
Maintain formatted content for the record; review any public-facing output before publishing.
Image Viewimage_viewImage
Optional
Complete the value according to the field label and the record’s validation rules.
QuantityqtyFloat
Required
Enter a numeric value using the required unit and precision.
Stock UOMstock_uomLink
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

Subcontracted Quantitysubcontracted_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
UOMuomLink
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_factorFloat
Required · Read-only
Enter a numeric value using the required unit and precision.
Qty as per Stock UOMstock_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Stock Reserved Qty (in Stock UOM)stock_reserved_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Price List Rateprice_list_rateCurrency
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_rateCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Margin Typemargin_typeSelect
Optional
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Percentage
  • Amount
Margin Rate or Amountmargin_rate_or_amountFloat
Optional
Enter a numeric value using the required unit and precision.
Rate With Marginrate_with_marginCurrency
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_percentagePercent
Optional
Enter the percentage expected by the calculation and verify the resulting amount.
Discount Amountdiscount_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Distributed Discount Amountdistributed_discount_amountCurrency
Optional
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_marginCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
RaterateCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
AmountamountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Item Tax Templateitem_tax_templateLink
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

Basic Rate (Company Currency)base_rateCurrency
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_amountCurrency
Optional · 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_rateCurrency
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_itemCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Grant Commissiongrant_commissionCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Net Ratenet_rateCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Net Amountnet_amountCurrency
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_rateCurrency
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_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Billed Amtbilled_amtCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Valuation Ratevaluation_rateCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Gross Profitgross_profitCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Supplier delivers to Customerdelivered_by_supplierCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
SuppliersupplierLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Supplier

Weight Per Unitweight_per_unitFloat
Optional
Enter a numeric value using the required unit and precision.
Total Weighttotal_weightFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Weight UOMweight_uomLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: UOM

Source WarehousewarehouseLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Warehouse

Quotationprevdoc_docnameLink
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: Quotation

Against Blanket Orderagainst_blanket_orderCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Blanket Orderblanket_orderLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Blanket Order

Blanket Order Rateblanket_order_rateCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Qty (Warehouse)actual_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Qty (Company)company_total_stockFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
BOM Nobom_noLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: BOM

Projected Qtyprojected_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Ordered Qtyordered_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Production Plan Qtyproduction_plan_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Requested Qtyrequested_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Work Order Qtywork_order_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Delivered Qtydelivered_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Returned Qtyreturned_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Picked Qty (in Stock UOM)picked_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Additional Notesadditional_notesText
Optional
Provide the required record description or content. Keep operational instructions clear and applicable.
Page Breakpage_breakCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Material Requestmaterial_requestLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Material Request

Purchase Orderpurchase_orderLink
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

Material Request Itemmaterial_request_itemData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Purchase Order Itempurchase_order_itemData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Cost Centercost_centerLink
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

ProjectprojectLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Project

Sales Taxes and Charges — child-row fields
FieldType / behaviorHow to use it
Typecharge_typeSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Actual
  • On Net Total
  • On Previous Row Amount
  • On Previous Row Total
  • On Item Quantity
Reference Row #row_idData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Account Headaccount_headLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

DescriptiondescriptionSmall 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_rateCheck
Optional
If checked, the tax amount will be considered as already included in the Print Rate / Print Amount
Considered In Paid Amountincluded_in_paid_amountCheck
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_accountCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Cost Centercost_centerLink
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

ProjectprojectLink
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 RaterateFloat
Optional
Enter a numeric value using the required unit and precision.
Account Currencyaccount_currencyLink
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_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Amounttax_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
TotaltotalCurrency
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_amountCurrency
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_amountCurrency
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_amountCurrency
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_totalCurrency
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_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Packed Items — child-row fields
FieldType / behaviorHow to use it
Parent Itemparent_itemLink
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_codeLink
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_nameData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Supplier delivers to Customerdelivered_by_supplierCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
DescriptiondescriptionText Editor
Optional
Maintain formatted content for the record; review any public-facing output before publishing.
From WarehousewarehouseLink
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_warehouseLink
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_factorFloat
Optional
Enter a numeric value using the required unit and precision.
QtyqtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
RaterateCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
UOMuomLink
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_fieldsCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Serial and Batch Bundleserial_and_batch_bundleLink
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_noText
Optional
Provide the required record description or content. Keep operational instructions clear and applicable.
Batch Nobatch_noLink
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_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Actual Qtyactual_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Projected Qtyprojected_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Ordered Qtyordered_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Packed Qtypacked_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Requested Qtyrequested_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Incoming Rateincoming_rateCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Picked Qtypicked_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Page Breakpage_breakCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Pricing Rule Detail — child-row fields
FieldType / behaviorHow to use it
Pricing Rulepricing_ruleLink
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_codeData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Rule Appliedrule_appliedCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Payment Schedule — child-row fields
FieldType / behaviorHow to use it
Payment Termpayment_termLink
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

DescriptiondescriptionSmall Text
Optional
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
Due Datedue_dateDate
Required
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Invoice Portioninvoice_portionPercent
Optional
Enter the percentage expected by the calculation and verify the resulting amount.
Mode of Paymentmode_of_paymentLink
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_onSelect
Optional · Read-only
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Day(s) after invoice date
  • Day(s) after the end of the invoice month
  • Month(s) after the end of the invoice month
Credit Dayscredit_daysInt
Optional · Read-only
Enter a whole-number value.
Credit Monthscredit_monthsInt
Optional · Read-only
Enter a whole-number value.
Discount Datediscount_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
DiscountdiscountFloat
Optional
Enter a numeric value using the required unit and precision.
Discount Typediscount_typeSelect
Optional
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Percentage
  • Amount
Discount Validity Based Ondiscount_validity_based_onSelect
Optional · Read-only
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Day(s) after invoice date
  • Day(s) after the end of the invoice month
  • Month(s) after the end of the invoice month
Discount Validitydiscount_validityInt
Optional · Read-only
Enter a whole-number value.
Payment Amountpayment_amountCurrency
Required
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
OutstandingoutstandingCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Paid Amountpaid_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Discounted Amountdiscounted_amountCurrency
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_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Outstanding (Company Currency)base_outstandingCurrency
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_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Sales Team — child-row fields
FieldType / behaviorHow to use it
Sales Personsales_personLink
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_percentageFloat
Optional
Enter a numeric value using the required unit and precision.
Contribution to Net Totalallocated_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Commission Ratecommission_rateData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
IncentivesincentivesCurrency
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.