With all due respect RenjolynC, you and AlexV do not understand the requirement and purpose of the requested fix.  What is being proposed with the "Customer Balance Detail" report isn't relevant nor comes anywhere close to meeting the requirement.   Please do more research on the need and avoid trying to propose a solution.   A solution does not exist short of fixing the issue.  Don't take my firmness incorrectly, and I appreciate you're good intention of trying to offer some solution, but you are way way way off the mark.  This is Intuit's issue, not yours.   I am being firm because there are hundreds of these requests over many years accompanied by milk toast Intuit responses and with apparently no real interest on Intuit's part to fix a very specific and apparently simple issue (as reference MHS365's response in this thread hacking a table join).  The data exists, Intuit just will not make a simple report that presents it in a useful way.