Posted Payables

This API endpoint provides a detail list of posted payables (purchases and expenses) across Worksheet transactions. Each row represents one payable: Either a material purchase or an expense, related to a specific shipment or load as represented by a Worksheet.

Request Example

https://api.cietrade.net/PostedPayables?UserID=Example@gmail.com&DateFrom=1/1/2025&DateTo=6/12/2025&Vendor=black trucks&Dept=""&DateType=POST&InvoiceNo=""

Query Parameters (Filters)

UserID	cieTrade.net User Name.	Required
DateFrom	Start date range. If not provided will default to 30 days prior to today.	Optional
DateTo	End of date range. Default to Today if left out/blank.	Optional
DateType	Sets which date field to filter payables on. ‘POST’: uses the payables posting date ‘INVOICE’: uses the payables invoice date. Defaults to POST if not provoided.	Optional
Vendor	Returns payables only for specified vendor. Accept short name or cieTrade Vendor ID. Returns all if left blank.	Optional
Dept	Only returns payables associated with a specific department. Can be expressed as Dept ID or Department short name. Returns all departments if left blank.	Optional
InvoiceNo	Filter payables based on matching vendor invoice number.

Response Example

{
        "Invoice Date": "2025-01-01",
        "Posted Date": "2025-01-01",
        "AP Batch No": "105150",
        "Invoice No": "0001059032",
        "Vendor": "BLACK TRUCKS",
        "Wks No": "513575",
        "Wks Invoice Date": "2025-01-01",
        "Wks Shipping Date": "2025-01-01",
        "Payment Terms": "NET 30",
        "Due Date": "2025-01-31",
        "Amount": 294.93,
        "Currency": "USD",
        "{HC} Amount": 294.93,
        "GL Account": "Purchases"
    }