HomeGenie Collections Dashboard

Pulls Payment Entry collections from the HomeGenie site and the ERP site side by side for the same window, so the two ledgers can be checked against each other.

From date

To date

HomeGenie total

—

no data yet

ERP total

—

no data yet

HomeGenie + ERP total

—

run a query to compare

home.homegeniegroup.in

HomeGenie — Payment Entry wise

home_homegenie_payment

Subtotal—

Sr No	Payment entry	Posting date	Sales person / CRO	Customer	Quotation	Paid amount
Set a date range and run the reconciliation.

erp.homegeniegroup.in

ERP — User-wise collection

erp_homegenie_payment

Subtotal—

Sr No	User	Opportunity collection	Field owner 1 collection	Field owner 2 collection	Total collection
Set a date range and run the reconciliation.

Note on the date filter: the HomeGenie endpoint reads from_date/to_date from the request and works correctly here. The ERP endpoint's server script currently has the range hardcoded (from_date = "2026-01-01", to_date = "2026-01-31") and ignores the query parameters it's sent — until that script is updated to read frappe.form_dict.get("from_date") the same way the HomeGenie one does, the ERP panel will keep returning January 2026 data regardless of the dates chosen above.

Note on cross-origin access: both APIs are called directly from this page's browser session. If your Frappe sites don't send CORS-allow headers for this origin, the browser will block the response and the panel will show a fetch error — in that case the calls need to be proxied through a backend you control, or CORS enabled on the Frappe side for the domain hosting this dashboard.