Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Standard Cost Changes - Impact on existing Purchase Orders

Posted on by 10

We utilize Standard Costing in NAV 2017, and just entered a new fiscal year, so many Standard Costs were updated.

Our Finance team has instructed us to "refresh" open Purchase Orders so that the new Standard is picked up in those documents. They claim that without this "refresh", price variances will be calculated in error once invoices are posted to those POs, since the PO line still contains the old Standard Cost value.  As with many NAV screens, there is a "Refresh" button in the PO document, but I do not believe it is designed to pull new Standard Cost values from the Item Card.

I also know Production Orders have a "Refresh Production Orders" command, which is designed to perform a re-calculation. I am not aware of any similar functionality in Purchase Orders.

So my questions are:

1. Is it necessary to "refresh" the standard cost value attached to the PO line when changing standards, or does NAV handle that in the background?

2. When variances are calculated, is NAV comparing to the Standard Cost present at the PO line level, or is it referring back to the value in the Item Card?

3. If this "refresh" is necessary, does NAV offer any tools to simplify the process? The only method we've come up with so far, is to change values in  one of the fields on the PO line to force it to update.  However, with thousands of PO lines to manage, this simply isn't practical.

Would appreciate whatever suggestions/ideas you have used or tried in your NAV travels.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Standard Cost Changes - Impact on existing Purchase Orders

    Hi,

    No problem, hopefully this item in our Docs gives you the answer you need:

    docs.microsoft.com/.../finance-how-to-update-standard-costs

    Otherwise, you need to ask your partner for direct assistance.

    Thank you.

  • Switzman Profile Picture
    Switzman 10 on at
    RE: Standard Cost Changes - Impact on existing Purchase Orders

    Hi Marco - apologies for not replying sooner. Thanks for providing the link.  I did a preliminary review of the topics and did not find any obvious answers to our issue. What we are trying to understand, is when the Standard Cost field is updated in the Item Card, whether an additional step is required to pull the new value into open documents (such as Purchase Orders). Thanks again for taking the time to respond.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Standard Cost Changes - Impact on existing Purchase Orders

    Hello,

    Are you looking for information like this:

    docs.microsoft.com/.../finance-learn-about-costing

    Thank you.

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans