Announcements
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
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?
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
Thank you for your response.
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156