Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Trying to understand weighted avg by date calculation

Posted on by 30

I have provided a snip it of transactions from item details. I understand the W.A. calc when the PO is purchased and we have 9 more POs at $0 come in affecting the next two sales orders after to adjust out at $26 (260/10=26) 

But I don't understand the last two transactions and where 32.5 and 110.66 came from? 

pastedimage1626383139960v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trying to understand weighted avg by date calculation

    Good morning Cost accountant pdx,

    Many thanks for the screenprints.

    I believe the second one that you shared in your last reply is the important one as it shows a marking.

    Marking lines overrules what's done when running an inventory close / recalculation.

    Can you please continue investigating the voucher and the transaction related to this marking line?

    Best regards,

    Ludwig

  • RE: Trying to understand weighted avg by date calculation

    Question 1: The SO and PO are linked. However, the lot ID for the PO ( shown in pic 1) is different than what is showing for the SO shown in pic 2.

    pastedimage1626904035908v1.png

    pastedimage1626904102541v2.png

    Question 2:

    I can't understand where the 171.06 is coming from in the cost explorer. Nowhere on the PO states a $ amount and there is none listed on the item details. I don't know what calculation would've occurred from the inv recalculation that occurred bc nothing it coming out to the 171.06 based on past costs listed in the item details from above. The 16.06 shows as a vendor balance on the cost explorer. When I looked at settlements its showing up as an adjustment (shown below)

    pastedimage1626904869492v4.png

    Question 3: The item model group for this item is IM1 - Average costing

    pastedimage1626904958728v5.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trying to understand weighted avg by date calculation

    Hi Cost accountant pdx,

    It might take a while until we find the underlying issue but let's continue here.

    Question 1:

    Is your sales order ending 932 linked to the purchase order?

    Can you please check the lot ids in the PO / SO lines?

    Question 2:

    Can you identify the prices that the cost explorer shows in your PO ending 147?

    What is the price of 155 and what are the 16.06?

    Has there some incorrect matching?

    Some typing errors?

    Question 3:

    Can you share the setup of the item model group for the item used in the PO?

    Best regards,

    Ludwig

  • RE: Trying to understand weighted avg by date calculation

    PO145147 is a zero dollar PO. We don't use AX dynamics 2012 we still use 2009. This is what I found in cost explorer for the two sales orders at the end that I could not understand the calculation for. It isn't giving me much though?

    pastedimage1626480077039v3.png

    pastedimage1626479996496v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trying to understand weighted avg by date calculation

    Hi,

    On 8 April there was an inventory close / recalculation that might have an impact on those prices.

    Also, what is the purchase price in the PO 145147?

    Have you tried using the cost explorer that you can find in AX2012 for the item?

    This explorer should give you some insights and explanations where those prices originate from.

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans