I just printed off a full set of financial reports for the previous quarter (ending March 31st, 2018). Both the Vendor and Customer Balance reports incorrectly show a zero zero balance at the end of quarter - basically, empty reports - suggesting that all customer and vendor accounts were settled by March 31st - they weren't.
Payables and Receivables Aging Summaries appear to be correct (i.e. they showed the correct open amounts as a function of time).
The generated Vendor Balance Reports explicitly states: "Vendor Balances As of Mar 31, 2018", which in my case means they should NOT be returning a zero balance, as there are known balances for specific vendors on March 31st. Same for the Customer Balance Report.
I think I am right in saying that the only way the Vendor/Customer Balance reports could show a zero balance on my accounts is if they are including transactions on the dates after the requested report "as of" date - all of the vendor and customer accounts were settled between the report "as of" date and the date when the report was generated. I have not tested extensively, but this seems to be what is happening.
I am looking for solution or workaround for this, as these reports are a basic and necessary part of documenting the closing state of a past financial period.
Thanks in advance.