Type: Custom Data View
Data View: Inventory Cost Review
Public: Yes
Reports Included: Yes
Description: List of invoices, sales, credits, and inventory/serialized adjustments with items containing costs that vary from the daily average cost.
Drill Down: Yes, opens transaction type
Columns and data for the Inventory Cost Review Custom Data View are outlined below:
| Column Name | Form | Field | Notes |
| Tran Date | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Date | |
| Tran Number | Transaction | Number | |
| Tran Type | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Type located in Title Bar | |
| Tran Date | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Date | |
| Tran Number | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Number | |
| Item Name | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Associated Item Name/Number | |
| Item Type | Item | Associated Item Type | |
| Tran Qty | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Associated Transaction Item Quantity | |
| Tran Cost | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Associated Transaction Cost/Unit Price | |
| AvgCost | Item Register | Calculated Field | The reported average cost for the item as of the transaction date |
| Cost Match? | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Calculated Field | Analysis of whether the transaction cost matches the item register reported average cost |
| Cost Difference | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Calculated Field | AvgCost minus Tran Cost |
| Expected Total Cost | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Calculated Field | AvgCost times Tran Qty |
| Tran Total Cost | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Calculated Field | Tran Cost times Tran Qty |
| Value Difference | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Calculated Field | (AvgCost times Tran Qty) minus (Tran Cost times Tran Qty) |
| Recommended Action | ****** | Proposed resolution to correction the difference calculated | |
| Item User Created | Item | Item Security Label | |
| Item Date Created | Item | Item Security Label | |
| Item User Revised | Item | Item Security Label | |
| Item Date Revised | Item | Item Security Label | |
| Tran User Created | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Transaction Security Label | |
| Tran Date Created | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Transaction Security Label | |
| Tran User Revised | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Transaction Security Label | |
| Tran Date Revised | Invoice/Sale/Credit/
Inventory Adjustment/ Serialized Adjustment |
Transaction Security Label | |
| TranID | Work Order | Table ID of Transaction | |
| ItemID | Item | Table ID of Item Employee |
