D365 Finance & Operations and Dynamics AX Forum

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------

When automation is required, we usually work with an ISV called SK Global  that specializes in banking processes:  https://sksoft.com/dynamics-ax/treasury-automation/vendor-payment-automation/

I'm sure that it's possible to build it using other tools as well.

------------------------------
Shirley Adams
AKA, an HSO company
------------------------------

Original Message:
Sent: Mar 25, 2021 05:13 PM
From: Justin Cooper
Subject: ACH & Positive Pay Processing

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------

Thank you, Shirley. We actually have a demo scheduled with SK Global next week. I was curious on if there were any other alternatives out there, just to have some options when making a decision.

------------------------------
Thank you,
Justin Cooper
------------------------------

Original Message:
Sent: Mar 26, 2021 08:59 AM
From: Shirley Adams
Subject: ACH & Positive Pay Processing

When automation is required, we usually work with an ISV called SK Global  that specializes in banking processes:  https://sksoft.com/dynamics-ax/treasury-automation/vendor-payment-automation/

I'm sure that it's possible to build it using other tools as well.

------------------------------
Shirley Adams
AKA, an HSO company

Original Message:
Sent: Mar 25, 2021 05:13 PM
From: Justin Cooper
Subject: ACH & Positive Pay Processing

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------

Justin,

Agreed with Shirley, the SK Global ISV is the most preferable route in my experience. The majority of the clients I work with leverage SK.

If you're seeking an alternative method, you'll most likely end up requiring a Logic App that takes the file export from D365 and uploads it via SFTP to your bank's server or another file share.

------------------------------
Ian Gorman, PMP, MCSE
MCA Connect
Solution Architect
------------------------------

Original Message:
Sent: Mar 25, 2021 05:13 PM
From: Justin Cooper
Subject: ACH & Positive Pay Processing

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------

In the past I implemented ACH payment in D365.
It's out of the box, and is quite robust.

For positive pay, there seems to be out of the box functionality described here (I have not implemented it myself)
https://docs.microsoft.com/en-us/dynamics365/finance/accounts-payable/set-up-generate-positive-pay-files

While the SKG product is good and popular, it probably make sense to assess the out of the box options as well

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC
------------------------------

Original Message:
Sent: Mar 25, 2021 05:13 PM
From: Justin Cooper
Subject: ACH & Positive Pay Processing

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------

I'm in the process of setting up ACH for both U.S. NACHA and European SEPA Credit payments. The main issue with the out of the box solution seems to be a lack of support for sending remittance details, at least on the NACHA side. D365 supports CCD and CTX file formats, but without any addenda detail. This is severely limiting. I haven't gotten far enough on the SEPA side to see if addenda are supported there, but I highly doubt it. If the data is available to be printed on a check stub, it should be available to the ACH file creation.

This is something I posted to Microsoft Ideas back in 2019, and it still isn't in. I'd appreciate any votes you folks would give it. Microsoft Idea · Add support for addenda lines to NACHA CCD+ and CTX file formats (dynamics.com)

------------------------------
Steve Latta
Accountant
Ortec, Inc.
Easley SC
------------------------------

Original Message:
Sent: Mar 29, 2021 12:51 AM
From: Zvika Rimalt
Subject: ACH & Positive Pay Processing

In the past I implemented ACH payment in D365.
It's out of the box, and is quite robust.

For positive pay, there seems to be out of the box functionality described here (I have not implemented it myself)
https://docs.microsoft.com/en-us/dynamics365/finance/accounts-payable/set-up-generate-positive-pay-files

While the SKG product is good and popular, it probably make sense to assess the out of the box options as well

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Mar 25, 2021 05:13 PM
From: Justin Cooper
Subject: ACH & Positive Pay Processing

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------

Hi Steve!

Easley isn't too far from me, just relocated to Five Forks ;)!

Check out this blog, which leverages out of the box functionality to send payment advice to vendors: https://vamsipraneethdax.blog/2020/08/09/emailing-payment-advice-using-batch-job-and-print-management-configuration-in-dynamics-365-finance/

I also have built a modification for similar functionality over at MCA Connect. If you ever want to sync up, let me know!

------------------------------
Ian Gorman, PMP, MCSE
MCA Connect
Solution Architect
------------------------------

Original Message:
Sent: Mar 30, 2021 08:30 AM
From: Steve Latta
Subject: ACH & Positive Pay Processing

I'm in the process of setting up ACH for both U.S. NACHA and European SEPA Credit payments. The main issue with the out of the box solution seems to be a lack of support for sending remittance details, at least on the NACHA side. D365 supports CCD and CTX file formats, but without any addenda detail. This is severely limiting. I haven't gotten far enough on the SEPA side to see if addenda are supported there, but I highly doubt it. If the data is available to be printed on a check stub, it should be available to the ACH file creation.

This is something I posted to Microsoft Ideas back in 2019, and it still isn't in. I'd appreciate any votes you folks would give it. Microsoft Idea · Add support for addenda lines to NACHA CCD+ and CTX file formats (dynamics.com)

------------------------------
Steve Latta
Accountant
Ortec, Inc.
Easley SC

Original Message:
Sent: Mar 29, 2021 12:51 AM
From: Zvika Rimalt
Subject: ACH & Positive Pay Processing

In the past I implemented ACH payment in D365.
It's out of the box, and is quite robust.

For positive pay, there seems to be out of the box functionality described here (I have not implemented it myself)
https://docs.microsoft.com/en-us/dynamics365/finance/accounts-payable/set-up-generate-positive-pay-files

While the SKG product is good and popular, it probably make sense to assess the out of the box options as well

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Mar 25, 2021 05:13 PM
From: Justin Cooper
Subject: ACH & Positive Pay Processing

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------

you got my vote :)

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC
------------------------------

Original Message:
Sent: Mar 30, 2021 08:30 AM
From: Steve Latta
Subject: ACH & Positive Pay Processing

I'm in the process of setting up ACH for both U.S. NACHA and European SEPA Credit payments. The main issue with the out of the box solution seems to be a lack of support for sending remittance details, at least on the NACHA side. D365 supports CCD and CTX file formats, but without any addenda detail. This is severely limiting. I haven't gotten far enough on the SEPA side to see if addenda are supported there, but I highly doubt it. If the data is available to be printed on a check stub, it should be available to the ACH file creation.

This is something I posted to Microsoft Ideas back in 2019, and it still isn't in. I'd appreciate any votes you folks would give it. Microsoft Idea · Add support for addenda lines to NACHA CCD+ and CTX file formats (dynamics.com)

------------------------------
Steve Latta
Accountant
Ortec, Inc.
Easley SC

Original Message:
Sent: Mar 29, 2021 12:51 AM
From: Zvika Rimalt
Subject: ACH & Positive Pay Processing

In the past I implemented ACH payment in D365.
It's out of the box, and is quite robust.

For positive pay, there seems to be out of the box functionality described here (I have not implemented it myself)
https://docs.microsoft.com/en-us/dynamics365/finance/accounts-payable/set-up-generate-positive-pay-files

While the SKG product is good and popular, it probably make sense to assess the out of the box options as well

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Mar 25, 2021 05:13 PM
From: Justin Cooper
Subject: ACH & Positive Pay Processing

Hi,
We are looking for a way to have our ACH & Pos. Pay files get sent over to our banks automatically after getting generated, without end user interaction of the file(s). Does anyone know if there is any sort of out of the box functionality for this or integration with sFTP services?

------------------------------
Thank you,
Justin Cooper
------------------------------