Bulk update Purchase item price

ERPNext Buying
1

Hello,

We have a use case where there are same items appear multiple times in the purchase order child table and the price is not fixed. Is there a way to bulk set/update the price as we have 1-2 products inserted in hundreds of item rows.

bulk-update-purchase price
bulk-update-purchase price1279×445 39.4 KB

Do we need to use client script like this one showed by NCP:

How to Quickly Update Item Prices in Frappe/ERPNext Using ListView Client Script

Thanks.

2

Hi,

You can use the script shared by NCP or alternatively you can use the upload/download functionality.

You can download the child table data in the csv file and in excel update the prices and save the file upload the updated file back using upload button and boom you have updated child table.

image
image926×332 39.1 KB

Thanks,

Divyesh Mangroliya