Quick Start: Inventory Audit Report
In the course of business, you often times need to figure out how your inventory is moving. The Inventory Audit Report will provide you this information; it will show you where the item was moved to or received from as well as the document that cause that movement.
Step-by-step guide
- Go to Inventory->Inventory Reports->Inventory Audit Report
- In this new window, you can select your search parameters
- You can choose to search by date or item range, as well as system or posting date
- You can also search by item group and warehouse
- You have an option to display it by the item or G/L account in the Display section
- Lastly, you can group by warehouse, choose to display items/account without transactions and hide them if they have no cumulative quantity
The report will show you when the item was posted, what document affect that movement, the quantity affected and the cost associated with it, as well as a lot of other information.
Note:
- The Abbreviation Types will tell you what the 2-letter abbreviations for the document refers to
- Alternatively, if you only want the report for one item, you can run the inventory audit report from the item master data
