-
Notifications
You must be signed in to change notification settings - Fork 2
Create Sales Order
syazanisimit edited this page Mar 12, 2026
·
2 revisions
Using CURL in terminal console to insert the Sales Order data.(* If there is no data in the data column, user may direct remove the column from the insert data array.)
curl --header "Content-Type: application/x-www-form-urlencoded" \
--request POST \
--data '
{
"action":"createSalesOrder",
"module":"sales",
"token":"",
"uid":"admin",
"org":"SIMIT",
"branch":"HQ",
"data": {
"headerarr" : {
"document_type" : "SO",
"document_no" : "API-SO-01104",
"document_refno" : "API_DOC_TEST",
"document_date" : "2026-02-23",
"document_status" : "D",
"document_prepareby" : "admin",
"document_desc" : "TEST DESCRIPTION",
"document_note" : "TEST NOTE",
"document_reason" : "TEST REASON",
"bpartner_no" : "6000028",
"bpartner_name" : "",
"billcontacts_name" : "",
"billcontacts_hp" : "",
"billaddress_street1" : "",
"billaddress_street2" : "",
"billaddress_street3" : "",
"billaddress_street4" : "",
"billaddress_postcode" : "",
"billaddress_city" : "",
"billaddress_area" : "",
"billaddress_country" : "",
"shipaddress_street1" : "",
"shipaddress_street2" : "",
"shipaddress_street3" : "",
"shipaddress_street4" : "",
"shipaddress_postcode" : "",
"shipaddress_city" : "",
"shipaddress_area" : "",
"shipaddress_country" : "",
"shippinginfo" : "",
"shipcontacts_name" : "",
"shipcontacts_hp" : "",
"totalamt" : "10",
"totalamt_local" : "",
"totaltaxamt" : "",
"totaltaxamt_local" : "",
"totalnetamt" : "10.6",
"totalnetamt_local" : "",
"salesagent_name" : "",
"terms_name" : "",
"terms_day" : "",
"currency_code" : "MYR",
"currency_rate" : "1",
"document_trackdate" : "0000-00-00",
"document_tracktype" : "",
"document_trackremark" : "",
"document_trackupdated" : "0000-00-00 00:00:00",
"document_trackupdatedby" : "",
"track1_code" : "",
"track2_code" : "",
"track3_code" : "",
"track4_code" : "",
"track5_code" : "",
"isprinted" : "0",
"isop" : "0",
"isimport" : "0",
"filling_date" : "2019-08-06",
"filingdatelastchangebyuser" : "admin",
"created" : "2019-08-06 12:04:36",
"createdby" : "admin",
"updated" : "2019-08-06 12:04:36",
"updatedby" : "admin",
"organization_code" : "HQ",
"branch_code" : "HQ",
"rounding_amount" : "0.00"
},
"linearr" : [
{
"documentline_seq" : "10",
"documentline_desc" : "",
"documentline_promisedate" : "0000-00-00",
"item_code" : "DRINK001",
"item_name" : "",
"quantity" : "1",
"basequantity" : "1",
"uom_code" : "Unit",
"baseuom_code" : "Unit",
"unitprice" : "10",
"unitprice_local" : "10",
"discount" : "",
"discount_amt" : "",
"amount_sub" : "10",
"amount_sub_local" : "10",
"amount_tax" : "",
"amount_tax_local" : "",
"amount_netttotal" : "10.6",
"amount_netttotal_local" : "10.6",
"isinclusive" : "0",
"tax_code" : "SST-6",
"tax_rate" : "6%",
"accounts_code" : "11-10",
"msic_code" : "",
"serialno" : "",
"batchno" : "",
"lotno" : "",
"track1_code" : "",
"track2_code" : "",
"track3_code" : "",
"track4_code" : "",
"track5_code" : "",
"customfield1" : "",
"customfield2" : "",
"customfield3" : "",
"created" : "2019-08-06 12:04:36",
"createdby" : "admin",
"updated" : "2019-08-06 12:04:36",
"updatedby" : "admin",
"isprint" : "0",
"isremark" : "0",
"inventorydebitacc_id" : "",
"inventorycreditacc_id" : "",
"taxupdatedby" : "",
"inventorycost" : "",
"othercost" : "",
"hscode_code" : ""
}
]
}
}
' \
https://simbiz_system_url/simbiz/api.php
The available field for insert Sales Order Data
Sales Order Header Data
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | document_no | varchar(255) | Y | Sales Order document number |
| 2 | document_type | varchar(255) | Sales Order document type | |
| 3 | document_refno | varchar(255) | Sales Order reference number | |
| 4 | document_date | date | Sales Order document date | |
| 5 | document_status | varchar(30) | Sales Order document status | |
| 6 | document_prepareby | varchar(50) | Preparer of the document | |
| 7 | document_desc | text | Sales Order description | |
| 8 | document_note | text | Sales Order document note | |
| 9 | document_reason | varchar(255) | Sales Order Void reason | |
| 10 | bpartner_no | varchar(50) | Sales Order business partner number | |
| 11 | bpartner_name | varchar(255) | Sales Order business partner name | |
| 12 | billcontacts_name | varchar(255) | Sales Order Bill Contact Name | |
| 13 | billcontacts_hp | varchar(255) | Sales Order bill contact handphone number | |
| 14 | billaddress_street1 | varchar(255) | Sales Order bill address street 1 | |
| 15 | billaddress_street2 | varchar(255) | Sales Order bill address street 2 | |
| 16 | billaddress_street3 | varchar(255) | Sales Order bill address street 3 | |
| 17 | billaddress_street4 | varchar(255) | Sales Order bill address street 4 | |
| 18 | billaddress_postcode | varchar(50) | Sales Order bill address postcode | |
| 19 | billaddress_city | varchar(50) | Sales Order bill address city | |
| 20 | billaddress_area | varchar(50) | Sales Order bill address area | |
| 21 | billaddress_country | varchar(50) | Sales Order bill address country | |
| 22 | shipaddress_street1 | varchar(255) | Sales Order ship address street 1 | |
| 23 | shipaddress_street2 | varchar(255) | Sales Order ship address street 2 | |
| 24 | shipaddress_street3 | varchar(255) | Sales Order ship address street 3 | |
| 25 | shipaddress_street4 | varchar(255) | Sales Order ship address street 4 | |
| 26 | shipaddress_postcode | varchar(50) | Sales Order ship address postcode | |
| 27 | shipaddress_city | varchar(50) | Sales Order ship address city | |
| 28 | shipaddress_area | varchar(50) | Sales Order ship address area | |
| 29 | shipaddress_country | varchar(50) | Sales Order ship address country | |
| 30 | shippinginfo | varchar(255) | Sales Order shipping info | |
| 31 | shipcontacts_name | varchar(255) | Sales Order shipping contact name | |
| 32 | shipcontacts_hp | varchar(50) | Sales Order shipping contact handphone | |
| 33 | totalamt | decimal(22,2) | Sales Order total amount | |
| 34 | totalamt_local | decimal(22,2) | Sales Order total amount in local currency | |
| 35 | totaltaxamt | decimal(22,2) | Sales Order total tax amount | |
| 36 | totaltaxamt_local | decimal(22,2) | Sales Order total tax amount in local currency | |
| 37 | totalnetamt | decimal(22,2) | Sales Order total net amount (amt + tax) | |
| 38 | totalnetamt_local | decimal(22,2) | Sales Order total net amount in local currency | |
| 39 | salesagent_name | varchar(255) | Sales Order sales agent | |
| 40 | terms_name | varchar(255) | Sales Order term name | |
| 41 | terms_day | int(11) | Sales Order term day | |
| 42 | currency_code | varchar(255) | Sales Order currency code | |
| 43 | currency_rate | decimal(14,8) NULL | Sales Order currency rate | |
| 44 | document_trackdate | date [1970-01-01] | Sales Order track date | |
| 45 | document_tracktype | varchar(100) | Sales Order track type | |
| 46 | document_trackremark | text | Sales Order track remark | |
| 47 | document_trackupdated | datetime | Sales Order track last update date time | |
| 48 | document_trackupdatedby | varchar(50) | Sales Order track last update by | |
| 49 | track1_code | varchar(255) | Sales Order track 1 code | |
| 50 | track2_code | varchar(255) | Sales Order track 2 code | |
| 51 | track3_code | varchar(255) | Sales Order track 3 code | |
| 52 | track4_code | varchar(255) | Sales Order track 4 code | |
| 53 | track5_code | varchar(255) | Sales Order track 5 code | |
| 54 | isprinted | smallint(1) | Sales Order is allow print out in the print format (Yes[1]/No[0]) | |
| 55 | isop | smallint(1) [0] | ||
| 56 | isimport | smallint(1) | ||
| 57 | created | datetime | Sales Order created date in the system | |
| 58 | createdby | varchar(50) | Sales Order creator | |
| 59 | updated | datetime | Sales Order last updated date | |
| 60 | updatedby | varchar(50) | Sales Order last updated user | |
| 61 | organization_code | varchar(10) | Sales Order was created under which organization | |
| 62 | branch_code | varchar(40) | Sales Order was created under which branch |
Sales Order Line Data
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | documentline_seq | smallint(6) | Sales Order's document line Sequence No | |
| 2 | documentline_desc | text | Sales Order's Line description | |
| 3 | documentline_promisedate | date | Sales Order's line promise date | |
| 4 | item_code | varchar(255) | Sales Order's line item code | |
| 5 | item_name | varchar(255) | Sales Order's line item name | |
| 6 | quantity | decimal(28,8) | Sales Order's line item quantity | |
| 7 | basequantity | decimal(28,8) | Sales Order's line item base quantity | |
| 8 | uom_code | varchar(255) | Sales Order's line item UOM | |
| 9 | baseuom_code | varchar(255) | Sales Order's line item base UOM | |
| 10 | accounts_code | varchar(50) | Y | Sales Order's line item account code |
| 11 | tax_code | varchar(50) | Sales Order's line tax code | |
| 12 | tax_rate | varchar(50) | Sales Order's line tax rate | |
| 13 | unitprice | decimal(24,4) | Sales Order's line item unit price | |
| 14 | unitprice_local | decimal(24,4) | Sales Order's line item unit price in local currency | |
| 15 | discount | varchar(255) | Sales Order's line item discount percentage | |
| 16 | discount_amt | decimal(24,2) | Sales Order's line item discount amount | |
| 17 | amount_sub | decimal(22,2) | Sales Order's line sub amount (unitprice * quantity) | |
| 18 | amount_sub_local | decimal(22,2) | Sales Order's line sub amount in local currency | |
| 19 | amount_tax | decimal(22,2) | Sales Order's line tax amount | |
| 20 | amount_tax_local | decimal(22,2) | Sales Order's line tax amount in local currency | |
| 21 | amount_netttotal | decimal(22,2) | Sales Order's line net total (sub amount + tax amount) | |
| 22 | amount_netttotal_local | decimal(22,2) | Sales Order's line net total in local currency | |
| 23 | isinclusive | smallint(11) | Is Inclusive tax? (Yes[1]/No[0]) | |
| 24 | msic_code | varchar(30) | Sales Order's line MSIC code | |
| 25 | serialno | text NULL | Sales Order's line item's serial number | |
| 26 | batchno | varchar(255) | Sales Order's line item's batch number | |
| 27 | lotno | varchar(255) | Sales Order's line item's lot number | |
| 28 | track1_code | varchar(255) | Sales Order's line track 1 code | |
| 29 | track2_code | varchar(255) | Sales Order's line track 2 code | |
| 30 | track3_code | varchar(255) | Sales Order's line track 3 code | |
| 31 | track4_code | varchar(255) | Sales Order's line track 4 code | |
| 32 | track5_code | varchar(255) | Sales Order's line track 5 code | |
| 33 | customfield1 | varchar(255) | Sales Order's line custom field 1 | |
| 34 | customfield2 | varchar(255) | Sales Order's line custom field 2 | |
| 35 | customfield3 | varchar(255) | Sales Order's line custom field 3 | |
| 36 | created | datetime | Sales Order's line created date in the system | |
| 37 | createdby | varchar(50) | Sales Order's line creator | |
| 38 | updated | datetime | Sales Order's line last updated date | |
| 39 | updatedby | varchar(50) | Sales Order's line last updated user | |
| 40 | isprint | smallint(1) [1] | Sales Order's line is allow print out in the print format? (Yes[1]/No[0]) | |
| 41 | isremark | int(11) | Is remark? (Yes[1]/No[0]) | |
| 42 | inventorydebitacc_id | varchar(50) | ||
| 43 | inventorycreditacc_id | varchar(50) | ||
| 44 | taxupdatedby | varchar(50) | ||
| 45 | inventorycost | decimal(22,2) NULL | Sales Order's line item's inventory cost | |
| 46 | othercost | decimal(22,2) NULL | Sales Order's line item's landing cost | |
| 47 | hscode_code | varchar(50) | Sales Order's line item's HS code |