Fetch Item field in Sales Invoice

ERPNext
1

Hi,

I want to fetch ERP Number field from Item Doctype in the Sales Invoice Item table.

image

When the user selects Item from dropdown it should automatically populate with the ERP Number in the table.

image
image1130×404 15.2 KB

I have gone through a lot of docs regarding this requirement but not able to achieve it.

Can someone please explain the exact steps from start to end?

Thanks!

2

I would have done this:

Create a field on Sales Order Item and set ‘fetch from’ item.erp_number assuming erp_number is the name of the field (not title) and ‘item’ is the name of the field on the Sales Order Item which refers to the item table (Link).

Have you tried this?

1 Like
4

Hi Shreyansh,

Thanks for your response.

I cannot find ‘fetch from’ anywhere. I’m using Erpnext V9.

image
image1118×629 20.5 KB

5

Hi @erpnext_user99
Sorry, I forgot to reply earlier.
And also apologies - I have no idea about v9. When I said ‘fetch from’ I was implicitly referring to v12.