iVendNextDevelopers Request a sandbox

POS Invoice

One sale rung up at a till: its lines, payments, customer and store. A till return is a POS Invoice with Is Return ticked.

Area: Till sales · Why it is here: openapi.yaml; contract fiscal_reader; guide chapter 01c; guide chapter 10; recipe customer_history_page; recipe duty_free_allowance; recipe gift_card_on_spend; recipe loyalty_provider; recipe lucky_draw; recipe portal; recipe post_sale_feedback; recipe receipt_format; recipe restaurant_back_office; recipe stock_alerts; recipe system_sync; recipe webhook_receiver; sample S13; sample S2; sample S22; sample S25; sample S3; sample S36; sample S4; sample S41; sample S43; sample S49; sample S52; sample S9; the MCP server; the feed client; the request collection; retail core · Fields: 219 · Submitted (booked) records: send docstatus: 1 to book it as you create it, or submit a draft with submit.

Read and write it

Every call runs as your app's own user, with its key in one header, at the retailer's own address. The user reads and writes only what its role allows: your app's user, and the rights the retailer gives it.

Read a list (only name unless you ask for fields):

curl -s "https://⟨site⟩/api/resource/POS%20Invoice?fields=%5B%22*%22%5D&limit_page_length=20" \
  -H "Authorization: token ⟨api key⟩:⟨api secret⟩"

Read one, with its tables:

curl -s "https://⟨site⟩/api/resource/POS%20Invoice/⟨name⟩" -H "Authorization: token ⟨api key⟩:⟨api secret⟩"

Create one (the required fields first), if your app's role may:

curl -s -X POST "https://⟨site⟩/api/resource/POS%20Invoice" -H "Authorization: token ⟨api key⟩:⟨api secret⟩" \
  -H "Content-Type: application/json" -d '{"naming_series": …, "company": …, "posting_date": …, "currency": …, "conversion_rate": …, "selling_price_list": …}'

Change one with PUT /api/resource/POS%20Invoice/⟨name⟩ and the fields you change; a table sent there replaces its rows, so send its existing rows too. All the record calls and their answers: the API reference.

Samples that use it

s1_warranty · s2_bins · s3_price_audit · s4_receipt_pack · s7_system_sync · s9_bi_feed · s13_portal · s22_customer_loyalty · s25_gift_on_spend · s27_stock_alerts · s28_merge_and_history · s30_units_as_serials · s32_coupon_rules · s36_duty_free · s39_pharmacy_counter · s40_expiry_recall · s41_regulated_register · s42_optical_prescriptions · s43_third_party_payer · s44_lucky_draw · s45_restaurant_back_office · s49_post_sale_feedback · s52_phone_plans

Fields

Read from the product at POS 2.1.0.667 (till app 60147699c): its own fields, the fields iVendNext adds to it, and iVendNext's changes to any of them. Read-only fields are set by iVendNext; a hidden one is not on the form but can be read. Every record also has name (its id, in the address), owner, creation, modified, modified_by and docstatus (0 a draft, 1 submitted, 2 cancelled), all read-only.

