Well, after looking around it looks like the Sales Reports -> Price Listing report is pretty close to what I need.
I like the GP% but would like to add an optional cost column.
But the Gross Profit is based upon the Material Cost (running average)
If I have some large cost changes (which I have, one Rare Earth Material I rely upon has increased 5x-6x in the last year)
I would like to reset the average material_cost (stock_master) to actual cost.
I am thinking of a simple module that clears all material_cost and recomputes material_cost based on foriegn item_codes
and manufacturing BOM's
I could then re-run the Price Listing and check the GP to see what prices need to be adjusted.
The nice part is the report can be loaded in excel if needed...
Now... (finally a question)
Will updating the material cost to actual cost have any serious negative impact from an accounting point of view?
(like violate any Accounting 101 concepts)
or is it maybe just a Good Idea?
ps. I also notice that last_cost is updated, but all of my actual_cost fields are 0, is that normal? Is actual_cost no longer used?
pps. actual_cost is only referenced in One place... read only... includes/ui/items_cart.inc the constructor for class line_item
Last edited by tom (07/09/2011 02:39:47 pm)