Skip to Content
avatar image
Former Member

Final Selling price based on Cost + Margin in Sales order

Dear All,

Please suggest on the below requirement

In Sales order Final selling price bases on Cost Price + Price Margin

1.Cost price is updated from Material Master

2. Price Margin =Fixed amount or Percentage base

Final selling Price= Cost Price + Price Margin

Pricing Procedure

In Sales order ,Condition value showing the total value of cost price + Price Margin

In Net value field the final selling value is not displayed.

Regards,

H V Kumar

1.jpg (79.2 kB)
11.jpg (73.6 kB)
3.jpg (51.3 kB)
4.jpg (85.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Nov 15, 2017 at 07:24 AM

    In the sale order, the moving price is showing in yellow icon. Did you check the Analysis screen from condition tab?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 15, 2017 at 09:05 AM

    Hi Lakshmipathi ji,

    Done the config changes as updated

    Now we have maintained only one cost condition type(ZCOS-Standard or Moving price) and maintained as statistical in pricing procedure

    Condition Category is G for cost condition type -ZCOS

    Standard cost from Material Master

    Sales order ,item condition screen still not displaying the Final net value and only showing Price Margin value

    Regards,

    H V Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 15, 2017 at 01:17 PM

    Hi Lakshmipathi ji,

    As updated...

    1.Changed the Condition class to A for ZCOS-cost condition type

    ZMAR -Margin condition type with Condition class- B

    When SO is created ,cost condition type in still inactive

    2. In other case ZCOS -condition type to B

    ZMAR- Price Margin Condition class to A

    When created new SO, Cost condition type in now active

    How to fetch the Final selling value in Net value field

    Regards,

    H V Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 08:14 AM

    While I am not sure what condition category you set for this ZCOS, I am also not sure why two condition types are being used for costs (one is standard EK01 and other one is customized). Normally, system would fetch the cost only if it is set to statistical in pricing procedure which is missing in your case. Also, if your pricing procedure have two condition types for cost and both are set to "G" against condition category, with the standard, system will not work as you expected. You need to go for modification as recommended in OSS note 15462

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 10:13 AM

    Try to create a new sale order and update. Configuration changes will not work for existing documents.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Lakshmipathi ji,

      Created new order still same issue

      Cost price condition type showing inactive because of subsequent price

      Regards,

      H V Kumar

      6.jpg (77.9 kB)
      7.jpg (44.5 kB)
  • Nov 15, 2017 at 12:38 PM

    Change the Condition Class to "A" from "B" and again create a new order. You cannot have two condition types with the same condition class "B"

    Add comment
    10|10000 characters needed characters exceeded