Trying to do up a Crystal report that will give the opening and closing balances for 4 GL accounts so that an employee (who I don't want to give Financial Reporter or GL access to) can run a report monthly to determine some tax payments. We are not using Sage Intelligence currently. ALso, some tax entries are made by journal entries, so tax reports have to be run out of the GL.
Is there an easier way than adding up all the previous period changes to the opening balance in GLAFS and creating a pile of formulas?
I was hoping to take fiscal year and period as a parameter and return the opening and closing balances for these 4 accounts.
Then they can run a Crystal transaction report that I have already created for the accounts, and use this report to check the opening and closing.