22. General Distributions

01. General Distributions

Interface

It allows you:

• to insert new general distributions (master&details in one json file)

• to view general distributions (master&details in one json file) - ordered descending by created date and document date

Prerequisites:

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

• to have an Organization active

• to have an Warehouse active

• to have a Customer active with all the mandatory fields

• to have a price list active

Columns that can be used as filters:

• Organization

• DocumentNo

• BPartner

Actions can be done:

• list

• create

General Distribution fields (Master&Details)

A General Distribution in SocrateCloud has the following structure:

• Master document which contains data about header document:

  • No. document

  • General Distribution data

  • Customer

  • etc.

• Document details (see  General Distributions Details)  which contains informations about:

  • Product 

  • Quantity

  • Currency

  • Price

  • Employee

  •  etc

To update only master data, or a specific distribution line see General Distribution Master, General Distribution Details chapters.

API Methods:

List:

URL: https://api.socratecloud.com/webapi/rest/distribution/list_full/{version}?accessToken={access_token}

Method: GET

Return: JSON object with next format:

{

   "data": [

       {

           "Organization": "TESTIRINA SRL",

           "DocumentNo": "RGA 1000029",

           "DateAcct": "2020-10-14 00:00:00+0000",

           "BPartner": "1000024",

           "DocType": "General Distribution",

           "DocStatus": "CO",

           "DocAction": "CL",

           "Description": "test 1234",

           "DistributionType": "D-P",

           "SourceDocType": "AP Invoice",

           "lines": [

               {

                   "Organization": "TESTIRINA SRL",

                   "Distribution_ID": 1001549,

                   "Created": "2020-10-16 11:08:25+0000",

                   "CreatedBy": "TESTIRINA_Admin",

                   "Updated": "2020-10-16 11:08:25+0000",

                   "UpdatedBy": "TESTIRINA_Admin",

                   "Description": "descriere detaliu test",

                   "Qty": 10,

                   "UOM": "Each",

                   "Price": 150,

                   "Percentage": 100,

                   "Amount": 1500,

                   "Currency": "RON",

                   "CurrencyType": "Spot",

                   "Tax": "5%",

                   "DeductibleAmt": 100,

                   "NonDeductibleAmt": 150,

                   "DeductibleQty": 1,

                   "NonDeductibleQty": 2,

                   "TrxOrganization": "ADM",

                   "Account": "Patrimoniul regiei",

                   "BPartner": "1000024",

                   "Employee": "ANA OBRETIN",

                   "Product": "001",

                   "Charge": "Cheltuieli cu salariile-421",

                   "Warehouse": "Standard",

                   "AssetValue": "1000055",

                   "Line": 10,

                   "Project": "PACHE_1",

                   "ProjectPhase": "pache_fz_1",

                   "ProjectSubPhase": "pache_A",

                   "Campaign": "Campanie testare API",

                   "Activity": "Dulgherie",

                   "SalesRegion": "REGIUNEA TRANSILVANIA",

                   "LocationFrom": "Sfantu Gheorghe",

                   "LocationTo": "Alba Iulia",

                   "Contract": "1000002",

                   "User1": null,

                   "User2": null,

                   "CardNumber": "numar_card_1234",

                   "ResourceName": null,

                   "DistributionLine_ID": 1002250

               }

           ]

       }

   ],

   "totalRows": 1

}

Create:

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

Method: POST

Return: document no for success or error message (start with "ERROR: ")

Data format:

{

    "Organization": "TESTIRINA SRL",

    "DocumentNo": "RGA 1000001",

    "DateAcct": "2020-10-15 00:00:00+0000",

    "BPartner": "1000024",

    "DocType": "General Distribution",

    "DocStatus": "DR",

    "DocAction": "CO",

    "Description": "test 123",

    "DistributionType": "D-P",

    "SourceDocType": "AP Invoice",

    "lines": [

        {

            "Organization": "TESTIRINA SRL",

            "Description": "descriere detaliu test",

            "Qty": 10,

            "UOM": "Each",

            "Price": 150,

            "Percentage": 100,

            "Amount": 1500,

            "Currency": "RON",

            "CurrencyType": "Spot",

            "Tax": "5%",

            "DeductibleAmt": 100,

            "NonDeductibleAmt": 150,

            "DeductibleQty": 1,

            "NonDeductibleQty": 2,

            "TrxOrganization": "ADM",

            "Account": "Patrimoniul regiei",

            "BPartner": "1000024",

            "Employee": "ANA OBRETIN",

            "Product": "001",

            "Charge": "Cheltuieli cu salariile-421",

            "Warehouse": "Standard",

            "AssetValue": "1000055",

            "Project": "PACHE_1",

            "ProjectPhase": "pache_fz_1",

            "ProjectSubPhase": "pache_A",

            "Campaign": "Campanie testare API",

            "Activity": "Dulgherie",

            "SalesRegion": "REGIUNEA TRANSILVANIA",

            "LocationFrom": "Sfantu Gheorghe",

            "LocationTo": "Alba Iulia",

            "Contract": "1000002",

            "User1": null,

            "User2": null,

            "CardNumber": "numar_card_1234"

        }

    ]

}