Calculating Profit per Sale when using Sub Assemblies

[gcamp]

Hi, I've had a good look around the website and can't find anyone asking a similar question, I hope you can help!

We are using Sage 50 Accounts Professional 2011 Version 17.0.15.208.

How do I get Sage to realise that the cost of a product is the sum of the costs of the items in the Bill of Materials?

We would like to calculate profit by customer, I have used the Invoice Profit Report - By Customer. However, this doesn't give me useful information because the costs come out as 0.

This is because we almost never sell standard stock items which we buy in and then don't change/assemble; Instead, we buy for example 3 goods, A, B and C and assemble them to make a fourth good D.

If A, B and C each cost £1, we should be able to see that D costs £3. However I don't know how to make Sage understand this. We make D (the sub assembly) and use the "transfer in" button on the Products tab before we allocate and send the goods out.

How do I get sage to acknowledge that D has a value of £3? Or to rephrase, how do I get Sage to realise that the cost of a product is the sum of the costs of the items in the Bill of Materials?

Thanks for your help!

[brucedenney]

I suspect that the problem is with the original cost fo the goods used to make the product.

Sage adds together the costs of the items on the BOM to determine the cost of the items when the transfer is made.

I suspect that the cost of the component items are all 0.00 if the assembled item has a value of 0.00

Sage uses the cost price of goods transaction and the cost price off the stock record depending on the type of item.