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
View original
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/
+1
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
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.
+1
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
