How can i fetch a single value from child table of one doctype to another doctype.
I have a link field for " Shipping rule " doctype in Sales Order and i have created Custom field called " Shipping Cost".
My requirement is once i select the shipping rule the shipping cost should be fetched automatically. ( Below is the Sales Order Form)
But in " Shipping Rule " Doctype i don’t have “Shipping cost” or any other Amount field to use “add_fetch” to get it.
Instead we have " Shipping Rule Condition " Table which contains the field i required. ( Below is the "Shipping Rule " form fields)
Below is the “Shipping Rule Condition” Table. And the field i want fetch is “Shipping Amount”.