Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
The client is on NAV 2016
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:
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.
While the Bank Card -> 'Export Format' is set to "US", we were able to find (through the assistance of a developer) that the export file is not creating because the Bank Card -> 'Payment Export Format' field is blank. This appears to be a bug of some sort as we should not need to populate this field.
I populated the field and that created a whole slew of messages prompting us to add an IBAN, etc. This is not a foreign bank account. This is a US customer attempting to pay US vendors using a US bank.
The database contains NA objects. I'm curious as to if there are any ideas out there as to what might be triggering these issues? As stated earlier, we were able to set this up in Cronus and execute the functionality with no issues.
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
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.
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".
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!
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.
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.
check this video
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.
This is a known issue that was resolved in CU14:
Cumulative Update 14 - December 2016
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.
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.
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.
Business Applications communities