Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Payment Journal

(0) ShareShare
ReportReport
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

  • Rebecca Rüdelstein Profile Picture
    130 on at
    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
    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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans