Bug 576 - Customer Balance Summary shows a doubled outstanding balance (17,780.60) for Nancy because INV0005 is counted twice
Summary: Customer Balance Summary shows a doubled outstanding balance (17,780.60) for ...
Status: OPEN
Alias: None
Product: Smartwas
Classification: Unclassified
Component: Reports (show other bugs)
Version: unspecified
Hardware: PC Windows
: --- High
Assignee: Arun (Arun)
URL:
Depends on:
Blocks:
 
Reported: 2026-10-15 12:20 UTC by Karunakaran (Karunakaran)
Modified: 2026-10-15 12:20 UTC (History)
0 users

See Also:
Associated Test Case ID:
Triaged By: ---
Root Cause Analysis (RCA):
Resolution Summary / Fix Details:
Impact Area:


Attachments
Customer Balance Summary shows a doubled outstanding balance (17,780.60) for Nancy because INV0005 is counted twice (168.64 KB, image/png)
2026-10-15 12:20 UTC, Karunakaran (Karunakaran)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Karunakaran (Karunakaran) 2026-10-15 12:20:14 UTC
Created attachment 417 [details]
Customer Balance Summary shows a doubled outstanding balance (17,780.60) for Nancy because INV0005 is counted twice

On Reports > Sales Report > Customer Report > Customer Balance Summary, Nancy’s row lists the same invoice twice (“INV0005, INV0005”) and shows an outstanding balance of 17,780.60. The INV0005 detail page shows a pending payment of only 8,506.3. The report total is roughly double the real pending amount, so the invoice appears to be counted once per payment record instead of once per invoice.