Projects:Stock Search Criteria/Functional Specification

Description

In WebPOS in order to work offline all products that are included in the pricelist and are also included in the assortment are retrieved from the backend when login. These products are kept in the client side so every query related to products are always done against the info stored in the client side. Therefore to select products with stock available can only work being online and doing a query to the backend. So the flow when having in place the stock search criteria will be:

• The system does a query in the client side based on the filters defined by the user and gets some products
• With these products does a query in the backend against the table m_storage_detail with the corresponding whereclause:
  • warehouses of the store
  • list of products coming from the webpos
  • >0; >x <y
  • Get the new list of products and show them in the webpos

This new module will add a new filter in the SEARCH panel area

Scope WebPOS

See figures to understand the solution: It won’t be possible to filter with less than 0 Numeric values will be positive

Figure 1:

• The module will add the new filter button Stock
• Press the button to select the criteria

Figure 2:

• The popup gets opened
• Ability to filter by different criterias, more than, less than, equals to
• There will be a preference that will allow to configure that by default the popup will be opened with the option “more than 0” selected

Figure 3:

• Stock criteria must be in yellow colour in order to know you are filtering by stock
• It must show the stock, if more than one warehouse then the sum of all of them
• This stock will be shown following the product characteristic format