Field Field name Type Required Read-only Hidden Links to
Title title Data yes
Series naming_series Select yes one of: ACC-PSINV-.YYYY.-
Customer customer Link Customer
Customer Name customer_name Data yes
Tax Id tax_id Data yes
POS Profile pos_profile Link POS Profile
POS Opening Entry (added by iVendNext) custom_pos_opening_entry Link POS Opening Entry
POS Terminal (added by iVendNext) custom_pos_terminal Data yes
Sold on iVendNext POS (Till, Tablet or Phone) (added by iVendNext) custom_retail_mpos_source Check yes
Settle At Till (added by iVendNext) custom_settle_at_register Link POS Terminal
Consolidated Sales Invoice consolidated_invoice Link yes Sales Invoice
Consolidated Credit Note (added by iVendNext) custom_consolidated_credit_note Link yes Sales Invoice
Consolidated FulFillment Invoice (added by iVendNext) custom_consolidated_fulfillment_invoice Link yes Sales Invoice
Include Payment (POS) is_pos Check yes yes
Is Return (Credit Note) is_return Check
Update Billed Amount in Sales Order update_billed_amount_in_sales_order Check
Suspended (added by iVendNext) custom_suspended Check yes
Quotation (added by iVendNext) custom_quotation Check yes
Disabled (added by iVendNext) custom_disabled Check yes
Void Transaction (added by iVendNext) custom_void_transaction Check yes
Update Billed Amount in Delivery Note update_billed_amount_in_delivery_note Check
Company company Link yes Company
Date posting_date Date yes
Posting Time posting_time Time
Edit Posting Date and Time set_posting_time Check
Payment Due Date due_date Date
Email (added by iVendNext) custom_email Data yes
Phone Number (added by iVendNext) custom_phone_no Data yes
Invoice UUID (added by iVendNext) custom_invoice_uuid Data yes yes
Amended From amended_from Link yes POS Invoice
Return Against return_against Link yes POS Invoice
Deliver Against (added by iVendNext) custom_deliver_against Link yes POS Invoice
Quotation Reference Number (added by iVendNext) custom_quotation_reference_number Link yes Quotation
Is Table Visible (added by iVendNext) custom_is_table_visible Check
Project project Link Project
Cost Center cost_center Link Cost Center
Customer's Purchase Order po_no Data
Customer's Purchase Order Date po_date Date
Customer Address customer_address Link Address
Address address_display Small Text yes
Contact Person contact_person Link Contact
Contact contact_display Small Text yes
Mobile No contact_mobile Data yes yes
Contact Email contact_email Data yes
Territory territory Link Territory
Shipping Address Name shipping_address_name Link Address
Shipping Address shipping_address Small Text yes
Company Address Name company_address Link Address
Company Address company_address_display Small Text yes yes
Company Contact Person company_contact_person Link Contact
Currency currency Link yes Currency
Exchange Rate conversion_rate Float yes
Price List selling_price_list Link yes Price List
Price List Currency price_list_currency Link yes yes Currency
Price List Exchange Rate plc_conversion_rate Float yes
Ignore Pricing Rule ignore_pricing_rule Check
Source Warehouse set_warehouse Link Warehouse
Update Stock update_stock Check
Scan Barcode scan_barcode Data
Transaction Mode (added by iVendNext) transaction_mode Link yes POS Transaction Mode
Items items Table yes POS Invoice Item
Pricing Rule Detail pricing_rules Table yes Pricing Rule Detail
Packed Items packed_items Table Packed Item
Time Sheets timesheets Table Sales Invoice Timesheet
Total Billing Amount total_billing_amount Currency yes
Total Quantity total_qty Float yes
Total (Company Currency) base_total Currency yes
Net Total (Company Currency) base_net_total Currency yes yes
GC Total (added by iVendNext) custom_gc_total Currency yes
Total total Currency yes
Net Total net_total Currency yes
Total Net Weight total_net_weight Float yes
Sales Taxes and Charges Template taxes_and_charges Link Sales Taxes and Charges Template
Shipping Rule shipping_rule Link Shipping Rule
Tax Category tax_category Link Tax Category
Item Surcharges (added by iVendNext) custom_item_surcharges Table yes Item Surcharge
Sales Taxes and Charges taxes Table Sales Taxes and Charges
Taxes and Charges Calculation other_charges_calculation Text Editor yes
Total Taxes and Charges (Company Currency) base_total_taxes_and_charges Currency yes
Total Surcharge (added by iVendNext) custom_total_surcharge Currency yes
Head Surcharge (added by iVendNext) custom_head_surcharge Currency yes
Total Taxes and Charges total_taxes_and_charges Currency yes
Tax before Surcharge (added by iVendNext) custom_tax_before_surcharge Currency yes
Loyalty Points loyalty_points Int
Loyalty Amount loyalty_amount Currency yes
Redeem Loyalty Points redeem_loyalty_points Check
Points Available (added by iVendNext) custom_points_available Int yes
Points Redeemed (added by iVendNext) custom_points_redeemed Int
Amount Redeemed (added by iVendNext) custom_amount_redeemed Currency yes
Redeem Loyalty Points (added by iVendNext) custom_redeem_loyalty Check
Loyalty Program loyalty_program Link yes Loyalty Program
Redemption Account loyalty_redemption_account Link Account
Redemption Cost Center loyalty_redemption_cost_center Link Cost Center
Loyalty Program (added by iVendNext) custom_loyaltyprogram Link yes Loyalty Setup
Redemption Account (added by iVendNext) custom_redemptionaccount Link Account
Redeption Cost Center (added by iVendNext) custom_redemptioncostcenter Link Cost Center
Coupon Code coupon_code Link Coupon Code
Apply Additional Discount On apply_discount_on Select one of: Grand Total, Net Total
Additional Discount Amount (Company Currency) base_discount_amount Currency yes
Additional Discount Percentage additional_discount_percentage Float
Additional Discount Amount discount_amount Currency
Promotions (added by iVendNext) custom_promotions Table yes Transaction Promotion Bonus Buys Detail
Coupons (added by iVendNext) custom_coupons Table yes Transaction Coupon
Grand Total (Company Currency) base_grand_total Currency yes yes
Rounding Adjustment (Company Currency) base_rounding_adjustment Currency yes
Rounded Total (Company Currency) base_rounded_total Currency yes
In Words (Company Currency) base_in_words Data yes
Grand Total grand_total Currency yes yes
Rounding Adjustment rounding_adjustment Currency yes
Rounded Total rounded_total Currency yes
Disable Rounded Total (added by iVendNext) disable_rounded_total Check
In Words in_words Data yes
Total Advance total_advance Currency yes
Outstanding Amount outstanding_amount Currency yes
Allocate Advances Automatically (FIFO) allocate_advances_automatically Check
Advances advances Table Sales Invoice Advance
Payment Terms Template payment_terms_template Link Payment Terms Template
Payment Schedule payment_schedule Table Payment Schedule
AR Payment (added by iVendNext) custom_ar_payment Table yes AR Payment
Coupon Issue (added by iVendNext) custom_coupon_issue Table yes Coupon Detail
AR Payment Total (added by iVendNext) custom_ar_payment_total Currency yes
Cash/Bank Account cash_bank_account Link yes Account
Sales Invoice Payment payments Table Sales Invoice Payment
Paid Amount (Company Currency) base_paid_amount Currency yes
Paid Amount paid_amount Currency yes
Base Change Amount (Company Currency) base_change_amount Currency yes
Change Amount change_amount Currency
Account for Change Amount account_for_change_amount Link Account
Write Off Amount write_off_amount Currency
Tender Discount Amount (added by iVendNext) custom_tender_discount_amount Currency yes
Write Off Amount (Company Currency) base_write_off_amount Currency yes
Write Off Outstanding Amount write_off_outstanding_amount_automatically Check
Write Off Account write_off_account Link Account
Write Off Cost Center write_off_cost_center Link Cost Center
Lost Sale (added by iVendNext) custom_lost_sale Table Lost Sale
Terms tc_name Link Terms and Conditions
Terms and Conditions Details terms Text Editor
Letter Head letter_head Link Letter Head
Group same items group_same_items Check
Print Language language Data yes
Print Heading select_print_heading Link Print Heading
Inter Company Invoice Reference inter_company_invoice_reference Link yes Purchase Invoice
Customer Group customer_group Link yes Customer Group
Campaign campaign Link Campaign
Is Discounted is_discounted Check yes
Status status Select yes one of: Draft, Return, Credit Note Issued, Consolidated, Submitted, Paid, Unpaid, Unpaid and Discounted, Overdue and Discounted, Overdue, Cancelled, Open …
Source source Link Lead Source
Debit To debit_to Link yes Account
Party Account Currency party_account_currency Link yes yes Currency
Is Opening Entry is_opening Select one of: No, Yes
Remarks remarks Small Text
Sales Partner sales_partner Link Sales Partner
Amount Eligible for Commission amount_eligible_for_commission Currency yes
Commission Rate (%) commission_rate Float
Total Commission total_commission Currency
Sales Team sales_team Table Sales Team
From Date from_date Date
To Date to_date Date
Auto Repeat auto_repeat Link yes Auto Repeat
Against Income Account against_income_account Small Text yes
Buyer Tax ID (added by iVendNext) custom_buyer_tax_id Data
POS Idempotency Key (added by iVendNext) custom_mpos_idempotency_key Data yes yes
Card Terminal (added by iVendNext) custom_card_terminal_id Data yes yes
Employee Discount Value (added by iVendNext) custom_mpos_employee_discount_value Currency yes yes
Card Terminal Reference (added by iVendNext) custom_card_txn_ref Data yes yes
Fiscal Cancelled At Authority (added by iVendNext) custom_ivn_fiscal_cancelled Check yes yes
POS Hand-off Offered To (added by iVendNext) custom_mpos_offered_to Link yes User
POS Source Device (added by iVendNext) custom_mpos_source_device Data yes yes
Fiscal Invoice Type (added by iVendNext) custom_ivn_fiscal_invoice_type Data yes yes
Fiscal Submission Attempts (added by iVendNext) custom_ivn_submission_attempts Int yes yes
POS Override Approvals Used (added by iVendNext) custom_mpos_override_requests Small Text yes yes
Fiscal Original Reference (added by iVendNext) custom_ivn_fiscal_original_ref Data yes yes
Fiscal QR (added by iVendNext) custom_ivn_fiscal_qr Long Text yes yes
Fiscal Signature (added by iVendNext) custom_ivn_fiscal_signature Code yes yes
Fiscal Reference (added by iVendNext) custom_ivn_fiscal_ref Data yes yes
Fiscal Regime (added by iVendNext) custom_ivn_fiscal_regime Data yes yes
Fiscal Response JSON (added by iVendNext) custom_ivn_fiscal_response_json Long Text yes yes
Fiscal Status (added by iVendNext) custom_ivn_fiscal_status Select yes yes one of: PENDING, CLEARED, FAILED, REPORTED, NOT-FISCAL
Call Number (added by iVendNext) custom_mpos_call_number Data yes
Service Mode (added by iVendNext) custom_mpos_service_mode Data yes
POS Cancel Reason (added by iVendNext) custom_mpos_cancel_reason Small Text yes yes
Provisional Receipt Reference (added by iVendNext) custom_mpos_provisional_ref Data yes
Captured Offline At (added by iVendNext) custom_mpos_captured_at Datetime yes
Voucher Promised Offline, Not Issued (added by iVendNext) custom_mpos_voucher_not_issued Small Text yes
Open Check (added by iVendNext) custom_mpos_check Link yes Retail Open Check
Coupon Taken Offline, Refused at Sync (added by iVendNext) custom_mpos_coupon_refused Small Text yes
POS Sale Discount % (added by iVendNext) custom_mpos_sale_discount_pct Percent yes yes
POS Exchange Replacement (added by iVendNext) custom_mpos_exchange_key Data yes yes
Kitchen Order (added by iVendNext) custom_mpos_kitchen_ref Data yes
Paid by Customer (added by iVendNext) custom_mpos_patient_share Currency yes
Returned Whole Only (added by iVendNext) custom_mpos_payer_no_partial_refund Check yes
Payer Answer (added by iVendNext) custom_mpos_payer_answer Long Text yes yes
Payer Share Given Back (added by iVendNext) custom_mpos_payer_back Currency yes
Of It, Billed Back Earlier (added by iVendNext) custom_mpos_payer_back_billed Currency yes
Bill-Back Role (added by iVendNext) custom_mpos_payer_bill_back_role Data yes
Prescription Reference (added by iVendNext) custom_mpos_payer_prescription Data yes
Claim Reference (added by iVendNext) custom_mpos_payer_claim_ref Data yes
Billed to Payer (added by iVendNext) custom_mpos_payer_share Currency yes
Payer Clearing Account (added by iVendNext) custom_mpos_payer_clearing_account Link yes Account
Payer Code (added by iVendNext) custom_mpos_payer_code Data yes
Plan (added by iVendNext) custom_mpos_payer_plan Data yes
Payer Journal (added by iVendNext) custom_mpos_payer_journal Link yes Journal Entry
Payer Service (added by iVendNext) custom_mpos_payer_subscription Data yes
Payer (added by iVendNext) custom_mpos_payer_customer Link yes Customer
Payer Name (added by iVendNext) custom_mpos_payer_title Data yes
Member Reference (added by iVendNext) custom_mpos_payer_member Data yes
Member (added by iVendNext) custom_mpos_payer_member_label Data yes
Prescriber (added by iVendNext) custom_mpos_payer_prescriber Data yes
Prescriber Licence (added by iVendNext) custom_mpos_payer_prescriber_licence Data yes
POS Sale Discount Amount (added by iVendNext) custom_mpos_sale_discount_amt Currency yes yes
POS Basket (added by iVendNext) custom_mpos_sale_ref Data yes yes
POS Recall Reference (added by iVendNext) custom_pos_recall_reference Link yes POS Invoice
Printed (added by iVendNext) custom_printed Check yes
Reasons Code (added by iVendNext) custom_reasons Table yes Item Reason Code
Sale Order reference number (added by iVendNext) custom_sale_order_reference_number Link yes Sales Order
Valid Till (added by iVendNext) custom_valid_till Date yes
Fulfillment Plan Details (added by iVendNext) custom_fulfillment_plan_details Table Fulfillment Plan Details
POS Invoice Sale Attribute (added by iVendNext) custom_pos_invoice_sale_attribute Table POS Invoice Sale Attribute
POS Invoice Transaction Item Attribute (added by iVendNext) custom_pos_invoice_transaction_item_attribute Table POS Invoice Transaction Item Attribute

