v1

latestOpenAPI 3.0.3Apache 2.02026-08-062991191002.1 KB

AgedPayablesReport

Retrieves an aged payables report

Retrieves a AgedPayablesReport resource.

get/aged_payables_report

Query parameters

asOfstring date-time

YYYY-MM-DD

refreshstring

If refresh is set, data will be fetched from the source application even when cached data is available

sort'descending' | 'ascending' | 'alphabetical'

Vendors can be sorted by total amount in ascending or descending order, or alphabetically. Default is alphabetical.

Response

AgedPayablesReport resource

asOfstring date

lastReconciledstring date nullable

isReconciledboolean

sourcesstring[]

Example response

{
  "asOf": "2021-06-30",
  "summary": [
    {
      "id": "32",
      "name": "Cal Telephone",
      "current": 0,
      "1to30": 56.5,
      "31to60": 0,
      "61to90": 0,
      "91andOver": 0,
      "total": 56.5
    },
    {
      "id": "48",
      "name": "PG&E",
      "current": 86.44,
      "1to30": 0,
      "31to60": 0,
      "61to90": 0,
      "91andOver": 0,
      "total": 86.44
    },
    {
      "name": "TOTAL",
      "current": 86.44,
      "1to30": 56.5,
      "31to60": 0,
      "61to90": 0,
      "91andOver": 0,
      "total": 142.94
    }
  ],
  "lastReconciled": "2021-01-31",
  "sources": [
    "xero"
  ]
}