Exact Globe+

 

Excel Add-in: Explanation of function ACC_DATA

Introduction

With the [ACC_DATA (acc_nr;co;field)] function, you can retrieve the master data for a general ledger account. If you do not select a field, the description will be included. If you want specific information from a series of general ledger accounts to be displayed, you can use this function in combination with the FILE_NEXT and FILE_FIRST functions.

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 "ACC_DATA".

Column

Select the field you want to have displayed. If you don't make a selection, the description will be displayed.

Example

ACC_DATA("     1300";001;"debcrd")

This function displays whether account 1300 in company 001 is a debit (D) or credit (C) account.

     

Main Category:	Attachments & notes	Document Type:	Support - On-line help
Category:		Security  level:	All - 0
Sub category:		Document ID:	13.130.815
Assortment:	Exact Globe+	Date:	10-02-2025
Release:		Attachment:
Disclaimer