msanders67
Technical User
I am putting together a report that will pull data from MAS90 files. I need two years worth of GL account informations on the same report. The files I need to use are:
GL History&Budget
GL Account Master
GL Parameters
The files are linked from history&budget to account master by account number and from history&budget to parameters by fiscal year. Herein lies the problem. I need account balances from this fiscal year and last fiscal year. The history&budget files hold this data, but I need to get the current accounting period from the parameters file and the parameters file only stores the current fiscal year.
Here is what I have now:
The files mentioned above are linked. I have a column of account balances for the current month to date for the current fiscal year and for the year to date. I need the account balances for the current month to date for the same period only last year and last year's ytd balances.
How can I change the fiscal year to last year and pull in the data from the history&budget file?
TIA,
Margo
GL History&Budget
GL Account Master
GL Parameters
The files are linked from history&budget to account master by account number and from history&budget to parameters by fiscal year. Herein lies the problem. I need account balances from this fiscal year and last fiscal year. The history&budget files hold this data, but I need to get the current accounting period from the parameters file and the parameters file only stores the current fiscal year.
Here is what I have now:
The files mentioned above are linked. I have a column of account balances for the current month to date for the current fiscal year and for the year to date. I need the account balances for the current month to date for the same period only last year and last year's ytd balances.
How can I change the fiscal year to last year and pull in the data from the history&budget file?
TIA,
Margo