Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

(0) ShareShare
ReportReport
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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 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,272 Super User 2024 Season 1 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 74,036 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans