How to update specific field base in reference value of the field

ERPNext
1

Hello Guys,

Is there anyone who can figure out or any idea’s to update the field with the same DocNo value from Sales Order, to Identify the Sales Order have a ReferenceNo for Sales Invoicing. I don’t know if the Bulk Update can do this.

ERPNext Version 12.10.1

Please see the image below

image
image596×854 15.7 KB

2

Is that a report? What are you showing exactly?

3

Is not Sir, that image showing:
from the upper part image with “Sales Order” caption is current Sales Order records in ERPNext and the lower part of the image with “Data to update via import” caption is received from our client every month for Invoice generation.

From the current Sales Order Records we need to update the ReferenceNo field (which is current no value) base on the DocNo received from our client every month which is the lower part of the image with “Data to update via import” caption.

I dont know if custom script is needed or can do this on Import Data update, any Idea will appreciated.

Thanks

4

Is there anyone have an idea to accomplishe this?

Thanks