Create Journal Entry

Create Journal Entry

Using CURL in terminal console to retrieve the Creditors Journal Entry. (* If there is no data in the data column, user may direct remove the column from the get data array.)

{yourtoken} : Get your Token here

curl --header "Content-Type: application/x-www-form-urlencoded" \
--request POST \
--data '
{
	"action":"postToJE",
	"module":"accounting",
	"token":"{yourtoken}",
	"uid":"{youruid}",
	"org":"{yourorg}",
	"branch":"{yourbranch}",
    "data":
    {
        "headerarr":
        {
            "document_date":"2022-05-26",
            "document_no":"TEST_JE_01",
            "document_title":"Payment",
            "document_desc":"",
            "document_status":"CO",
            "totaldebit_amt":"20",
            "totalcredit_amt":"20",
            "isbookmark":"0",
            "isinternal":"0"
        },
        "linearr":
        [
            {
                "accounts_code":"21-1000",
                "bpartner_no":"BP_001",
                "chequeno":"C_001",
                "ref_no":"SI_001",
                "memo":"",
                "documentline_seq":"10",
                "debitamt":20,
                "debitamt_local":20,
                "tax_code":"SST-6",
                "currency_code":"MYR",
                "currency_rate":"1",
                "terms_code":"14D",
                "track1_code":"",
                "track2_code":"",
                "track3_code":"",
                "track4_code":"",
                "track5_code":"",
                "msic_code":"",
                "hscode_code":""
            },
            {
                "accounts_code":"21-1000",
                "bpartner_no":"BP_001",
                "chequeno":"C_001",
                "ref_no":"SI_001",
                "memo":"",
                "documentline_seq":"20",
                "creditamt":20,
                "creditamt_local":20,
                "tax_code":"SST-6",
                "currency_code":"MYR",
                "currency_rate":"1",
                "terms_code":"14D",
                "track1_code":"",
                "track2_code":"",
                "track3_code":"",
                "track4_code":"",
                "track5_code":"",
                "msic_code":"",
                "hscode_code":""
            }
        ]
    }
}

https://simbiz_system_url/simbiz/api.php

The available field for insert Journal Entry Data Journal Entry Header Data

No	Field Name	Data Type (Size)	Required	Description
1	document_no	varchar(255)		Document No
2	document_date	Date	Y	Document Date
3	document_title	varchar(255)		Document Title
4	document_desc	varchar(255)		Document Remarks/Description
5	document_status	varchar(10)		CO = confirm , D = draft
6	totaldebit_amt	decimal(22,2)		Total debit amount
7	totalcredit_amt	decimal(22,2)		Total credit amount
8	isbookmark	smallint(1)		Remarks document as bookmark
9	isinternal	smallint(1)		Remarks document as internal

Journal Entry Line Data

No	Field Name	Data Type (Size)	Required	Description
1	accounts_code	varchar(255)	Y	Accounts Code
2	bpartner_no	varchar(255)		Business Partner Number,must got link with Accounts Code
3	chequeno	varchar(255)		Cheque Number
4	ref_no	varchar(255)		Ref. No.
5	memo	text		Memo
6	documentline_seq	smallint(6)		Seq No.
7	debitamt	decimal(22,2)		Total debit amount (only can choose debit or credit in one line)
8	debitamt_local	decimal(22,2)		Total debit amount local
9	creditamt	decimal(22,2)		Total credit amount (only can choose debit or credit in one line)
10	creditamt_local	decimal(22,2)		Total credit amount local
11	tax_code	varchar(255)		Document Tax Code
12	currency_code	varchar(50)		Document Currency Code
13	currency_rate	decimal(14,8)		Document Currency Rate
14	terms_code	varchar(255)		Terms Code
15	track1_code	varchar(255)		Track1 Code
16	track2_code	varchar(255)		Track2 Code
17	track3_code	varchar(255)		Track3 Code
18	track4_code	varchar(255)		Track4 Code
19	track5_code	varchar(255)		Track5 Code
20	msic_code	varchar(255)		MSIC code
21	hscode_code	varchar(255)		HScode Code