Skip to main content

Get Invoice Listing (Specific)

Get invoice listing using specific listing filters.

Request​

POST:/{accountBookId}/invoice/listing

Request Body​

object: Invoice Listing Input Model

Example Request Body
Get invoice listing using a date filter

Available date filters for invoice records are date, createdDate and lastModifiedDate. Add date filters in invoice listing filter input model according to your needs.

Example: Get invoice 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 invoice listing using a string filter

Available string filters for invoice records are docNo, debtorCode and salesAgent. Add string filters in invoice listing filter input model according to your needs.

Example: Get invoice records with specific document numbers.

For filtering specific string values, use the multiSelect field in the filter.

{
  "page": 1,
  "filter": {
    "docNo": {
      "multiSelect": ["I-000001", "I-000002"]
    }
  }
}

Example: Get invoice 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": "I-000001",
      "to": "I-000005"
    }
  }
}

Composite example:

{
  "page": 1,
  "filter": {
    "date": {
      "from": "2023-01-06",
      "to": "2023-03-06"
    },
    "docNo": {
      "multiSelect": ["I-000001","I-000003","I-000005"]
    }
  }
}

Example Request URL:

Parameters:
accountBookId = 1

URL:
POST: https://accounting-api.autocountcloud.com/1/invoice/listing

Response​

Success Response​

Status Code: 200

Response Body​

FieldDescriptionType
dataResponse data.array[Invoice View Model]
totalCountNumber of records retrieved.number
Example Success Response Body
{
    "data": [
        {
            "master": {
                "docKey": 121,
                "docNo": "I-000001",
                "docDate": "2023-03-06T00:00:00",
                "taxDate": null,
                "dueDate": "2023-03-06T00:00:00",
                "debtorCode": "300-D002",
                "debtorName": "Customer B",
                "currencyCode": "MYR",
                "currencyRate": 1.000000000000,
                "email": "debtorB@gmail.com",
                "emailCC": null,
                "emailBCC": null,
                "address": "No. 1327, Jalan Padang Benggali, Butterworth, Pulau Pinang",
                "attention": "",
                "phone1": "04-656 3345",
                "fax1": "",
                "deliverAddress": "No. 1327, Jalan Padang Benggali, Butterworth, Pulau Pinang",
                "deliverContact": "",
                "deliverPhone1": "",
                "deliverFax1": "",
                "ref": null,
                "description": null,
                "note": null,
                "remark1": null,
                "remark2": null,
                "remark3": null,
                "remark4": null,
                "creditTerm": "C.O.D.",
                "salesAgent": "Bob",
                "salesLocation": "HQ",
                "inclusiveTax": false,
                "isRoundAdj": false,
                "cancelled": false,
                "totalExTax": 450.00,
                "taxableAmt": 450.00,
                "localTaxableAmt": 450.00,
                "tax": 22.50,
                "localTax": 22.50,
                "exTax": 22.50,
                "localExTax": 22.50,
                "netTotal": 472.50,
                "localNetTotal": 472.50,
                "roundAdj": 0.00,
                "total": 450.00,
                "finalTotal": 472.50,
                "paymentMethod": "CASH",
                "paymentAmt": 0.00,
                "paymentRef": null,
                "toBankRate": 1.000000000000,
                "createdTimeStamp": "2023-03-06T12:41:17.7399527",
                "createdUserID": "ADMIN",
                "lastModified": "2023-03-08T14:20:22.6243419",
                "lastModifiedUserID": "ADMIN",
                "status": "Full Payment"
            },
            "details": [
                {
                    "docKey": 121,
                    "dtlKey": 201,
                    "seq": 0,
                    "productId": 11,
                    "productCode": "P-00002",
                    "productVariantId": null,
                    "productVariant1Option": null,
                    "productVariant2Option": null,
                    "accNo": "500-0000",
                    "description": "Pants",
                    "furtherDescription": "",
                    "qty": 1.00000000,
                    "unit": "pairs",
                    "unitPrice": 450.00000000,
                    "discount": null,
                    "discountAmt": 0.00,
                    "taxCode": "S-5",
                    "taxRate": 5.000000,
                    "taxAdjustment": 0.00,
                    "localTaxAdjustment": 0.00,
                    "tariffCode": "40159000",
                    "taxExportCountry": null,
                    "taxPermitNo": null,
                    "localTotalCost": 0.00000000,
                    "subTotalExTax": 450.00,
                    "localSubTotalExTax": 450.00,
                    "tax": 22.50,
                    "localTax": 22.50,
                    "subTotal": 450.00,
                    "localSubTotal": 450.00,
                    "yourPONo": null,
                    "yourPODate": null,
                    "deptNo": null
                }
            ]
        }
    ],
    "totalCount": 1
}

Error Response​

Response Body​

object: Error Response Model

Example Error Response Body
{
  "statusCode": 401,
  "message": "401 Unauthorized."
}