G/L Account History Inquiry
This form lets you display:
-
Actual and quantity information for prior years, including the opening and closing account balances and the net changes and balances for each fiscal period.
-
Total quantity and total net change information for the fiscal year.
-
G/L transaction details for a period (by double-clicking on the period for which you want more information)
-
If the account you select is a rollup account, you can view each account separately or roll up the balances. Amounts will appear in the Net Change and Balance columns when you select the Use Rolled Up Amounts option.
To view historical data
-
Enter an account number or select one with the Finder.
-
Select the year for which you want to view balances. (Click the down arrow.)
-
If you are running a multicurrency database, select a Currency and the Currency Type.
-
Choose either Source or Functional in the Currency Type dropdown list.
-
If the euro is your functional currency, you can choose an additional Currency Type option, Reporting. This option only appears if you specified a reporting currency on the Company Profile form in Common Services.
-
If you have a single currency system and your functional currency is the euro, the Currency Type options you can choose from are Functional and Reporting.
-
If the option, Show Quantity is available, select it to view quantity data that's been posted to the account.
Results are automatically displayed when you change any input field.
-
Double-click a transaction detail line to drilldown to the G/L Transaction History form.
-
If the account you select is a rollup account, select the Use Rolled Up Amounts option to see the rollup account as well as the rollup member transactions.
You can also see the rolled up quantity balances by selecting the Show Quantity option. Note that a rollup account can have the selection for Show Quantity even though Maintain Quantities is not used for this rollup account. When the Use Rolled Up Amounts option is selected, it will check if any of the rollup members do maintain quantities. If they do, when Use Rolled Up Amounts is selected, Show Quantity will also be enabled. The quantities balances will then be rolled up as well.
Click here for hints on using forms.
See also