Ribbons for Disclosure Management

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

The Lucanet Disclosure Management User Interface

All Steps at a Glance

Basic Configuration

Dashboard

Configuring a Document

Cockpit

Creating and Editing Chapters

Creating and Editing Periods

Importing Data

Working with MS Office Files

Ribbons for Disclosure Management

Creating and Editing Excel Files

Creating and Editing Word Files

Versioning and Recovery of MS Office Files

Creating and Inserting Document Variables

Creating and Editing Validations

Using the Data View

Using the XBRL Tagger

Creating Result Document

Rolling Forward or Copying a Document

Editing Documents in the XBRL Tagger

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

When working with MS Office documents, you can use functions in specific ribbons for MS Excel and MS Word. The functions provided in the ribbons are perfectly adapted for use in conjunction with Lucanet Disclosure Management:

The

Excel ribbon

helps you program an MS Excel file for Disclosure Management.

The

Word ribbon

helps you create result documents in MS Word.

Have you not installed the ribbons yet? Then go to the Toolbox of Disclosure Management and first install the Excel ribbon, the Word ribbon, and the Dispatcher. The Dispatcher is responsible for communication between Disclosure Management and the MS Office files, so installing it is a prerequisite.

For Disclosure Management, there are functions that are available in all ribbons and special functions for the MS Office product being used. The following figures highlight the general functions in the ribbons for MS Excel and MS Word:

Displays the Excel ribbon for Disclosure Management. The 'Server' and 'Files' areas and the 'Insert Document Variable' button are highlighted. — Excel ribbon containing the general functions for Disclosure Management

Displays the Word ribbon for Disclosure Management. The 'Server' and 'Files' areas and the 'Insert Document Variable' button are highlighted. — Word ribbon containing the general functions for Disclosure Management

The following functions are available in the Excel ribbon and Word ribbon:

Check In

: The current file will be saved in the database.

Comments

can be stored during the check-in process. Comments will be displayed in the document's history.

Update

: By clicking

Update

, changes made in Excel or Word files can be viewed as a preview at any time without having to check in the file. The file view will be refreshed according to the current, changed settings.

Examples:

You have created names and name extensions, but the corresponding cells of an Excel file have not yet been filled with content. By clicking

Update

in the Excel ribbon, the document's reference year will appear in the

sn_year

named range, for example.

Values in Excel files are to be updated if a new data import has been performed in the meantime.

Event Reports

: Disclosure Management has an internal error logging system that flags invalid references, etc.

Show Log

opens the results of the log.

Save File Locally

saves the file in the local file directory.

Open Local File

opens a file from the local file directory.

Recover Version

opens or recovers a previous version of the document that is currently open.

Insertion of a document variable; document variables are text building blocks that can be created in the document variable management tool and then easily inserted in every Excel and Word file of the current document.

More information on document variables can be found in Using Document Variables.

The following specific functions are available in the Excel ribbon:

Name Manager

opens MS Excel's standard Name Manager.

Delete Names

deletes a selected name from the Excel file.

Delete All Names

deletes all names from the Excel file.

Insert

adds a new outarea.

Move

shifts an outarea.

Insert Document Variable

: Insertion of a document variable; document variables are text building blocks that can be created in the document variable management tool and then easily inserted in every Excel and Word file of the current document.

Name

: button for creating a name column

Value

: button for creating a value column

Prog

: button for creating a programming column

Other

: button for creating other columns, e. g. footnote columns

Edit Properties opens a dialog where the general properties of the Excel file can be configured.

Add Layout Area defines an area where a specific layout from the Layout Robot is to be applied (see Configuring Document). By doing so, you ensure that a table layout defined using the Layout Robot is implemented in the Word document.

The following specific functions are available in the Word ribbon:

Compare with Local Document opens the local directory structure where a file can be selected for comparison.

Insert Table

opens a dialog where a table can be selected from an Excel file to carry it over to the Word document.

More information on inserting tables can be found in

Inserting Tables in a Word Document

Insert XBRL Text Block Tag

opens a window in MS Word where you can assign an XBRL text block tag to a selected area in the Word document.

Insert XBRL Footnote Tag

opens a window in MS Word where you can assign an XBRL footnote tag to a selected area in the Word document.

Highlight XBRL Text Blocks

highlights all XBRL text blocks in the current Word file and displays a comment field for all highlighted text blocks.

More information on inserting XBRL tags can be found in

Inserting XBRL Tags

Text adjustment

: Opens a window in MS Word that allows you to optimize a selected text in the Word document with AI support.

Text draft

: Opens a window in MS Word that enables you to create a taxonomy-compliant text with AI support.

For more information on using the Copilot in Disclosure Management, see

Using Copilot for Disclosure Management