web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Export file from payme...
Microsoft Dynamics NAV (Archived)

Export file from payment journal

(0) ShareShare
ReportReport
Posted on by hpb1988 200

Hello experts

I need some help regarding exporting payments to bank file. When the file is generated the amount is missing. So how to I get the amount in the file, when exporting from a Payment journal? Some guides available  ?

*This post is locked for comments

I have the same question (0)
  • Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    How you are exporting the file??

  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    hi,

    try action menu (left-top corner in the page) --> print & send --> microsoft excel.

    or .. select all rows in the payment journal, right-click --> copy rows --> paste the rows in an empty excel doc.

    if that does not help, maybe it's a bug. check for hotfixes and updates.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    Apart from jonathan's suggestion you can just click the excel button in the page to export all the information to a excel file. ( Only the field in the page will be exported, so any field that has been hidden will not be exported)

  • hpb1988 Profile Picture
    hpb1988 200 on at

    I am using the Danish format which i born with. I am not sure the bank will accept an Excel file, but it is worth trying to see if the amount will be present in Excel. But do you know if there are any guides available about this subject? thanks for answering :)

  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    how do you export the data from the payment journal? using the excel button or a customization (additional not standard button with not standard function behind)? what kind of export file do you create (xls,csv, dat, edi, ...)? if it is a customization contact your developer team. the (only) standard export function is the excel button.

  • hpb1988 Profile Picture
    hpb1988 200 on at

    this might be special to the Danish version of NAV! This export of bankfile is standard in 2013R2 but i cant find any documentation of how it Works ? So what to do?

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    follow

    http://msdn.microsoft.com/en-us/library/hh173994(v=nav.71).aspx

    http://dynamicsuser.net/blogs/admin/archive/2013/10/10/cash-management-in-dynamics-nav-2013-r2-what-is-it-and-why-now.aspx

    result is: in nav 2013 r2 standard, there is no import/export functionality in the payment journal (i checked it). 

    it depends on the local version. in your case there is one, maybe developed by microsoft denmark.

    it seems you have found a bug or it is a configuration issue (Posting Exchange Definition and Posting Exchange Mapping).

    for more info read this:

    http://msdn.microsoft.com/en-us/library/dn495312(v=nav.71).aspx

    and contact your nav provider and/or microsoft denmark about that bug/issue.

  • hpb1988 Profile Picture
    hpb1988 200 on at

    Great job.. Now I got something to move on with! Great help so far

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans