How to import AyaNova data into QuickBooks

Top  Previous  Next

If you have just finished configuring QBI for the first time, after the following message

 

15nowneedtomapbetween

 

QBI will open to the Map/Import screen defaulting to the Clients objects.

 

Or if you need to import objects at any time, select the menu Tools, than Map and import to open the Map/Import screen which defaults to showing the AyaNova clients on the left and QuickBooks customers on the right.

 

toolsmapimport

 

 

 

Select the menu Object to drop down to select which objects you want to import

 

 

objects-vendors-wholesalers

 

 

 

Only AyaNova clients and/or vendors can be imported into QuickBooks.

 

Note when importing an AyaNova vendor into QuickBooks,  the QuickBooks vendor type is not set as the vendor type set in the AyaNova vendor because in QuickBooks you could have set up any vendor type, whereas AyaNova vendor types are pre-set.

 

AyaNova parts or rates can not be imported into QuickBooks because QuickBooks requires a specific account to be selected for each part or rate which is not possible to set via QBI at the time of import.

 

AyaNova Tax Codes are not importable into QuickBooks. An invoice in QuickBooks created via QBI uses the tax codes set up for its Items - it does not refer to the tax code selected in the AyaNova service workorder.

 

 

 

Basic steps to import

 

1.Click and hold down on the object indicator (the square to the left of the AyaNova client or vendor) <you will note that the object indicator now shows an arrow within it>

dragayanovatoqbimport1

2.Now drag it to the Drop here to import AyaNova item(s) <you will note that your cursor changes to a cursordrag while being dragged>

dragayanovatoqbimport2

3.Release over the Drop here to import AyaNova item(s) and confirmation that you want to import will display.

dragayanovatoqbimport3

4.You can also import multiple AyaNova items at one time by select the first AyaNova client or vendor and than holding the SHIFT key when you select the last AyaNova client or vendor <note how all from the first selected to the last are highlighted>. And than drag and drop as above.

dragayanovatoqbimport5

5.Or select the first AyaNova item, hold the CTRL key and select more AyaNova items <note how only the items selected are highlighted>. And than drag and drop as above.

dragayanovatoqbimport4

 

NOTE - QBI only obtains QuickBooks and AyaNova information when QBI first loads - so if you enter new information into either QuickBooks or AyaNova with QBI running - QBI will not be aware of it. You will need to close QBI and restart it.