Open Amounts

Interface

It allows you:

• to view current open invoices (receivables)

Prerequisites:

In order to use this API Method for GET there must be accomplished the following requirements in SocrateCloud:

• to have an Organization active

  • to have an Role active

Columns that can  be used as filters:

• • BillBPartner

• DocumentNo

  • DaysDue

• SalesTransaction

• LastModified

  • invoice updated

  • invoice pay schedule updated

  • allocation updated

  • bank statements updated

Actions can be done:

• list open invoices

API Method

List:

URL: https://api.socratecloud.com/webapi/rest/report/open_items/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}

Method: GET

Return: JSON object with next format:

{

    "data": [

        {

            "Organization": "Org 1",

            "DocumentNo": "1000001",

            "OrderNo": null,

            "OrderReference": null,

            "DateInvoiced": "2014-01-07 00:00:00",

            "BillBPartner": "some_bp",

            "BillBPartnerName": "some_bp",

            "Currency": "RON",

            "DueDate": "2014-01-07 00:00:00",

            "DaysDue": 157,

            "GrandTotal": -62,

            "PaidAmount": 124,

            "OpenAmount": 62

        },

        {

            "Organization": "Org 1",

            "DocumentNo": "100103",

            "OrderNo": null,

            "OrderReference": null,

            "DateInvoiced": "2013-12-31 00:00:00",

            "BillBPartner": "some_other_bp",

            "BillBPartnerName": "some_bp",

            "Currency": "RON",

            "DueDate": "2014-02-20 00:00:00",

            "DaysDue": 113,

            "GrandTotal": 80600,

            "PaidAmount": 0,

            "OpenAmount": 80600

        }

    ],

    "totalRows": 151

}