Hi Sandy24,

When you run the report, which data files are you selecting?

The report is calculating the beginning balance from the transactions with an accounting date before the From Date entered on the report. It's going to use the transactions from the files you selected. If you are including the New file, those are unposted transactions. If there is anything unposted with accounting dates before the From Date, that will create this problem.

Also, selecting multiple data files can cause some "file merging" problems that result in incorrect reporting. For this particular report, you should only be selecting Current file. You can run it on Current and History when you are running it for dates that includes data in the History file. The New file should not be selected.

Does this help?

April

Hi Sandy24,

When you run the report, which data files are you selecting?

The report is calculating the beginning balance from the transactions with an accounting date before the From Date entered on the report. It's going to use the transactions from the files you selected. If you are including the New file, those are unposted transactions. If there is anything unposted with accounting dates before the From Date, that will create this problem.

Also, selecting multiple data files can cause some "file merging" problems that result in incorrect reporting. For this particular report, you should only be selecting Current file. You can run it on Current and History when you are running it for dates that includes data in the History file. The New file should not be selected.

Does this help?

April

April,

I was running the report with current only, however your response did give me an idea.    When I run the report without adding any conditions the terminated leases are not there.   If I add a condition for rent payment then they show up.  Sounds like a glitch to me, unfortunately I need it with rent payment only.    Thank you for the help!

Sandy