Skip to content

Get Creditors Aging Detail

Jump to bottom
seansimit edited this page May 12, 2022 · 1 revision

Get Creditors Aging Detail

Using CURL in terminal console to retrieve the Creditors Aging Detail. (* 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":"getCreditorsAgingDetail",
	"module":"accounting",
	"token":"{yourtoken}",
	"uid":"{youruid}",
	"org":"{yourorg}",
	"branch":"{yourbranch}",
	"data":
	{
		"till date":"2022-04-29"
	}
}
' \
https://simbiz_system_url/simbiz/api.php

The available field for retrieve Creditors Aging Detail Data (same as simbiz Creditors Aging Detail Report) Required field for calling API

No Field Name Data Type (Size) Required Description
1 till date date (YYYY-mm-dd) Till date for transaction, if empty will auto set as today
2 currency code varchar(3) Transaction currency code
3 accounts code varchar(50) Account Code
4 bpartner no varchar(50) Business Partner No
5 bpartnergroup code varchar(50) Business Partner Group
6 industry code varchar(50) Industry Code
7 salesagent no varchar(50) Sales Agent

Creditors Aging Detail Data

No Field Name Data Type (Size) Required Description
1 Document Id varchar(50) Backend id for the document
2 Document No varchar(255) Document No
3 Document Type varchar(10) Document Type
4 Document Reference No varchar(255) Document Reference No
5 Document Date Date Document Date
6 Sales Agent varchar(50) Transaction Sales Agent
7 Supplier Sales Agent varchar(50) Business Partner Sales Agent
8 Purchase Limit decimal(12,2) Business Partner Purchase Limit
9 Document Currency varchar(3) Document Currency
10 Terms Code varchar(50） Document Terms Code
11 Terms Day int(11) Document Terms Day
12 Due Date date(YYYY-mm-dd) Document due date (document date + terms day)
13 Supplier Id varchar(50) Backend id for the Business Partner
14 Supplier Name varchar(255) Business Partner Name
15 Supplier No varchar(50) Business Partner No
16 Supplier Terms Code varchar(50) Business Partner Terms Code
17 Supplier Terms Day varchar(50) Business Partner Terms Day
18 Over Due Days date(YYYY-mm-dd) Over due days (untill filter till date)
19 Contact Tel varchar(20) Business Partner contact Tel
20 Contact Name varchar(60) Business Partner contact name
21 Contact Fax varchar(20) Business Partner Contact Fax
22 Address Tel1 varchar(255) Business Partner Address Tel1
23 Address Tel2 varchar(255) Business Partner Address Tel2
24 Address varchar(255) Business Partner Address
25 Billaddress Country varchar(50) Business Partner Billaddress Country
26 Billaddress Area varchar(50) Business Partner Billaddress Area
27 Industry Name varchar(50) Business Partner Industry Name
28 Total Balance Amount decimal(22,2) Total over due balance amount
29 Total Balance Amount Local decimal(22,2) Total over due balance amount Local (show only when filter currency)
30 Transaction Amount decimal(22,2) Document Transaction Amount
31 Current Month decimal(22,2) Current Month Amount
32 1 Months decimal(22,2) Over due 1 Months Amount
33 2 Months decimal(22,2) Over due 2 Months Amount
34 3 Months decimal(22,2) Over due 3 Months Amount
35 4 Months decimal(22,2) Over due 4 Months Amount
36 5 Months decimal(22,2) Over due 5 Months Amount
37 6 Months decimal(22,2) Over due 6 Months Amount
38 7 Months decimal(22,2) Over due 7 Months Amount
39 8 Months decimal(22,2) Over due 8 Months Amount
40 9 Months decimal(22,2) Over due 9 Months Amount
41 10 Months decimal(22,2) Over due 10 Months Amount
42 11 Months decimal(22,2) Over due 11 Months Amount
43 12 Months decimal(22,2) Over due 12 Months Amount
44 Over 12 Months decimal(22,2) Over due over 12 Months Amount

Sample Data (The data will use Business Partner Code as the key of the group of array data)

{
    "status": "OK",
    "msg": "",
    "data": {
        "S01": {
            "Supplier Id": "1-1-1",
            "Supplier Name": "SIMIT SDN BHD",
            "Supplier No": "S01",
            "Default Sales Agent": "",
            "Supplier Terms Code": "120D",
            "Supplier Terms Day": "120",
            "Contact Tel": "",
            "Contact Name": "",
            "Contact Fax": "",
            "Address Tel1": "",
            "Address Tel2": "",
            "Address": "",
            "Billaddress Country": "",
            "Billaddress Area": "",
            "Purchase Limit": "0.00",
            "Industry Name": ,
            "Total Balance Amount": "2060.00",
            "Total Balance Amount Local": "2060.00",
            "data": {
                [
                    {
                        "Document Id": "1-1-1",
                        "Document No": "PI 00001",
                        "Document Type": "PI",
                        "Document Reference No": "",
                        "Document Date": "2019-04-30",
                        "Transaction Sales Agent": "",
                        "Document Currency": "MYR",
                        "Terms Code": "120D",
                        "Terms Day": "120",
                        "Due Date": "2019-08-28",
                        "Over Due Days": "876",
                        "Transaction Amount": "2060.00",
                        "Current Month": "0.00",
                        "1 Months": "0.00",
                        "2 Months": "0.00",
                        "3 Months": "0.00",
                        "4 Months": "0.00",
                        "5 Months": "0.00",
                        "6 Months": "0.00",
                        "7 Months": "0.00",
                        "8 Months": "0.00",
                        "9 Months": "0.00",
                        "10 Months": "0.00",
                        "11 Months": "0.00",
                        "12 Months": "0.00",
                        "Over 12 Months": "2060.00"
                    }
                ]
            }
        }
    }     
}
Clone this wiki locally