Table: AR Payment

The rows of custom_ar_payment. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Type type Select yes yes one of: AR Payment, Advance Payment, AR-SO
POS Invoice pos_invoice Link yes POS Invoice
Sales Invoice sales_invoice Link yes Sales Invoice
Selected Row selected_row Check yes
Invoice Total invoice_total Currency yes
Invoice Balance invoice_balance Currency yes
Allocated Amount allocated_amount Currency yes yes

Table: Coupon Detail

The rows of custom_coupon_issue. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Coupon Name coupon Data
Coupon Code coupon_code Data
Description description Data
Serial Number serial_number Data
Promotion Name source_promotion_name Data
Item Name source_item_name Data

Table: Fulfillment Plan Details

The rows of custom_fulfillment_plan_details. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
item item Link Item
Fulfillment Plan fulfillment_plan Link Fulfillment Plan
Qty qty Float
Rate rate Currency
Delivery Date delivery_date Date
Delivery Address delivery_address Small Text
Row No row_no Int

Table: Item Reason Code

The rows of custom_reasons. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Item Row Reference item_row_reference Int yes
Reason Code reason_code Link yes Reason Code Master
Reason Type reason_type Data yes
Comment comment Small Text yes

Table: Item Surcharge

The rows of custom_item_surcharges. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Item Code sur_item_code Link Item
For Item Row No. sur_item_row_no Int
Surcharge sur_surcharge Link yes Surcharge
Default Surcharge Amount sur_default_amount Float
Surcharge Value sur_surcharge_value Float
Amount Before Tax sur_amount_before_tax Float
Total Tax sur_total_tax Float
Amount After Tax sur_amount_after_tax Float
Discountable sur_is_discountable Check
Refundable sur_is_refundable Check yes
Taxable sur_is_taxable Check
Load on Item Cost sur_load_on_item_cost Check
Is Multitax (added by iVendNext) custom_is_multitax Check yes
Amount Type sur_amount_type Select yes one of: Flat Amount, Percentage
DIscount Type sur_discount_type Select one of: Flat Amount, Percentage
Flat Discount sur_flat_discount Float
Discount % sur_discount_percent Percent
Discount Given sur_discount_given Float
Tax Template sur_tax_template Link Item Tax Template
Tax Rate % sur_tax_rate Percent
Account Head sur_account_head Link Account
Sur Tax Account Head sur_tax_account_head Link yes Account
Return is_return Check yes
Surcharge Total Tax Types (added by iVendNext) custom_surcharge_total_tax_types Text yes
Tax Detail sur_tax_detail Long Text

