2,401
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 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!
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
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.
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.
I'm not sure. Can you guide me?
Right, that's what I would expect.
Do you have the database log enabled for your products?
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" ..?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (