Skip to Content

System should pick price from precceding order not from Price FX

Dear Experts,


System should pick price from preceding order not from Price FX for this can you please suggest any logic.

We have created an order on 1/03/2020 in which price got determined from price FX lets say ZPR0 condition value value is 99 rs.
Next day changes were done in price fx for the above order customer let us say price changed from 99 to 100 .
Now invoice created on 02/03/2020 for the order which was created on 01/03/2020 now invoice picking the latest price FX price
100 Rs here invoice ZPr0 condition value is differing from its preceding sales order value .

Could you please suggest me any standard user exit .

Add a comment
10|10000 characters needed characters exceeded

  • kumar kumar, please follow up on your open question.

    • comment answers or your question if there are still open issues.
    • otherwise mark an answer as accepted if it helped you solve your problem
    • or post an answer of yourself and accept it if you found another useful solution yourself
    • or redirect your question to another question that is related and was useful to solve your problem
    • in the end, close your question

Related questions

4 Answers

  • Posted on Feb 03 at 02:22 PM

    I am not sure you picked the right example to describe your problem, since the invoice should have the same pricing date as the order, even though it was created a day later, therefore it should also pick the condition from the day before.

    But in case you do have the requirement to keep condition records 1:1 from the order to the invoice (or any other document you copied from and to), there might be examples that I can think of where you would need something like this. For instance with freight costs based on the total value (or weight) of the order, and not all items were able to be delivered in full, but you still dont want to change the freight cost between order and invoice.

    In this case you will have to setup the customizing with Trx. VTFA accordingly for your source sales document and target billing type. For all necessary items you can set "Pricing Type" (e.g. 'D' - Copy pricing elements unchanged), "Pricing Exchange Rate Type" (e.g. 'A' - Copy from Sales Order) as well as "Price Source" (e.g. ' ' - Order). You can also define a copy routine to and implement any solution necessary that is not covered by the customizing options.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Michael,

      Thanks for your time

      We are creating invoice with reference to delivery not with order in copy control of VTFL price source blank that means copy it from order but system taking price from price fx not from order

  • Posted on Feb 04 at 05:31 AM

    What value is set against Pricing Type? This will decide whether system to fetch sale order price or condition record. In standard, this would be G in which case, system would fetch the price from sale order to billing. If it is set to B, then, system would consider condition record depending upon the validity of the condition record

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 06 at 12:30 PM


    Maintain the pricing type as "G" in Copy control. In this case, except tax all the condition types will be copied from the Sales Order. Except tax if it is required to have any other condition type to be redetermined at the time of creation of Billing document, maintain "Condition category" as "L" against the Condition type in V/06.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 06 at 02:51 PM


    Apart from checking the Copy Control records as mentioned above, check for the interface implemented in your Company with Pricefx.

    I understand Pricefx is the SAP independent solution for Pricing, Rebates, Bonus, etc. There is generally an interface between SAP and Pricefx to update Price in SAP. Please check how the Interface between Pricefx and SAP is defined and also note how the changes in Price in Pricefx effects the Documents.


    Add a comment
    10|10000 characters needed characters exceeded

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.