Go to documentation repository
Documentation for POS PSIM 1.0.1.
Previous page
Next page
Create a query before starting the search:
Select the report type in the Report list drop-down list (1).
Each query type has its own set of parameters which is displayed when the query type is selected (2).Note
Some queries, for example, the List of all queries, have no parameters.- Enter the date/time interval of the receipts to be searched for in the Period from and to fields (3).
The query's creating is complete.
If settings of search query was not been performed (see the Editing the receipts database queries (optional) section of the Administrator's Guide document) then queries described in the following table are used on default.
Name of query | Parameters | Purpose of query |
|---|---|---|
| №01 List of all receipts | - | Getting the list of all receipts recorded to the database for the specified period. The cashier number is displayed for each receipt |
| №02 All receipts list with a cashier's name | - | Getting the list of all receipts recorded to the database for the specified period. The cashier number is displayed for each receipt |
| №03 List of all good's returns (1) | - | Getting the list of all good's returns for the specified period. Return is defined by non-zero value of the return parameter in the database |
| №03 List of all good's returns (2) | - | Getting the list of good's returns with negative number of goods for the specified period |
| №04 Search by receipt number | Receipt number | Search for receipt with the specified number for the specified period |
| №05 Search by return number | Return number | Search for receipts containing the specified return number. Value of this parameter is specified on the parser |
| №06 Search by cashier number | Cashier number | Search for receipts containing the specified cashier number for the specified period |
| №07 Search by marking of good | Marking of goods | Search for receipts containing the specified marking of goods for the specified period |
| №09 Goods report | Goods | Getting the number of sold goods with specified name and realized sum for the specified period |
| №10 Archive depth | - | Getting the information about the earliest receipt date in the database and the latest receipt date and the number of receipts between these dates |
| №11 Search by goods amount in receipt | Minimal goods amount Maximal goods amount | Getting the list of receipts for the specified period in which the amount of goods is in the specified range |
| №12 Query by receipt's total | Minimal total Maximal total | Getting the list of receipts, sum (total) of which is in the specified range |
| №13 List of all receipts by goods (and) | Goods No.1 Goods No.2 | Getting the list of receipts containing both of specified goods for the specified period |
| №14 List of receipts by goods (or) | Goods No.1 Goods No.2 Minimal price Maximal price | Getting the list of receipts for the specified period containing at least one of the specified goods and in which the price is in the specified range |
| №15 Search of receipts by goods | Goods | Getting the list of receipts containing the specified goods |
| №16 List of all receipts of cashier | Cashier name | Search for receipts containing the specified cashier name for the specified period |
| №17 List of receipt's cancellation (negative sum) | - | Getting the list of receipts for the specified period sum of which is negative |
| №18 Query by goods weight | Goods maximal weight | Search for receipts for the specified period containing the catchweight goods weight of which less than the specified weight |
| №19 Query by discount value | Minimal discount Maximal discount | Search for receipts discount of which is in the specified range for the specified period |
| №20 List of all receipts of waiter | Waiter's name | Getting the list of receipts containing the waiter's name for the specified period |
| №21 List of receipt's cancellations (receipt's numbers) | - | Getting the list of cancelled receipts for the specified period |
| №22 Selling for a period | - | Total sum of gain for the specified period |
| №23 Receipts with cancelled positions (negative sum) | - | Search for receipts containing positions with negative sum for the specified period |
| №24 Goods rating by selling sum | Goods quantity to list Name | Getting the specified amount of goods of specified name with the most total sum by all receipts for the specified period |
| №25 Goods rating by quantity | Goods quantity to list Name | Getting the specified amount of goods of specified name with the most total amount by all receipts for the specified period |
| №26 List of receipts with multyple same goods | Goods Min. goods amount Max. goods amount | Getting the list of receipts containing the specified goods in the amount is within the specified range for the specified period |
| №27 Cash point's gain report for every 30 minutes | - | Getting information about gain by all cash points for every 30 minutes for the specified period |
Overview
Content Tools