Exact Globe+

Excel Add-in: Explanation of function CU_BAL_DATE

Introduction

With the CU_BAL_DATE (acc_nr;cu;co;VWeekFrom;VWeekTo;balance_type;value) function, you can include the balance amount for a cost unit by general ledger account, in a particular date range, in the worksheet.

Fields

Company

Select the administration from which you want to retrieve the Exact data. If you select Default, the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function

Select the function you want to use. In this case "CU_BAL_DATE".

G/L account

Select the general ledger account for which you want the balance to be displayed. You can also enter the account number. Select multiple accounts as follows: 0050:3000. In this case, the balance for accounts 00500 through 3000 will be displayed.

Cost unit

Select the cost unit for which you want the balance to be displayed. Select multiple cost units as follows: a:bzzzz. In this case the balance of all the cost units that start with an 'A' or a 'B' will be displayed. If you leave the field empty, the balance of all the cost units will be included.

From date

Select the date as of which you want to retrieve the balance. Transactions prior to this date will not be included.

To date

Select the date through which you want to retrieve the balance. Transactions that occur after this date will not be included.

Unprocessed

You can retrieve information after entry. This means that information from unprocessed entries will also be displayed (unprocessed= 1; processed= 0).

Value

Select which value you want to have displayed in the worksheet. You have the following options:

Debit (1): the total of the amounts debited
Credit (2): the total of the amounts credited
Balance (3): the balance of the debit total and the credit total
Positive (4): same as the balance, but only positive values are displayed
Negative (5): same as the balance, but only negative values are displayed (as positive values)
Quantity (6): The quantity (as entered) is included

Range

Enter whether the date or the reporting date should be used when selecting the information. If this field is left empty, the value from the settings will be used. This setting concerns the date field described above.

Example

CU_BAL_DATE("3000";"ABON";100;01/01/2002;31/01/2002;1;3;2)

Note: The balance 'after entry' for the 'ABON' cost unit in the reporting date range January 1 through January 31, 2002, based on the amounts that were entered in general ledger account 3000 in company 100 will be displayed.