1 Topic by michaelmandy (edited by michaelmandy 09/07/2025 09:10:05 am)

  • From: South Africa
  • Registered: 07/15/2018
  • Posts: 3

Topic: Help / Advice on Integrations

Hi All,

I am looking for some help / advice on the best way to integrate our Transport Management System with FrontAccounting!

Obviously the integration wont be the same as Xero or QBO as we have access to the system and DB

I need to know the best ways to connect to the different sections so i can get things ready for our developers!

Best ways to connect to:

1.   Customers, Suppliers, Items / Services, Fixed Assets (Vehicles), Users (Staff / Drivers)
(having access to the db etc.. Direct to DB connection or api?)

2.   We will Create, and Email the Invoices with attachments from within the Transport Management System)
(Advice  on Best way to Handle that? direct or api) (also to ensure all steps / processes are followed etc...)

3.   We will use the Direct Invoice to Create the Invoices!

Post's attachments

f1.png 277.7 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,270

Re: Help / Advice on Integrations

Assuming you have a local MySQL/PHP or equivalent application for your Transport Management Solution (TMS) that has it's own database.
Create a read only view that takes the data from some SQL query in the FA database. Now tailor your application in your TMS to partake of the necessary FA data from within itself (RO views).

apmuthu's Website