Inventory Control
Leave a Comment
The Inventory module is the heart of the Distribution Suite where all your Stock Control, Replenishment and Product structure flows to the rest of the system through the strong built-in ledger interfaces. In summary, it provides the following features: Stock Replenishment Stock Take Multi-Warehouse Bin/Shelf Tracking Serial/Batch/Dual Tracking Stock Transfers Inventory Costing Bar Coding/Label production […]
Read more »
The use of ‘Colours’ in the system is optional and can be enabled/disabled via the Product Format function. In fact the very term ‘Colour’ is configurable within Online Advantage via the same Product Format definition tool. If ‘Colour’ is disabled in your system then there should be no need to create or maintain a list of them […]
Purpose The ‘Product Currency Prices’ function is used to specify prices for a Product in a foreign currency in Sales Order Entry. In order for the price to be picked up from this ‘Product Currency Prices’ list instead of the normal ‘local currency’ price list, you must enable the System Options so that Sales Order Entry will […]
This Stock Analysis report is requested interactively from the menu when a user requires it. Purpose This report attempts to list all the Inventory items selected ranked by the “Line Demand”. Line Demand is not an “Order Quantity” related measure. It is not Stock Usage or Stock Demand. Line Demand is essentially how many times […]
Purpose This procedure is used to upload and update Standard Prices from a file created outside of the system. This is an alternative way of adjusting prices to the standard system functions for changing and editing items. Using this method a “spread-sheet” style tool can be used to adjust a list of products you want […]
Purpose This function is used to enter or adjust the details of product ‘Brands’ set up within the system. A ‘Brand’ can be allocated to a Product to ‘tag’ it for reporting purposes. Product Brands can also have an image uploaded against them and this image is used in the Ecommerce portal to help customers recognise product by […]
End of Day Inventory Control Pricing
This End Of Day (EOD) report is produced during Inventory EOD processing. It shows products where the replacement cost has changed out of the bounds of the Cost Variation % defined in System Options. For example, if you set the Cost Variation percentage to 8%, this report will include products where the replacement cost has […]
This End Of Day (EOD) report is produced during the Inventory EOD processing. It shows products where the standard cost has changed out of the bounds of the Cost Variation % defined in System Options. For example, if you set the Cost Variation percentage to 8%, this report will include products where the standard cost […]
End of Day Inventory Control
This End Of Day (EOD) report is produced during Stock EOD. It shows the stock transactions posted since the previous EOD run that were entered via Stock Value Adjustments. Can I Exclude It? No. This report provides an audit trail of stock transactions so should not be excluded. Can I Reproduce It? No. This report […]
This End Of Day (EOD) report is produced during Stock EOD. It shows the stock transactions posted since the previous EOD run that have caused an Auto Value Adjustment to be created. Can I Exclude It? No. This report provides an audit trail of stock transactions so should not be excluded. Can I Reproduce It? […]
This End Of Day (EOD) report is produced during the Inventory EOD. It shows the stock transactions posted since the previous EOD run that were entered as Manual Issues or Manual Receipts. Can I Exclude It? No. This report provides an audit trail of stock transactions so should not be excluded. Can I Reproduce It? […]
Frequently Asked Questions Inventory Control Order Management Point Of Sale Purchasing
From an OA perspective, the system is typically sitting and waiting for the input of a bar code at a “normal” prompt like any other text prompt, without any filtering. OA only does “something” once it receives an “end character”. The end-character is typically a suffix setting on the bar code reader. Usually a “tab” […]
Purpose This procedure is used to create a Manual Stock Transfer transaction between two Stock Locations by selecting the products to transfer using selection filters. It is designed to work on a large number of inventory items and is more efficient when compared to manually entering each product to be transferred. This function is particularly […]
Online Advantage contains a ‘Stock Take’ module that is designed to help you manage the process of comparing your physical stock holdings to the perpetual quantities recorded in the Inventory system. The module allows you to create a stock take for a whole stock location, or for selected inventory items i.e. fast moving, spare parts, […]
Purpose This function is used to record the physical ‘Stock Take counts’ on the items on a stock take run. This information is recorded by hand by the ‘counters’ on the stock take tally sheets/tickets produced for the stock take run. Before entry of stock counts can take place, all outstanding processing must be completed to […]
Purpose This function is used to enter the stock take ticket numbers that have not been used during counting. This allows you to record what tickets have not been used for a given stock take run. Note that the entry of unused tickets can be done with ticket ranges based on the item numbers on […]
Purpose This function is used to finalise a stock take. It will automatically adjust your stock on hand for any variances between the stock counted and the freeze quantity (“Stock Take” on hand figure). This adjustment is critical to the accuracy of the Inventory system to keep the Perpetual Inventory system in-line with the actual […]
Purpose This function is used to create (initiate) a stock take ‘run’. Each ‘run’ is a list of inventory items that you want to perform a stock take on at the same time, so it is basically a ‘batch’ of items to count. The main purpose of this function is the selection of the inventory […]
Purpose This function is used to ‘Freeze Stock’ on an existing Stock Take Run. The ‘”freeze” process records the current Inventory ‘Stock On-Hand Quantity’ as the ‘Freeze Quantity’ of each item on the stock take run. Stock should be frozen for a run before count quantities are entered unless you have control of what warehouse […]
Purpose This function is used to enter the physical stock count of an inventory item at any time. It is the quickest way to correct an item’s stock on hand quantity. It will bring the perpetual stock on hand into line with the physical quantity. This function is designed to be used as and when […]
Purpose This procedure is used to cancel a stock take run – use it carefully as once a run is submitted for cancellation there is no facility to reverse the changes made. The routine will ask you to specify which stock take run you wish to cancel. Only runs that have not yet been finalised […]
Purpose This function can be used to manually enter the details of ‘Stock Receipts’ that have occurred in a given Stock Location. Once a receipt is completed using this facility the items appear in the inventory for the receiving stock location via ‘Manual Stock Receipts (MSR)’ transactions, and the value of the inventory being received […]
Purpose This function can be used to manually enter the details of ‘Stock Issues’ that have occurred in given Stock Locations. Once an issue is completed using this facility, the items are moved out of the inventory from the issuing stock location via a ‘Manual Stock Issue (MSI)’ transaction, and the value of the inventory being […]
Purpose Use this function at any time during the day to generate Stock Transfer Orders based on the current inventory levels held in the system. This function allows you to generate transfer orders in the same way as the overnight (End-Of-Day) replenishment functionality except that this procedure can be run at any time during the day, any number […]