Go to Finance ➔ Reports ➔ Pivot analysis, and click Settings.
This document provides the information to define the setting for a pivot analysis.
The information in this document is based on product update 397. If you have versions lower than this, certain features explained here will not be applicable.
Select this check box to display the server information of the selected database.
Select this check box to display the company ID of the selected database.
Select this check box to display closing balance entries. By default, this check box is not selected and therefore, the closing balance entries will not be displayed. Due to this, the profit and loss accounts will not have zero balances after performing the year-end closing.
Select this check box to display the total values of the selected columns in Columns.
Select 0, 1, 2 or 3 to indicate the required number of digits after the decimal point. The maximum is 3 digits. By default, the value is set to 0.
Select this check box to display the pivot analysis with horizontal grid lines.
Select this check box to display the pivot analysis with vertical grid lines.
Note: You can define these grid line colors at the Interface tab at System ➔ General ➔ User settings. Under Grid, select Grid lines: Horizontal or Grid lines: Vertical check box to enable the icon and select the preferred horizontal and vertical grid line colors.
Select Date for entry date or Reporting date for the reporting date you want to view in the pivot analysis. The selected date option determines whether the entry date or reporting date is used during the grouping of fields in the Date category. For instance, Year, Month, Weekday, Quarter, Week and Period.
Click this to exit.