Finance | Project Operations, Human Resources, ...

Trying to understand weighted avg by date calculation

(0) Share

Report

Posted on by Cost accountant pdx

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?

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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
Cost accountant pdx 30 on at

Like (0)

Report

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.

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)

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

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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
Cost accountant pdx 30 on at

Like (0)

Report

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?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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