How to Set up Inventory Average Unit Price

This blog is deprecated - see this blog for more information.

Calem inventory includes global items and site inventory. 

• Items have unit prices which are intended as unit prices in work order miscellaneous cost calculation when an item is used as a miscellaneous line item in work orders. 
• Site Inventory has average unit price that is calculated based on inventory transactions as average moving cost. The average unit price is used in work order material cost calculation excepting asset, store-priced or lot-priced inventory items.

Step 1. Set up Item Unit Price

The item unit price can be directly edited in the item screen. 

The item can be a misc cost item in work order.

Step 2. Set up Average Unit Price by Site

The average price of site inventory cannot be directly edited. Instead, an inventory transaction is required to set the price. The average price is updated whenever an item is received from purchase orders.

The first option is to set up the average price by menu at site inventory.

The second option is to include average unit price in the site inventory excel file (see Step 4 of Site Inventory Upload).

The other option is to use bulk average unit price transaction to import average price from the Calem excel template file Inventory_Avg_Unit_Price.xls. Use the transaction menu below to import the average prices.

Step 3. Set up Average Unit Price by Store

The average price by store is available. See this blog to set it's price.

Additional resources

• When to Use Store-Based Pricing for Inventory
  
• Data Upload Part 1: Inventory Setup
• Inventory Training
• User Guide and Admin Guide (customer account required)
  
• Calem Enterprise Training Site
  
• Calem Enterprise Blogs
  
• Calem Enterprise demo