Get Journal Entry Listing (Specific)
Get journal entry listing using specific listing filters.
Request
POST:/{accountBookId}/journalEntry/listingRequest Body
object: Journal Entry Listing Input Model
Example Request Body
Get journal entry listing using a date filter
Available date filters for journal entry records are date, createdDate and lastModifiedDate.
Add date filters in journal entry listing filter input model according to your needs.
Example: Get journal entry records with document date falling between a specific date range.
Date formats for from and to fields can be found here.
{
"page": 1,
"filter": {
"date": {
"from": "2022-05-02",
"to": "2023-05-02"
}
}
}
Get journal entry listing using a string filter
Available string filter for journal entry records is docNo.
Example: Get journal entry records with specific document numbers.
For filtering specific string values, use the multiSelect field in the filter.
{
"page": 1,
"filter": {
"docNo": {
"multiSelect": ["JV-000001", "JV-000002"]
}
}
}
Example: Get journal entry records with document number falling between a range of string values.
For filtering a range of string values, use the from and to fields in the filter.
{
"page": 1,
"filter": {
"docNo": {
"from": "JV-000001",
"to": "JV-000005"
}
}
}
Composite example:
{
"page": 1,
"filter": {
"date": {
"from": "2023-01-06",
"to": "2023-05-06"
},
"docNo": {
"multiSelect": ["JV-000001","JV-000003","JV-000005"]
}
}
}
Example Request URL:
Parameters:accountBookId = 1 URL:
POST: https://accounting-api.autocountcloud.com/1/journalentry/listing Response
Success Response
Status Code: 200
Response Body
| Field | Description | Type |
|---|---|---|
data | Response data. | array[Journal Entry View Model] |
totalCount | Number of records retrieved. | number |
Example Success Response Body
{
"data": [
{
"master": {
"docKey": 283,
"docNo": "JV-000001",
"docNo2": null,
"docDate": "2023-03-14T00:00:00",
"taxDate": null,
"currencyCode": "MYR",
"currencyRate": 1.000000000000,
"journalType": "GENERAL",
"description": "Payment for I-000003\t",
"note": null,
"cancelled": false,
"totalDR": 1507.50,
"totalCR": 1507.50,
"localTotalDR": 1507.50,
"localTotalCR": 1507.50,
"totalDRExTax": 1507.50,
"totalCRExTax": 1507.50,
"localTotalDRExTax": 1507.50,
"localTotalCRExTax": 1507.50,
"taxableDR": 0.00,
"taxableCR": 0.00,
"localTaxableDR": 0.00,
"localTaxableCR": 0.00,
"taxDR": 0.00,
"taxCR": 0.00,
"localTaxDR": 0.00,
"localTaxCR": 0.00,
"exTaxDR": 0.00,
"exTaxCR": 0.00,
"localExTaxDR": 0.00,
"localExTaxCR": 0.00,
"netTotalDR": 1507.50,
"netTotalCR": 1507.50,
"localNetTotalDR": 1507.50,
"localNetTotalCR": 1507.50,
"createdTimeStamp": "2023-03-14T10:32:48.8295116",
"createdUserID": "ADMIN",
"lastModified": "2023-03-16T16:24:28.6829841",
"lastModifiedUserID": "ADMIN",
"status": "Fully Applied"
},
"details": [
{
"docKey": 283,
"dtlKey": 596,
"seq": 1,
"accNo": "300-D003",
"toAccountRate": 1.000000000000,
"ref": null,
"description": "Payment for I-000003\t",
"furtherDescription": null,
"dr": null,
"cr": 825.00,
"localDR": null,
"localCR": 825.00,
"taxCode": null,
"taxRate": null,
"taxAdjustment": null,
"localTaxAdjustment": null,
"tariffCode": null,
"taxExportCountry": null,
"taxPermitNo": null,
"taxBRNo": null,
"taxBName": null,
"taxRefNo": null,
"taxRegisterNo": null,
"taxBillDate": null,
"taxDR": null,
"taxCR": null,
"localTaxDR": null,
"localTaxCR": null,
"totalDR": null,
"totalCR": 825.00,
"localTotalDR": null,
"localTotalCR": 825.00,
"totalDRExTax": null,
"totalCRExTax": null,
"localTotalDRExTax": null,
"localTotalCRExTax": null,
"salesAgent": null,
"inclusiveTax": true,
"name": null,
"deptNo": null
},
{
"docKey": 283,
"dtlKey": 604,
"seq": 3,
"accNo": "310-1000",
"toAccountRate": 1.000000000000,
"ref": null,
"description": "Payment for I-000003\t",
"furtherDescription": null,
"dr": 825.00,
"cr": null,
"localDR": 825.00,
"localCR": null,
"taxCode": null,
"taxRate": null,
"taxAdjustment": null,
"localTaxAdjustment": null,
"tariffCode": null,
"taxExportCountry": null,
"taxPermitNo": null,
"taxBRNo": null,
"taxBName": null,
"taxRefNo": null,
"taxRegisterNo": null,
"taxBillDate": null,
"taxDR": null,
"taxCR": null,
"localTaxDR": null,
"localTaxCR": null,
"totalDR": 825.00,
"totalCR": null,
"localTotalDR": null,
"localTotalCR": null,
"totalDRExTax": null,
"totalCRExTax": null,
"localTotalDRExTax": null,
"localTotalCRExTax": null,
"salesAgent": null,
"inclusiveTax": false,
"name": null,
"deptNo": null
},
{
"docKey": 283,
"dtlKey": 640,
"seq": 5,
"accNo": "310-1000",
"toAccountRate": 1.000000000000,
"ref": null,
"description": "Payment for I-000003\t",
"furtherDescription": null,
"dr": 682.50,
"cr": null,
"localDR": 682.50,
"localCR": null,
"taxCode": null,
"taxRate": null,
"taxAdjustment": null,
"localTaxAdjustment": null,
"tariffCode": null,
"taxExportCountry": null,
"taxPermitNo": null,
"taxBRNo": null,
"taxBName": null,
"taxRefNo": null,
"taxRegisterNo": null,
"taxBillDate": null,
"taxDR": null,
"taxCR": null,
"localTaxDR": null,
"localTaxCR": null,
"totalDR": 682.50,
"totalCR": null,
"localTotalDR": null,
"localTotalCR": null,
"totalDRExTax": null,
"totalCRExTax": null,
"localTotalDRExTax": null,
"localTotalCRExTax": null,
"salesAgent": null,
"inclusiveTax": false,
"name": null,
"deptNo": null
},
{
"docKey": 283,
"dtlKey": 642,
"seq": 4,
"accNo": "300-D003",
"toAccountRate": 1.000000000000,
"ref": null,
"description": "Payment for I-000003\t",
"furtherDescription": null,
"dr": null,
"cr": 682.50,
"localDR": null,
"localCR": 682.50,
"taxCode": null,
"taxRate": null,
"taxAdjustment": null,
"localTaxAdjustment": null,
"tariffCode": null,
"taxExportCountry": null,
"taxPermitNo": null,
"taxBRNo": null,
"taxBName": null,
"taxRefNo": null,
"taxRegisterNo": null,
"taxBillDate": null,
"taxDR": null,
"taxCR": null,
"localTaxDR": null,
"localTaxCR": null,
"totalDR": null,
"totalCR": 682.50,
"localTotalDR": null,
"localTotalCR": 682.50,
"totalDRExTax": null,
"totalCRExTax": null,
"localTotalDRExTax": null,
"localTotalCRExTax": null,
"salesAgent": null,
"inclusiveTax": true,
"name": null,
"deptNo": null
}
]
}
],
"totalCount": 1
}
Error Response
Response Body
object: Error Response Model
Example Error Response Body
{
"statusCode": 401,
"message": "401 Unauthorized."
}