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 |