Quickbooks¶

First of all, you need to set up QuickBooks.

Administration > Parameters > Accounting Parameters

Before using the Quickbooks program, please install ‘Quickbooks Software Development Kit (SDK)’ on the client's PC (where Quickbooks will be used).
Please note that Quickbooks SDK on the client PC should be the same version as your QB application.
Quickbooks Data Location that is specified in Blindata Parameters should be accessible from both the server and client PC - eg. \\SERVER\Folder or C:\Folder (where C: is a mapped drive on both the server and client).

Switch on Quickbooks accounting and set the data path:

Please check the QuickBooks Tutorial for more information about available settings.

If you have any issue with the connection Blindata to QB, please check the link 1 and link 2 .

Re-check the parameters:

1. Add a Tax Code that will be equal to the values from the ‘Sales Tax Rates’ system table.

Create Supplier/Vendor:

To make the process easy, you can import/export the data from/into QuickBooks/Blindata then please check the Accounting Utilities.

Create Customer:

Set up QuickBooks preferences:

And then add items that you will be selling/buying:

Add QuickBooks Ref to the blind type and employee record:

When everything is finally done, create a sales order, produce it and then create a sales order:

‘Quickbooks Export’

There is a new ‘Quickbooks Export’ button in the ‘Order Amend Enquiry’ form.

This has a button permission setting in Administration > Users > Button Visibility (2) called ‘Quickbooks Export’.

The button will export a CSV for all filtered records.

The file layout is as follows:

Ref Number,Txn Date,Department,Private Note,Txn Status,CustomerRef,CustomerMemo,,LineTaxCode,Item Ref,Description,Price,Quantity,Amount,Sales Tax Code Ref
17485,2/1/2018,Hoboken,Good customer please ship asap,Pending,GZ Interiors,Great order thanks,,NON,MTRF-WIFIBRIDGE-KIT,Wi-Fi Control Bridge Kit,180,1,180,Sales Tax

Ref Number – this is the invoice number
Txn Date – invoice date
Department – department description
Private Note – Note field in order
Txn Status – sales tax code
CustomerRef – customer company name
CustomerMemo – not required
, - not required
LineTaxCode - sales tax code
Item Ref – Batch Num (from order detail line).
Description – Blind type description, fabric description, width x drop?
Price – net price (for quantity of 1)
Quantity – detail line quantity
Amount – net total
Sales Tax Code Ref – sales tax code

A software tool called Zed Axis will then be used to import the sales invoices to Quickbooks online.

https://support.zed-systems.com/kb/a197/import-invoices-into-quickbooks-online.aspx