Table: Lost Sale

The rows of custom_lost_sale. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Item Code item_code Link Item

Table: POS Invoice Item

The rows of items. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Barcode barcode Data
Has Item Scanned has_item_scanned Check yes
Transaction Mode (added by iVendNext) transaction_mode Link POS Transaction Mode
Original Transaction Mode (added by iVendNext) custom_original_transaction_mode Link yes yes POS Transaction Mode
Fulfillment Option (added by iVendNext) custom_fulfillment_option Data yes
Selected Row (added by iVendNext) selected_row Check yes
Open Price (added by iVendNext) custom_open_price Check yes
Is weighted item (added by iVendNext) custom_is_weighted_item Check yes
Print as Gift Item (added by iVendNext) custom_print_as_gift_item Check yes
Item item_code Link Item
Item Name item_name Data yes
Customer's Item Code customer_item_code Data yes yes
Gift Card Master (added by iVendNext) custom_gift_card_master Link yes Gift Card Master
Gift Card Type (added by iVendNext) custom_gift_card_type Data yes
Gift Card Serial No (added by iVendNext) custom_gift_card_serial_no Data
Surcharge Amount (added by iVendNext) custom_surcharge_amount Float
Description description Text Editor yes
Item Group item_group Link yes yes Item Group
Brand Name brand Data yes
Image image Attach yes
Quantity qty Float
Stock UOM stock_uom Link yes UOM
UOM uom Link yes UOM
UOM Conversion Factor conversion_factor Float yes
Qty as per Stock UOM stock_qty Float yes
Price List Rate price_list_rate Currency yes
Price List Rate (Company Currency) base_price_list_rate Currency yes
Margin Type margin_type Select one of: Percentage, Amount
Margin Rate or Amount margin_rate_or_amount Float
Rate With Margin rate_with_margin Currency yes
Discount (%) on Price List Rate with Margin discount_percentage Percent
Discount Amount discount_amount Currency
Total Discount Amount (added by iVendNext) total_discount_amount Currency yes
Rate With Margin (Company Currency) base_rate_with_margin Currency yes
Rate rate Currency yes
Amount amount Currency yes yes
Barcode Masked (added by iVendNext) custom_barcode_masked Check yes
Label Total (added by iVendNext) custom_barcode_mask_amount Currency yes
Tender Discount Apportioned (added by iVendNext) custom_tender_discount_apportioned Currency yes yes
Item Tax Template item_tax_template Link Item Tax Template
Rate (Company Currency) base_rate Currency yes yes
Amount (Company Currency) base_amount Currency yes yes
Pricing Rules pricing_rules Small Text yes yes
Is Free Item is_free_item Check yes
Grant Commission grant_commission Check yes
Net Rate net_rate Currency yes
Net Amount net_amount Currency yes
Net Rate (Company Currency) base_net_rate Currency yes
Net Amount (Company Currency) base_net_amount Currency yes
Delivered By Supplier delivered_by_supplier Check yes
Income Account income_account Link yes Account
Is Fixed Asset is_fixed_asset Check yes yes
Asset asset Link Asset
Finance Book finance_book Link Finance Book
Expense Account expense_account Link Account
Deferred Revenue Account deferred_revenue_account Link Account
Service Stop Date service_stop_date Date
Enable Deferred Revenue enable_deferred_revenue Check
Service Start Date service_start_date Date
Service End Date service_end_date Date
Weight Per Unit weight_per_unit Float yes
Total Weight total_weight Float yes
Weight UOM weight_uom Link yes UOM
Warehouse warehouse Link Warehouse
POS Fulfilment Mode (added by iVendNext) custom_mpos_fulfilment_mode Select yes one of: Ship to Home, Collect at Store, Curbside
POS Fulfilment Store (added by iVendNext) custom_mpos_fulfilment_store Link yes Warehouse
POS Ship-To Address (added by iVendNext) custom_mpos_ship_to_address Small Text yes
POS Ship-To Address Record (added by iVendNext) custom_mpos_ship_to_address_link Link yes Address
Customer Warehouse (Optional) target_warehouse Link yes Warehouse
Quality Inspection quality_inspection Link Quality Inspection
Serial and Batch Bundle serial_and_batch_bundle Link Serial and Batch Bundle
Use Serial No / Batch Fields use_serial_batch_fields Check
Allow Zero Valuation Rate allow_zero_valuation_rate Check
Item Tax Rate item_tax_rate Small Text yes yes
Available Batch Qty at Warehouse actual_batch_qty Float yes
Available Qty at Warehouse actual_qty Float yes
Serial No serial_no Text
Batch No batch_no Link Batch
Sales Order sales_order Link yes Sales Order
Sales Order Item so_detail Data yes yes
POS Invoice Item pos_invoice_item Data yes
Cross sell parent line item name (added by iVendNext) custom_cross_sell_parent_line_item_name Data yes
Delivery Note delivery_note Link yes Delivery Note
Delivery Note Item dn_detail Data yes yes
Delivered Qty delivered_qty Float yes
Is fulfillment delivered (added by iVendNext) custom_is_fulfillment_delivered Check yes
Total Tax (added by iVendNext) custom_total_tax Float yes
Tax Total Breakup (added by iVendNext) custom_tax_breakup Text yes
Promotional Quantity (added by iVendNext) custom_promotional_quantity Float yes
Discount Source (added by iVendNext) custom_discount_source Select one of: System Discount, Manual Discount, Promotion Discount, Coupon Discount
Is fulfillment returned (added by iVendNext) custom_is_fulfillment_returned Check yes
Cost Center cost_center Link yes Cost Center
Project project Link Project
Page Break page_break Check
Open Check Line (added by iVendNext) custom_mpos_check_line Data yes yes
Supplier Funded Amount (added by iVendNext) custom_mpos_funded_amount Currency yes
Promotion Funded By (added by iVendNext) custom_mpos_funded_by Link yes Supplier
Funded Promotion (added by iVendNext) custom_mpos_funded_promotion Link yes Promotion Bonus Buys Master
POS Replaced List Price (added by iVendNext) custom_mpos_list_rate Currency yes yes
Option Group (added by iVendNext) custom_mpos_option_group Link yes Retail Option Group
Billed to Payer (added by iVendNext) custom_mpos_payer_share Currency yes
Paid by Customer (added by iVendNext) custom_mpos_patient_share Currency yes
Payer Covered Qty (added by iVendNext) custom_mpos_payer_covered_qty Float yes
Payer GTIN (added by iVendNext) custom_mpos_payer_gtin Data yes
Payer Share Given Back (added by iVendNext) custom_mpos_payer_back Currency yes
POS Pickup Handed At (added by iVendNext) custom_mpos_pickup_handed_at Datetime yes
POS Price Intent (added by iVendNext) custom_mpos_price_intent Select yes one of: Open Price
POS Typed Price (added by iVendNext) custom_mpos_typed_rate Currency yes yes
POS Partner Price Reason (added by iVendNext) custom_mpos_price_reason Data yes
POS Pickup Notified At (added by iVendNext) custom_mpos_pickup_notified_at Datetime yes
POS Pickup Status (added by iVendNext) custom_mpos_pickup_status Select yes one of: Picking, Ready, Handed Over
POS Partner Price Percent Before (added by iVendNext) custom_mpos_price_before_pct Percent yes
POS Partner Price Cut (added by iVendNext) custom_mpos_price_cut Currency yes

