Title here
Summary here
This gives you access to item level sales data from invoice and credit note. Equivalent to the Stock Turnover in SI.
Method: GET
URL: https://silink.smart-it.co.za/api/v1/salesdata?fromdate=2020-01-01&todate=2025-12-28fromdate - date in format yyyy-mm-dd (year-month-day), zero padded
todate - date in format yyyy-mm-dd (year-month-day), zero padded
1<sales>
2 <meta>
3 <fromdate>2020-01-01</fromdate>
4 <todate>2025-12-28</todate>
5 <last_update>2025-10-02</last_update>
6 </meta>
7 <data>
8 <row>
9 <origin>INV</origin>
10 <docno>1</docno>
11 <datum>2020-11-22</datum>
12 <branch_name>Head Office</branch_name>
13 <description>Duracell AA</description>
14 <stockno>2</stockno>
15 <brand>None</brand>
16 <quantity>1</quantity>
17 <unitprice_excl>7.69</unitprice_excl>
18 <turnover>7.69</turnover>
19 <unit_cost>5.3</unit_cost>
20 <cost>5.3</cost>
21 <stock_group>Builders>Paint</stock_group>
22 <stock_group_root>Builders</stock_group_root>
23 <employee_name>user</employee_name>
24 <stock_customlist1>2022</stock_customlist1>
25 <stock_customlist2>XLT</stock_customlist2>
26 <stock_customlist3>DOHC</stock_customlist3>
27 <stock_customlist4>No Longer Ordered</stock_customlist4>
28 </row>
29 <row>
30 <origin>CRN</origin>
31 <docno>11</docno>
32 <datum>2025-08-28</datum>
33 <branch_name>CybersShop</branch_name>
34 <description>batdaa</description>
35 <stockno>90</stockno>
36 <brand>None</brand>
37 <quantity>-1</quantity>
38 <unitprice_excl>-13.48</unitprice_excl>
39 <turnover>-13.48</turnover>
40 <unit_cost>-9</unit_cost>
41 <cost>-9</cost>
42 <stock_group>Batteries</stock_group>
43 <stock_group_root>Batteries</stock_group_root>
44 <employee_name>Alfred</employee_name>
45 <stock_customlist1>None</stock_customlist1>
46 <stock_customlist2>None</stock_customlist2>
47 <stock_customlist3>None</stock_customlist3>
48 <stock_customlist4>None</stock_customlist4>
49 </row>
50 </data>
51</sales>
meta
----
fromdate - date, from date parameter
todate - date, to date parameter
last_update - date, last time data was updated
sales.data.row
--------------
origin - string, INV = invoice, CRN = credit note
docno - long integer, document number invoice number, creditnote number
datum - date, document date
branch_name - string, branch
description - string, line/item description
stockno - long integer, SI stock/item number
brand - string, Brand
quantity - decimal, quantity sold
unitprice_excl - decimal, item unit price excluding VAT
turnover - decimal, line total excluding VAT
unit_cost - decimal, item unit cost
cost - deciaml, line item cost
stock_group - string, stock group/category, level seperated by > eg: Groceries > Perishable
stock_group_root - string, stock group/category, lowest level of the full stock group eg. Groceries
employee_name - string, Employee/Rep code
stock_customlist1 - string, stock item custom list 1 value
stock_customlist2 - string, stock item custom list 2 value
stock_customlist3 - string, stock item custom list 3 value
stock_customlist4 - string, stock item custom list 4 value