Inventory Cost Review CDV

Inventory & Purchasing

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