Show/Hide Toolbars

DBA Help

Navigation: Screen Help (F1) > Inventory

Inventory Data Views

Scroll Prev Top Next More

(Inventory – Data Views)

Menu_Inventory_DataViews

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:

Screen_Help   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:  

All Fields
Basic Item List by Item Category
Basic Item Listing
Items by Default Supplier
Reorder Levels
Menu_Inventory_DataView_StockItemList

 

Stock On Hand  

This data view focuses on stock quantities, inventory costs, and locations:  Standard layouts include:  

All Fields
Qty by Location
Item by Location
Qty by Item Category
Menu_Inventory_DataView_StockonHand

 

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
All Fields
Characteristics by Item Category
Qty by Location
Menu_Inventory_DataView_StockonHand_lotserial

 

Inventory Transaction Detail

This data view enables you to track inventory transactions and includes the following standard layouts:

By Item
All Fields
By Reference
By Transaction Type

Inventory Transactions Lot/Serial

This data view enables you to track inventory transactions by lot and serial numbers.  Standard layouts include:  

By Item
All Fields
By Reference
By Transaction Type
Menu_Inventory_DataViews_InventoryTrxnsDetail

 

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:  

By Supplier
All Fields
By DBA Item D
By Manufacturer
Menu_Inventory_DataViews_ItemSources