Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Calculate Item Cost funcionality

(0) ShareShare
ReportReport
Posted on by 15

Does anybody knows if is possible to Calculate Item Cost (standard cost) based on active trade agreements prices for a purchased item? Our customer´s request is to consider the trade agreements prices of an item instead of the last purchase price for the new standard cost. 

With this parameters we get a new pending standard cost based on the last purchase price but is not what we need: 

pastedimage1636046384617v1.png

Thank you 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Calculate Item Cost funcionality

    Hi Sorana,

    The problem that I see from that is that you want to have a vendor specific 'standard cost price'.

    In my opinion that is not a standard cost price if you have a price of $1 for item X if it is purchased from vendor A and $1.5 for item X if it is purchased from vendor B.

    That is my understanding from what you mentioned.

    If my understanding is correct then I don't see the necessity of using standard costs.

    Best regards,

    Ludwig

  • Sorana Profile Picture
    15 on at
    RE: Calculate Item Cost funcionality

    Hi Ludwig,

    Thank you for your answer.

    Our client needs to update the standard cost each semester and the request is: "it should consider the price that the next order would go through at".

    For example. From 01/07/2021 to 31/12/2021 the standard cost is 1 EUR. Last purchase price is 0.8 EUR and they renew the prices with one of the vendors to 1.1 EUR from 01.01.2022. They ask to calculate a new standard cost for the first semester of 2022 of 1.1 EUR.

    How do you think about this business process?

    Thank you in advance

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Calculate Item Cost funcionality

    Hi,

    If I get you right then you want to have cost prices that consider the trade agreements that you have with your vendors. Is that right?

    Why would you need that?

    Wouldn't you get simply other trade agreement prices?

    I don't understand the reasoning behind.

    Would be great if you could elaborate.

    Many thanks,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,983 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans