Skip to main content
Solved

Does anyone know of an I app to develop flat files to send over to third parties?


Hello,

 

We recently implemented acumatica.
We now need a way to extract invoice and sales data to send once a day to different integrators.

The files need to be in different formats such as csv, pipe delimited and/or tab delimeted.

The files need to be sent the files via FTP or SFTP
The extraction needs to be scheduled to run automatically

The extraction needs some logic to send only incremental data (new invoices or sales orders since last execution)

Best answer by asommer

There’s probably multiple ways to do this, but one way is the REST API: https://www.acumatica.com/blog/yes-we-have-an-api-for-that-an-introduction-to-the-acumatica-cloud-erp-apis/

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

4 replies

asommer
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 21 replies
  • Answer
  • February 14, 2023

There’s probably multiple ways to do this, but one way is the REST API: https://www.acumatica.com/blog/yes-we-have-an-api-for-that-an-introduction-to-the-acumatica-cloud-erp-apis/


Shawn Burt
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • 109 replies
  • February 14, 2023

not knowing for sure what you are wanting I would say Export Scenario’s.

You can export to a CSV or other formats and I believe you can schedule to sync those to FTP. not 100% on SFTP but think that is possible too.

 

https://openuni.acumatica.com//pdf/S125_Document_Management(V4.20).pdf

page 18


Forum|alt.badge.img+5
  • Captain II
  • 509 replies
  • February 14, 2023

As Shawn said, File Synchronization can use SFTP but you have to generate a certificate and package that up so you can upload it into Acumatica for use in the File Synch process. I found that process challenging to figure out - but it works.

Generating the CSV or flat file might just be an Export Scenario depending on the complexity of the layout.  If it is too complex, then you’ll want to consider creating your own Data Provider.

Figuring out what you last sent is a little trickier. You’ll need a way of limiting the output to only new transactions. Business Events and Push Notifications make use of temp tables to allow them to react to new/modified/deleted transactions - you might be able to leverage those.

Otherwise, part of me would be tempted to have an Exported flag on your transactions that is toggled when they’ve been packaged up - but that’s a little more complicated.


Shawn Burt
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • 109 replies
  • February 14, 2023

if you need full, New/Modified/Deleted you might prefer to use the webhook. Assuming your target can receive them, that process can push the update data to the webhook endpoint in realtime so you updates as they happen.


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