| | Unit Cost used in the Purchase Order, sales order, and Inventory modules |
| Resolution | For the Item Pricing Hierarchy, see Item Cost Hierarchy Vendor Price Levels (Highest Priority) - Open Accounts Payable, Main menu, Vendor Maintenance.
- Select or enter a vendor.
- Click More to access the drop-down menu.
- Select Items to open Vendor Receipt History.
- Click Pricing to access Vendor Price Level Maintenance.
- Click the Vendor Price List (flashlight icon) to open the Vendor Price List.
- Search for price level settings for the vendor that apply to a specific Product Line or Item Code.
- Review, edit, or delete entries as needed, including Quantity Breaks.
If Vendor Price Levels Aren’t Used Standard and Average Cost Items - Standard Valuation:
- Use Standard Cost from Inventory master file.
- If zero, use Last Cost.
- If zero, use Warehouse Average Cost.
- If zero, use Item Average Cost.
- Average Valuation:
- Use Warehouse Average Cost.
- If zero, use Item Average Cost.
- If zero, use Last Cost.
- If zero, use Standard Cost.
- LIFO/FIFO/Lot/Serial Cost Items
- Use Vendor Last Cost.
- If the cost is zero or no vendor assigned, use Item Last Cost.
- If zero, follow the hierarchy for the valuation method.
Auto Generate Orders Selection - When selecting Update Unit Cost With:
- Standard Default or Last Unit Cost: Primary vendor’s last cost
- Standard Unit Cost: Item’s standard cost
- Average Unit Cost: Item’s average cost
- If any cost is zero, follow a hierarchy based on the valuation method:
- Standard Valuation: Standard → Last → Warehouse Avg → Item Avg
- Average Valuation: Warehouse Avg → Item Avg → Last → Standard
- FIFO/LIFO/Lot/Serial: Vendor Last → Item Last → Standard → Warehouse Avg → Item Avg
More information - Sales Order Module: The system calculates cost during the Sales Journal update. If the standard cost is zero, the hierarchy applies.
- Inventory Module: Hierarchy determines cost in Inventory Transaction Entry.
- Inventory Requirements Planning: The system uses Vendor price level if none. Primary vendor’s last cost → item’s last cost → standard cost.
[BCB:155:Chat 100 US:ECB] |
|