2 Point-Of-Sales
From Microinvest
There is a technology for organizing two POS in a common base, with a complete separation of documents and operations. Each of the locations works with its own range of document numbers and maintains its own stock availability. As an example of such an organization we will look at a central warehouse with two stores.
Contents |
Basics
It is recommended to use a SQL server, such as MSDE, MySQL or MS SQL. When working with an Access base, it is likely that a high load on the computers will occur and therefore the recording of operations will be delayed. Also, when working with SQL Server, there is low data traffic across the network, allowing robust Wi-Fi connection. Definition It is recommended to define the following locations:
- Central warehouse. Items supply and their subsequent distribution oto the stores happens here. The distribution itself is done through the Transfer operation;
- Store 1;
- Store 2.
For some of the systems, the central warehouse and store 1 may be combined into one site, where the store also plays the role of a central warehouse for the company.
Locations’ numbering
Including locations’ numbering allows separation of documents by numbering. This setting brings an individual range of numbers for each location, and they work independently of each other. Recommended numbering of locations is:
- Central warehouse, initial document number 1 000 000;
- Store 1, Initial Document Number 2,000,000;
- Store 2, Initial Document Number 3,000,000.
These figures are indicative, with the difference of 1 000 000 documents between them providing a sufficiently wide range of operations before it is necessary to create new ranges of documents. The numbering is included once and does not change during the process. Stores take the highest number of documents to be able to issue growing numbers of documents.
Operators’ locking by location
Microinvest Warehouse Pro allows each operator to be locked to a particular location. In this way, they can perform operations, reports, and edits only in that location. It is recommended that all operators are locked to the corresponding location in which they operate. This protects the system from random errors. In turn, site managers can work on all sites and thus control and manage the entire chain.
Other settings
Once the settings in Microinvest Warehouse Pro are set, it is necessary to set the access rights correctly. The setting of Microinvest Warehouse Pro Light is done individually, with each workstation associated with one location. Microinvest Warehouse Pro Light automatically follows the numbering of locations that is set in the back office.
