Bulk Update Prices on POs

Prepare your file by making a copy of the linked template.

Fill out the columns accordingly.

Delete the headers of the columns, download as a CSV file and save it to your NAV session.

Go to Departments > Utilities > Tasks and then locate "Update Purch. Line Unit Cost"

Navigate to your upload file and select it.

IMPORTANT Once it has loaded, NAV might open an Excel file which will outline the reason each PO line failed to be updated. 

1. • If this happens, resolve the affected PO lines manually and remove the lines from your upload file.

   • You can then re-upload your file and there should be no further issues.

You should check that the POs have been changed via lookup.