Querying Comments
Last updated on 2025-04-29
Overview
You can use LUCANET formulas to query comments in Lucanet (e.g. for values in the general ledger, in subledgers or in schedules) and read them in to MS Excel.
Dieser Artikel enthält folgende Abschnitte:
Structure of the LUCANET Formulas
To read in comments from Lucanet to MS Excel, the LUCANET formula must be set up as follows:
=LN.COMMENT("Abbreviation","Data level","Adjustment level","Organization element",
"Account or Item","Periodicity","StartDate",["EndDate"],["Transaction type"],
["Display currency"],["Transaction currency"],["Partner/partner group"])
=LN.COMMENT(”Abbreviation”,"Data level","Adjustment level/Adjustment level group","Consolidation unit","Account or item","Periodicity","Date")
Parameters
All parameters must be specified just as described in Querying Values. The formula can be added with optional parameters.