Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How can I setup AR/GL/CB to inherit the financial dimensions from a Free text invoice on the customer payment settlement

Posted on by Microsoft Employee

When I post an free text invoice with financial dimensions assigned manually - I want those dimensions carried into the customer payment journal - however it appears the default values for the customer record are on the credit side of the transaction. Is it possible for the customer payment journal to inherit the fin dims from the original invoice?

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: How can I setup AR/GL/CB to inherit the financial dimensions from a Free text invoice on the customer payment settlement

    Hi G-Squared,

    During settlement, Dynamics AX will evaluate if there are differences in dimensions used on the customer transactions. If there are differences, these will be posted with zero effect on the ledger accounts; only to reverse the open balances per dimension value.

  • G-Squared Profile Picture
    G-Squared 244 on at
    RE: How can I setup AR/GL/CB to inherit the financial dimensions from a Free text invoice on the customer payment settlement

    If you use Centralized Payments in a central company to settle invoices in a related company, then you would have Due-to and Due-from entries.  But also, would you have the financial dimensions on the payment match up with the financial dimensions on the invoice?  If so, that seems like a solution.  FYI, I don't have an available environment to test.  Thanks.

  • G-Squared Profile Picture
    G-Squared 244 on at
    RE: How can I setup AR/GL/CB to inherit the financial dimensions from a Free text invoice on the customer payment settlement

    <Out of the box, there is no option to get financial dimensions defaulted on a payment journal from the invoice that will be settled. What if you would settle two invoices with a single payment line which has different dimensions?

    If the dimensions on the payment line are not provided or different compared to the invoice, the settlement job will create additional accounting entries to zero out open values per financial dimension. This is automatically and is possibly the better alternative for your requirement.>

    This is a helpful explanation for why the financial dimensions from an open customer transaction will not default to a payment journal.

    What is meant ny "settlement job will create additional accounting entries to zero out open values per financial dimension.".  What process is that?

    Thanks, Andre.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How can I setup AR/GL/CB to inherit the financial dimensions from a Free text invoice on the customer payment settlement

    Hello Joe,

    As Andre mentioned, the inheritence of the findims from the invoice to the payment journal does not work.

    What does, however, work is the inheritence of the description that is posted with the free text invoice.

    Some weeks ago I used something similar but for the customer reference.

    The customer reference is a field that you can find in the free text invoice header.

    You can include this field in the default description by referencing the free text invoice table.

    Please check this in the OrgAdmin module.

    Once this is done the customer reference that one enteres in the free text invoice will be recorded in the posting text and will be visible in the payment journal.

    If you could somehow enter the your findims in the customer ref. field then you have a workaround.

    Note: The cust ref. field is a field in the header. In other words, you will get only one single findim-account combination inherited. This workaround does not work at the line level.

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: How can I setup AR/GL/CB to inherit the financial dimensions from a Free text invoice on the customer payment settlement

    Hi Joe,

    Out of the box, there is no option to get financial dimensions defaulted on a payment journal from the invoice that will be settled. What if you would settle two invoices with a single payment line which has different dimensions?

    If the dimensions on the payment line are not provided or different compared to the invoice, the settlement job will create additional accounting entries to zero out open values per financial dimension. This is automatically and is possibly the better alternative for your requirement.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans