-
Notifications
You must be signed in to change notification settings - Fork 2
Create Payment Voucher
simitben edited this page Oct 16, 2025
·
4 revisions
Using CURL in terminal console to insert the Payment Voucher 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": "createPaymentVoucher",
"module": "sales",
"token": "simit_5d6ce44404688-30487",
"uid": "admin",
"organization_code": "SIMIT",
"branch_code": "HQ",
"data": {
"headerarr": {
"document_no": "API-PV-00013",
"document_refno": "API_DOC_TEST",
"document_date": "2025-05-22",
"document_status": "D",
"isrefund": "1",
"document_prepareby": "admin",
"document_desc": "DOCUMENT CREATED FROM API",
"document_note": "ADDITIONAL NOTE",
"document_reason": "",
"document_glmemo": "ADDITIONAL GLMEMO",
"accounts_code": "11-3007",
"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": "200",
"totalamt_local": "",
"totaltaxamt": "",
"totaltaxamt_local": "",
"totalnetamt": "200",
"totalnetamt_local": "",
"salesagent_name": "",
"payment_method_code": "Cash",
"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",
"document_bankrefno": "Testt 123",
"document_bankrefno": "Testt 123",
"filling_date": "2025-05-22",
"filingdatelastchangebyuser": "admin",
"created": "2025-05-22 12:04:36",
"createdby": "admin",
"updated": "2025-05-22 12:04:36",
"updatedby": "admin",
"organization_code": "SIMIT",
"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": "100",
"unitprice_local": "100",
"discount": "",
"discount_amt": "",
"amount_sub": "100",
"amount_sub_local": "10",
"amount_tax": "",
"amount_tax_local": "",
"amount_netttotal": "100",
"amount_netttotal_local": "",
"accounts_code": "51-0010",
"isinclusive": "0",
"tax_name": "",
"tax_rate": "",
"taxaccounts_id": "",
"msic_code": "",
"serialno": "",
"batchno": "",
"lotno": "",
"track1_code": "",
"track2_code": "",
"track3_code": "",
"track4_code": "",
"track5_code": "",
"customfield1": "",
"customfield2": "",
"customfield3": "",
"created": "2025-05-22 12:04:36",
"createdby": "admin",
"updated": "2025-05-22 12:04:36",
"updatedby": "admin",
"isprint": "0",
"isremark": "0",
"linedocument_no": "",
"inventorydebitacc_id": "",
"inventorycreditacc_id": "",
"syscalgstamt": "",
"taxupdatedby": "",
"inventorycost": "",
"othercost": "",
"hscode_code": ""
},
{
"documentline_seq": "10",
"documentline_desc": "",
"documentline_promisedate": "0000-00-00",
"item_code": "DRINK002",
"item_name": "",
"quantity": "1",
"basequantity": "1",
"uom_code": "Unit",
"baseuom_code": "Unit",
"unitprice": "100",
"unitprice_local": "100",
"discount": "",
"discount_amt": "",
"amount_sub": "100",
"amount_sub_local": "10",
"amount_tax": "",
"amount_tax_local": "",
"amount_netttotal": "100",
"amount_netttotal_local": "",
"accounts_code": "51-0010",
"isinclusive": "0",
"tax_name": "",
"tax_rate": "",
"taxaccounts_id": "",
"msic_code": "",
"serialno": "",
"batchno": "",
"lotno": "",
"track1_code": "",
"track2_code": "",
"track3_code": "",
"track4_code": "",
"track5_code": "",
"customfield1": "",
"customfield2": "",
"customfield3": "",
"created": "2025-05-22 12:04:36",
"createdby": "admin",
"updated": "2025-05-22 12:04:36",
"updatedby": "admin",
"isprint": "0",
"isremark": "0",
"linedocument_no": "",
"inventorydebitacc_id": "",
"inventorycreditacc_id": "",
"syscalgstamt": "",
"taxupdatedby": "",
"inventorycost": "",
"othercost": "",
"hscode_code": ""
}
]
}
}
' \
https://simbiz_system_url/simbiz/api.php
The available field for insert Payment Voucher Data
Payment Voucher Header Data
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | document_no | varchar(255) | Y | Payment Voucher document number |
| 2 | document_refno | varchar(255) | Payment Voucher reference number | |
| 3 | document_date | date | Payment Voucher document date | |
| 4 | document_status | varchar(30) | Payment Voucher document status | |
| 5 | isrefund | smallint(1) | Payment Voucher is use as refund (Yes[1]/No[0]) | |
| 6 | document_prepareby | varchar(50) | Preparer of the document | |
| 7 | document_desc | text | Payment Voucher description | |
| 8 | document_note | text | Payment Voucher document note | |
| 9 | document_reason | varchar(255) | Payment Voucher Void reason | |
| 10 | document_glmemo | varchar(255) | Payment Voucher document GL memo | |
| 11 | accounts_code | varchar(50) | Y | Payment Voucher Account Code |
| 12 | bpartner_no | varchar(50) | Payment Voucher business partner number | |
| 13 | bpartner_name | varchar(255) | Payment Voucher business partner name | |
| 14 | payeetype | varchar(255) | Payment Voucher payee type ("others"/"bpartner") | |
| 15 | paidfrom_to | varchar(255) | Payment Voucher Paid From To | |
| 16 | billcontacts_name | varchar(255) | Payment Voucher Bill Contact Name | |
| 17 | billcontacts_hp | varchar(255) | Payment Voucher bill contact handphone number | |
| 18 | billaddress_street1 | varchar(255) | Payment Voucher bill address street 1 | |
| 19 | billaddress_street2 | varchar(255) | Payment Voucher bill address street 2 | |
| 20 | billaddress_street3 | varchar(255) | Payment Voucher bill address street 3 | |
| 21 | billaddress_street4 | varchar(255) | Payment Voucher bill address street 4 | |
| 22 | billaddress_postcode | varchar(50) | Payment Voucher bill address postcode | |
| 23 | billaddress_city | varchar(50) | Payment Voucher bill address city | |
| 24 | billaddress_area | varchar(50) | Payment Voucher bill address area | |
| 25 | billaddress_country | varchar(50) | Payment Voucher bill address country | |
| 26 | shipaddress_street1 | varchar(255) | Payment Voucher ship address street 1 | |
| 27 | shipaddress_street2 | varchar(255) | Payment Voucher ship address street 2 | |
| 28 | shipaddress_street3 | varchar(255) | Payment Voucher ship address street 3 | |
| 29 | shipaddress_street4 | varchar(255) | Payment Voucher ship address street 4 | |
| 30 | shipaddress_postcode | varchar(50) | Payment Voucher ship address postcode | |
| 31 | shipaddress_city | varchar(50) | Payment Voucher ship address city | |
| 32 | shipaddress_area | varchar(50) | Payment Voucher ship address area | |
| 33 | shipaddress_country | varchar(50) | Payment Voucher ship address country | |
| 34 | shippinginfo | varchar(255) | Payment Voucher shipping info | |
| 35 | shipcontacts_name | varchar(255) | Payment Voucher shipping contact name | |
| 36 | shipcontacts_hp | varchar(50) | Payment Voucher shipping contact handphone | |
| 37 | totalamt | decimal(22,2) | Payment Voucher total amount | |
| 38 | totalamt_local | decimal(22,2) | Payment Voucher total amount in local currency | |
| 39 | totaltaxamt | decimal(22,2) | Payment Voucher total tax amount | |
| 40 | totaltaxamt_local | decimal(22,2) | Payment Voucher total tax amount in local currency | |
| 41 | totalnetamt | decimal(22,2) | Payment Voucher total net amount (amt + tax) | |
| 42 | totalnetamt_local | decimal(22,2) | Payment Voucher total net amount in local currency | |
| 43 | salesagent_name | varchar(255) | Payment Voucher sales agent | |
| 44 | payment_method_code | varchar(255) | Payment Voucher payment method code | |
| 45 | terms_name | varchar(255) | Payment Voucher term name | |
| 46 | terms_day | int(11) | Payment Voucher term day | |
| 47 | currency_code | varchar(255) | Payment Voucher currency code | |
| 48 | currency_rate | decimal(14,8) NULL | Payment Voucher currency rate | |
| 49 | document_trackdate | date [1970-01-01] | Payment Voucher track date | |
| 50 | document_tracktype | varchar(100) | Payment Voucher track type | |
| 51 | document_trackremark | text | Payment Voucher track remark | |
| 52 | document_trackupdated | datetime | Payment Voucher track last update date time | |
| 53 | document_trackupdatedby | varchar(50) | Payment Voucher track last update by | |
| 54 | track1_code | varchar(255) | Payment Voucher track 1 code | |
| 55 | track2_code | varchar(255) | Payment Voucher track 2 code | |
| 56 | track3_code | varchar(255) | Payment Voucher track 3 code | |
| 57 | track4_code | varchar(255) | Payment Voucher track 4 code | |
| 58 | track5_code | varchar(255) | Payment Voucher track 5 code | |
| 59 | isprinted | smallint(1) | Payment Voucher is allow print out in the print format (Yes[1]/No[0]) | |
| 60 | isop | smallint(1) [0] | ||
| 61 | isimport | smallint(1) | ||
| 62 | document_bankrefno | varchar(255) | Payment Voucher Ref No. | |
| 63 | filling_date | date | Payment Voucher filling Date | |
| 64 | filingdatelastchangebyuser | varchar(50) | Payment Voucher filling Date last updated user | |
| 65 | created | datetime | Payment Voucher created date in the system | |
| 66 | createdby | varchar(50) | Payment Voucher creator | |
| 67 | updated | datetime | Payment Voucher last updated date | |
| 68 | updatedby | varchar(50) | Payment Voucher last updated user | |
| 69 | organization_code | varchar(10) | Payment Voucher was created under which organization | |
| 70 | branch_code | varchar(40) | Payment Voucher was created under which branch | |
| 71 | process_auto_knockoff | smallint(1) | Option to procress auto knockoff with FIFO method (1 for turn on / 0 for turn off) |
Payment Voucher Line Data
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | documentline_seq | smallint(6) | Payment Voucher's document line Sequence No | |
| 2 | documentline_desc | text | Payment Voucher's Line description | |
| 3 | documentline_promisedate | date | Payment Voucher's line promise date | |
| 4 | item_code | varchar(255) | Payment Voucher's line item code | |
| 5 | item_name | varchar(255) | Payment Voucher's line item name | |
| 6 | quantity | decimal(28,8) | Payment Voucher's line item quantity | |
| 7 | basequantity | decimal(28,8) | Payment Voucher's line item base quantity | |
| 8 | uom_code | varchar(255) | Payment Voucher's line item UOM | |
| 9 | baseuom_code | varchar(255) | Payment Voucher's line item base UOM | |
| 10 | accounts_code | varchar(50) | Y | Payment Voucher's line item account code |
| 11 | unitprice | decimal(24,4) | Payment Voucher's line item unit price | |
| 12 | unitprice_local | decimal(24,4) | Payment Voucher's line item unit price in local currency | |
| 13 | discount | varchar(255) | Payment Voucher's line item discount percentage | |
| 14 | discount_amt | decimal(24,2) | Payment Voucher's line item discount amount | |
| 15 | amount_sub | decimal(22,2) | Payment Voucher's line sub amount (unitprice * quantity) | |
| 16 | amount_sub_local | decimal(22,2) | Payment Voucher's line sub amount in local currency | |
| 17 | amount_tax | decimal(22,2) | Payment Voucher's line tax amount | |
| 18 | amount_tax_local | decimal(22,2) | Payment Voucher's line tax amount in local currency | |
| 19 | amount_netttotal | decimal(22,2) | Payment Voucher's line net total (sub amount + tax amount) | |
| 20 | amount_netttotal_local | decimal(22,2) | Payment Voucher's line net total in local currency | |
| 21 | isinclusive | smallint(11) | Is Inclusive tax? (Yes[1]/No[0]) | |
| 22 | tax_name | varchar(255) | Payment Voucher's line tax name | |
| 23 | tax_rate | decimal(10,4) | Payment Voucher's line tax rate | |
| 24 | taxaccounts_id | varchar(50) | Payment Voucher's line tax account | |
| 25 | msic_code | varchar(30) | Payment Voucher's line MSIC code | |
| 26 | serialno | text NULL | Payment Voucher's line item's serial number | |
| 27 | batchno | varchar(255) | Payment Voucher's line item's batch number | |
| 28 | lotno | varchar(255) | Payment Voucher's line item's lot number | |
| 29 | track1_code | varchar(255) | Payment Voucher's line track 1 code | |
| 30 | track2_code | varchar(255) | Payment Voucher's line track 2 code | |
| 31 | track3_code | varchar(255) | Payment Voucher's line track 3 code | |
| 32 | track4_code | varchar(255) | Payment Voucher's line track 4 code | |
| 33 | track5_code | varchar(255) | Payment Voucher's line track 5 code | |
| 34 | customfield1 | varchar(255) | Payment Voucher's line custom field 1 | |
| 35 | customfield2 | varchar(255) | Payment Voucher's line custom field 2 | |
| 36 | customfield3 | varchar(255) | Payment Voucher's line custom field 3 | |
| 37 | created | datetime | Payment Voucher's line created date in the system | |
| 38 | createdby | varchar(50) | Payment Voucher's line creator | |
| 39 | updated | datetime | Payment Voucher's line last updated date | |
| 40 | updatedby | varchar(50) | Payment Voucher's line last updated user | |
| 41 | isprint | smallint(1) [1] | Payment Voucher's line is allow print out in the print format? (Yes[1]/No[0]) | |
| 42 | isremark | int(11) | Is remark? (Yes[1]/No[0]) | |
| 43 | inventorydebitacc_id | varchar(50) | ||
| 44 | inventorycreditacc_id | varchar(50) | ||
| 45 | syscalgstamt | decimal(14,2) | ||
| 46 | taxupdatedby | varchar(50) | ||
| 47 | inventorycost | decimal(22,2) NULL | Payment Voucher's line item's inventory cost | |
| 48 | othercost | decimal(22,2) NULL | Payment Voucher's line item's landing cost | |
| 49 | hscode_code | varchar(50) | Payment Voucher's line item's HS code |