Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

AR matching transactions

Posted on by 582

Hi. We frequently need to match debits and credits in our AR sub-ledger.  We do this by creating multiple payments journals.. We would like to be able to create one payments journal that has an amount of 0 (zero) and proceed to match debits and credits.   AX though won't allow a payments journal with a 0 amount.   Is there a simpler method in AX of matching these debits and credits? IS there a way of enabling a zero payment journal?

Cheers

*This post is locked for comments

  • Hendo Profile Picture
    Hendo 582 on at
    RE: AR matching transactions

    Hi Andre

    As  you would expect, this issue is all about matching transaction where the sum of the matching transactions is zero.  You suggestion works fine.  I'm waiting on a response from our Accts department.  I'll mark this as complete.  Thanks.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR matching transactions

    Hello James,

    I know 2 different ways to do settmlment in AX :

    1. From payment journal, lines /go to function /settlment

    2. From customer or vendor sheet / Invoice / Settle open transactions

    Hope this is helpful.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR matching transactions

    Hello James Henderson,

    Just wondering whether this issue has been resolved or whether some additional support/Information is required.

    Would be great if you could keep us updated here.

    Many thanks,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR matching transactions

    Hi James Henderson,

    When you record customer payments aren't your open transactions directly marked and automatically settled with the posting of the customer payment journal?

    Best regards,

    Ludwig

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    RE: AR matching transactions

    Hi James,

    If the purpose of doing this is settling open transactions, you can execute the settlement starting from the customer form. Use the menu item 'Edit as open transactions'.

    Otherwise explain what this proces is about. Possibly you can use a general journal instead of a payment journal.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans