Inherit financial dimension from invoice to customer payment journal

(0) Share

Report

Posted on by Community Member

Hi,

Ive trying to search for solution but dont find any without customization.

Is there anyway to inherit financial dimension when doing settlement between free text invoice and customer payment journal?

That the customer payment journal inherits the dimensions from posted free text invoice? If there is lots of transactions, it takes some time to add fin.dim to every transaction.

Any ideas? Same issue with AP as well.

If cannot be solved with config, possible with customization?

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Randy,

The settlement process can clear the balance on dimension level automatically. When you have a dimension used on the invoice, but not the payment, there will be additional ledger transactions created to zero out the open balance also financially.

If you test this yourself, you might conclude that you don't need a customization.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello RandySWE,

If I understand you correctly then you want to use the same findim that was used on the free text invoice in the payment transaction.

In AX2012 there was a country specific feature which supported that; I think for Norway. Not sure if this is still available in D365FO and can be used for making a customization.

Before thinking about that, please consider how you will handle cases where multiple free text invoice lines use different findims.

They would have to create separate customer balance transactions, which can be realized by a GL parameter.

When recording the payment you will then get 2 lines for a single invoice broken up by findim.

Is that really what you want?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your answers. Just for clarification, I want it to inherit the fin.dim on the customer balance account which the payment will be offset against. In this case, always 1 lines. Still a customization thing?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Randy,

Right. If you need this inheritance of the findims then a customization is needed.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Randy,

Have you verified my answer? Upon settlement, additional ledger transactions will be created automatically to clear the dimension balances. In my opinion, there is really no customization required.

When you want to view or post directly the correct dimensions upon the payment, then yes, you need to do a customization, but what if you select multiple invoices with different dimensions?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André,

Thank you for your answer. I posted a FTI with a dimension for customer balance. Thereafter in customer payment journal, posted the payment transaction. Upon settlement, dimension balance was not created. (Did not work)

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello RandySWE,

Have you checked out the country specific feature in a demo/test environment?

Does that do the 'job' for you?

Best regards,

Ludwig

Was this reply helpful? Yes No
RandyS 15 on at

Like (0)

Report

Hi Ludwig, Thanks for your answer. I tried to find country specific feature both in LCS and Microsoft website, I checked Norway, Denmark, Sweden, FInland but couldnt find anything. Any ideas where this functionality might be found? thanks alot.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi RandySWF,

Can you share some screenshots about the settlement and differences in dimensions?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi RandyS,

It is indeed a Norwegian feature that can be setup in the Method of payments for customers and vendors.

An alternative might be the use of default descriptions that allow you inheriting information from the invoice into the payment.

Here is an example how this can work for vendor invoices.

https://dynamicsax-fico.com/tag/default-descriptions/

The process described here can be applied in a similar way for customer invoices and payments.

Best regards,

Ludwig

Was this reply helpful? Yes No