> ## Documentation Index
> Fetch the complete documentation index at: https://docs.arcuserp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# AP aging by vendor

> Returns an accounts-payable aging summary for the entity, grouping open vendor-bill balances
into configurable buckets (Current, 1-30, 31-60, 61-90, 90+ days past due). Each row
contains the vendor name, account ID, and the outstanding balance in each bucket. Use
`as_of_date` to run historical aging snapshots without altering live data.
Requires `migration:read` scope.




## OpenAPI

````yaml /openapi.yaml get /entities/{entity_id}/reconciliation/ap-aging
openapi: 3.1.0
info:
  title: Arcus ERP Public API
  version: 1.0.0
  description: >
    Arcus ERP public REST API. Designed for external integrations and data
    migration.


    **Authentication.** Bearer token (API key) via the `Authorization` header.

    Format: `Authorization: Bearer ark_live_ent_<code>_<random>` (or
    `ark_test_*` for sandbox).

    API keys are issued per-entity in **Settings > Developers > API Keys**.


    **Entity scoping.** The entity is encoded in the API key prefix; routes are
    flat

    (e.g. `/v1/accounts`, `/v1/orders`, `/v1/products`). A small set of platform
    endpoints

    (migration, reconciliation, events, webhook endpoints, API keys) use the

    `/v1/entities/{entity_id}/...` form -- those are noted in their tags.


    **Key capabilities.**
      - Related-resource hydration via `?expand[]=` (see `x-arcus-expand` on each resource).
      - Cursor-based pagination (`starting_after` / `ending_before` / `limit`).
      - Idempotency via the `Idempotency-Key` header.
      - Webhook events for asynchronous notification.
      - Conditional requests / ETag for cache validation.
servers:
  - url: https://api.arcuserp.com/v1
    description: Arcus ERP API (accepts both live `ark_live_*` and test `ark_test_*` keys)
  - url: https://dev-api.arcuserp.com/v1
    description: >-
      Dev sandbox API (test-only data, accepts `ark_test_*` keys against dev
      RDS)
security: []
paths:
  /entities/{entity_id}/reconciliation/ap-aging:
    get:
      tags:
        - Reconciliation
      summary: AP aging by vendor
      description: >
        Returns an accounts-payable aging summary for the entity, grouping open
        vendor-bill balances

        into configurable buckets (Current, 1-30, 31-60, 61-90, 90+ days past
        due). Each row

        contains the vendor name, account ID, and the outstanding balance in
        each bucket. Use

        `as_of_date` to run historical aging snapshots without altering live
        data.

        Requires `migration:read` scope.
      operationId: getReconciliationAPAging
      parameters:
        - name: entity_id
          in: path
          required: true
          schema:
            type: string
            format: uuid
        - name: as_of_date
          in: query
          schema:
            type: string
            format: date
      responses:
        '200':
          description: AP aging summary
          content:
            application/json:
              schema:
                type: object
                properties:
                  object:
                    type: string
                    enum:
                      - ap_aging
                  as_of_date:
                    type: string
                    format: date
                  vendors:
                    type: array
                    items:
                      $ref: '#/components/schemas/AgingRow'
                  totals:
                    type: object
        '400':
          $ref: '#/components/responses/Error'
        '401':
          $ref: '#/components/responses/Error'
        '403':
          $ref: '#/components/responses/Error'
      security:
        - ApiKeyAuth: []
components:
  schemas:
    AgingRow:
      type: object
      properties:
        id:
          type: string
          format: uuid
        name:
          type: string
        current:
          type: number
          format: double
        days_1_30:
          type: number
          format: double
        days_31_60:
          type: number
          format: double
        days_61_90:
          type: number
          format: double
        days_over_90:
          type: number
          format: double
        total:
          type: number
          format: double
    ErrorEnvelope:
      type: object
      description: |
        Canonical error response envelope. All API errors use this shape.
      required:
        - error
        - code
      properties:
        error:
          type: string
          description: Machine-readable error key
          example: not_found
        code:
          type: string
          description: Machine-readable error code (often same as error)
          example: not_found
        type:
          type: string
          enum:
            - validation_error
            - permission_error
            - not_found
            - conflict
            - rate_limit
            - internal
            - expand_error
            - not_implemented
          example: not_found
        hint:
          type: string
          description: Human-readable one-sentence explanation (English)
          example: >-
            The requested order does not exist or does not belong to this
            entity.
        param:
          type: string
          description: The parameter that caused the error, if applicable
          example: expand[0]
        required:
          type: string
          description: The scope required (only on insufficient_scope errors)
          example: accounts:read
        request_id:
          type: string
          description: >-
            Unique request ID for support tracing (maps to CloudWatch log
            stream)
          example: req_abc123
  responses:
    Error:
      description: Error response (400/401/403/404/409/422/429/500)
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorEnvelope'
  securitySchemes:
    ApiKeyAuth:
      type: http
      scheme: bearer
      description: |
        API key issued per entity via Settings > Developers > API Keys.
        Each key carries scopes (e.g. orders:read, products:write).
        Bearer token format: Authorization: Bearer ark_live_ent_<code>_<random>
        Test keys use ark_test_ent_<code>_<random>. Both are issued per entity
        via Settings > Developers > API Keys.

````