23.2 Cash Details

Interface

It allows you:

to insert new lines (one by one) into an existing cash
to view cash lines

Prerequisites:

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

to have an existing open cash (document status: Draft) else it will create a new cash master

Columns that can be used as filters:

Organization (Name)
Cashbook (Name)
StatementDate

Mandatory Parameters from Cash Master when inserting lines:

- Organization (Name)
- Cashbook (Name)
- StatementDate

Actions can be done:

list
create

API Methods:

List:

URL: https://api.socratecloud.com/webapi/rest/cash/line/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}&Organization={Organization}&CashBook={CashBook}&StatementDate=2022-08-12%2000%3A00%3A00%2B0000WWVz

Available filter parameters:

- Organization (Name)
- CashBook (Name)
- StatementDate -Range

Method: GET

Return: JSON object with next format:

{

"Organization_ID": 1000001,

"OrganizationValue": "Demo",

"Organization": "Demo SRL",

"Created": "2022-08-24 11:55:54+0000",

"CreatedBy_ID": 1021485,

"CreatedBy": "Ionut Ursuleanu",

"Updated": "2022-08-24 11:55:54+0000",

"UpdatedBy_ID": 1021485,

"UpdatedBy": "Ionut Ursuleanu",

"Line": 10,

"Description": "bbbb",

"CashType": "Charge",

"DocType_ID": null,

"DocType": null,

"DocumentNo": "125",

"BPartner_ID": 1000375,

"BPartnerValue": "U1",

"BPartnerName": "Ursu Unu",

"Amount": 62,

"Invoice_ID": null,

"InvoiceNo": null,

"Order_ID": null,

"OrderNo": null,

"BillLocation": null,

"Charge_ID": 1000006,

"ChargeName": "CAS Asigurati",

"TrxOrganization_ID": null,

"TrxOrganizationValue": null,

"TrxOrganization": null,

"Project_ID": null,

"ProjectValue": null,

"ProjectName": null,

"ProjectPhase_ID": null,

"ProjectPhase": null,

"ProjectTask_ID": null,

"ProjectTask": null,

"Activity_ID": null,

"ActivityValue": null,

"Activity": null,

"Asset_ID": null,

"AssetValue": null,

"Asset": null,

"User1_ID": null,

"User1": null,

"Campaign_ID": null,

"CampaignValue": null,

"CampaignName": null

}

Create:

URL: https://api.socratecloud.com/webapi/rest/cash/line/create/{version}?accessToken={access_token}

Mandatory when inserting:

- Organization (Name)
- CashBook (Name)
- StatementDate

Method: POST

Return: line no and the Cash ID for success or error message (start with "ERROR: ")

Data format:

{