Comparing Two Fiscal Sets

Sage 300 ERP

Home > Looking Up Account and Transaction Information > Comparing Two Fiscal Sets

Comparing Two Fiscal Sets

Use the G/L Fiscal Set Comparison screen to display account information for two fiscal sets, comparing the net changes or period balances. More...

You can compare actual, quantity, provisionally-posted and budget fiscal sets, in any combination you choose.

To compare two fiscal sets:

  1. Open General Ledger > G/L Accounts >  Fiscal Set Comparison.

  2. In the Account field, enter an account number you want to view, or use the Finder to select one.

    If you choose a rollup account, the Use Rolled Up Amounts option appears.

  3. Select the Use Rolled Up Amounts option (if it appears), if you want to view rolled-up amounts for this account.
  4. Select the type of comparison to perform:
    • Select Net Change to compare account activity between two fiscal sets.
    • Select Balance to view changes in the account balance for two fiscal sets.
  5. Use the Fiscal Set 1 and Year fields to select the type of fiscal set and the year for the first fiscal set of the pair you are comparing.
  6. Use the Fiscal Set 2 and Year fields to select the type of fiscal set and the year for the second fiscal set.
  7. If General Ledger and the selected account are multicurrency:
    • In the Currency Type field, specify whether to display balances in the source currency amounts or in their functional currency equivalents.
    • In the Currency field, specify the currency of the balances or net changes that you want to view.

    Note: Transactions can be posted to multicurrency accounts in various currencies. When you specify a source currency in the Currency field, the program displays only balances or net changes for transactions posted to the account in that currency. You can choose to view source currency amounts or their functional currency equivalents.

  8. Click the Go button to display the accounts you have specified.

Related Topics