NexCommand AINexCom Knowledge Base
Field reference

POS Invoice

How to use POS Invoice in Point of Sale: access, working steps, fields, related records and troubleshooting.

Purpose and access

Select the permitted POS profile, customer and items, then review totals and the payment method. Opening and closing activities, stock availability and posting rules depend on the configured profile and assigned permissions.

This page is a record page in Sales & Marketing → Point of Sale. 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: Series, Company, 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

  1. Open POS Invoice from Sales & Marketing → Point of Sale, 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
Seriesnaming_seriesSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • ACC-PSINV-.YYYY.-
CustomercustomerLink
Optional
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.
Tax Idtax_idData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
POS Profilepos_profileLink
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

Consolidated Sales Invoiceconsolidated_invoiceLink
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

Include Payment (POS)is_posCheck
Required · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Is Return (Credit Note)is_returnCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Update Billed Amount in Sales Orderupdate_billed_amount_in_sales_orderCheck
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_noteCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
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

Dateposting_dateDate
Required
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Posting Timeposting_timeTime
Optional
Record the time in the format accepted by the field.
Edit Posting Date and Timeset_posting_timeCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Payment Due Datedue_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Amended Fromamended_fromLink
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: POS Invoice

Return Againstreturn_againstLink
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: POS Invoice

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

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

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 Currency is converted to customer'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 customer's base currency
Ignore Pricing Ruleignore_pricing_ruleCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
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

Update Stockupdate_stockCheck
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.
ItemsitemsTable
Required
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: POS Invoice 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

Packed Itemspacked_itemsTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Packed Item

Time SheetstimesheetsTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Sales Invoice Timesheet

Total Billing Amounttotal_billing_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Total Quantitytotal_qtyFloat
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
Required · 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.
Total Net Weighttotal_net_weightFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
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

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

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 ChargestaxesTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Sales Taxes and Charges

Taxes and Charges Calculationother_charges_calculationText Editor
Optional · Read-only
Maintain formatted content for the record; review any public-facing output before publishing.
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.
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

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 Amount (Company Currency)base_discount_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Additional Discount Percentageadditional_discount_percentageFloat
Optional
Enter a numeric value using the required unit and precision.
Additional Discount Amountdiscount_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Grand Total (Company Currency)base_grand_totalCurrency
Required · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Rounding Adjustment (Company Currency)base_rounding_adjustmentCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Rounded Total (Company Currency)base_rounded_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
In Words (Company Currency)base_in_wordsData
Optional · Read-only
In Words will be visible once you save the Sales Invoice.
Grand Totalgrand_totalCurrency
Required · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
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.
In Wordsin_wordsData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Total Advancetotal_advanceCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Outstanding Amountoutstanding_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Sales Invoice PaymentpaymentsTable
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_amountCurrency
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 · 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_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Change Amountchange_amountCurrency
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_amountLink
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_automaticallyCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
AdvancesadvancesTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Sales Invoice Advance

Write Off Amountwrite_off_amountCurrency
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_amountCurrency
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_automaticallyCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Write Off Accountwrite_off_accountLink
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_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

Loyalty Pointsloyalty_pointsInt
Optional
Enter a whole-number value.
Loyalty Amountloyalty_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Redeem Loyalty Pointsredeem_loyalty_pointsCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Loyalty Programloyalty_programLink
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: Loyalty Program

Redemption Accountloyalty_redemption_accountLink
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_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

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

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.
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 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.
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.
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 LanguagelanguageData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
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

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

Inter Company Invoice Referenceinter_company_invoice_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 Invoice

Is Discountedis_discountedCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
StatusstatusSelect
Optional · Read-only
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Draft
  • Return
  • Credit Note Issued
  • Consolidated
  • Submitted
  • Paid
  • Partly Paid
  • Unpaid
  • Partly Paid and Discounted
  • Unpaid and Discounted
  • Overdue and Discounted
  • Overdue
  • Cancelled
TitletitleData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Debit Todebit_toLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

Is Opening Entryis_openingSelect
Optional
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • No
  • Yes
RemarksremarksSmall Text
Optional
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
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 Rate (%)commission_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 · 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

Child tables

Items — child-row fields
FieldType / behaviorHow to use it
BarcodebarcodeData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Has Item Scannedhas_item_scannedCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Itemitem_codeLink
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_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
Optional
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

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
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.
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
Required
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
AmountamountCurrency
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_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

Rate (Company Currency)base_rateCurrency
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_amountCurrency
Required · 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.
Delivered By Supplierdelivered_by_supplierCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Income Accountincome_accountLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

AssetassetLink
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_bookLink
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_accountLink
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_accountLink
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_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Enable Deferred Revenueenable_deferred_revenueCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Service Start Dateservice_start_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Service End Dateservice_end_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Weight Per Unitweight_per_unitFloat
Optional · Read-only
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 · 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

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

Quality Inspectionquality_inspectionLink
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_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

Use Serial No / Batch Fieldsuse_serial_batch_fieldsCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Allow Zero Valuation Rateallow_zero_valuation_rateCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Available Batch Qty at Warehouseactual_batch_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Available Qty at Warehouseactual_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
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

Sales Ordersales_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: Sales Order

POS Invoice Itempos_invoice_itemData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Delivery Notedelivery_noteLink
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_qtyFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Cost Centercost_centerLink
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

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

Page Breakpage_breakCheck
Optional
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.
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.
Time Sheets — child-row fields
FieldType / behaviorHow to use it
Activity Typeactivity_typeLink
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

DescriptiondescriptionSmall Text
Optional · Read-only
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
From Timefrom_timeDatetime
Optional
Record the date and time in the configured system/user time zone.
To Timeto_timeDatetime
Optional
Record the date and time in the configured system/user time zone.
Billing Hoursbilling_hoursFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Billing Amountbilling_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Time Sheettime_sheetLink
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_nameData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
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.
Sales Invoice Payment — child-row fields
FieldType / behaviorHow to use it
Mode of Paymentmode_of_paymentLink
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

AmountamountCurrency
Required
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Reference Noreference_noData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
AccountaccountLink
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

TypetypeRead Only
Optional
System-provided value; correct its source record or calculation rather than overwriting the displayed result.
Base 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.
Clearance Dateclearance_dateDate
Optional · Read-only
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Advances — child-row fields
FieldType / behaviorHow to use it
Reference Typereference_typeLink
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_nameDynamic Link
Optional · Read-only
Select the record identified by the associated document-type field. Verify both the type and the linked record.
RemarksremarksText
Optional · Read-only
Provide the required record description or content. Keep operational instructions clear and applicable.
Advance amountadvance_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Allocated amountallocated_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Exchange Gain/Lossexchange_gain_lossCurrency
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_rateFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Difference Posting Datedifference_posting_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
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.