ARInfo
This method returns some statistical information given an item identifier (ar_numero).
Body - raw:
{
"Method": "ArInfo",
"Parameters": [
<cMethod>,
<nItemId>[,
<dEndDate>][,
<dStartDate>][,
<cGroup>]
]
}
| Parameters | Description |
|---|---|
| cMethod | Indicates which type of statistics has to be returned. The possible values are: product_sales_quantity: total sales quantity for the item; product_group_sales_quantity: total sales quantity for the group of items; product_sales_amount: total sales amount for the item; product_group_sales_amount: total sales amount for the group of items; product_sales_amount_vatexcluded: total sales amount for the item excluding VAT; product_sales_amount_vatincluded: total sales amount for the item including VAT; product_group_sales_amount_vatexcluded: total sales amount for the group of items, excluding VAT; product_group_sales_amont_vatincluded: total sales amount for the group of items, including VAT. |
| nItemId | Primary key identifying the item (ar_numero). |
| dEndDate | The transactions up to the date specified are selected. The parameter is not mandatory. If the parameter is missing all the transactions are selected. |
| dStartDate | The transactions starting from the date specified are selected. The parameter is not mandatory. If the parameter is missing all the transactions are selected. |
| cGroup | If this parameter is specified and the cMethod includes the keyword _group_ only items included in this group are selected and the statistics are cumulative for the whole group. |
Example:
*/ Return the total sales quantity for the item with ID = 1000.
{
"Method": "ArInfo",
"Parameters": [
"product_sales_quantity",
1000
]
}
*/ Return the total sales quantity for the items in the group ITEMS_TEST.
{
"Method": "ArInfo",
"Parameters": [
"product_group_sales_quantity",
,
"",
"",
"ITEMS_TEST"
]
}
*/ Return the total sales quantity for the items in the group ITEMS_TEST up to the 31.03.2017.
{
"Method": "ArInfo",
"Parameters": [
"product_group_sales_quantity",
,
"31.03.2017",
"",
"ITEMS_TEST"
]
}
*/ Return the total sales quantity for the items in the group ITEMS_TEST from the 01.03.2017 to the 31.03.2017.
{
"Method": "ArInfo",
"Parameters": [
"product_group_sales_quantity",
,
"31.03.2017",
"01.03.2017",
"ITEMS_TEST"
]
}
*/ Return the total sales quantity for the item with ID = 1000 from the 01.03.2017 to the 31.03.2017.
{
"Method": "ArInfo",
"Parameters": [
"product_sales_quantity",
"1000",
"31.03.2017",
"01.03.2017"
]
}