How to setup QuickBooks / Myob accounts integration

Setting up QuickBooks integration

Idronic Account integration Interface

media_1308717507950.png

The above shows the default view for IAI once a clean install has taken place

Integration Setting

media_1308717523069.png

From the Setting Menu you can access the Integration settings!

Integration Settings options

media_1308717547710.png

Here you can choose to record a log for all the activities for various levels of messages and the schedule the frequencies at which the sync of data from LQ to QuickBooks will take place.

Accounting Options

media_1308717608404.png

The income Accounts is the sale account as it is set up into your QuickBooks File
Steel Account is the Cost of goods sold account as set up into your QuickBooks file for the raw steel purchases
Services Account relates to the purchases of services ( i.e. any subcontracted costs )
Spare Parts Account is cost of goods sold for Consumables and Spare Parts
Other is anything else that does not belong to the above descriptions ( cost of goods sold only )

Database List

media_1308718520967.png

This list refers to the LaserQuote database settings and multiple installs of LQ can be synced to one QuickBooks file

LQ server settings

media_1308718533790.png

Here you can enter the required LQ server settings :

  • Title – just give it a relevant name
  • User Name – this is the Mysql user name and it is usually “root”
  • Server Address – This has to point to the internal ip address of the server where LQ is installed
  • Password – Is the password you used when you installed the Mysql database on your server
  • Database Name – It is the name of the database in LQ – should always be “basdb”
  • Company name – this is the name of the table suffix for your LQ install and by default it should be “laserquote”

Sync

media_1308718550493.png

The actual sync takes place automatically at the time interval you set in the step above. You can however invoke a manual sync at anytime by selection the menu option above.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us