Archive for February, 2023

Dynamics 365 Finance – Tags – new feature

February 13th, 2023

Source: Microsoft

After transactions are posted, it’s common for organizations to require visibility into subledger data, to analyse the accounting entries. Organizations use fields such as the document number, description, or financial dimensions to track subledger data in the general ledger, because it’s difficult to navigate the data model to the subledger data.

The types of subledger data that are often tracked include sales order or purchase order numbers, vendor or customer names, payment references, invoice numbers, or reference numbers from external transactions that are imported into Microsoft Dynamics 365 Finance.

In addition to being used for analytics, the subledger data is used for processes such as ledger settlement.

The Financial tags (tags) feature eliminates the need to solely rely on document numbers, descriptions, or financial dimensions and an organization can now create and enter up to 20 user-defined fields on transactions. Those fields are then stored on the accounting entries that are created for the transactions.

Tag values aren’t stored in any subledger tables, nor in the Customer transactions or Vendor transactions table.

Tags were introduced in the 10.0.32 release of Dynamics 365 Finance. This release supports the capability to define up to 20 user-defined tags and to enter tag values on the following journals (and corresponding Open Data Protocol [OData] and Data management entities):

  • General journal
  • Global general journal

In subsequent new releases, tags will be implemented in additional journals, documents, and processes.


To use the functionality, enable the Financial tags feature in the Feature management workspace.

The feature can be disabled at any time. When the feature is enabled but later disabled, any values that were entered for financial tags on transactions will be maintained in the database. However, they’ll no longer be visible on any transactions or in inquiries in Dynamics 365 Finance.

Enter tags on transactions resembles similar to entry a ledger account that uses financial dimensions.

Tags don’t use the same control as a ledger account, but those still require a delimiter between the tag values, so define the tag delimiter before you define any financial tags.

  • On the General ledger parameters page, select Financial tags, and specify the delimiter.
  • The delimiter that you specify must not be used in any tag values that are entered on transactions. The delimiter can’t be changed after it’s defined.

After the feature is enabled, each legal entity can define up to 20 financial tags.

 Tags are legal entity–specific.

Use the Financial tag configuration and Financial tags custom list value entities to import the tags for each legal entity to quickly and easily define the same initial setup in multiple legal entities.

Create financial tags

Before you create financial tags, note the following points:

  • Evaluate whether the data should be tracked as a financial dimension or a financial tag.
  • Financial tags are an alternative to financial dimensions, especially when you’re tracking values that have little or no reusability, such as sales order numbers or purchase order numbers..
  • After a financial tag is created, it can be deactivated but not deleted. This restriction helps to ensure that the tag values remain available for reporting on posted general ledger entries. Financial tags can easily be activated and deactivated at any time.
  • The label of each financial tag can be changed at any time, even after transactions are posted.
  • If no transactions have been posted for a specific financial tag, then a change to the tag’s label will have no impact. This behavior is useful when you must repurpose a tag so that you can track other data.
  • When transactions are posted for a specific financial tag, the tag values don’t change. When the tag’s label was originally “Purchase order number,” but it’s later changed to “Sales order number,” the accounting entries that were posted before the label change will still contain the purchase order numbers that were entered and posted to the general ledger.

Create a financial tag

Follow these steps to create a financial tag.

  1. Go to General ledger > Chart of accounts > Financial tags > Financial tags.
  2. Select New to create a financial tag.
  3. Enter a label for the tag. The label must start with a letter or underscore, and it can contain only letters, numbers, and underscores. No special characters, including spaces, are permitted.
  4. In the Value type field, select TextList, or Custom list.
  5. If you selected List in the Value type field, select the value source in the Use values from field. The field contains a list of entities that the tag values can be selected from during transaction entry.
  6. If you selected Custom list in the Value type field, select Tag values to create the custom list of tag values that will be available for selection during transaction entry.
  7. Select Activate to activate the tag.

Enter financial tag values on transactions

After one financial tag is activated, tags are available for entry on each transaction that supports the feature.

Journals and lines

When you enter journals, define tag values on the journal batch header. Those values will be used as default values for the lines in the journal.

  • As for other default values in the journal, they’ll automatically be entered on new lines that are added to the journal.
  • However, these will not be entered on lines that already exist when you define the values on the header.

Default values

Tag values that you enter in a journal are entered as default values in the following way:

  • Single-line voucher:
    • Tag values that you add to the journal batch header are entered as default values on the account.
    • Tag values that you add to the account are entered as default values on the offset account.
    • If the offset account already exists when you add tag values to the account, then those tag values aren’t entered as default values on the offset account.
    • If tag values exist on both the account and the offset account, then changes to the tag values in one place don’t cause the values in the other place to be updated. For example, when you change the tag values on the account, the tag values on the offset account aren’t updated. This behavior helps to prevent loss of data should a user manually override the default values.
    • When you add a new line, and you assign a new voucher number (which represents a new transaction), the defaulting behavior starts over.
    • Tag values from the lines of one voucher are never entered as default values on the lines of a different voucher.
  • Multiline voucher:
    • Tag values that you add to the journal batch header are entered as default values on the account of each line that’s added to the voucher.
    • The tag values that you add to the account on the first line aren’t entered as default values on the account of the next line of the voucher, and so on.
Financial tag values on journal lines.

Tag values from master data are never used as default values. For example, there’s no capability to define default tag values on customers or vendors.

In addition, tag values from the transaction itself aren’t automatically entered as default values. For example, when a tag was created to track the customer name and subsequent transaction contains a customer, then the  tag value isn’t entered as the customer name by default. The value must be manually entered or imported.


When tag values are entered on transactions, no validation occurs during either transaction entry or posting.

Even when a tag of the List or Custom list value type is defined, the tag values aren’t validated to ensure that they exist in the list.

For example, a tag of the List value type is created, and the purchase order number is selected as the source of the list. Although a list of purchase order numbers will be presented, the user can still enter a purchase order number that doesn’t exist in the list.

Posting transactions that have tag values

After a transaction is posted, the financial tags are available on the lines of the general ledger account entry.

  • Those are shown on the Voucher transactions ,and the Transactions for main account pages.
  • The financial tags are shown in separate columns, so that they’re easier to sort and filter.

For reporting, the tags aren’t part of the dimension sets. Therefore, you can’t get a summarized balance of transactions for a specific tag value. For example, when you’re looking at the trial balance, you can’t get balances per tag value.

However, when you drill down into the balances from the trial balance, the tag values will be shown on the detailed transactions. The detailed transactions, including the tag values in separate columns, can be exported to Excel, where they can be summarized if balances are required.

When a tag is deactivated, the tag values remain on the posted transactions.

 By default, deactivated tags aren’t shown on inquiry pages. However, you can add the columns by selecting Show inactive financial tags.

Correct tag values after posting

Although financial tags are available for reporting, they aren’t part of the ledger account and have no impact on financial statements.

Because tags are used only for internal analysis, edits to the tag values are permitted after transactions are posted.

  1. In the Feature management workspace, enable the feature that’s named Allow edits to internal data on general ledger vouchers. This feature enables some roles to modify the Description field of posted accounting entries.
  2. If the Financial tags feature is also enabled, then this feature is enhanced to enable edits to the tag values.
  3. After the feature is enabled, go to Voucher transactions.
  4. Use the query to find the transactions that you want to edit.
  5. Select the lines in Voucher transactions, and then select Edit internal voucher data.
  6. You can edit only lines that are selected.
Editing tag values on voucher transaction lines.

The page shows the lines that you selected in Voucher transactions, including the current financial tags and new financial tags.

The current tag values are entered as default values for the new tags. Therefore, you don’t have to manually enter everything again but can instead change only what’s incorrect.

Use the Bulk update selected records button to do mass updates. Mass updates are useful to assign tag values to large groups of posted transactions that were incorrect or that no tag values were defined for (for example, because they were posted before the feature was enabled).

Example uses

  1. Stock # – Solar company or auto reseller wants to keep track of all the transactions for a specific unit throughout the life of an asset.
  2. Vendor accruals – Keep track of accrued expenses by vendor in the General Ledger, instead of maintaining Excel files outside the system to track Vendor ID for expenses coming through accrual entries.
  3. Lot – Expense tracking by specific lots, value add, etc. going directly through AP/GL
  4. Marketing campaigns – tracking marketing campaigns is not a perfect candidate for a financial dimension as you don’t want to keep adding too many financial dimensions. But Financial tags can serve this purpose to track expenses by marketing campaign.

