Issue in getting complete General Ledger Report & applying filter

ERPNext
1

I am trying to fetch General Ledger information using api.

I am running following query to fetch information in total:

domain_name/api/method/frappe.desk.query_report.run?report_name=General Ledger&filters=[[“company”,“Company Name Pvt Ltd”],[“from_date”,“10-12-2022”],[“to_date”,“11-01-2023”],[“group_by”,“Group by Voucher (Consolidated)”]]

Issue: I am not getting same output as displayed on ERP portal

I am running following query to fetch information for specific customer:

[[“company”,“Company Name Pvt Ltd”],[“from_date”,“10-12-2022”],[“to_date”,“11-01-2023”],[“party_type”,“customer”],[“group_by”,“Group by Voucher (Consolidated)”],[“party”,“ALLIED STRIPS LIMITED”]]

Issue: I am getting error – “exception”: “json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)”

[[“company”,“Company Name Pvt Ltd”],[“from_date”,“10-12-2022”],[“to_date”,“11-01-2023”],[“party_type”,“customer”],[“group_by”,“Group by Voucher (Consolidated)”],[“customer”,“ALLIED STRIPS LIMITED”]]

Issue: I am not getting same output as displayed on ERP portal

I am running following query to fetch information for specific supplier:

[[“company”,“Company Name Pvt Ltd”],[“from_date”,“10-12-2022”],[“to_date”,“11-01-2023”],[“party_type”,“supplier”],[“group_by”,“Group by Voucher (Consolidated)”],["party ",“BANSAL STEEL UDYOG”]]

Issue: I am getting error – “exception”: “json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)”

[[“company”,“Company Name Pvt Ltd”],[“from_date”,“10-12-2022”],[“to_date”,“11-01-2023”],[“party_type”,“supplier”],[“group_by”,“Group by Voucher (Consolidated)”],[“supplier”,“BANSAL STEEL UDYOG”]]

Issue: I am not getting same output as displayed on ERP portal

Sometime it even gives error in from_date & to_date even both dates are valid

2

Looking for urget help. I am stuck with this issue for past 15 days now.