Skip to Content

Sale of Assembled Materials

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.

1.jpg (44.4 kB)
2.jpg (57.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 22 at 06:45 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 22 at 03:48 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded