Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / 2016 ACH - Payment Jou...
Microsoft Dynamics NAV (Archived)

2016 ACH - Payment Journal 'Export' Function Issue

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good Morning.

The client is on NAV 2016

9.0, GIG6.00.01

9.0.42815.0

Upon attempting to create a test ACH payment file to submit to my client's bank, we are finding the 'Export' function is not working. When we click the button, nothing happens.

Note: I have run through this process in Cronus several times, so the we are more than familiar with the functionality.

All of the necessary setups have been checked several times:

  • Company Info -> Federal Tax ID No. field populated
  • Bank Card fields populated (Export and Sent files have read/write/delete permissions; paths end in " \ ". The "Remit" and "Export" files are defined. All bank routing and account information is populated).
  • All Vendor Bank Card fields populated ('Use for Electronic Payments' Boolean = Yes)

When we ran 'Suggest Vendor Payments', the journal populated. The 'Bank Payment Type' is "Electronic Payment".

In addition, the Payment Journal Batch of "ACH" has the 'Allow Payment Export' Boolean' checked. (Note: We have tried exporting with this both on and off).

We have tried to export the payment multiple times but nothing happens when we click the button. We don't get an error. Nothing happens.

The Export Payments Codeunit (# 10090) has not been modified.

Any suggestions would be greatly appreciated.

Thank you.

*This post is locked for comments

  • cbmagnet33 Profile Picture
    cbmagnet33 5 on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    From the Development environment locate Report Selections and Run. Add the V.Remittance Advice Report 10083. In the NAV Companies , You may also need to type Report Selections in the Search bar. Select Report Selection - Purch. Select Vendor Remittance Adv and select Report 10083. My problem I cannot produce the Electronic files for the RAs,, unless the user is a Super User.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    **RESOLVED**

    This is a known issue that was resolved in CU14:

    Cumulative Update 14 - December 2016

    381364

    When you try to export the North America EFT, no error message is displayed and nothing happens if no vendor remittance is selected in report selections in the North American version.

    mbs.microsoft.com/.../NAV2016AppHotfixOverview

    To fix, go into the ‘Report Selection –> Purchase’ and set the Vendor Remittance to Report ID 10083 – Export Electronic Payments.

    I tested this and it worked. The file now exports in my client's TEST database.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    Thanks. According to her video, the 'Payment Export Format' field is blank, which is how we have this set up in Cronus. And when that field is blank (in Cronus), I am able to export the file.

    In my customer's Test database, the export is not working when the field is blank. When I populate the field, I get an array of different errors.

    So what I'm trying to figure out (since Debugger only points us to the 'Payment Export Format' field, is why is the export file not creating, due to that field being blank, when it does not have to be populated in the first place? I'm looking specifically for object versions to compare.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    check this video

    www.youtube.com/watch

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    Note: I went back into Cronus and updated Bank Account: No.= ACH, the Bank Card -> Payment Export Format to "SEPACT". Next, I ran 'Suggest Vendor Payments' and pulled in an invoice. Now when I click the Export button, I receive the following error:

    "Payment Export Format must have a value in Bank Account: No.=WWB-OPERATING. It cannot be zero or empty."

    When I clear the field and run it again, the export function works.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    The best way to find is run through the debugger and check if there any setups or conditions it is failing to export the file. Compare it with Cronus.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    That field is blank in our Cronus database yet the file exports without a problem. What is the default option for US "NACHA" format? Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    Hello Suresh ~

    The 'Export Format' is set to "US" and the 'Payment Export Format' is blank. According to MSDN, the 'Payment Export Format' field should only need to be populated if the desired format is not country-specific, so it doesn't make sense that this would be a mandatory field.

    As I mentioned, testing this in Cronus worked fine; we're only having the issue in the customer's test database.

    The 'Exported to Payment File' is "No".

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    Bank ->  Payment Export Format defines you Bank Export/Import Setup and the Codeunit to run the process for exporting the file. You need to make sure you set that format appropiately.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: 2016 ACH - Payment Journal 'Export' Function Issue

    Do you have set the Payment Export Format on the Bank Account Card ? And can you xoom on the line and check if the Exported to Payment File is Set to true or false

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans