COPA reporting for scheme products

[former_member221515]

Hi

I have following requirement in COPA wrt scheme prodcuts.

My scenario:

My client is trader in External Hard disks, cell phones and memory card.

They have following scheme for their customer:

Customer will get 1 memory card free on purchase of 10 external hard disks

Customer will get 2 memory cards free on purchase of 10 cell phones

Customer will get 5 memory cards free on purchase of 10 cell phones and 5 External hard disk.

Now we show this free item in bill as Sale price (Rs.250) - Discount 100% (Rs.250).

My SD and FI entries are running fine.

But wrt COPA, at present, cost of these memory card is shown in memory card itself. It implies wrong picture.

Ideally, the cost of memory card should be deducted (on basis of number of items purchased) from cost of external disk / cell phones since it given free on these products.

Please help me how to achieve this. Do i need to use from substitution rule or something.

Please help

[ajaycwa1981]

Hi Deepak

Why on earth would you deduct the cost of memory card from cost of phones and hard disk??

You are selling hard disks worth 100 and giving memory card worth 10 for free.. So, your Total cost of this transaction is 110... Why you want 100-10 = 90?

System is abs right in accounting the cost of memory card into COGS...

Imagine like this - you are selling Hard disk as well as Memory card... however, you are billing only the Hard disk

So, revenue will be accounted for Hard disks alone and COGS for both HD + MC

btw, can you help us in getting these items for cheap (Phones + HD + MC)

br, Ajay M

[former_member221515]

ya,

It should be added to cost of original items (like hard disk and cell phone). So how to achieve this?.

At present when i see COPA report of hardisk, it shows cost of original items only. So i want to add cost of memory cards to original items. (In this case it should be Rs.110).

So how to achieve this in COPA

[ajaycwa1981]

Hi,

nothing in this world can give you this.... Thats not the right way of doing this

br, Ajay M

[Former Member]

Hi Deepak,

As explained, It can be achieved through defining a separate statistical condition type especially created for COPA reporting and not for pricing and use addition field in sale order line item as characteristics to include the cost of memory card in the cost of hard disk/Phones.

Thanks,

Manoj

[Former Member]

Hi,

I believe you mean the cost of memory card should be added/included (on basis of number of items purchased) in the cost of external disk / cell phones since it given free on these products.

If you are using costing based COPA then you need to define a separate statistical condition type for FOC item and should use one of the addition field in Sale order line time as characteristics to fetch this item in COPA.

If you are using accounting based COPA then you can map with separate account key since these cost will flow with the GL account in this case.

Thanks,

manoj