Manage Currency Exchange Rate by Child Table Date

Hello community, is possible to change the exchange rate base on a child table info. Basically creating a from an to date with the actual exchange rate between days, so the parent doctype exchange rate field gets automatically updated. See image below, what custom scrip could it be used? Many Thanks in advance

You could possibly write frappe.db.sql(“”“update table1 set rate = …”“”) on save to update the parent doc type table with the latest rate.

Hi @Randy_Lowery,

See this pull request Proposal: Updates to Currency Exchange DocType and Exchange Rate Determination by manqala · Pull Request #6287 · frappe/erpnext · GitHub for a way to handle without child table. A small bit of work left to do though (making sure all calls to get_exchange_rate are updated to include date as one of the arguments)

Regards,
cksgb