Skip to main content
Answer

How to import data from bank to acumatica using SOAPAPI

  • November 13, 2022
  • 3 replies
  • 110 views

Michael Ndungi
Varsity I
Forum|alt.badge.img

how can I use SOAP APIs to import payments from bank to acumatica. 

Best answer by Dmitrii Naumov

@development93 The standard Acumatica workflow for this is to import bank statements as OFX files.

Then, on the Process Bank Transactions screen you can match records that have their counterparts in Acumatica and create payments for the ones that do not have them.

 

See more here:

https://help-2022r2.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=c9810aa3-dbf2-41fb-a260-eaeb6c4e91e9

3 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • November 13, 2022

First of all, I don’t think using SOAP is the right approach since Acumatica is going to stop SOAP support in some time. 

Second, it really is a very vague question. Depends on what bank, what exact data you need to transfer, etc.

 

I’d recommend to check the existing integrations first, see here: https://help-2022r2.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=cced4b81-106f-4c06-9769-6d4fd9f22e0d


Michael Ndungi
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • November 15, 2022

First of all, I don’t think using SOAP is the right approach since Acumatica is going to stop SOAP support in some time. 

Second, it really is a very vague question. Depends on what bank, what exact data you need to transfer, etc.

 

I’d recommend to check the existing integrations first, see here: https://help-2022r2.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=cced4b81-106f-4c06-9769-6d4fd9f22e0d

Thank you so much for your response. The link was really helpful.

The update about SOAP is really helpful. Would appreciate any ideas on the way forward, probably will use REST APIs.  Basically the project is about ,customization to Import bank payments (made by customers) directly from the bank and apply them to Invoices using an Import scenario in Acumatica.

Any helpful ideas on how to go along with this?


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • Answer
  • November 15, 2022

@development93 The standard Acumatica workflow for this is to import bank statements as OFX files.

Then, on the Process Bank Transactions screen you can match records that have their counterparts in Acumatica and create payments for the ones that do not have them.

 

See more here:

https://help-2022r2.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=c9810aa3-dbf2-41fb-a260-eaeb6c4e91e9