You can calculate the total of the revenue and expense codes on the basis of the run setup. The calculation results are presented in a hierarchical structure, similar to the directory of revenue and expenses. In the Totals on codesform, you can double-click the cells to view the register lines containing the data that forms the basis for the calculations. In the Register linesform, you can click Sourceto view the primary documents (index). After you calculate the totals, you can validate the figures that appear in the tax statement report by comparison with the primary documents. The calculation and display of the revenue and expense code totals are handled by Microsoft OLAP Services.

Before you calculate the revenue and expense code totals, generate and calculate the tax register journals.

  1. Click General ledger> Journals> Tax register journal.

  2. Select the journal for which you want to calculate the totals.

  3. Click Totals on codes> Update. The OLAP server will calculate the totals of the revenue and expense codes according to the specified settings.

  4. Click Totals on codes> Showto view the revenue and expense code totals in a standard OLAP viewing form after calculation.

    • The revenue or expense codes for which totals have been calculated are displayed in a hierarchical structure on the left side of the form. A total is displayed for each revenue or expense code.

    • The registers that were included in the calculations are listed horizontally in the upper section of the form. A total is displayed for each register.

    • The total for the revenue or expense code in a given register is displayed in a cell at the intersection of the revenue or expense code and the register. If the given register is not set to calculate the code, the cell is empty. If the calculation was made, but the amount for the revenue or expense code register is 0, then the cell displays 0.

  5. Press CTRL+S or close the form.

    Note Note

    To view the register lines that were used to calculate the total displayed in the cell, double-click a cell between the register and the revenue or expense code.

See Also