Stock Take Entry¶
This form is on the 'Stock Control' menu, called ‘Stock Take Entry’.
This function allows the quick entry of actual stock levels against stock items.
It is important to have correct stock values to operate the sales orders (Bill Of Materials) and purchase orders.
Please check the Bill Of Materials section for more details.
The first example is when the company only has 1 production place which is a storage and a place where it makes blinds, which we would call - 'Warehouse', according to Blindata it is when the 'Enable Factory Stock' flag is turned off in the 'Parameters'.
So it means that all products are located only in 1 place, which means that in order to make a revision (Stock Control) we would probably need to pause the manufacturing process, in order to calculate the stocks.
In this case, it is important to avoid stock movement until the 'Stock Control' process is finished.
And the second example is when you have 2 production places - 1 storage (Warehouse) and another place where you manufacture blinds (Factory), in this case, you probably move products from 'Warehouse' to 'Factory' from time to time.
So you would have 2 stock numbers ('Stock In Hand' and 'Factory Stock In Hand') the 'Enable Factory Stock' flag is turned on in the 'Parameters'.
In this case, it is easy to calculate the stock since you don't need to pause the manufacturing process.
It means that you can calculate the 'Warehouse' ('Stock In Hand' value) without interruptions in production since you have stocks needed for production in Factory (Factory Stock In Hand)
Stock Take Entry and Factory Stock
A stock quantity can be entered (which will be the stock take figure), the difference between the stock quantity and stock take figure will be calculated and a stock take adjustment figure will be created which will be the difference between the two figures.
Please note that 'Stock Take Entry’ can be imported by XLS file.
The actual example of the spreadsheet is located in the 'Blindata > Help > Help > Imported Files > Sample Import Files > Blindata Import Master Spreadsheet.xls.
Please see the example below:
Select an import file and run the routine:
There are options to be able to import either warehouse stock or factory stock or both.
Previously it was only possible to import both.
There are two flags in this form, called ‘Import Warehouse Stock’ and ‘Import Factory Stock’, which both default to true.
‘Import Factory Stock’ only displays if factory stock is switched on in Parameters.
There is functionality to make the quantity of all non-counted items ‘0’.
Previously if the stock take records were imported, only the records that were imported updated the relevant ‘Stock In Hand’ figures in the records.
There are two flags, called ‘Zeroise Stock in Hand’ and (if ‘Use Factory Stock’ = true) ‘Zeroise Factory Stock In Hand’.
If these are set to true, then the relevant stock record fields are zeroized before the import is done.
Check the 'Stock Item > Stock Trasnaction' tab:
Purchase Ordering
During the 'Stock Take Entry' process, it is important to update the stock item > cost price to the actual supplier price.
This can be done via the 'Administration > Import From Excel > Stock Item > Unit Costs' routine and the file below:
More details about the 'Unit Costs' tab are here.
In case you are using the purchase ordering function, it is also a good idea to update the reorder level, minimum order quantity, and 'Purchase Order Generation' flag via the 'Import from Excel > Stock Update' routine.
More details about regular purchase ordering are here.