In any warehouse environment, accurate stock is key to minimising picking discrepancies and ensuring the Pick, Pack and Dispatch process is as efficient as it possible can be.
All stock movements on the 3EX.NET system are recorded and can therefore be enquired upon. This allows your warehouse team to have a clear and detailed view of all stock on the system.
The Product Stock Enquiry is accesible via the menu system. This enquiry can also be embedded into the Transaction Line Entry (as it is on the Stock Adjustment entries) or can be accessed via a toolbar option on all Sales Order Processing and Purchase Order Processing entry systems.
Once a Product is entered, the Data Grid automatically shows the current stock holding for the selected product, along with a breakdown of the location at which the stock resides. The Product Stock Enquiry also encapsulates the standard Product Data Panel, ensuring the user has all the information they could need about the product they are equiring upon.
As stock for a product is increased, either by way of receipting purchase order or by stock adjustments a stock record is created, which records the date at which the stock was received. As stock is reduced, either by way of a Sales Order being dispatched or by a Stock Adjustment, the system will find the earliest positive stock record and use the cost against this record to calculate the profitability of the Sales Transaction. 3EX.NET uses FIFO costing.
The data grid in the screenshot below shows three rows, representing the fact that three deliveries have been received for the selected product. On each of the rows the cost for the product is slightly different. You may also notice that an Uplifted Cost has also been applied. Uplifts allow for additional charges such as Freight and Duty to be applied to the product.
The second screenshot shows the affect of selling 12 items. You will see that the first and oldest row now has a Remaining Quantity of zero, and the next line has a remaining quantity of 18.
The Stock Movement Enquiry, simply shows the physical stock movements for a particular product during a certain time frame. This enquiry can be particularly useful when trying to track down the cause of stock discrepancies as it will show all the locations at which the stock has been.