Table: POS Invoice Sale Attribute

The rows of custom_pos_invoice_sale_attribute. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Sale Attribute sale_attribute Link Sale Attribute
Attribute Value attribute_value Data

Table: POS Invoice Transaction Item Attribute

The rows of custom_pos_invoice_transaction_item_attribute. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Transaction Item Attribute transaction_item_attribute Link Transaction Item Attribute
Item Ref item_ref Link Item
Item ID Ref item_id_ref Data yes
Attribute Value attribute_value Data
Row No Ref row_no_ref Int

Table: Packed Item

The rows of packed_items. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Parent Item parent_item Link yes Item
Item Code item_code Link yes Item
Item Name item_name Data yes
Description description Text Editor
From Warehouse warehouse Link Warehouse
To Warehouse (Optional) target_warehouse Link Warehouse
Conversion Factor conversion_factor Float
Qty qty Float yes
Rate rate Currency yes
UOM uom Link yes UOM
Use Serial No / Batch Fields use_serial_batch_fields Check
Serial and Batch Bundle serial_and_batch_bundle Link Serial and Batch Bundle
Serial No serial_no Text
Batch No batch_no Link Batch
Actual Batch Quantity actual_batch_qty Float yes
Actual Qty actual_qty Float yes
Projected Qty projected_qty Float yes
Ordered Qty ordered_qty Float yes
Packed Qty packed_qty Float yes
Incoming Rate incoming_rate Currency yes
Picked Qty picked_qty Float yes
Page Break page_break Check yes
Prevdoc DocType prevdoc_doctype Data yes yes
Parent Detail docname parent_detail_docname Data yes yes

