Sales

Sales Data

This gives you access to item level sales data from invoice and credit note. Equivalent to the Stock Turnover in SI.

List

Request
Method: GET
URL: https://silink.smart-it.co.za/api/v1/salesdata?fromdate=2020-01-01&todate=2025-12-28

Parameters

fromdate - date in format yyyy-mm-dd (year-month-day), zero padded

todate - date in format yyyy-mm-dd (year-month-day), zero padded

Example Response
Response
 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>

Model


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