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

Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

(0) Share

Report

Posted on by Chad Schug

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

All responses (4)

Answers (0)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

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 9,272 Super User 2024 Season 1 on at

Like (0)

Report

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 5 on at

Like (0)

Report

RE: Updated Purchase Order Pricing Reverting Back To Last Receipt Pricing

Thank you for your response.
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

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