Accounts Receivable Report Showing Double Total for Particular Customer

Dear Frappe Team,

We are facing a technical issue in the Accounts Receivable Report in ERPNext Version 15.

For one particular site, the correct outstanding receivable balance is SAR 202,811.38.

The individual transaction/balance is correct, but the report total is showing SAR 405,622.76, which is exactly twice the actual amount.

Expected Total: SAR 202,811.38
Displayed Total: SAR 405,622.76

The issue appears only in the report total calculation for this customer. We have verified the underlying accounting entries and could not find any duplicate transaction causing this amount.

Therefore, this appears to be a technical issue in the Accounts Receivable report calculation/display.

Kindly investigate the issue and advise us on the required fix.

Screenshots and report details are attached for reference.

Also attach the screenshot showing the 202,811.38 customer balance and the 405,622.76 total.

image

Hi @Saif1 and welcome to the community

Try to remove the “Add Total Row” as per this discussion and it might work

Hope it helps