Skip to Content
0
Former Member
Dec 30, 2009 at 12:25 AM

CALCULATE COST FOR ITEM

15 Views

how do i calculate the cost of an item on a report

in my database i have boms. master and components. and regular items not bom

the regular items have a reorder cost, avgcost,. the master item does not have any of those. how do i calculate in a report to sum the avgcost of the components for the master item. if there is no avgcost then sum the reorder cost.

example

itemcode -itemtype


reorder cost
avgcost
--


need report to show

item A---- regular item


25.00
24.00
--


24.00

item AB-- master


0.00
0.00
--


220.00

item AB1 component(regular item) -129.00--


125.00--


125.00

item AB2 component(regular item) -100.00--


95.00--


95.00

item AC-- master


0.00
0.00
--


250.00

item AC1 component(regular item) -150.00--


0.00--


150.00

item AC2 component(regular item) -100.00--


0.00--


100.00

PLEASE HELP.