Table: Payment Schedule

The rows of payment_schedule. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Payment Term payment_term Link Payment Term
Description description Small Text
Due Date due_date Date yes
Mode of Payment mode_of_payment Link Mode of Payment
Invoice Portion invoice_portion Percent
Discount Type discount_type Select one of: Percentage, Amount
Discount Date discount_date Date
Discount discount Float
Payment Amount payment_amount Currency yes
Outstanding outstanding Currency yes
Paid Amount paid_amount Currency
Discounted Amount discounted_amount Currency yes
Payment Amount (Company Currency) base_payment_amount Currency

Table: Pricing Rule Detail

The rows of pricing_rules. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Pricing Rule pricing_rule Link yes Pricing Rule
Item Code item_code Data yes
Margin Type margin_type Data yes yes
Rate or Discount rate_or_discount Data yes yes
Child Docname child_docname Data yes yes
Rule Applied rule_applied Check yes

Table: Sales Invoice Advance

The rows of advances. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Reference Type reference_type Link yes DocType
Reference Name reference_name Dynamic Link yes
Remarks remarks Text yes
Reference Row reference_row Data yes yes
Advance amount advance_amount Currency yes
Allocated amount allocated_amount Currency
Exchange Gain/Loss exchange_gain_loss Currency yes
Reference Exchange Rate ref_exchange_rate Float yes
Difference Posting Date difference_posting_date Date

