Logs

This tab is very important: the log allows you to check the reason for the error, when the actual stock does not correspond to SIM.
It also allows you to make statistics on top selling products, prices, traffic periods, etc.
These analysis are easily done with an Excel export. It is also possible to have analysis modules specific to your needs.

Button	Action
Help	Opens a browser on the SIM website page.
Refresh	Displays all data in the database, regardless of previous searches. Also allows you to have up-to-date data in a multi workstation version.
Export	Exports the displayed data in an Excel file, in the displayed order.
Print	The selected entries are printed
Quit	Exits the software

As in the products tab, we have search boxes.
As the journal is very informative, searches can be combined with each other.
Here is an example:
If you are looking for modified operations: you enter "mod" to obtain the list

If you search for operations on "mayonnaise", enter "mayo" in the description box and press enter or click on the description button.

If you are looking for modified operations on mayonnaise, you must empty the boxes that are not concerned, then press All filters to search Type "mod" AND Description "mayo".

Printing selected lines of the log is done in different ways depending on the options available to you:

• Customizable basic printing, according to the model bordereau_.txt which is located in your SIM directory.
• Printing by Excel file, according to the slip.xls template of your SIM directory. The generated file will be numbered and archived in a subdirectory DOC<./li>

A movement refers to either adding or removing goods from the stock.
All movements are saved (logged) in the logbook.
Operations such as editing and deleting a product are also stored.

Field	Format	Description
ID	Integer	Identifier.
Dates	Text
Type	Text	Before = quantity before any movement After = quantity after any movement Input = Products added to stock Output = Products removed from stock Modif = Modification of the properties of a product
Comment	Text	Le commentaire saisi lors de l'opération
Category	Text	La famille du produit
ID_prod	Integer	Product identifier.
Reference	Text	Product reference
Description	Text	Product description
Supplier	Text	The suuplier
Quantity	Decimal	Available quantity in stock
Mouvement	Decimal	Quantity moved
Mini	Decimal	Warning threshold
Location	Text	Location of the product
UnitBuy	Decimal	Unit purchase price
UnitSell	Decimal	Unit selling price
TotalBuy	Decimal	Total purchase price
TotalSell	Decimal	Total selling price
User	Text	Refers to the user/PC that executed the operation

To avoid any confusion, by default there are two lines per operation.
The first one is of the " BEFORE " type and gives the state of the stock.
The second is of the "INPUT" or "OUTPUT" type and refers to the stock variation.
The option "LOG_SIMPLE=1" deletes the first "BEFORE" record. The option "LOG_SIMPLE=0" restores it.