Bug 576

Summary: Customer Balance Summary shows a doubled outstanding balance (17,780.60) for Nancy because INV0005 is counted twice
Product: Smartwas Reporter: Karunakaran (Karunakaran)
Component: ReportsAssignee: Arun (Arun)
Status: OPEN ---    
Severity: High    
Priority: ---    
Version: unspecified   
Hardware: PC   
OS: Windows   
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

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.