Table: Sales Invoice Payment

The rows of payments. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Default default Check yes yes
Mode of Payment mode_of_payment Link yes Mode of Payment
Exchange Rate (added by iVendNext) custom_exchange_rate Float
Amount amount Currency yes
Transaction Amount (added by iVendNext) custom_transaction_amount Currency yes
Tender Discount Amount (added by iVendNext) custom_tender_discount_amount Currency yes
Reference No reference_no Data
Account account Link yes Account
Currency (added by iVendNext) custom_currency Link yes Currency
Type type Read Only yes
Base Amount (Company Currency) base_amount Currency yes
Clearance Date clearance_date Date yes
Credit Card Name (added by iVendNext) custom_credit_card_name Data yes
Card Last4 (added by iVendNext) card_last4 Data yes
Expiry Date (added by iVendNext) custom_expiry_date Data
Authorization Code (added by iVendNext) card_authorization_code Data yes
Reference No (added by iVendNext) custom_reference_no Data
Voucher No (added by iVendNext) custom_voucher_no Data
Cheque No (added by iVendNext) custom_cheque_no Data
Gift Certificate Type (added by iVendNext) custom_gift_certificate_type Select one of: System Generated, User Defined
Gift Certificate No (added by iVendNext) custom_gift_certificate_no Link Gift Card
Store Credit Gift Certificate Type (added by iVendNext) custom_store_credit_gift_certificate_type Select one of: System Generated, User Defined
Store Credit Gift Certificate No (added by iVendNext) custom_store_credit_gift_certificate_no Data
Remarks (added by iVendNext) custom_remarks Data yes
Card Terminal Txn Ref (added by iVendNext) custom_card_txn_ref Data yes

