API
/
SQL Account
/
SQL Account Customer Invoice

Beehexa Customization SQL Account Rest API (1.0)

SQL Account is an accounting software from Malaysia that is suitable for all businesses, from small businesses to large organizations. It is crucial to find a business solution that suits the nature of your business. The right accounting software will broaden the horizons and expand business opportunities for you.

This is a comprehensive REST API for managing SQL accounts. It provides endpoints for user authentication, customer data management, sales transactions, and stock control. Use this API to integrate your applications with the SQL Account software.

Metadata

KeyValue
releaseDate10 Mar 2025
keywordSQL Account Rest API
Download OpenAPI description
docs.json
docs.yaml
Languages
Servers
Mock server
https://docs.beehexa.com/_mock/api/sql-account/docs/
https://sqlaccountrestapi.beehexa.com/

SQL Account App

Provides authentication, system module retrieval, user actions, and application updates.

Operations

SQL Account BizObject

Manages business objects, including querying, creating, updating, and transferring entities.

Operations

SQL Account Customer

Handles customer data retrieval based on email, code, and date filters.

Operations

SQL Account Customer Invoice

Retrieves customer invoices based on document numbers, date filters, and transaction history.

Operations

Retrieves customer invoices by document number

Request

This API fetches customer invoices that match the provided document number.

Path
documentNumberstringrequired

The document number to search.

Default ""
Example: IV-00001
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/customer-invoices/docno/IV-00001?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
AGENTnumber or string
Example: "Yuki"
One of:
number
AREAnumber or string
Example: "Selangor"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
CANCELLEDnumber or string
Example: "F"
One of:
number
cdsDocDetailArray of objects(CustomerInvoiceDetail)
CODEnumber or string
Example: "300-T0001"
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
CURRENCYRATEnumber or string
Example: 1
One of:
number
DESCRIPTIONnumber or string
Example: "Sales"
One of:
number
DOCAMTnumber or string
Example: 800
One of:
number
DOCDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
DOCNOnumber or string
Example: "IV-00001"
One of:
number
DOCNOEXnumber or string
Example: ""
One of:
number
DUEDATEnumber or string
Example: "2024-08-10 00:00:00"
One of:
number
FROMDOCTYPEnumber or string
Example: "IV"
One of:
number
GLTRANSIDnumber or string
Example: 1
One of:
number
INVOICEAMTnumber or string
Example: 800
One of:
number
JOURNALnumber or string
Example: "SALES"
One of:
number
LOCALDOCAMTnumber or string
Example: 800
One of:
number
NOTEnumber or string
Example: ""
One of:
number
LASTMODIFIEDnumber
Example: 1730460182
PAYMENTAMTnumber or string
Example: 0
One of:
number
POSTDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
PROJECTnumber or string
Example: "----"
One of:
number
TAXDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TERMSnumber or string
Example: "60 Days"
One of:
number
UPDATECOUNTnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "DOCNO": "IV-00001",
    "DOCNOEX": "",
    "CODE": "300-T0001",
    "JOURNAL": "SALES",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "TERMS": "60 Days",
    "DUEDATE": "2024-08-10T00:00:00",
    "DESCRIPTION": "Sales",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "PAYMENTAMT": 800,
    "FROMDOCTYPE": "IV",
    "TAXEXEMPTNO": "",
    "GLTRANSID": 1,
    "CANCELLED": "F",
    "UPDATECOUNT": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "LASTMODIFIED": 1730460182,
    "cdsDocDetail": [ … ]
  }
]

Retrieves customer invoices from a certain number of days ago

Request

Fetches customer invoices based on the number of days before the current date.

Path
daysinteger(int32)required

The number of days ago to search.

