Multi Location¶

There is a ‘Stock Location’ system table, where you can enter all stock location names.

The ‘Location’ field (Stock Control > Stock Items > General > Location) in its turn looks up the ‘Stock Location’ system table.
A user may choose a correspondent location from a drop down list.

Users are set up to be in one or another group location.
Generally, if a user enters an order, that order is normally made in
the same location as where the order was entered.
But sometimes because there is not enough stock available in one location, the
order will be made in the other location.
Before this can be decided, a manager will need to see if enough stock is available in each location.

If ‘Enable Stock Transaction By Location’ is switched on and there is a Button Visibility choice in Administration > Users (Print BOM by location),
then there will be a new report called ‘Bill Of Materials By Location’ (Order Processing > Orders > Print BOM by Location).

Multi Location

The process of making the stock control in Blindata ‘multi location’ has been started.
Stage 1 involves storing the correct stock location against stock transactions.

Import From Excel > Stock Group Locations

There is a new import routine called ‘Stock Group Location’.
This spreadsheet contains fields for stock code, group location and stock location.
The records will import to the table FabricStockLocation.

There is a global parameter called ‘Enable Stock Location by Transaction’, which defaults to false.
If it is set to true, then the stock location is held against the stock transaction.

If ‘Enable Stock Location by Transaction’ = true, then there is a new field in the user record called ‘Default Group Location’.

Also if this parameter is true, there is a new tab in the stock record called ‘Stock Location’.
There are two fields in this tab, ‘Group Location’ and ‘Stock Location’.

This means that it will have to be entered at PO delivery but the default location is pulled from the ‘Stock Location’ tab, depending on the ‘Group Location’ that is set up for that user.
The user will then have the option of amending the stock location.

When a blind becomes WIP or is manufactured, it selects the stock location from the ‘Stock Location’ tab according to the user.

The stock in hand values for the multi-location can be checked by right-click on the stock item:

Currently, we only have one stock in hand figure, which is held against the stock record.
But we can calculate the stock in hand for the group location by doing a query on the stock transactions that exist, by group location.

If the parameter ‘Enable Stock Transaction By Location’ is switched on, then there is a new report called ‘Bill Of Materials By Location’.
This is the same as ‘Bill Of Material’ except there are columns for ‘Stock code’, ‘Stock Description’, ‘Unit Of Measure’, ‘Quantity’, Stock at A’, ‘Stock at B’, ‘stock In Hand’ (where A is the first group stock location and B is the second group stock location.

The stock in hand for each item will be the sum of the quantities of the stock group location of the stock transactions.
This could lead to some discrepancies, but in theory, the sum of the stock transactions (+receipts – issues) should be equal to the stock in hand.
The total for a stock for A + B should in theory equal the stock in hand figure.

There is a button for this report on the ‘Order Amend Enquiry’ called ‘BOM By Location’.
It is a Button Visibility choice in Administration > Users.

Administration > Maintenance

If the multi-warehouse location functionality is going to be used, it is now possible to populate the existing stock transactions with a 'Group Stock Location'.
There is a new Maintenance option called 'Update Group Stock Location In Stock Transactions'.
If selected, the user can select a 'Group Stock Location' from a lookup and then all stock transactions that have a blank in the 'Group Stock Location' will be filled with the selection made.

Stock Control > Stock Transaction Entry

If 'Enable Stock Location By Transaction' is switched on and 'Enable Factory Stock' is switched off, we still need to be able to move stock from one group stock location to another.
If 'Batch Number' is switched on for the item, then the 'Batch' field is also enabled.
Here you also can make a relocation between 'Group Stock Location' values.

If ‘Enable Stock Location by Transaction’ = true, there is a function to transfer stock from one 'Group Stock Location' to another.
An issue date will be entered which will also fill the receipt date with the same date.
There is a choice to enter 'From Group Stock Location' and 'To Group Stock Location'.

When 'OK And Next' is selected, two stock transactions are created, one 'Issue' from the 'From' location and another to the 'To' location.

Stock Control > Reports > Stock Valuation

If a specific 'Group Stock Location' is selected, the report still showed the overall figure in the Warehouse Stock In Hand.
It now only shows the total for the warehouse (group stock location) specified.
If a 'Group Stock Location' is specified in the criteria, it is printed in the header of the report.

Stock Control > Stock Take Entry

If 'Enable Stock Location By Transaction' is switched on, it is now possible to enter the 'Group Stock Location' in the Stock Take Entry form.
The 'Group Stock Location' has been added to column K when a stock take entry 'Import' is done.

Purchase Order Enquiry > Generate Regular PO

If 'Enable Stock Location By Transaction' is switched on, at the moment the 'Group Stock Location' is taken from the User record and saved against the stock transactions.
We should consider the possibility that someone might want to enter regular POs for a different 'Group Stock Location'.
Therefore there is now a 'Group Stock Location' held in the PO header.
This defaults to the 'Group Stock Location' for the user, but it is now possible to change it and it then is saved against the PO.
This 'Group Stock Location' is now used when PO transactions are saved.

It is now possible to amend the ‘Group Stock Location’ field in the stock transaction if there is permission.
Therefore, there is a new advanced permission for a user called 'Amend Stock Trans Group Location' which defaults to false.

Order Processing > Orders > Component Detail Line Entry

If 'Enable Stock Location By Transaction' is true in Parameters, when entering a component detail line, it is now possible to see the stock in hand by 'Group Stock Location' as well as the overall total stock in hand.

And when the sales order status changed to 'Order Manufactured', the 'Stock In Hand' qty decreased by BOM quantity.