web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Running average cost always used, even when marking is already in place

(0) ShareShare
ReportReport
Posted on by 2

Hi all,

I am looking into setting up a system where the purchase price is immediately used for the sales order delivery note voucher and subsequent sales order invoice voucher so that GSNI and COS are updated correctly.

In the example I am creating a sales order with one line (stocked service) of quantity 1 for sales price of 1,500. Then creating a Direct Delivery Purchase order from the Sales order and giving the Purchase order line a unit price of 1,000. Double checking I can confirm the marking is as expected already in place between the two order lines.

So I post the product receipt which auto-delivers the sales order lines (due to being direct delivery) but the sales order delivery note voucher is seemingly using last cost price of the item and not the purchase price from the marked line... this is not what I am expecting based on the following excerpt from the documentation.

pastedimage1640085009761v1.png

Found here: FIFO with physical value and marking - Supply Chain Management | Dynamics 365 | Microsoft Docs

Where could I be going wrong?

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,714 Super User 2025 Season 2 on at

    Hi Chris,

    Have you enabled the option 'Use physical value' on the item model group? If this is not enabled, the cost for the purchase order will only considered at the moment when the invoice is posted.

  • cpironmo Profile Picture
    2 on at

    Hi Andre, many thanks for replying... the Use physical value isn't ticked as I wasn't bothered about the physical transactions being included in the running average cost calculation.. however even with this un-ticked.. the delivery note uses a cost price over the purchase price but even when I post the sales order invoice it is reversing the delivery note posting but then posting the invoice vouchers still with the cost price and not purchase price.. even though marking it all in place.

  • Suggested answer
    OsmanIstanbul Profile Picture
    2,818 on at

    Hi,

    Could you try to recalculate inventory and check results?

  • cpironmo Profile Picture
    2 on at

    Hi Andre.. I thought I'd try it anyway and it worked.. so this parameter isn't just about the recalculation process.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 412 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans