Vendor Balance Report: Default Grouping

Grouping by Rows

 

In the basic Vendor balance report, the data is grouped by Vendor, then by Account, and then by Invoice. As a result, a 3-level hierarchy is formed with links between levels being of the parent-child type. To see sublevel details in the generated report, you have to drill down to lower levels.   

For more details on grouping data in reports, see Grouping Report Data.

The default grouping settings are defined in the rows section of the basic Vendor balance report. To define the groupings, the fields have been added by which data in the report has to be grouped by rows. However, you can change the pre-defined settings and choose how to group data by yourself.   

To do that:

  1. On the page for configuring report parameters, click the Customize button.
  2. In the rows section, view and customize the default groupings as follows:
    • To add fields for grouping, click the Select an option box, and then select a field by which you want to group data from the list of options.

The list displays fields from the selected report type which you can use to group data y rows.

    • To remove fields, click the cross icon next to the field you wish to remove.

 

Fields for grouping

Field

Used for grouping by

Vendor

Vendors whom you owe money as of the specified start date or Vendors with whom your company has had purchase transactions during the report date range.

Account

Accounts in which Vendor balances and purchase transactions are recorded.

Currency

Currencies of purchase transactions with Vendors. As a result, they are also currencies of Vendor balances.  

Purchase Invoice
Purchase invoices issued by Vendors that form Vendor balances.

 

Grouping by Columns

 

In the Vendor Balance report, columns are by default grouped only by Currency. Summarizing columns that display each Vendor’s opening balance, outstanding balance, the total amount of all invoices issued by each Vendor and the total amount of all invoices paid or cancelled for each Vendor are sorted/grouped by currencies with the amounts being shown in a Vendor’s currency and in your system currency.

This grouping by columns is defined in the columns section of the report, and you are allowed to choose how to group data by yourself as in case of the groupings by rows. You do that as follows:

  1. On the page for configuring report parameters, click the Customize button.
  2. Use the columns section to view and customize the default groupings.

As with groupings by rows, in the columns section, you add fields by which you want to group data. The set of fields available for grouping data by columns is the same as for grouping data by rows.

 

More information