Financial tag values used within D365 are not critical for financial reporting outside the company, but they can be important for the internal reporting by FP&A teams. These teams need the ability to make changes to transactions after posting rather than reclass journal entries.

Tags and Financial dimensions

Financial dimensions are used to code accounting entries for reporting (for example, to identify sales per department or expenses per cost center in general dimensions are primarily used to create a detailed P@Ls at the dimension level).

 Financial tags (tags) are not meant to be an alternative to financial dimensions. An organization can create up to 20 user-defined financial tags and enter values for these on transactions.

 Like financial dimension values, tag values are stored on the accounting entries that are created for the transactions. However, tag values aren’t stored in any subledger tables, such as the Customer transactions or Vendor transactions table. Both financial dimensions and financial tags can be used for analytical reporting, and also for some processes, such as ledger settlement.

Financial dimensions are very structured. The setup is used to control which dimensions are required, which dimension values are valid, and which dimension combinations are valid.

Financial tags have limited structure, no validation is done, and very limited defaulting is done.

The following table describes, in detail, the differences between financial dimensions and financial tags, to help organizations determine which feature they should use.

FunctionalityFinancial dimensionsFinancial tags
Account structuresDimensions must be included in an account structure before they can be used in a legal entity. The account structure determines the dimensions that are required for the main account and the valid combinations.Tags aren’t part of the account structure.
ValidationDimension values on the ledger account are validated against the account structures to determine whether the dimension values are active, the dimension combinations are valid, and the values exist.Tag values aren’t validated during transaction entry or posting.  Any value can be entered, even when the tag is defined as a tag of the List or Custom list type. A value doesn’t have to be selected in the list. There’s no way to require a tag value.
DefaultingDefault dimension values are entered from master data, such as customers, vendors, products, or projects. These are also entered from the header of a document to the lines. For journals, these are entered from the journal header to the account, and from the account to the offset account.Default tag values aren’t entered from master data. However, they’re entered from the header of a document to the lines. For journals, these are entered from the journal header to the account, and from the account to the offset account.
ReportingDimension values can be used for reporting in multiple ways. Dimensions can be included in a dimension set, which is used to calculate totals for the ledger account. Dimension values can also be viewed on each detailed transaction. The segments can be parsed out, and then used to sort and filter the detailed transactions.Tag values aren’t included in dimension sets. In Microsoft Dynamics 365 Finance, you can’t generate a trial balance to view balances for tag values. When you drill down from the balances on the trial balance, tag values are shown on each detailed transaction.  The tag values are in separate columns. Therefore, it’s easy to sort and filter on transactions in the Voucher transactions or Transactions for main account inquiry. The detailed transactions can be exported to Excel or Power BI.
Impact on General ledger processesAlthough dimensions are considered unlimited, the more dimensions that are created and used in a dimension set, the slower transaction entry, import, and processes will become.Because tags have no structure or validation, there’s minimal impact when they’re used on transactions or imported via an entity.
Non-reusable valuesDimensions should never be used to track non-reusable values, such as document numbers or reference numbers. This type of data will cause your chart of accounts to explode, because of the uniqueness of so many ledger accounts. Therefore, performance will be negatively affected, especially around the year-end close and during foreign currency revaluation and consolidations.Tags should be used to track non-reusable values, such as document numbers or reference numbers.
Ability to activate or deactivateNew financial dimensions can be activated, but the system must be in maintenance mode. Financial dimensions can’t be deactivated. Instead, they can be removed from an account structure, so that they’re no longer used by any legal entities that use that account structure.Tags can be activated or deactivated at any time.
Ability to deleteDimensions can’t be deleted if they’re referenced anywhere, such as on a posted transaction. If the dimension references an entity, the entity and entity values can’t be deleted. This restriction helps maintain referential integrity.Tags can’t be deleted. This restriction helps maintain the tag values that have been entered on posted transactions. However, tags can be deactivated at any time. If a tag references an entity for a list, then no reference to that entity is maintained. For example, if the tag is mapped to the Customer name entity, customers can be deleted, because the tag values hold no reference to the customer. In addition, if a customer name is changed, the customer name isn’t updated in the tag values.
Ability to edit after postingDimension values can’t be edited on posted transactions, because any change to the ledger account will directly affect financial statements.Tag values are used only for internal analysis and processing. Therefore, they can be added, removed, or edited on posted transactions by using the Allow edits to internal data on general ledger vouchers feature. An audit trail is maintained for all edits that are made to the tag values after posting.
Global or legal entity specific?Dimensions are set up globally, and they are “assigned” to each legal entity through the account structures. Dimensions also have legal entity overrides, so that the same dimension can be active in one legal entity but inactive in another legal entity.Tags are set up at the legal entity level. They can be shared by using the Shared data feature. The tags and custom tag values can be copied to each legal entity by using the data management entities.

