V. Advanced Stock Management

fmStockManagement ,
fmStockMovement,
fmWarehouse
fmWarehouseEdit
fmStockManagementEdit

Using this application, allows sellers (managers) to distinguish their real reserves from available ones. This feature is compatible with the multi-store function and helps:


- manage inventory and supervise your real stocks - their numbers; values;


- manage inventory for delivery;


- keep the history of the inventory’s movement (Stock Movement);


- manage the simplified version of warehouse etc.



Warehouses


You can have one or more warehouses at your store. To add warehouses to Store Manager, go to Stock section, choose 'Warehouses' option and press the appropriate button in the toolbar:


Advanced stock management


In the form below type basic information about warehouse: its name, reference, location, address details, currency (UAH, euro, dollar). 


Add warehouse


When the necessary data is successfully specified, be sure to click the 'OK' button.


Once the warehouse is created, you can fill it with the appropriate products. 


Go to Product Page and choose products, which are available in stock. From the lower menu select ‘Warehouses’ field and assign these products to the necessary ones.


If the products have its own attributes, such as color, size etc, you can assign separately for each color and size value to the certain warehouse.  Press ‘Apply Changes’ button to save your actions.


Apply changes


Section Stock Management’ makes possible to set required number of units in stocks. In order to perform this, find necessary one from the product list and double clicking on it,


open “Edit Stock Management” form. 


Increase in Warehouse


Specify quantity, which will be added to the selected product in stock; choose warehouses, where this quantity will be available, type a price for a


new product’s batch  and select label by which these changes are identified:


- as demand growth (increase),


- for adjusting of inventories (regulation following an inventory of stock);


- as they (stocks) become available (supply order).


If the number of products in stock is more than zero, you can use the arrows in the top menu, Increase button  - to add a number of products in stock,


Decrease - to reduce the existing number of goods in stock.


If you have to subtract the amount of a particular product, select the appropriate arrow in the menu. Clicking reduction mode, you will get such window:


Decrease edit form


Enter the value of quantity reduction for this product; select warehouse, in which the number of product is decreased; choose label of the proposed three options:


- as decreasing demand;


- for regulating warehouse stocks (regulation following an inventory of stock);


- as customer order.


Press ‘OK’ button.


'Transfer ' option calls the form, by filling which you can send certain units of products from one warehouse to another one :


Transfer option


Hit the triangle buttons opposite each active field to select the necessary details from the drop-down list, specify the units number you want to be transferred, check the appropriate checkboxes to set product available for sale 


for outgoing and incoming warehouses. 


Do not forget to indicate the source and destination warehouses before pressing 'OK' button. 


Source warehouse - Destination warehouse


Take into account the 'Usable for Sale' field  - it means the specified amount of item will be available  for ordering and will influence on the total number of product at the store. 


Usable for sale


If you leave this box unchecked  - current units can not be used for purchasing and do not affect the general product's quantity  (will be perceived as a reserve ).



Movement of goods in warehouses - increasing or decreasing quantity, date of changes, a price for each delivered units (or dropped out units) and so on - all is reflected in ‘Stock Movement’ section.


Stock movement


If the recent changes are not reflected in this section - click ‘refresh’ button to update the ‘Stock Movement’ table.


The filter allows view the movement of product stock at one particular warehouse or at all warehouses at once. To filter out goods you just need to select the appropriate filter parameter from the drop-down.


Filter movement



To assign products to the appropriate warehouse move to the lower menu in Products page where you can find the necessary position.


On the right pane in the 'Assign' column check the warehouse you want the product to be associated with and do not forget to press 'Apply Changes' button to save your assignment.


Assing to Warehouse


To link the quantity of product with the stock in warehouses to which it has been assigned choose the Quantities tab from the lower menu and check the field below:


Thereby, the base number of the product will be directly depending on its quantity in the certain stocks (warehouses) .


Advanced Stock Management enavled in Product grid


The second one condition which can be checked allows to take into account the physical quantity of product specified manually . 


Specify quantity manually


For example, let's take the product named 'Vintage Wedding Dress' with the advanced stock management enabled and 


the first variant checked (see an illustration above) . 


In the stock management section specify the quantity you want to add to each warehouse. We have two warehouses created - Warehouse-top and Reservation. 


Use  the 'increase' option to indicate the number of units in the selected stock and press 'OK' button to update:


Quantity to add field


Perform the same for the second warehouse - specify the quantity which will be available to purchase :


Add quantity for second warehouse

 

Now you  get the following results on both warehouses positions:


Warehouse availability in Stock Management section

Once, the current product is selected during ordering in POS section of Store Manager, choose the appropriate variant according to the warehouse availability:


Warehouse availability in POS section


The quantity of product will be taken from the usable amount, available in the warehouse, which has been chosen. 

Please note, the quantity of product after ordering in the Advanced Stock Management will be changed only if the order status is  Delivered or Shipped .



Export

If you want to export warehouse quantity of products among the other data to a file choose the appropriate fields and drop it from the let to the right on the fields selection step of export:

Seelct warehouse during exporting


Import

Link the fields in your database with the corresponding columns from a file which relate to the warehouses on the Assignment step of import :


Select warehouse fields during importing



There is the one more important field relates to update warehouse quantity during importing  - on the Import Options step -  'Increment existing warehouse stock by quantity specified in the import file'


that means if the number of products does not directly depend on the actual (physical) number at the store (field not checked) - 


Field of ASM  is not checked


then you can make the increasing availability of the product in storage  at the amount specified in the file.


Increment existing quantity


If you have any questions or need any assistance to perform such operation properly - contact us and we will gladly assist you. 


Check the following guides on Advanced Stock Management functionality to better understand how it works :






By eMagicOne Inc.

Comments