(Inventory – Data Views)
The Data View utility is a reporting tool used throughout DBA that enables you to filter, sort, and group your data to create your own inquiries, spreadsheets, and reports. It organizes related data from multiple tables without requiring “joins” and other complicated programming techniques.
Link:
Data View Reporting tool
Inventory Data Views
Stock Item List
This data view focuses on item settings, such as item categories, default suppliers, and MRP settings. Standard layouts include:
| • | Basic Item List by Item Category |
| • | Items by Default Supplier |
Stock On Hand
This data view focuses on stock quantities, inventory costs, and locations: Standard layouts include:
Stock On Hand Lot/Serial
This data view helps you track lot and serial numbers within stock on hand. Standard layouts include;
| • | Characteristics by Item Category |
Inventory Transaction Detail
This data view enables you to track inventory transactions and includes the following standard layouts:
Inventory Transactions Lot/Serial
This data view enables you to track inventory transactions by lot and serial numbers. Standard layouts include:
Item Sources
This data view enables you to view item sources (Suppliers and Manufacturers). This data view can be used as the basis for data import for mass price changes for a supplier for a set of items. Standard layouts include:
