Vendor Balance Report: Default Summarizing

The basic Vendor balance report summarizes opening balances for each displayed Vendor as of a start date of the report (in the Opening amount column) and outstanding balances as of an end date of the report (in the Balance amount column). The total amount of all invoices issued for a given period is summarized for each Vendor (in the Amount Dt column) as well as the total amount of all invoices paid to the Vendor together with the amounts returned by the Vendor according to issued debit notes (in the Amount Ct column). The amounts are worked out by summing the original/primary values (using the SUM function).

So summary values are presented in 4 columns - Opening amount, Balance amount, Amount Dt and Amount CT columns which are grouped/sorted by currencies with the total amounts being shown in a Vendor’s currency and in your system currency. The final total amount of all transactions and balances for each Vendor for a given period is presented in the Total column in your system currency.

 

Note: Summary values are presented at all grouping levels and at the grand total level. If no summary value is available for a certain grouping level or rather for the intersection of groupings by rows and columns, nothing is displayed for it.

 

The default summarizing settings are defined in the values section of the Vendor balance report. To define the summarizing methods, the summable fields have been added and summarizing options have been specified for them. Except for specific reports that do not provide for full customization (see Customizing Reports), you can change the summable fields and the summarizing methods for your reports. In case of Vendor balance report, you are allowed to do that.

 

To customize the default summarizing parameters:

  1. On the page for configuring report parameters, click the Customize button.
  2. Use the values section to view and customize the default summable fields and summarizing methods defined for them.

 

You can delete, rearrange, add new summable fields and specify summarizing methods for them.

 

For information how to customize summarizing settings, see Summarizing Report Data.

 

To add a summable field:

  • In the values section, click the Select an option box, and then select a summable field from the list of options.

 

The list displays summable fields from the selected report type which you can use to summarize report data in columns. For Vendor balance report, there is a number of fields you can use:

Field

Used for summarizing and displaying

Opening currency amount

Vendor opening balances as of the indicated start date being displayed in your Vendors’ currencies (currencies of invoices).

If the system currency coincides with the currency of a Vendor, values in both fields will be identical.  

Opening amount

Vendor opening balances as of the indicated start date being displayed in your company’s system currency.

Currency amount Dt

The total amount of all purchase invoices issued by each Vendor during a given period being displayed in your Vendors’ currencies (currencies of invoices).

If the system currency coincides with the currency of a Vendor, values in both fields will be identical.

Amount Dt

The total amount of all invoices issued by each Vendor during a given period being displayed in your system currency.

Currency amount Ct

The total amount of all invoices paid to each Vendor plus the amounts returned by the Vendor according to issued debit notes. The amount is presented in your system currency.

Amount Ct

The total amount of all invoices paid to each Vendor plus the amounts returned by the Vendor according to issued debit notes. The amount is presented in your system currency.

Balance currency amount

Vendor outstanding balances as of the specified end date being displayed in your Vendors’ currencies (currencies of invoices).

If the system currency coincides with the currency of a Vendor, values in both fields will be identical.

Balance amount

Vendor outstanding balances as of the set end date being displayed in your company’s system currency.


The SUM function is selected as a default summarizing method for all fields. 

 

In case it is necessary to change the summarizing method, you do that as follows:

  • Click the calculation option box to the right of the field, and then select one of the available summarizing options from the list.
 
For summarizing options, see Summarizing methods.

 

More information