Some highlights:

  1. Create financial tags and use these in the general journals, via the web interface or through the upload function.
    • Update Financial tags after posting (as needed without need for journal entries for reclass)
  2. To reduce maintenance derive Financial tags from other values like a vendor, customer, etc. either as a standalone list or created as custom list.
  3. Unlike Financial dimensions; Financial tags are not validated against such lists and do not have to be predefined prior to use on the transaction.  
  4. Voucher screen and standard reports will show financial tags.

For the future?:

  1. We can only use tags now in GL transactions not in subledgers. It will be a much stronger feature when available on purchase orders, sales orders, and inventory close/adjustments to track write-down adjustments, purchase requisitions, and other transactions.
  2. To distribute an amount across multiple tag values. For example, the GL has one transaction for an expense, but the amount needs to be distributed across multiple Financial tag values for reporting purposes.

New Penalties for violating the UAE Federal Decree by Law No 32 of 2021 concerning Commercial Companies (“Commercial Companies Law”).

February 9th, 2023
Recently, the UAE Cabinet issued a resolution that stipulates penalties for violating the UAE Federal Decree by Law No 32 of 2021 concerning Commercial Companies (“Commercial Companies Law”).
This applies to all UAE onshore or mainland companies, including Limited Liability Companies (LLCs). Penalties for Non-Compliance
·  Accounting Registers: A fine of AED 15,000 for failing to maintain accounting registers. ·  Trade Name Change: A monthly fine of AED 500 for failing to comply with the decision to change the trade name, with a maximum annual amount of AED 5,000. ·
 Ownership: When the LLC carries out activities with strategic significance, it may face a fine of AED 100,000 for non-compliance with the required UAE national ownership percentage or minimum number of Emirati board members.
·  Memorandum of Association: A fine of AED 1,000 on the director or chairman of the board for not having updated the MOA as per the Commercial Companies Law.
·  Loss Disclosure: A fine of AED 50,000 will be given to the director, chairman of the board, or their representative when a general assembly is not called to disclose losses equal to 50% or more of its capital.
·  Data Access: A fine of AED 5,000 for refusing access to minutes of meetings, books, and other related transaction documents with respect to shareholders.
·  Board Meetings: A fine of AED 3,000 for failing to invite a director or board member to a board meeting.
·  Refusal of Information or Misleading Information: AED 5,000 fine on the director or chairman of the board of directors of the LLC, their representative, or the auditor upon refusal, concealment or providing misleading information to authority inspectors.
·  Penalties for Share Disposal: A fine of AED 20,000 may be imposed on any individual who disposes shares in violation of the Commercial Companies Law.
·  General Assembly: The director or chairman of the LLC board may be fined AED 5,000 for failing to call the annual general assembly meeting, with a fine of AED 10,000 for failing to call the meeting when requested by the Ministry.

The implementation i suggests that authorities are considering a stringent examination of companies’ adherence to the Commercial Companies Law. so thoroughly assess your corporation’s practices to minimise the likelihood of fines due to non-compliance.
Companies Are Required to Achieve 1% Emirationsation by 1 July 2023 to Avoid Penalties
– The penalties for private companies that fail to meet Emiratisation targets under the amended scheme will now be imposed ‘semi-annually‘.
– Firms that don’t achieve the 1 per cent Emiratisation target growth by 1 July 2023 will be fined Dh7,000 for each UAE national who has not been hired.
– Violating companies will be charged from 1 July 2023.
– Private firms are now required to increase the number of Emiratis in skilled jobs by 1 per cent every six months, while remaining on track to achieve the overall 2 percent target by the end of the year.
– The penalties for non-compliance from 2022 will continue to be collected.