Prices based on batches

[Former Member]

02.09.2010

Hi friends,

We intend to use batch management. One of the requirement is that the prices should be based on the batches. eg. if price is changed on 1st September from Rs.10 to Rs.12 then all batches already in stock upto 31st August should be sold at Rs.10 and any new addition to the stock on or after 1st september should be sold at Rs.12. How can this be managed ?

Regards,

Uday

[Former Member]

Dear UDAYNATH KRISHNAN,

I handle this scenario with my last project

As other friend told you can add the batch field " CHARG " in the condition table with other required field and can generate the condition record but as you told to maintain the record is huge task i do agree.

We did small ABAP development to generate the condition record as per the batches that i can explain to you

But

In my case that was trading goods scenario ( no production )

So my case batch was generating at the time of Goods Receipt

So after doing MIGO transaction (in fact in migo transaction) you will find BADI where you can add coding and call the transaction VK11 and like a BDC pass the value e.g. Sales org, distribution channel , plat & batch number presnet in MIGO and create the condition record.

If in your case production is happening then you can find the similar logic like when the finish product with batch number is generating and the stock is moving to unrestricted use that time you can generate the Condition record through Abap development

Hope it will help you

Regards

Hanumant

Edited by: Hanumant Nimbalkar on Sep 2, 2010 4:29 PM

[jignesh_mehta3]

Hello Uday,

Add Batch in your Condition table & assign this Condition table in Access Sequence above the general Price Condition Table.

Subsequently maintain Condition Records for each of the old (before Sep 1) Batch & system will pick relevant price.

Hope this helps...

Thanks,

Jignesh mehta

[Former Member]

02.09.2010

Jignesh, thanks for the reply. But maintaining condition records for each of the batch would be a huge task. Is it possible to have the batch date (date on which the batch was created) as one of the fields in an access sequence. Please advise and if possible which would be the table and field

Regards

[bcrao]

Hi,

Already batch field -CHARG exists in pricing allowed list

Thanks

Chidambaram

[bcrao]

.