Customer Statements not working for a specific customer

Hi all,

We are going through the process of upgrading Epicor to 10.2.600, and we’ve started by upgrading Test and going through a testing process. One of the issues that came up was that the Customer Statement (which we have amended to only show open invoices) is coming up blank for a specific customer. It seems to be working for other customers I have trialed it with. I also discovered that a similar issue seems to exist in Live/Production (I copied the report across from live so that’s unsurprising) - while this customer doesn’t have any open invoices in Live, for other customers the report just doesn’t generate if none available, whereas for this one it generates a blank report with our company address and logo at the top.

So to recap, for this specific customer:

in upgraded Test, the customer has open invoices but the report is previewing blank except for our company info at the top. Other customers are doing what is expected: previewing the correct info if open invoices available, report not generating if none available
in old version of Live, the customer has no open invoices but is still generating a blank report. Other customers behaving as above.

Something to note about this customer is that it’s an Inter-Company customer, and I did try unchecking that option in Company maintenance in case that might fix it, but it did not.

Has anyone run into something similar or have any ideas for potential solutions please?

Found the issue - in the report query expression had this set to only generate report when TotalBalance >0, but cutomer in question balance was negative. Changed to <> 0 and hey presto!