web
You’re offline. This is a read only version of the page.
close
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
I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    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.

  • amigup1982 Profile Picture
    amigup1982 150 on at

    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.

  • Mea_ Profile Picture
    Mea_ 60,284 on at

    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

    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 :)

  • CU29041349-0 Profile Picture
    CU29041349-0 604 on at
    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.

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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans