Under Sales Order Preferences>Sales Profitability Settings there is the option “Cost Calculation Basis for Non-Stock Kits” which we have set to ‘Non-Stock Kit Standard Cost Plus Stock Component Cost’ The documentation seems really clear about it’s functionality:
Cost Calculation Basis for Non-Stock Kits The cost the system should use for non-stock kits in sales profitability reports. Select one of the following options:
- Stock Component Cost: The system uses the sum of the costs of the kit’s stock components.
- Non-Stock Kit Standard Cost: The system uses the standard current cost of the non-stock kit.
- Non-Stock Kit Standard Cost Plus Stock Component Cost: The system calculates the sum of the standard current cost of a non-stock kit and the costs of the stock components of this kit.
The costs of stock components of a non-stock kit are updated on release of the inventory issue generated for the Sales Orders invoice with this non-stock kit. For more information, see Inventory Item Kits.
However, every Sales Profitability Report we run has the cost of our kits as $0. I’ve triple checked that the Inventory Issue created from the Invoice has been released. This makes reporting on profitability really difficult as most of our Sales Order items have margins of 100% or 0%. The possible thing I can think of why it is not working is the standard cost of our kits is currently $0. Shouldn’t it still add the cost of the Stock components?
Anyway have any suggestions of experience with this?
Thanks