Default 0
Example: 1000
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/customer-invoices/days-ago/1000?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
AGENTnumber or string
Example: "Yuki"
One of:
number
AREAnumber or string
Example: "Selangor"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
CANCELLEDnumber or string
Example: "F"
One of:
number
cdsDocDetailArray of objects(CustomerInvoiceDetail)
CODEnumber or string
Example: "300-T0001"
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
CURRENCYRATEnumber or string
Example: 1
One of:
number
DESCRIPTIONnumber or string
Example: "Sales"
One of:
number
DOCAMTnumber or string
Example: 800
One of:
number
DOCDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
DOCNOnumber or string
Example: "IV-00001"
One of:
number
DOCNOEXnumber or string
Example: ""
One of:
number
DUEDATEnumber or string
Example: "2024-08-10 00:00:00"
One of:
number
FROMDOCTYPEnumber or string
Example: "IV"
One of:
number
GLTRANSIDnumber or string
Example: 1
One of:
number
INVOICEAMTnumber or string
Example: 800
One of:
number
JOURNALnumber or string
Example: "SALES"
One of:
number
LOCALDOCAMTnumber or string
Example: 800
One of:
number
NOTEnumber or string
Example: ""
One of:
number
LASTMODIFIEDnumber
Example: 1730460182
PAYMENTAMTnumber or string
Example: 0
One of:
number
POSTDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
PROJECTnumber or string
Example: "----"
One of:
number
TAXDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TERMSnumber or string
Example: "60 Days"
One of:
number
UPDATECOUNTnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "DOCNO": "IV-00001",
    "DOCNOEX": "",
    "CODE": "300-T0001",
    "JOURNAL": "SALES",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "TERMS": "60 Days",
    "DUEDATE": "2024-08-10T00:00:00",
    "DESCRIPTION": "Sales",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "PAYMENTAMT": 800,
    "FROMDOCTYPE": "IV",
    "TAXEXEMPTNO": "",
    "GLTRANSID": 1,
    "CANCELLED": "F",
    "UPDATECOUNT": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "LASTMODIFIED": 1730460182,
    "cdsDocDetail": [ … ]
  }
]

Retrieves customer invoices from a specific date

Request

Fetches customer invoices recorded from a given date onward.

Path
datestringrequired

The date in YYYY-MM-DD format.

Default ""
Example: 2020-01-01
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/customer-invoices/from-date/2020-01-01?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
AGENTnumber or string
Example: "Yuki"
One of:
number
AREAnumber or string
Example: "Selangor"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
CANCELLEDnumber or string
Example: "F"
One of:
number
cdsDocDetailArray of objects(CustomerInvoiceDetail)
CODEnumber or string
Example: "300-T0001"
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
CURRENCYRATEnumber or string
Example: 1
One of:
number
DESCRIPTIONnumber or string
Example: "Sales"
One of:
number
DOCAMTnumber or string
Example: 800
One of:
number
DOCDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
DOCNOnumber or string
Example: "IV-00001"
One of:
number
DOCNOEXnumber or string
Example: ""
One of:
number
DUEDATEnumber or string
Example: "2024-08-10 00:00:00"
One of:
number
FROMDOCTYPEnumber or string
Example: "IV"
One of:
number
GLTRANSIDnumber or string
Example: 1
One of:
number
INVOICEAMTnumber or string
Example: 800
One of:
number
JOURNALnumber or string
Example: "SALES"
One of:
number
LOCALDOCAMTnumber or string
Example: 800
One of:
number
NOTEnumber or string
Example: ""
One of:
number
LASTMODIFIEDnumber
Example: 1730460182
PAYMENTAMTnumber or string
Example: 0
One of:
number
POSTDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
PROJECTnumber or string
Example: "----"
One of:
number
TAXDATEnumber or string
Example: "2024-06-11 00:00:00"
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TERMSnumber or string
Example: "60 Days"
One of:
number
UPDATECOUNTnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "DOCNO": "IV-00001",
    "DOCNOEX": "",
    "CODE": "300-T0001",
    "JOURNAL": "SALES",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "TERMS": "60 Days",
    "DUEDATE": "2024-08-10T00:00:00",
    "DESCRIPTION": "Sales",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "PAYMENTAMT": 800,
    "FROMDOCTYPE": "IV",
    "TAXEXEMPTNO": "",
    "GLTRANSID": 1,
    "CANCELLED": "F",
    "UPDATECOUNT": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "LASTMODIFIED": 1730460182,
    "cdsDocDetail": [ … ]
  }
]

SQL Account Customer Payment

Manages customer payments, including retrieval by document number and payment history tracking.

Operations

SQL Account History

Provides access to system logs, log details, and historical transaction downloads.

Operations

SQL Account Sales Invoice

Retrieves sales invoices by document number and filters based on transaction dates.

Operations

SQL Account Sales Order

Handles sales orders, including retrieval by document number and transaction history.

Operations

SQL Account Stock Adjustment

Manages stock adjustments, including retrieval by document number and date-based filters.

Operations

SQL Account Stock Item

Retrieves stock item details based on code and historical transaction data.

Operations

SQL Account Stock Item Template

Provides access to predefined stock item templates for inventory standardization.

Operations