Stock List
Overview:
Stock Items are utilised throughout Workbench as the backbone of the Stock system. An Item is a piece of Stock, an Item must exist to manage a piece of Stock, and all necessary parts of Stock Setup must be completed. It is necessary to issue and value stock on an ongoing basis.
This screen can be accessed through both the Stock list and Stock Setup list.
Screen Guide:
List Screen
The initial list shows all existing Stock Items and details. New items can be created using the + New Item button. Additionally there is an Import to create multiple Items at once by importing all the data from a file.Â
Using the + button on the left side of each row drops down subtotals for each Stock Location that contains the stock item.
There are several links available to see detailed information:
The Code field links to the item maintenance where you can adjust details of the item itself.
The Quantity on Order field links to Stock Transactions screen and pre-populates the filter for the details of the line clicked on, showing only Purchase Orders. The list is Period based, same as Stock Transactions screen (as opposed to being Transaction Date based).
Quantity on Hand links to Stock Transactions as well but shows all other transaction types for the line clicked on. The list is Period based, same as Stock Transactions screen (as opposed to being Transaction Date based). This is always the balance recorded at the last stock close out (not necessarily the current Period), plus any subsequent transactions.
Stock Item Maintenance/Creation
Â
Updating Stock items values and quantities in bulk
To update the current Stock items rate and quantities by Location, you can use an export and import utility that will export the complete list of Items per Location for the latest Closed Stock period. Then use the same list to import the updated values.
Pre-requisite: There must be a previous Stock Close out.
Export utility: Stock By Period Export
Import: Stock By Period Reinitialisation
This will allow you to work with a complete list, an item per Stock location, review and update any Cost Rates or quantities as needed, and then import the same file. Both use the same file format.
The import will populate the values that will be used as the starting point for the new Stock period that is about to start (table StockByPeriod).
Example for Period Average method:
Period 2024/8 - Aug 2024 was Closed.
Period 2024/8 values and quantity per location will be exported so you can update/manipulate as needed (utility: Stock By Period Export)
Period 2024/8 can be imported using Stock By Period Reinitialisation. This will overwrite existing values in Period 2024/8 StockByPeriod table.
These new values will be used as the starting point when calculating the Average Rate Cost when Stock transactions are entered in Period 2024/9. And will also be used to populate the StockLocations average rate as part of this import. The rate in StockLocations table, which is the rate you see in the UI for each item, is updated by the utility wbUpdateAllStockCosts which is part of the import as well.
Optional step:
Manually run utility wbRepriceTransactions to recost unexported Stock issues in case any have been created for the new period.
Notes:
This import is designed to overwrite the last closed stock period, to get the right initialisation values.
The user must define what Year/Period this will be overwriting, which must be the last processed period.
The import executes the utility wbUpdateAllStockCosts to update all Average/Last stock values on ALL items. Standard method doesn’t require this step.
Â
Next Steps:
Stock Issues can be used to request and issue stock items.
Purchasing Stock in units different to the Stock Item unit. This can be managed from the Purchase Catalogue, using the Stock Multiplier column.
FAQs:
Filter by label
There are no items with the selected labels at this time.
Process Flow: