Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / From which table does ...
Finance forum

From which table does Export format field picks up values in Module AP > Payment setup > Methods of payment form

(0) ShareShare
ReportReport
Posted on by amigup1982 150

Hello All,

I developed custom classes to print vendor payment file as per a regional format. I can see that various format files setup appears in a lookup in Method of payment form at AP > Payment setup > Methods of Payments form.

Please find screen shot below:-

0871.Untitled.jpg

I tried a lot to find from where this lookup field picks up these classes for export format but couldn't find.

If anyone has an idea please help me in finding it out.

Thanks & Regards,

Amit Ashok Gupta.

Categories:
Development / Customization / SDK
  • CU29041349-0 Profile Picture
    CU29041349-0 383 on at
    From which table does Export format field picks up values in Module AP > Payment setup > Methods of payment form
    Would you happen to know where the data formats for individual fields like date at stored or managed? I'm simply trying to modify the TransDate to a format of m/d/yyyy where the default appears to be YYYY/MM/DD.
  • amigup1982 Profile Picture
    amigup1982 150 on at
    RE: From which table does Export format field picks up values in Module AP > Payment setup > Methods of payment form

    Hello Ievgen,

    Thanks for valuable help. I found out the table which was showing the values in lookup for selection of methods of payment. The table is VendPaymFormat. ideally automatically my newly created classes must have got added to the table but strangely it didn't happened. I have to add them manually after which all went well and I am able to print files in Westpac New Zealand format.

    Thanks a lot :)

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: From which table does Export format field picks up values in Module AP > Payment setup > Methods of payment form

    NZ Westpac can be built base on AU Westpac format, it's not a big job if you know what to do. However, ER is not straight forward and requires quite a bit of learning. I don't know what exactly to change, but I know that we've done this for several customers without any issues.

  • amigup1982 Profile Picture
    amigup1982 150 on at
    RE: From which table does Export format field picks up values in Module AP > Payment setup > Methods of payment form

    Hello Ievgen,

    We as of now don't have electronic file format for New Zealand available out of the box for electronic payment. We are trying with Australian bank but till then keeping this backup ready which was there even in AX 2009 with the client.

    Do let me know if you have any reference for any vendor payment file that can fulfill electronic payment for Westpac New Zealand.

    Hence I created some classes extending the VendOutPaym and VendOutPaymRecord. But these classes are not available in the lookup for selection for method of payments in the form I mentioned.

    Hence I was trying to find if I am missing onto something.

    Thanks & Regards,

    Amit Ashok Gupta.

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: From which table does Export format field picks up values in Module AP > Payment setup > Methods of payment form

    You have hierarchy of classes direved from vendoutpaym class and you need to implement your own one. However, that's an old way, you need to look at ER functionality, it allows to create export format without writing a line of x++ code, there are multiple examples on docs and in the web.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,886 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,768 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans