How to fetch a field from a doctype to custom field on child table of another doctype

ERPNext Customize ERPNext
1

i am trying to fetch expiry date from Batch master to sales invoice child table custom field expiry date.
can any body point in right direction. thanks

2
  1. Create a link field in your child table, linking to Batch (name this field Batch).
  2. Make sure the field type of expiry date in the child table is date type
  3. In the child table, edit the expiry date field, enter the following in the fetch from section:
    batch.expiry_date
    Make the expiry date field in the child table as read only.
1 Like
3

@Vesper_Solutions

2021-02-19_LI
2021-02-19_LI960×419 55.3 KB

2021-02-19%20(1)
2021-02-19%20(1)1920×885 34.4 KB

its not working … did i miss something

4

Are you selecting the batch in the batch linked field?
Also check the name of the expiry date field in the batch. The names of the expiry date fields should prefferably match

5

@Vesper_Solutions yes after selection of the batch the expiry date doesn’t update. the field name from batch master is correct.

6

The batch field in the child table is batch_no. So in the fetch from section you should write batch_no.expiry_date. Whenever fetching data from the link field, the format is this:
field_a (the name of the link field)
field_b (the name of the field in the linked document)

field_a.field_b

2 Likes
7

works like charm… thank you so much …:heartbeat: