In this task you will update your P item estimated costs.
Task Notes:
In an earlier phase, you imported your Supplier Prices for your purchased items. In this task you will go to the BOM>Estimated Purchase Costs screen, Load all Items, and perform a Mass Replace by Default Supplier Price.
If you still have items that have zero estimated costs, you should enter default supplier prices for those items. Or if you do not have supplier pricing info available, you can import an estimated cost against the P item. .
Link:
Data Import Guide - Stock Items (Update)
NOTE: Confine the import to the Estimated Cost field.
DBA Key Concepts
PO Receipts costs establish inventory value
DBA is an average cost inventory system. Inventory value for your purchased items is established by PO Receipt values. Accurate supplier pricing information is therefore essential to maintaining accurate inventory value and cost of goods sold in DBA.
Setup a Default Supplier and purchase price for all purchased Items
You should set up a default supplier and price for all items that you purchase in DBA. At system setup you can import all of your Item suppliers via Data Import - Item Suppliers. On an ongoing basis, when you add a new purchased item you should always define a default supplier and purchase price
Ongoing price maintenance - Verify purchase prices when you send out POs
In MRP, when POs are suggested for an item, it will pull in the pricing for the default supplier. You should verify your prices when send out your POs. The act of verifying your prices in MRP will automatically keep your default supplier price records up to date and improve your inventory value accuracy.
Regularly update your estimated costs for P items based on your default supplier price
On a weekly basis or after any changes to your default purchase prices, you should go to the BOM - Estimated Purchase Cost screen and perform a Mass Update to update your estimated costs based on your Default Supplier Prices.
Perform a BOM Cost Rollup after updating Estimated Purchased Item Costs
After you have updated your estimated costs for your purchased items, you must run a BOM > Cost Rollup to update all of your estimated costs for your manufactured items.
