Sale of Assembled Materials

[former_member573802]

We have something called "Cluster" item.

Three to four stock materials (components) are assembled together and sold as a "CLUSTER" item. These stock materials have a material number. The CLUSTER item also has a material number.

Price control for stock materials is V and for Cluster item it is S. We maintain a BOM for CLUSTER item. The stock materials are the components.

CLUSTER items do not have production orders and currently we are not costing them. Stock materials are trading items and they are also sold independently.

Issue

When we sell the CLUSTER item, since the CLUSTER ITEM has no cost, the cost of goods sold for Stock materials is getting debited. Whereas Sales revenue is getting booked to the CLUSTER ITEM.

Billing Doc

The item 300 is the CLUSTER item the other items following that are the Components

Cost of Goods Sold

The cost is getting recorded for the components. It is the Quantity in the invoice multiplied by the Moving average price at the time of sale.

Sales

Requirement

We want the cost of goods sold to get booked to the CLUSTER item and NOT to the Component material.

Please advise.

Raj.

[former_member573802]

Dear Lakshmipathi

Thanks for your solution. It appears this just might work and you have pointed me in the right direction.

However, the note says "free of charge" subitem.

When the sub-item is sold along with the Cluster material (header material) it is "free of charge". The cost of sub-items should roll up as the cost of the "Cluster item"

However, these sub-items are also sold independently in which case it is not a "free of charge" item. The cost and the sales revenues should be booked to the sub-item.

Will it work?

Best wishes

Raj.

[Lakshmipathi]

You need to take the inputs from OSS note 65908 and go for customization. This is also under the assumption that you ticked the check box in VTFL for "Cumulate Cost" for your CLUSTER item category but still not working.