Inventory Warehouse Transaction History
The Inventory Warehouse Transaction History form is opened from the Inventory Warehouse Stock form by clicking on the Transaction History button at the bottom of that form, from the Stock Detail button in the Bill Line Item Options form, or, from the Stock Detail button in the Stock Tab of the Warehouse form. This form will display every transaction that makes up the total stock for each warehouse. The Warehouse ID combo box field at the top of the form will default to 'All Warehouses', which will display the inventory details for all the warehouses. You can filter the list in this form by selecting a specific warehouse to view. The Item No field will display the selected product you are viewing.
This form can be confusing because of the way VisionCore needs to sell inventory based on the Costing Method for that item. The other confusing thing is since VisionCore allows you to unpost transactions it needs to keep track of what items were sold, or purchased, along with their exact costs. As an example you may purchase 5 of item 'abc' at 10.00 each and a week later 5 more of item 'abc' at 11.00 each giving you a total of 10 in stock. This form would display both of those transactions, which make up the 10 in stock. The tricky part comes in when you sell and buy more of these items at different costs and quantities. If you created an Invoice where you sold and shipped a total of 12, VisionCore would create three add lines in this form using the 5 previously purchased at 10.00 and the other 5 at 11.00 and then create a third line showing you sold 2 more without receiving any giving you a new total of -2 in stock. As you can see even though there was only one transaction line in the Invoice for selling the 12 items, this form displays 3 lines showing the breakdown of how the stock was sold and at what cost. When you purchase more lets say 20, VisionCore would then fill the -2 from the Invoice and display 18 in stock from the purchase.
Fields
The Date Posted field displays the date the inventory was received.
The Received field displays the total number of items that were received for the transaction at the selected warehouse.
The Sold field displays the total number of items that were sold for the transaction at the selected warehouse.
The Available field displays the total number of items that are available to sell for the transaction at the selected warehouse.
The Invoice Number field displays the original Invoice Number for the transaction.
The Type field displays the form type where the inventory was entered into.
The Warehouse ID field displays the Warehouse ID that the inventory was entered into.
The Last Cost field displays the Last Cost paid for the inventory item.
The Total Cost field displays the total cost or value of the inventory based on the quantity in stock (Available) times the Last Cost.
Toolbar Buttons
Toolbar Buttons perform an action on the current record like adding, deleting or saving.
The Transfer button will open the Inventory Transfer Detail form where you can transfer inventory from one warehouse to another.
Related Topics