Accounts Receivable

This dataset is essentially an "accounts receivable" report. It can be run for "current" outstanding invoices or "as of" a specified date. Each row is a separate invoice record. Results are based on the parameters used. Returns customer name, invoice date, due date, amount due, original amount etc. It does not include invoice details. By default this API will return all current open accounts receivable records. Note: If cieTrade's A/R module is disabled then this API will return an empty response.

Request Example

https://api.cietrade.net/ListAccountsReceivable?UserID=ExampleUser@gmail.com&UserPwd=1234&AsOfDate=06/20/2024&Dept=05&Customer=84698&PastDueOnly=true

Query Parameters (Filters)

UserID	cieTrade.net User Name.	Required
UserPwd	cieTrade.net User Password.	Required
AsOfDate	As of Reporting Date. Defaults to todays date.	Optional
Dept	Department Filter Example: “00” as it is stored in cieTrade, or Department Short Name. This parameter is Optional, no default value if not provided.	Optional
Customer	Customer receiving invoice. Pass the exact customer name as listed in cieTrade or the customer's account ID. Blank value defaults to all customers.	Optional
PastDueOnly	Indicates whether the results include only past-due invoices or any invoice regardless of payment due status. Default option is false. requires a value of "true" or "false"	Optional

Response Example

ListAccountsReceivable?UserID=dakota&UserPwd=asdf&AsOfDate=06/20/2024&Dept=05&Customer=84698
{
        "invoice_id": "510831",
        "group_invoice_id": 510963,
        "customer": "27 RECYCLING CORP XERO",
        "customer_id": "84698",
        "department": "Mount Morris Paper Company",
        "posting_date": "2023-05-31",
        "payment_date": "OPEN",
        "due_date": "2023-07-07",
        "amount": 15400.00,
        "payments": 2.00,
        "payment_terms": "NET 30",
        "balance": 15398.00,
        "hc_balance": 15398.00,
        "last_payment_date": "2023-11-01",
        "past_due": 349,
        "location_name": "1050 Mecha Norwalk",
        "created_by": "Ciara",
        "billingUDF1": ""
    }