Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Cash Management - Export file

Posted on by Microsoft Employee

I need some general help with setup to use payment journal - to export payments to file.

The bank account is setup, vendor is setup with bank connected. 

What is this used for? I get a message when i try run the setup that i need to set this up. I get the information from the bank correct?

Udklip3.PNG

Bonus question, I need to do the export files in DKK (danish kroner) currency. What is needed to export it in DKK (I have done it in EUR succesfully)? I get error messages sometimes telling me something is wrong with the currency code. Even tough i have set DKK in following pages - bank account , vendor , vendors bank.

Udklip4.PNG

Thanks in advance

*This post is locked for comments

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Management - Export file

    Hi,

    Thats cool - thanks. So its both for Bank Acc. Reconciliation and the Export of payment files. So you get the username and password from the bank right?

    In the case of the number 2 screenshot, I have the same currency code in Bank Account, Vendor Card and Vendors Bank, but still get the message.

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Cash Management - Export file

    Hello,

    A global provider of services to convert bank data to any file format that your bank requires is set up and connected.

    You can use the Bank Data Conversion Service feature to have a bank statement file that you receive from your bank converted to a data stream that you can import into Microsoft Dynamics NAV.

    Reversely, you can use the conversion service to have payment information that you export as a data stream converted to a bank payment file in the format that your bank requires.

    See bellow link for more info.
    How to: Set Up Bank Data Conversion Service

    For your bonus question, you have to also setup Currency Code for 
    Vendor Card, Bank Account.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans