Account entries

<< Prev   Next >>

The Account entries report shows all accounting entries posted to a company's account within a certain period.

To view the Account entries report:

1. Go to Accounting.
2. Under Reports, click Account entries.
3. Specify the main settings of the report.
4. Click Generate.

The Account entries report is displayed. You can customize it according to your needs. See Report settings.

Report settings

You can customize the Account entries report using any of the following options:

• Edit the main report settings such as the reporting period or target account. See Main settings.
• Group the report information by more granular time span within the reporting period. For example, view the account entries by week or by day. See Grouping.
• Add filters to view only the information relevant to you. For example, view only the account entries related to a certain product. See Filters.
• Add more details to the report or change its display settings. For example:
  • Add amounts in transaction currency.
  • Add quantity details.
  • Highlight negative account balances in red.

See Report details and view.

Main settings

You have the following options to fill in the main settings of the Account entries report:

• Fill in the main settings directly at the top of the report window.
• In the report window, click Settings. Then, fill in the Main tab in the report settings window.

The main settings include the following:

Grouping

Specify the Grouping settings if you want to view the Account entries report by more granular time span within the reporting period. For example, view the account entries by week or by day.

To specify the Grouping settings:

1. In the Account entries report, click Settings.
2. In the report settings window, on the Grouping tab, in the Periodicity field, select a time span.
3. Click Close and generate.

Filters

Add filters to the Account entries report if you want to view only certain information. For example, view only the account entries related to a certain product.

The following options are available for you:

• Add simple filter conditions.
• Add filter groups to create complex filtering conditions. For example, use this option if you need to apply filtering conditions that are nested or connected with the OR operator.

Adding simple filter conditions

To add a simple filter condition:

1. In the Account entries report, click Settings.
2. In the report settings window, on the Filters tab, click Add filter.
3. Specify the following:

   Field	Description
   Field	A filtering parameter. This can be any field of the report.
   Comparison type	The condition for the filtering parameter.
   Value	The filtering parameter value associated with the specified condition.

4. Click Close and generate.

You can repeat steps 2-3 to add as many filter conditions as you need. 1C:Drive will apply them using the AND operator. This means the report will show only the information matching all the filter conditions at once.

For example, consider the following filter conditions:

These filter conditions mean that the report will show only the account entries related to laptops stored in the main warehouse.

If required, include filter conditions in a group. See Adding filter groups.

To delete a filter condition, select it and click Delete.

Adding filter groups

After you add filter conditions, you can add filter groups.

To add a filter group:

1. In the report settings window, on the Filters tab, do any of the following:
   • To include filter conditions in a group, select them while holding down Ctrl or Shift.
   • To add a nested filter group to a filter group, select the filter group line or select the filter conditions in this group.
2. Click Add filter group and select the filter group type. One of the following:
   • AND group. The report must show data matching all conditions in this group.
   • OR group. The report must show data matching at least one condition in this group.
   • NOT group. The report must show data excluding items matching all conditions in this group.

To add a filter condition to a filter group, select a filter group line, click Add filter, and specify the filter conditions.

To ungroup filter conditions, right-click a filter group line and select Ungroup.

Report details and view

Specify the Report details and view settings if you want to view more details in the Account entries report or change its display settings. For example, you can view amounts in transaction currency, quantity details, or negative account balance highlighted in red.

To specify the Report details and view settings:

1. In the Account entries report, click Settings.
2. In the report settings window, on the Report details and view tab, select any of the following checkboxes depending on your needs:

   Checkbox	Description
   Pesentation currency (PC)	Indicates that the report shows amounts in the presentation currency of the company specified in the main settings of the report.
   Transaction currency (TC)	Indicates that the report shows amounts in the transaction currency. This applies only to the accounts where entries are posted both in the presentation and transaction currency (the Currency checkbox is selected in the account settings).
   Quantity (Qty)	Indicates that the report shows quantity details. For example, you can view the quantity of product items related to the account balance.You can select the checkbox only if the Quantity checkbox is selected in the account settings.
   Report title	Indicates that the report title is shown above report table. The title format is the following: [Report name] for [Account] [Reporting period if specified]
   Applied filters	Indicates that the report shows the settings and filters that the report is based on. This information appears above the report table.
   Highlight negative values	Indicates that negative account balances are highlighted in red.

   Note. You might select more than one of the three indicators: Presentation currency (PC), Transaction currency (TC), and Quantity (Qty). Then, the report includes the Indicator column with the selected indicators shown as PC, TC, and Qty.

3. Click Close and generate.

<< Prev   Next >>