Price difference for moving average

(0) Share

Report

Posted on by SU-22040800-0

2,459

I have an item setup as Moving average.

When i match the invoice (with a variance on the invoice) it was posting to " Price difference for moving average". Now this morning, it is posting to the stock cost account "Cost of purchased materials invoiced"

What have i done to break this?

I have the same question (0)

All responses (8)

Answers (3)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello James,

Did you post the same item with the same price and configuration?

Has there been another variance to the moving average or have you just posted the item with the current moving average cost price?

Do you know if somebody made changes to your item / posting setup?

Best regards,

Ludwig

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

Hi Ludwig

It is very possible that someone might have changed something. Just to confirm my steps:

I create a brand new item, with Moving Average item model group.

I create a PO for the new items: 3 @ 100 = 300

I receive the items

I open the invoice screen, and change the new amount from 300 to 333

I open matching details, and approve the variance

I post the invoice

The variance (33) should post to "Price difference for moving average" ..?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Right, that's what I would expect.

Do you have the database log enabled for your products?

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

I'm not sure. Can you guide me?

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

Like (1)

Report

Hi James,

I do think there is a difference if the goods were already taken out of the inventory or not. If the PO was receipt and an invoice is posted thereafter without deduction, it will correct the moving average price according to the invoice. In that case, it will take Cost of purchased materials.

When the goods or part of it has been deducted, then it will use the price difference.

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi James,

There is no posting to 'Price difference for moving average' if inventory still exists in the system. Moving average and other valuation methods like (FIFO/Wgt Avg) just work same when it's the first receipt of the product.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good Morning James,

I think the following white paper will help you as it includes a couple of illustrative examples:

www.microsoft.com/.../details.aspx

More information can be found on the MS docs site here:

docs.microsoft.com/.../about-moving-average

Best regards,

Ludwig

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

I feel like I've managed to work around this, by creating a Charge that I add at invoice time (for the variance amount).

I force the charge to post to a variance account.

Thanks for all the input!

Was this reply helpful? Yes No