'Slimstock file definitions'

Updated on 07 Jun 2024
4 Minutes to read
Contributors

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

</spanSales

- All sales (both cash and on account) are exported in batches (csv files) of up to 50,000 records and the transaction date exported is always the last 7 days for each export.

1	Transaction Number	Starts with CS or IS for cash or on account respectively, followed by transaction number
2	Sale type code	Sales type code
3	Sale type description	Sales type description
4	Transaction status	Completed or Active, 'Completed' when the delivery is invoiced for on account sales, 'Completed' for cash sales
5	Warehouse	From location, followed by a hyphen
6	Product number	Product number or external code (*2)
7	Transaction issue date	Transaction date
8
9
10	Transaction issue quantity	Quantity
11	Transaction line number	Primary key of line (note: can overlap with same primary key for cash sales and invoice sales)
12
13
14	Transaction customer number	Customer number (*3)
15	Transaction customer type	Customer type description
16	Transaction customer name	Customer name

17	Transaction sale price	Transaction net weighted unit price
18
19	Transaction supplier number	Supplier number
20
21	Transaction supplier name	Supplier name
22	Transaction issue quantity	Purchase price per unit excluding VAT

*3 - If no customer is known in the transaction, the fixed text 'Sales type' followed by the sales type code is placed here.

Sale Orders

- Only lines from sales orders with status 'Final' are exported

- Lines from sales orders must not be expired

- Only lines with remaining quantity >0 are exported

1	File ID	9
2	Year	yyyy
3	Month	mm
4	Week	Current week number (*1)
5	Warehouse	From location, followed by a hyphen
6	Product number	Article number or external code (*2)
7	Confirmed order number	Sales order number
8	Confirmed order required date	Sales order expected delivery date, if not specified, system date will be used
9	Still to received quantity	Remaining quantity to be delivered
10
11	Confirmed order type	Sales order classification description
12	Customer details	Customer name
13
14	Confirmed order comments	Sales order reference
15	Original order quantity	Sales order line quantity ordered
16	Supplied quantity	Sales order line quantity ordered - outstanding (=delivered quantity)
17
18
19
20
21
22

Purchase Orders

- Only lines from sent purchase orders will be exported

- Condition is that the purchase order does not have the 'closed' status: Purchase order must be 'final' in terms of status

- Line will only be exported if the quantity to be received is not equal to 0

Summary: All open lines from open final purchase orders will be exported

1	File ID	8
2	Year	yyyy
3	Month	mm
4	Week	Current week number (*1)
5	Warehouse	From location, followed by a hyphen
6	Product Code	Article number or external article code (*2)
7	Purchase order number	Purchase order number
8	Purchase order expected arrival date	Expected delivery date from purchase order line. If empty, the print date (shipping date) of the purchase order will be used
9	Purchase order open quantity	Remaining number of pieces to be received from purchase order line
10	Purchase order supplier details	Supplier name
11	Confirmed order type
12	Purchase order original quantity	Number of pieces ordered
13	Purchase order supplier quantity	Field 12 - field 9
14	Free text 1	Purchase order reference code
15	Free text 2	Article order code
16	Free number 1	Purchase order number (=field 7)
17	Free number 2	Total net price of product
18
19
20

Stock

- All products are exported, there are no criteria. As for the purchase information, the preferred line of the preferred supplier is exported.

1	File ID	3
2	Year	yyyy
3	Month	mm
4	Week	Current week number (*1)
5	Warehouse	From location, followed by a hyphen
6	Product Code	Product number or external product code (*2)
7	Stock on hand	Available stock. If <0 then export 0
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22	Criterium 1	Average FIFO purchase price per product
23
24
25
26
27
28
29
30
31
32	Product Description	Product description
33	Lead time	Standard delivery days from purchase or if empty then standard delivery days from supplier
34
35
36	Run code	Round((day of the month/7)+0.5)
37	Supplier number	Supplier number
38	Supplier name	Supplier name
39	MOQ Minimum order quantity	Minimum order quantity
40	IOQ Incremental Order Quantity	Minimum order quantity (otherwise it would be a field that RetailVista does not have, namely subsequent order quantity)
41
42	Unit price	Purchase price per unit of product, formatted to 4 decimals
43	Sales price	Selling price of product (if store price is empty, default selling price is used)
44	Analysis code 1	Product category code
45	Analysis code 2	Product category description
46	Analysis code 3 (Available for web)	"Y"
47	Analysis code 4	Order code
48	Analysis code 5	Purchase status description
49	Analysis code 6	Purchase assortment (from Assortment indication)
50	Price per	Quantity per purchase price
51	Stocked item	=Analysis code 6
52
53	User defined 2	Expected stock date supplier
54
55
56	Supplier stock	Supplier stock
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77

*1 - Week number determination is according to financial institutions with the first day of the week and the determination of the first week of the year

*2 - According to settings, section Inventory, tab Slimstock, article number determination

Import from SlimStock

Purchase orders:

These files start with 'OG' as the file name and have the extension 'txt'. With this information, purchase orders are created or supplemented. This uses the parameters around ordering articles (such as ordering based on preference rule or finding the correct packaging based on the ordered number of items).

Product code

Article number or external article code (*2)

Amount

The number of SKUs to order

(Must not be less than or equal to 0)

Min/max stock parameters:

These files start with 'MINMAX' as the file name and have the extension 'txt'. When processing this file, a stock record is searched for within the specified location. If it does not exist, it is created. Then, the calculated min and max stock values are taken over, and for the limit minimum stock, the iron stock from column 7 is taken over.

It is important that the stock vending machine is not enabled for the locations from which Slimstock data is provided, otherwise this machine will overwrite the calculated values as they are taken over from Slimstock.

1	Warehouse code	Warehouse code, must match warehouse code from location, tab Slimstock
2	Product code	Article number or external article code (*2)
3	Product Description	Article description, completely ignored
4	Minimum stock	Minimum stock

5	Maximum stock	Maximum inventory
6	Min/max Yes/No
7	Fixed Minimum stock	Minimum inventory limitation

Was this article helpful?

What's Next

What do the columns 'Voorraad' and 'Aantal' mean in the stock mutations in article statistics?

Table of contents

</spanSales
Sale Orders
Purchase Orders
Stock
Import from SlimStock