Skip to Content
author's profile photo Former Member
Former Member

Same Batch Material to be sold at different selling prices


I have a customer requirement where a material at depot belonging to the same batch should be sold at different sales price.

Eg: on 1st of May, Material XYZ belonging to batch AB052011 of 100 qts was GR into the Depot at Rs 100 / qty. A selling Price PR00 will be maintained at Rs 100 / qty. On 5th of May, sales happen for 50 qts, hence PR00 condition of Rs 100 /Qty will be picked accordingly. Till this point everything is fine.

Price change happens for the material at the plant.

Again on 15th of May another GR for XYZ material of Batch AB052011 of 200 qts was GR'ed into the Depot at Rs 150 / qty now. Accordingly PR00 price was changed to Rs 150 /qty.

On 20th of May the total stock of Material XYZ belonging to Batch AB052011 is 250 qts. On 20th if sale happens for 250 qts, Customer requirement is pick a PR00 of Rs 100 for the 50 qts and PR00 of Rs 150 for the remaining qty.

We dont want to allow price to be changed manually, this should only happen through condition records. Is there any way by which I can create a condition table which allows me to maintain two different prices for the same batch at a given point of time.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 10, 2011 at 07:32 AM

    Hi Rajendra,


    Assuming that you are only talking about Batch Number based price (and not Batch characteristics based price) you can maintain price condition record based on Batch where Batch number will be one of the key criteria in your Access Sequence. So you many need to create a new Condition table with Material/Batch Number and insert it into your Pricing condition Access Sequence.

    Since you will not know what batch you deliver till the goods been issued, you may need to redetermine the Pricing procedure during the Billing. Based on the batch that is delivered system will redetermine the Price from Condition record maintained on Batch basis.


    If you are talking about Batch Characteristics based Price, you have more to do.

    Please check these forums links which might help you and also look at the OSS Note: 675409

    Good Luck 😊

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ajay for your response.

      The problem is I need to maintain two different prices for the same batch. At a given point of time for a particular batch number I can only maintain one price.

      I have the batch number as I am making this sale from the depot and not from the manufacturing plant.

      Neither will batch characteristic be of use, because when I make GR at the depot for the stock will be maintained only at batch level.

      My problem is the material with same batch can be taken into stock at different prices; accordingly the sales price is maintained for each GR stock that is taken in. At a given point of time there can be sale happening for the material at the depot for stock arriving from two different prices.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.