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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Payment journal Link t...
Microsoft Dynamics AX (Archived)

Payment journal Link to Excel

(0) ShareShare
ReportReport
Posted on by Abdo Khoury 14,855

When i doing my payment journal

I have a Transfer order in a certain excel format, is there a way to link (odbc or any other connection) to ax payment journal , certain dynamic fields(Like amount and bank details) so i can print my trasfer order from excel to send to the bank?

Regards 

*This post is locked for comments

I have the same question (0)
  • Praveen Profile Picture
    Praveen 1,201 on at
    RE: Payment journal Link to Excel

    You would need to customize the Bank transfer order file to pick up the details from AX payment journal, actually what you are looking for meets the requirements for the electronic payments using the Generate payments in payment journals.

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,855 on at
    RE: Payment journal Link to Excel

    well, yes i figured that,

    but i am unable to modify a fomat that already exist or create a new one from scratch ,

    can you advise how to modify or create a new format for the electronic payement

    i appreciate it very much

  • Suggested answer
    Praveen Profile Picture
    Praveen 1,201 on at
    RE: Payment journal Link to Excel

    To create a new format for Vendor payments, you would need to extend the VendOutPaym classes. You can see a lot of existing formats that are supported for Europe/America. Once your classes are instantiated from the generate payment functions, you can use a excel template file to create a new Bank transfer order file with all the payment related details to that vendor. This is a fair bit of customization and testing you would need to do in the electronic payments to get your format out exactly as per the recipient banks format, or else the files will not be accepted by the bank gateway.

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,855 on at
    RE: Payment journal Link to Excel

    Thank you for that feedback,

    is there some sort of Step-by-Step as to how this can be achieved?

    thank you for your feedback

  • Praveen Profile Picture
    Praveen 1,201 on at
    RE: Payment journal Link to Excel

    Unfortunately there are no specific documentations for the customization, you would need to do reverse engineer some of the standard classes i.e pertaining to VendOutPaym and related classes and extend it by creating your own class. Also if the export format needs to appear in the export file types, you would need to add the export format under the VendOutPaymRecord classes.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#1
Community Member Profile Picture

Community Member 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans