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 / Microsoft Dynamics AX (Archived) / Is there a way to get ...
Microsoft Dynamics AX (Archived)

Is there a way to get a reference or account number to show up in the out of the box ACH file.

(0) ShareShare
ReportReport
Posted on by Brian Brown 365

For example if I was paying 4 different power bills that had 4 different account numbers how would one go about adding the account number as a reference number and then have it show up in the file so that the power company knew which account to apply the payment to.

Thanks,

Brian 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Brian,

    In the method of payment that is used / shown in your payment Journal, do you have the checkboxes "payment ID", "payment account" activated in the payment attributes section?

    If not, can you check if activating those Parameters fixes your Problem?

    Ludwig

  • Brian Brown Profile Picture
    Brian Brown 365 on at

    HI Ludwig,

    I just tested by checking those two attributes in the method of payment section setup and re-ran the process with account numbers filled in for the payment ID section and then when I opened up my export file I didn't see the account number that I added.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Brian,

    Have you entered a value in the payment reference field (probably manually)?

    If the payment reference field includes a value - not matter how it is entered in this field - is this value shown in the file that is created?

    If it is not included, can you let us know how your method of payment is Setup and what file type you selected?

    Ludwig

  • Brian Brown Profile Picture
    Brian Brown 365 on at

    This didn't work. How do I send you screen shots

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Brian,

    You can attach screen-prints via the rich formatting option just below the text box.

    I will certainly have a look but based on what I have checked so far I would guess that those fields are not included by default in the payment file generated and that you need a developer to make this adjustment.

    In addition to the screen-prints, can you also provide us your system version that you are using (please see e.g. community.dynamics.com/.../overview-of-microsoft-dynamics-ax-build-numbers)

    Thanks,

    Ludwig

  • Brian Brown Profile Picture
    Brian Brown 365 on at

    Method of Payment: VendAchPym

    Period: Invoice

    Grace Period:0

    Payment status: none

    payment type: Electronic payment

    File format section:

    Export format: NACHA (US)

    General File section:

    Account type: Bank

    Bank transaction type: ACH vendor

    type of draft: No draft

    Payment attributes:

    Payment ID

    kernel 6.2.2000.1377

    App 6.2.1000.4051

    Payment account

  • Brian Brown Profile Picture
    Brian Brown 365 on at

    Do you know what class that would control a reference to be populated into the out of the box ACH file

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Brian,

    I have not tested the process with your scenario yet as I just arrived back.

    Regarding the class and adjustment you asked for, please have a look at the following site that might help:

    stoneridgesoftware.com/modifying-electronic-payment-formats-in-ax-2012

    Best regards,

    Ludwig

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

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 November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans