Inventory Log Overview
Inventory Log is a bird’s-eye view of your warehouse and inventory movements.
- Inventory Log can be used to investigate inventory anomalies.
- Inventory Log can be used to sort and filter transactions.
You can narrow down records using the following filters:
- Date From – It will show records starting from the date selected.
- Date To – It will show records up to the date selected.
- Product Variant – It will show records of all the transactions with its specific product variant.
- Location – It will show records of all the transactions involving the warehouse.
- User – It will show records made by the specific user selected.
- Transaction – It will show all the records with the particular transaction such as Receive Order, Purchase Return, Delivery, Sales Return, Stock Adjustment, Stock Transfer, Assembly, Cash Invoice or All Transactions.
- Click Generate to fetch the results according to your filters. If all filters are blank, it will generate all inventory log, sorted by the most recent log.
Inventory Log Table Columns Definition:
- Date – The date and time the transaction was made.
- Product – The specific product transacted.
- Location – The source or storage place of the product transacted.
- Quantity – The number of stock that has been transacted.
- Unit Cost –The cost of buying or acquiring stocks.
- Beginning -> Ending Stock On Hand – The total quantity of the stock before and after the transaction occurred.
- Beginning -> Ending Inventory Cost –The inventory cost balance before and after the transaction occurred.
- Transaction – The transaction type e.g. Receive Order, Purchase Return, Delivery, etc.
- User – The one who made the transaction.
Export Inventory Log to PDF or Excel:
- In the Inventory Log Overview, click Export.
- There are two Export options: Export to PDF and Export to Excel. Click your desired format.
- Upon clicking Export to Excel, an excel sheet will be automatically downloaded to your computer.
Related Article: Beginning vs. Ending Inventory Cost