Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

Posted on by 5

Good Afternoon,

I have been assigned to assist my sister companies purchasing team clean up their invoices, and I found that the NAV system is reverting back PO price updates back to the last receipt price. Is there a way in NAV to keep that from happening? A lot of the POs placed have engineering changes that require the team to update pricing through out the process. Having the system revert pricing back causes a lot of extra work, and potential invoice issues.

Any help is much appreciated.

Thanks,

Chad

Categories:
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

    It sounds like they maybe should evaluate their costing method.

    Are they using the same item for purchasing things that are really different items?

    If that is the case then they should maybe look at their process. Maybe the use of variants or serial numbers could help them?

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,217 Moderator on at
    RE: Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

    hi

    when a purchase receipt is posted, it updates the item ledger entry with the new cost. When a purchase invoice is posted, it updates the item ledger entry with the new invoice price. However, if a purchase receipt is posted after a purchase invoice is posted, it will update the item ledger entry with the new cost from the receipt, which may result in the purchase invoice price being overridden.

    To prevent NAV from updating the purchase invoice price with the last receipt price, you can try the following steps:

    Go to the "Purchase & Payables Setup" page in NAV.

    Click on the "General" tab.

    Under "Purchase Order," uncheck the box for "Allow Receipt of an Item before Purchase Invoice."

    Click "OK" to save the changes.

    By doing this, you are preventing NAV from automatically updating the item ledger entry with the last receipt price when a purchase invoice is posted. Instead, the purchase invoice price will be retained and will not be overwritten by any subsequent purchase receipts.

    Please note that this setting may impact other processes in the purchasing cycle, so it is recommended to test this in a non-production environment before implementing it in a live environment.

    DAniele

  • Chad Schug Profile Picture
    Chad Schug 5 on at
    RE: Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

    Thank you for your response.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 70,124 Super User 2024 Season 2 on at
    RE: Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

    Hi, as far as I know, there is no way to set the standard optimal price logic in NAV, and it must be customized to solve it.
    Hopefully other experts can give you better advice.

    Thanks

    ZHU

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,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans