Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Payment Journal

Posted on by 130

Hi,

we would like to setup the payment journal and the automated clearing.

The setup was done but now there is the problem that we create only one DTAUS for the bank and when we post the statement there is only a total and not the created journal so we would have to seperate it manually..Does anybody know how to get it right?

in advance

Rebecca

*This post is locked for comments

  • Re: Payment Journal

    Thanks Jens that helps a lot.Now i'm postiv that we can start using it.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    Re: Payment Journal

    Hi Rebecca,

    what you describe sounds like the standard way with posting the payment on a transfer account. You get one DTAUS, as a result you have only one balancing line in the payment journal. This amount is posted to the transfer account. When you post the bank account statement, you post against the transfer account. There is a prerequisite though (I assume you're talking about german banking in NAV): You have to set up the transfer account in the bank account posting group.

    As for the statement: Lots of banks are giving only one line for the DTAUS in the statement. Usually you wouldn't need more, because posting the payment journal would apply the invoices of the vendors, and you post the statement line against the transfer account. It is different for foreign payments, though.

    It is handy if you have GL Open Items Management for doing the reconciliation of the transfer account, especially if you have foreign payments too. In the german version you would need an Add-On like opPlus or Smart IT Open Items for this functionality, though.

    with best regards

    Jens

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans