Bring report from 2 Erpnext system

1

is there any technical to bring data from 2 erpnext systems and generate one report
for example i want bring total sales from 2 erpnext .

2

Could be done with a script report

  • create a script report
  • use frappe client to connect to source sites and get report result
  • in your report execute, use the columns and aggregated data from above calls
    from frappe.frappeclient import FrappeClient

    client = FrappeClient(
        url="http://source1.site", username="Administrator", password="letmein"
    )
    out = client.get_api(
        "frappe.desk.query_report.run",
        params={"report_name": "Item Balance (Simple)", "filters": frappe._dict()},
    )
    columns = out["columns"]
    result = out["result"]
1 Like
3

how can i * use frappe client to connect to source sites and get report result ?