Table: Sales Invoice Timesheet

The rows of timesheets. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Activity Type activity_type Link yes Activity Type
Description description Small Text yes
From Time from_time Datetime
To Time to_time Datetime
Billing Hours billing_hours Float yes
Billing Amount billing_amount Currency yes
Time Sheet time_sheet Link yes Timesheet
Timesheet Detail timesheet_detail Data yes yes
Project Name project_name Data yes

Table: Sales Taxes and Charges

The rows of taxes. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Type charge_type Select yes one of: Actual, On Net Total, On Previous Row Amount, On Previous Row Total, On Item Quantity
Reference Row # row_id Data
Account Head account_head Link yes Account
Item (added by iVendNext) custom_item Link Item
On Item Row (added by iVendNext) custom_on_item_row Int
Surcharge (added by iVendNext) custom_surcharge Link Surcharge
Surcharge Amount (added by iVendNext) custom_surcharge_amount Float
Final Amount (added by iVendNext) custom_final_amount Float
Description description Small Text yes
Is this Tax included in Basic Rate? included_in_print_rate Check
Considered In Paid Amount included_in_paid_amount Check
Discount Type (added by iVendNext) custom_discount_type Select one of: Flat Amount, Percentage
Discount Amount (added by iVendNext) custom_discount_amount Float
Tax Template (added by iVendNext) custom_tax_template Link Item Tax Template
Applied Tax Amount (added by iVendNext) custom_applied_tax_amount Float
Discountable (added by iVendNext) custom_discountable Check
Taxable (added by iVendNext) custom_taxable Check
Refundable (added by iVendNext) custom_refundable Check
Load on Item Cost (added by iVendNext) custom_load_on_item_cost Check
Is return (added by iVendNext) custom_is_return Check yes
Tax Rate (added by iVendNext) custom_tax_rate Percent
Tax Per Item (added by iVendNext) custom_tax_per_item Float
Cost Center cost_center Link Cost Center
Tax Rate rate Float
Account Currency account_currency Link yes Currency
Amount tax_amount Currency
Total total Currency yes
Tax Amount After Discount Amount tax_amount_after_discount_amount Currency yes
Amount (Company Currency) base_tax_amount Currency yes
Total (Company Currency) base_total Currency yes
Tax Amount After Discount Amount (Company Currency) base_tax_amount_after_discount_amount Currency yes
Item Wise Tax Detail item_wise_tax_detail Code yes yes
Dont Recompute tax dont_recompute_tax Check yes yes

Table: Sales Team

The rows of sales_team. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Sales Person sales_person Link yes Sales Person
Contact No. contact_no Data yes
Contribution (%) allocated_percentage Float
Contribution to Net Total allocated_amount Currency yes
Commission Rate commission_rate Data yes
Incentives incentives Currency

Table: Transaction Coupon

The rows of custom_coupons. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Item Row Reference item_row_reference Int yes
Item Code item_code Data yes
Coupon Name coupon_name Data
Serial Number serial_number Data
Discount Amount discount_amount Data yes
Store store Link Warehouse
Customer customer Link Customer

Table: Transaction Promotion Bonus Buys Detail

The rows of custom_promotions. Each row also has idx (its place), parent, parentfield and parenttype.

Field Field name Type Required Read-only Hidden Links to
Item Row Reference item_row_reference Int yes
Item Code item_code Data yes
Promotion Name promotion_name Data yes
Discount Amount discount_amount Data yes
Quantity quantity Data yes yes
Store store Link Warehouse
Customer customer Link Customer

All record types · What you can use

This record type in the kit