Skip to main content
Solved

File Synchronization from the Export Scenario's Data Provider

  • 7 February 2024
  • 4 replies
  • 149 views

kdavis45
Semi-Pro I
Forum|alt.badge.img+1

One of our clients is in the process of automating their ACH batches to auto-sync to the bank’s SFTP site.

I have the file sync settings saved in the data provider, but it isn’t being added as new ACH batches are generated. Is there an automated way to do this without customization and/or a business event/import scenario?

I’ve attached both the export scenario and data provider for reference. Thank you in advance!

Best answer by kdavis45

Update: I created a business event to auto-update the file sync setting and it’s working successfully. I was hoping that the data provider would automatically pass those settings along, but this solution covers what the client needs.

View original
Did this topic help you find an answer to your question?

4 replies

kdavis45
Semi-Pro I
Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • 41 replies
  • Answer
  • April 22, 2024

Update: I created a business event to auto-update the file sync setting and it’s working successfully. I was hoping that the data provider would automatically pass those settings along, but this solution covers what the client needs.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2516 replies
  • April 22, 2024

Thank you for sharing your solution with the community @kdavis45!


  • Freshman I
  • 2 replies
  • October 2, 2024

Hi Kristen,

So happy to find this as I’m attempting the same.

Do mind sharing how you did the business event?
I would really appreciate it!

 

Thank you.

 

Wendy Pratley

 


kdavis45
Semi-Pro I
Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • 41 replies
  • November 21, 2024

@Wpratley7 

This particular client needed cash account-specific SFTP links, so I setup several layers:

  1. We added remittance settings to the ACH payment method so the client can easily manage cash account-specific settings. (This is where I added the SFTP link.)
  2. I created a GI that combined the UploadFileWithIDSelector to CashAccount, then CashAccount to CashAccountPaymentMethodDetail to get the SFTP link specific to each file.
    1. This GI is conditioned to show files created from the AP305000 screen, created within the past week, and an empty last exported date.
  3. I created an import scenario to fill out the synchronization settings using a combination of the above GI and hard-coded values based on the client’s requirements.
  4. We combined it all via business event. Every business day, the business event runs the import scenario for all records in the GI.
    1. This runs on a schedule, but could theoretically also run when a record is added.

Here’s a quick reference to the import scenario:

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings