iVendNextDevelopers Request a sandbox

Sales Invoice

A sale booked in the back office, or a till's day of sales merged into one document; a return is a Sales Invoice with Is Return ticked that names the sale it returns.

Area: Sales and returns · Why it is here: openapi.yaml; api/validate.sh; guide chapter 02; recipe bulk_reads; recipe customer_history_page; recipe price_checker; recipe print_pack; recipe webhook_receiver; sample S2; sample S29; sample S3; sample S39; sample S41; sample S43; the MCP server; the request collection; retail core · Fields: 172 · 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/Sales%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/Sales%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/Sales%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/Sales%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 · s24_price_checker · s28_merge_and_history · s29_print_pack · s30_units_as_serials · s32_coupon_rules · s39_pharmacy_counter · s40_expiry_recall · s41_regulated_register · s43_third_party_payer · s45_restaurant_back_office

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-SINV-.YYYY.-, ACC-SINV-RET-.YYYY.-
Customer customer Link Customer
Customer Name customer_name Small Text yes
Tax Id tax_id Data yes
Company company Link yes Company
Company Tax ID company_tax_id Data yes
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
Include Payment (POS) is_pos Check
POS Profile pos_profile Link POS Profile
Is Consolidated is_consolidated Check yes
Is Return (Credit Note) is_return Check
Return Against return_against Link Sales Invoice
Update Outstanding for Self update_outstanding_for_self Check
Update Billed Amount in Sales Order update_billed_amount_in_sales_order Check
Update Billed Amount in Delivery Note update_billed_amount_in_delivery_note Check
Is Rate Adjustment Entry (Debit Note) is_debit_note Check
Amended From amended_from Link yes Sales Invoice
Cost Center cost_center Link Cost Center
Project project Link Project
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
Scan Barcode scan_barcode Data
Update Stock update_stock Check
Source Warehouse set_warehouse Link Warehouse
Set Target Warehouse set_target_warehouse Link Warehouse
Items items Table yes Sales Invoice Item
Total Quantity total_qty Float yes
Total Net Weight total_net_weight Float yes
Total (Company Currency) base_total Currency yes
Net Total (Company Currency) base_net_total Currency yes yes
Total total Currency yes
Net Total net_total Currency yes
Tax Category tax_category Link Tax Category
Sales Taxes and Charges Template taxes_and_charges Link Sales Taxes and Charges Template
Shipping Rule shipping_rule Link Shipping Rule
Incoterm incoterm Link Incoterm
Named Place named_place Data
Sales Taxes and Charges taxes Table Sales Taxes and Charges
Total Taxes and Charges (Company Currency) base_total_taxes_and_charges Currency yes
Total Taxes and Charges total_taxes_and_charges Currency yes
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 Small Text yes
Grand Total grand_total Currency yes yes
Rounding Adjustment rounding_adjustment Currency yes
Use Company default Cost Center for Round off use_company_roundoff_cost_center Check
Rounded Total rounded_total Currency yes
In Words in_words Small Text yes
Total Advance total_advance Currency yes
Outstanding Amount outstanding_amount Currency yes
Disable Rounded Total disable_rounded_total Check
Apply Additional Discount On apply_discount_on Select one of: Grand Total, Net Total
Additional Discount Amount (Company Currency) base_discount_amount Currency yes
Is Cash or Non Trade Discount is_cash_or_non_trade_discount Check
Discount Account additional_discount_account Link Account
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
Taxes and Charges Calculation other_charges_calculation Text Editor yes
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 Hours total_billing_hours Float yes
Total Billing Amount total_billing_amount 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
Allocate Advances Automatically (FIFO) allocate_advances_automatically Check
Only Include Allocated Payments only_include_allocated_payments Check
Advances advances Table Sales Invoice Advance
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
Redeem Loyalty Points redeem_loyalty_points Check
Loyalty Points loyalty_points Int
Loyalty Amount loyalty_amount Currency yes
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
Redemption Cost Center (added by iVendNext) custom_redemptioncostcenter Link Cost Center
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 Small Text yes yes
Contact Email contact_email Data yes yes
Territory territory Link Territory
Shipping Address Name shipping_address_name Link Address
Shipping Address shipping_address Small Text yes
Dispatch Address Name dispatch_address_name Link Address
Dispatch Address dispatch_address Small Text yes
Company Address Name company_address Link Address
Company Address company_address_display Small Text yes
Company Contact Person company_contact_person Link Contact
Ignore Default Payment Terms Template ignore_default_payment_terms_template Check yes yes
Payment Terms Template payment_terms_template Link Payment Terms Template
Payment Schedule payment_schedule Table Payment Schedule
Terms tc_name Link Terms and Conditions
Terms and Conditions Details terms Text Editor
Customer's Purchase Order po_no Data
Customer's Purchase Order Date po_date Date
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
Unrealized Profit / Loss Account unrealized_profit_loss_account Link Account
Against Income Account against_income_account Small Text yes
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 Contributions and Incentives sales_team Table Sales Team
Letter Head letter_head Link Letter Head
Group same items group_same_items Check
Print Heading select_print_heading Link Print Heading
Print Language language Data yes
Subscription subscription Link Subscription
From Date from_date Date
Auto Repeat auto_repeat Link yes Auto Repeat
To Date to_date Date
Status status Select yes one of: Draft, Return, Credit Note Issued, Submitted, Paid, Partly Paid, Unpaid, Unpaid and Discounted, Partly Paid and Discounted, Overdue and Discounted, Overdue, Cancelled …
Inter Company Invoice Reference inter_company_invoice_reference Link yes Purchase Invoice
Campaign campaign Link Campaign
Represents Company represents_company Link yes Company
Source source Link Lead Source
Customer Group customer_group Link yes Customer Group
Is Internal Customer is_internal_customer Check yes
Is Discounted is_discounted Check yes
Remarks remarks Small Text
Base Reference (added by iVendNext) custom_base_reference Data
Quotation Reference Number (added by iVendNext) custom_quotation_reference_number Link yes Quotation
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
Payer Answer (Sealed) (added by iVendNext) custom_mpos_payer_ticket Long Text yes 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 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

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 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
Item item_code Link Item
Transaction Mode (added by iVendNext) transaction_mode Link POS Transaction Mode
Item Name item_name Data yes
Customer's Item Code customer_item_code Data yes yes
Description description Text Editor
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
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
Billed to Payer (added by iVendNext) custom_mpos_payer_share Currency 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
Rate of Stock UOM stock_uom_rate Currency 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
Discount Account discount_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
Target Warehouse 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
Incoming Rate (Costing) incoming_rate Currency
Item Tax Rate item_tax_rate Small Text yes yes
Available Batch Qty at Warehouse actual_batch_qty Float yes
Serial No serial_no Text
Batch No batch_no Link Batch
Qty (Warehouse) actual_qty Float yes
Qty (Company) company_total_stock Float yes
Sales Order sales_order Link yes Sales Order
Sales Order Item so_detail Data yes yes
Sales Invoice Item sales_invoice_item Data yes
Delivery Note delivery_note Link yes Delivery Note
Delivery Note Item dn_detail Data yes yes
Delivered Qty delivered_qty Float yes
POS Invoice (added by iVendNext) custom_pos_invoice Link yes POS Invoice
POS Invoice Item (added by iVendNext) custom_pos_invoice_item Data yes
Total Tax (added by iVendNext) custom_total_tax Float yes
Tax Total Breakup (added by iVendNext) custom_tax_breakup Text yes
Purchase Order purchase_order Link yes Purchase Order
Purchase Order Item purchase_order_item Data yes
Cost Center cost_center Link yes Cost Center
Project project Link Project
Page Break page_break Check
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

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