Type: Custom Data View
Reports Included: No
Description: Listing of all serialized and inventory parts that have an item bin entered in the item setup. If no bin information is entered, the item will not appear in this CDV. This is by design.
Drill Down: Yes, opens the item
Columns and data for the Inventory By Warehouse Bin Custom Data View are outlined below:
Column Name | Form | Field | Notes |
Warehouse | Item Bins | Warehouse | |
Item Name | Item | Name/Number | |
Item Type | Item | Type | |
Bin | Item Bins | Bin | |
Location | Item Bins | Location | |
Max | Item Bins | Max | |
Min | Item Bins | Min | |
Quantity | Item | Calculated Field | Difference of the quantity purchased (increases) and quantity sold (decreases) for all time for the item |
Cost | Item | Estimated Cost | |
AvgCost | Item | Calculated Field | Last average cost for the item increase |
LastCost | Item | Calculated Field | Last recorded purchase cost for the item |
Reorder? | Item | Calculated Field | Will appear as Yes when the Quantity column is less than the Min column |
Qty to Reorder | Item | Calculated Field | Difference of the Max and Quantity columns. |
Description | Item | Purchase Description | |
Sales Description | Item | Sales Description | |
Retail | Item | Retail Price | |
List | Item | List Price | |
Item Category | Item | Item Category | |
Category Display | Item | ******* | Associated Category Display Name |
Preferred Vendor | Item | Preferred Vendor | |
Generated Date | CDV | Query Field | Date CDV was created |
Generated Time | CDV | Query Field | Time CDV was created |
ItemID | Item | Table ID of Item | |
WarehouseID | Item Bins | Table ID of Warehouse | |
VendorID | Item | Table ID of Preferred Vendor | |
CategoryID | Item | Table ID of Item Category |