Skip to main content
Solved

Planned Purchase Cost and part step pricing

M
Sidekick (Customer)
Forum|alt.badge.img+5

Hi, 
We are interested in using the planned purchase cost in cost set 5.

It works good for entities that don’t have Part Step Pricing in their Supplier agreements or Supplier for Purchase part Price lists. We are on  ifs10

I have understood that when calculating planned purchase cost in this cost set, system will use purchase pricing logic, similar to when you enter a purchase order line for a part no.

I also read in another tread that when calculating the planned purchase cost in Costing system will use:

  • the standard lot size as order qty
  • the effectivity date as price date. 

For some reason we do not get this to work when using price breaks, even if we have the standard lot size on the inventory part.

Any one that have any input that could help us? 


Regards,

Marika

 

Best answer by Thushitha Chandrasiri

​
Hi @Marika Solgård-Olli  ,

 

If you have supplier agreement price and part step prices, then, the priority goes to them when calculating the Planned Purchase Costs. The first priority goes to part step prices actually.

For an example, if the Std Lot Size of the purchase part in the Planning Data tab in Inventory Part record, is 5, then the system first look at the relevant supplier agreement’s part step prices. If there are lines with Min Order Qty less than or equal to 5 (std lot size), it takes the price of the maximum of them (if there are lines with Min Order Qty of 2, 3 and 5, it takes the price of the line with 5) for the cost calculation.

If there are not any lines with Min Order Qty less than or equal to std lot size (in the above case, if all are with greater than 5), the system takes the price of the agreement line if it is not zero.

If it is also zero, the system takes the estimated material cost of the cost set 5 (either it is zero or not).

Hope this help ?
Thank you and Best Regards

View original
Marika
    Did this topic help you find an answer to your question?
    This topic has been closed for comments

    Thushitha Chandrasiri
    Superhero (Partner)
    Forum|alt.badge.img+21

    Hi @Marika Solgård-Olli ,

    The system looks for the correct purchase price list line with effective date and the standard lot size as below.

    looks for a line which have Min Qty equals to the Standard Lot size and effective date in between Valid From and Valid To Dates

    If any price list line does not match, system takes the Purchase Price from the Supplier for Purchase Part General tab.

    If it is also zero, it takes the value from the estimated material cost set cost value from part cost details tab or inventory part cost tab based on the setting when calculating cost

    Thank you and Best Regards

    Thushitha

    Thushitha Chandrasiri - Follow my LinkedIn profile and contact me via - https://www.linkedin.com/in/thushitha-a-chandrasiri-32a2b2134/
    M
    Sidekick (Customer)
    Forum|alt.badge.img+5

    Hi,

    Thanks for the solution! Got it to work now as you said for Supplier for purchase part price lists but still not for the agreement prices. Any idea what could be the reason? On agreement part tab we have zero as price and then behind RMB are the part step prices.

     

    Thanks & Regards,

    Marika

    Marika
    Thushitha Chandrasiri
    Superhero (Partner)
    Forum|alt.badge.img+21

    ​
    Hi @Marika Solgård-Olli  ,

     

    If you have supplier agreement price and part step prices, then, the priority goes to them when calculating the Planned Purchase Costs. The first priority goes to part step prices actually.

    For an example, if the Std Lot Size of the purchase part in the Planning Data tab in Inventory Part record, is 5, then the system first look at the relevant supplier agreement’s part step prices. If there are lines with Min Order Qty less than or equal to 5 (std lot size), it takes the price of the maximum of them (if there are lines with Min Order Qty of 2, 3 and 5, it takes the price of the line with 5) for the cost calculation.

    If there are not any lines with Min Order Qty less than or equal to std lot size (in the above case, if all are with greater than 5), the system takes the price of the agreement line if it is not zero.

    If it is also zero, the system takes the estimated material cost of the cost set 5 (either it is zero or not).

    Hope this help ?
    Thank you and Best Regards

    Thushitha Chandrasiri - Follow my LinkedIn profile and contact me via - https://www.linkedin.com/in/thushitha-a-chandrasiri-32a2b2134/
    M
    1 person likes this
    • M
      Marika Solgård-Olli
    M
    Sidekick (Customer)
    Forum|alt.badge.img+5

    Hi,

    Thanks, this helped for sure. Now I also got it working for supplier agreements in local currency, but it does not give the price for agreements that are in foreign currency. Any idea why so? Could it be some mistake we have made in some setups?


    Regards,
    Marika

    Marika
    Thushitha Chandrasiri
    Superhero (Partner)
    Forum|alt.badge.img+21

    Hi @Marika Solgård-Olli ,

    Happy to see it is working now for supplier agreements. It should work for foreign currencies also. But, when calculated in Part Cost screen, the cost figures shows in the local currency (converted to local currency).

    Did you not getting the values correct when converted into local currency ?

     

    Thushitha Chandrasiri - Follow my LinkedIn profile and contact me via - https://www.linkedin.com/in/thushitha-a-chandrasiri-32a2b2134/
    M
    Sidekick (Customer)
    Forum|alt.badge.img+5

    Hi,

    After further testing, we found the issue that caused the problem. We did not have the same currency on supplier for purchase part as on on supplier agreement. When correcting this it worked. 

    Thank you for the good inputs that brought us in right direction to find the solution.

    Regards,
    Marika

    Marika
    Thushitha Chandrasiri
    Superhero (Partner)
    Forum|alt.badge.img+21
    Marika Solgård-Olli wrote:

    Hi,

    After further testing, we found the issue that caused the problem. We did not have the same currency on supplier for purchase part as on on supplier agreement. When correcting this it worked. 

    Thank you for the good inputs that brought us in right direction to find the solution.

    Regards,
    Marika

    No problem.. Happy to see it is resolved. 😊

    Thushitha Chandrasiri - Follow my LinkedIn profile and contact me via - https://www.linkedin.com/in/thushitha-a-chandrasiri-32a2b2134/
    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings