Reply: 3

Auto translated

Verification/determination of average price Material

Hello,

In the summer, we used the average price of a material for a calculation. Now more invoices have been received, so the average price has logically changed. That is also okay. But now I have to prove the average price that was used for the calculation.

This raises the following questions:

What is the best way to provide proof?

Which period is used for the calculation?

How can I easily check whether the value is correct?

Thank you in advance for your help.

VG

You must be logged in to post a reply.

Login now

3 Answers

  • BETA
    ChatBot
    Automated answer
    This reply was automagically generated by our Espressi A.I. Think of it as a one-off attempt to instantly solve your problem. It will not respond to further replies.

    Hello, to prove the average price of a material in SAP for a certain period and check if the value is correct, you can consider the following steps: 1. Determining the relevant period: First, you should clarify which period was relevant for the original calculation. This is important because the average price may change depending on the bookings entered in this period. 2. Using SAP transactions for price analysis: - MB51 - Material voucher list: Here you can check all material movements for a specific period. This allows you to see all incoming and outgoing movements that could affect the average price. - MR51 - Material Accounting Line Items: This transaction shows the line items for material accounting, which can be helpful to see details of each posting. - CKM3 - Material Price Analysis: This transaction is very useful to look at the development of the average price of a material over time. You can set the time period and retrieve the historical average prices. 3. Documentation and record keeping: - Create documentation that includes all relevant information from the SAP transactions. Calculate the average price based on the collected data to verify the value. 4. Check data consistency: - Ensure that all material movements have been recorded correctly and that there are no incorrect postings.

    • Compare the calculated average price with the average price displayed in SAP systems to identify differences immediately. 5. Communication and reporting: - Create a clear and understandable report documenting the average price as used for your previous calculation. This can be in the form of a table or chart showing the price changes over time - Explain in your report the purpose of providing evidence and the methodology of your calculation If you have completed these steps, you should be able to effectively demonstrate the average price used for the calculation and confirm its accuracy.

    Need more help from our chatbot? Click here and visit our AI SAP Helper on the SAP learning platform et.training.1

    1. log in with your Espresso Tutorials account. Digital subscription or trial access required.

  • User #39967
    User #39967

    Hello,

    Please take a look at the SAP standard report MBMAPCHANGES for the change analysis of the GLD.

    VG

  • User #32671
    User #32671 (Author)

    Hello,

    Many thanks for this. The evaluation is great for this.

    VG