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

  • From: South Africa, Johannesburg
  • Registered: 07/15/2018
  • Posts: 4

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,273

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

3 Reply by michaelmandy (edited by michaelmandy 09/25/2025 08:53:31 am)

  • From: South Africa, Johannesburg
  • Registered: 07/15/2018
  • Posts: 4

Re: Help / Advice on Integrations

Hi Apmuthu,

Things seem to be going quite well:

We allow users to create their FA Account from within our system,   so that is automated,   then we run the FA system within our system via iframe so no need to login or out etc...

We do pull the required data direct from the DB

Next,   I need some help / advice on:

Exporting the Invoice
Emailing the Invoice
Voiding the Invoice

All above from within our System

what would be the best way to handle those functions?

Post's attachments

FAintsec.png 376.6 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,273

Re: Help / Advice on Integrations

Using iFrame for integration is generally not recommended as it may be used in a separate browser unless some session variables and parent frame's js/data are linked.
Exporting, EMailing and Voiding are separate activities that need on the fly generation and parameter checking before completion.
The URL for such actions will also be linked to session variables and logged in credentials as well besides the normal record ID info.
Command Line / bash utilities in batch mode too can be explored with dovetailed sequenced operation on specific URL usage.
Viewing the invoice in your iFrame is presently possible as alos the menu links. That should be enough to export and email the invoice when viewing it through the use of some external get variable to trigger such scripts.
New menu options in FA using some extensions too can be used to do the above.

apmuthu's Website