Multi Warehouse Enhancements

Perspective of three modules to manage multiwarehouse stock and movements of material between warehouses.

• Warehouse. New module with all data of a warehouse. Related in +info with a 1:m relation to Stock and Movements
• Stock. New module with, warehouse capture, product capture and stock numeric field. In this module, we can easily filter or report on the stock of given products or families, or warehouse,…
• Movements. New module with, source warehouse capture, destination warehouse capture, product capture and numeric field that indicates the amount of product moved from source to destination. Records in this module must increase or decrease the corresponding stock records.
• Product. Existing module. Related in +info with a 1:m relation to Stock and Movements
• Once created the infrastructure, the application must be modified to control warehouse selection and stock. We can take two approaches:
  • Multiwarehouse on each invoice (Q/SO/PO)
    • product capture must now contemplate the warehouse it is coming from and permit not only searching by warehouse but also consulting the available stock in each warehouse
    • the warehouse information must be captured and saved on each product line
    • adapt current increase and decrease stock functions to the new structure, by creating the corresponding movement records
    • convert the current stock field in products to readonly and update it consistently through the stock module
  • One warehouse on each invoice (Q/SO/PO) THIS ONE HAS BEEN IMPLEMENTED
    • add one warehouse capture field on Q/SO/PO/I, this will be the warehouse the whole invoice will work with, all the products on the invoice will be from this warehouse
    • modify the Q > SO > I conversion to pass along the warehouse field
    • modify product line popup to automatically show only products from the selected warehouse
    • adapt current increase and decrease stock functions to new structure, by creating the corresponding movement records
    • convert the current stock field in products to readonly and update it consistently through the stock module
• Review and validate reporting to make sure we can get information about all the new modules and stock movements:
  

You have two virtual warehouse, Sales and Purchase. These warehouses simulate the stock movement when you do a purchase or sale.

To work correctly, you have to create your physical warehouse to do the purchase stock movement to your warehouse or when you do a sale from your physical warehouse.

You can do these movements using the virtual warehouse, for example:

• When you want to do a purchase for your warehouse, you have to go to Inventory → Stock Movement and create a new movement.

• There, you have to select the source warehouse, that in this case is Purchase, select destination warehouse, for example, WH00001 and finally select the product and units that you have bought.

• And if you want to do a sale from your warehouse WH00001, you have to select the source warehouse, WH00001, and then the Sales warehouse as the destination.
• If you have more warehouses, you can do movements between them selecting the source and destination warehouse accordingly

We have created three workflows to help control the stock when working with PO and Invoice (SO). The first two are related to the normal work sequence in coreBOS while the third is to handle returns.

As normal, to configure workflows you have to go to Settings→Workflows, where we have already added the new workflows related to the entities, so you just have to configure them depending on your business model conditions.

This is when you make a sale through an Invoice or Sales Order. You have to edit the first workflow (module → Invoice , description → UpdateInventoryProducts On Every Save), then edit the Task and change the UpdateInventory function to mwDecrementStock.

This is when you buy products on a Purchase Order. You have to create a new workflow with the Purchase Order module and create a new task selecting Invoke Custom Function. In this task, you have to select the mwIncrementStock.

You return stock when you cancel an Invoice (Sales Order) or return products to your vendor. Normally you would create new workflows with a condition depending on some status field on the record. The mwReturnStock custom function knows when it is returning a Sale or a Purchase so we use the same custom function for both.

• Stock module, you only have to use for reports, filters, etc, …. you don't have to create new stock here, because this action is done automatically by the Stock Movement module. You can easily disable the create/edit option in the profiles settings.

If we have products to import and we want to initialize the stock, we have to follow the next steps.

• First we have to import a CSV with products to the Products module.
• Now we have all our products imported and we want to initialize the stock and first movement from the virtual Purchase warehouse to our warehouse.
• If you have created a new warehouse, you can export the products that you need to initialize from the Products Module. We need the CSV that coreBOS generates to obtain the product number in the application. Something like this:

  Products::::PRO27

• Now we can edit this CSV and add or delete columns we need to import Movements to coreBOS. We have to obtain a CSV like this:

• After importing these movements we can see that we have new stock registers.