Dynamics Community Forum Thread Details

Automatic ledger settlements on financial tags - exclude blank values

Hi all,

When using the Automatic ledger settlement it is possible to specify a matching criteria to match on financial tags.

However, I notice that if I have transactions without a tag (i.e tag is blank) these transactions are also settled automatically based on this rule, which I would hope they didn't.

My questions is therefore if anyone knows if I can specify my rule to exclude blank values from the settlement?

Here is my scenario:

I have a financial tag called 'Settlement' setup of value type "Text" that I would like to use for my settlements.

The process automation rule I have setup is for main account 853700 with match Criteria financial tag and the financial tag "Settlement".

I have two postings on this main account with the same amount, however I have no financial tags added to this transactions. Yet, they are automatically settled.

If one of the lines would have a "Settlement"- financial tag it wouldn't settle, but when both are blank they settles.

Any thoughts on how to get around this?

Hello.

I am working for a client where we also want to settle transactions with Fin Tag as a matching criteria. I asked to a developer to customize the code, but it looks like the code is "protected" and cannot be changed.

I agree that, functionally speaking, it does not make any sense to settle automatically transactions that have the same absolute value amount if tag is blank, as at my customer, it led to settled apples with pears.

I was forced to disable the automatic settlement, and we had to settle the transactions manually, in the standard form in GL menu, sorting and filtering transactions by tag value.

We should ask to Product Group to enhance the behaviour of the system. At least to offer an option in the setup of settlement rules such as "blank value to be settled? Yes / No" when Financial tag is selected as a matching criteria.

There is also one pain point with automatic settlement. As we are in the first days of 2025, the batch does not try to settle automatically transactions from 2024. As the batch cannot be launched, even if we use the "repeats" option set to "once" in the settlement rule setup, with an effectivety date, we are forced now to cleanup the transactions that were not settled until now, manually, as we cannot ask the batch to settle all transactions where accounting date is <= 31/12/2024 with a settlement date = 31/12/2024 for example...

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL