list_accounting_transactions
GET /list_accounting_transactions
To get the TOTAL COUNT of the list of all accounting transactions.
Use this method FIRST to determine how many total records there are for the interface filter criteria.
After you call this method, then call the method below, and pass the required paging parameters.
/list_accounting_transactions?token=XXXXX&interface_flag=all&interface_status=all
| field |
description |
| token |
Credentials provided by Powersoft that allow access to the API |
| interface_flag |
'processed' = Only the processed transactions. 'unprocessed' = Only the unprocessed transactions. 'all' = All the transactions(processed and unprocessed) |
| interface_status |
'open' = Only the open (not at all processed) transactions. 'failed' = Only the failed (processed and failed) transactions.'passed' = Only the passed (processed and successfully) transactions. 'all' = All the transactions |
Returns
{
"api_response": {
"response_code": "1",
"response_msg": "OK",
"response_id": ""
},
"total_count_list_transactions": 2
}
GET /list_accounting_transactions
To get a list of all accounting transactions for interface filter criteria.
/list_accounting_transactions?token=XXXXX&interface_flag=all&interface_status=all&page_number=1&page_size=10
| field |
description |
| token |
Credentials provided by Powersoft that allow access to the API |
| interface_flag |
'processed' = Only the processed transactions. 'unprocessed' = Only the unprocessed transactions. 'all' = All the transactions(processed and unprocessed) |
| interface_status |
'open' = Only the open (not at all processed) transactions. 'failed' = Only the failed (processed and failed) transactions.'passed' = Only the passed (processed and successfully) transactions. 'all' = All the transactions |
| page_number |
The page number in the entire list. eg Page 1 |
| page_size |
The number of rows to return. eg 10 transactions |
Returns
{
"api_response": {
"response_code": "1",
"response_msg": "OK",
"response_id": ""
},
"list_transactions": [
{
"transaction_header": {
"transaction_code_365": "00100001",
"transaction_description": "Total for 27/11/2012 (001) Cust 122103",
"reference_number": "00100001",
"transaction_date_local": "2012-11-27 09:48:35",
"transaction_date_utc0": "2012-11-27 09:48:35",
"transaction_value": 111,
"store_code_365": "001",
"cost_center": "",
"interface_flag": "Unprocessed",
"interface_status": "Open",
"fiscal_period": "2012-04",
"vat_period": null,
"type_code_365": "BI",
"type_name": "Batch Sales Invoices",
"is_euc": false
},
"list_transaction_details": [
{
"account_code_365": "122103",
"account_secondary_code": "",
"account_code_name": "CASH CUSTOMER",
"debit_credit": "DR",
"amount": 111,
"details": "Total for 27/11/2012 (001) Cus",
"vat_code_365": "",
"vat_value": 0,
"payment": false,
"eucAccount": false,
"is_supplier": false,
"is_customer": true,
"customer_supplier_code_365": "100000125"
},
{
"account_code_365": "411108",
"account_secondary_code": "",
"account_code_name": "LOCAL SALES - 17%",
"debit_credit": "CR",
"amount": 94.87,
"details": "CASH CUSTOMER",
"vat_code_365": "017",
"vat_value": 0.17,
"payment": false,
"eucAccount": false,
"is_supplier": false,
"is_customer": false,
"customer_supplier_code_365": ""
},
{
"account_code_365": "216208",
"account_secondary_code": "",
"account_code_name": "VAT 17%-OUT",
"debit_credit": "CR",
"amount": 16.13,
"details": "CASH CUSTOMER",
"vat_code_365": "017",
"vat_value": 0.17,
"payment": false,
"eucAccount": false,
"is_supplier": false,
"is_customer": false,
"customer_supplier_code_365": ""
}
]
},
{
"transaction_header": {
"transaction_code_365": "00100002",
"transaction_description": "Total for 27/11/2012 (001) Cust 122103",
"reference_number": "00100001",
"transaction_date_local": "2012-11-27 09:48:35",
"transaction_date_utc0": "2012-11-27 09:48:36",
"transaction_value": 111,
"store_code_365": "001",
"cost_center": "",
"interface_flag": "Unprocessed",
"interface_status": "Open",
"fiscal_period": "2012-04",
"vat_period": null,
"type_code_365": "RC",
"type_name": "Receipts From Customers",
"is_euc": false
},
"list_transaction_details": [
{
"account_code_365": "124001",
"account_secondary_code": "",
"account_code_name": "CASH A/C",
"debit_credit": "DR",
"amount": 111,
"details": "CASH",
"vat_code_365": "",
"vat_value": 0,
"payment": true,
"eucAccount": false,
"is_supplier": false,
"is_customer": false,
"customer_supplier_code_365": ""
},
{
"account_code_365": "122103",
"account_secondary_code": "",
"account_code_name": "CASH CUSTOMER",
"debit_credit": "CR",
"amount": 111,
"details": "Total for 27/11/2012 (001) Cus",
"vat_code_365": "",
"vat_value": 0,
"payment": true,
"eucAccount": false,
"is_supplier": false,
"is_customer": false,
"customer_supplier_code_365": ""
}
]
}
]
}
GET /list_accounting_transactions
To get the TOTAL COUNT of the list of all accounting transactions.
Use this method FIRST to determine how many total records there are.
After you call this method, then call the method below, and pass the required paging parameters.
/list_accounting_transactions?token=XXXXX
| field |
description |
| token |
Credentials provided by Powersoft that allow access to the API |
Returns
{
"api_response": {
"response_code": "1",
"response_msg": "OK",
"response_id": ""
},
"total_count_list_transactions": 2
}
GET /list_accounting_transactions
To get a list of all accounting transactions.
/list_accounting_transactions?token=XXXXX&page_number=1&page_size=10
| field |
description |
| token |
Credentials provided by Powersoft that allow access to the API |
| page_number |
The page number in the entire list. eg Page 1 |
| page_size |
The number of rows to return. eg 10 transactions |
Returns
{
"api_response": {
"response_code": "1",
"response_msg": "OK",
"response_id": ""
},
"list_transactions": [
{
"transaction_header": {
"transaction_code_365": "00100001",
"transaction_description": "Total for 27/11/2012 (001) Cust 122103",
"reference_number": "00100001",
"transaction_date_local": "2012-11-27 09:48:35",
"transaction_date_utc0": "2012-11-27 09:48:35",
"transaction_value": 111,
"store_code_365": "001",
"user_code": "",
"user_name": "",
"fiscal_period": "2012-04",
"vat_period": null,
"type_code_365": "BI",
"type_name": "Batch Sales Invoices",
"is_confirmed": false,
"is_euc": false
},
"list_transaction_details": [
{
"account_code_365": "122103",
"account_code_name": "CASH CUSTOMER",
"debit_credit": "DR",
"amount": 111,
"details": "Total for 27/11/2012 (001) Cus",
"cheque_no": ""
},
{
"account_code_365": "411108",
"account_code_name": "LOCAL SALES - 17%",
"debit_credit": "CR",
"amount": 94.87,
"details": "CASH CUSTOMER",
"cheque_no": ""
},
{
"account_code_365": "216208",
"account_code_name": "VAT 17%-OUT",
"debit_credit": "CR",
"amount": 16.13,
"details": "CASH CUSTOMER",
"cheque_no": ""
}
]
},
{
"transaction_header": {
"transaction_code_365": "00100002",
"transaction_description": "Total for 27/11/2012 (001) Cust 122103",
"reference_number": "00100001",
"transaction_date_local": "2012-11-27 09:48:35",
"transaction_date_utc0": "2012-11-27 09:48:36",
"transaction_value": 111,
"store_code_365": "001",
"user_code": "",
"user_name": "",
"fiscal_period": "2012-04",
"vat_period": null,
"type_code_365": "RC",
"type_name": "Receipts From Customers",
"is_confirmed": false,
"is_euc": false
},
"list_transaction_details": [
{
"account_code_365": "124001",
"account_code_name": "CASH A/C",
"debit_credit": "DR",
"amount": 111,
"details": "CASH",
"cheque_no": ""
},
{
"account_code_365": "122103",
"account_code_name": "CASH CUSTOMER",
"debit_credit": "CR",
"amount": 111,
"details": "Total for 27/11/2012 (001) Cus",
"cheque_no": ""
}
]
}
]
}