AyaNova parts data imported into QuickBooks

<< Click to Display Table of Contents >>

Navigation:  Mapping & Importing > How to import AyaNova data into QuickBooks >

AyaNova parts data imported into QuickBooks

The following identifies the information that is imported into the QuickBooks item from an AyaNova part:


If the information is not listed here, than it does not get imported.


NOTE the following:


You must select a QuickBooks COGS account, Income Account and a Asset Account when importing AyaNova parts into QuickBooks - see the example below.

All AyaNova parts are imported into QuickBooks as type  "inventory part"

The QuickBooks On Hand and Restock amount will be set to that of the total of all warehouses in AyaNova for that part

Serial Numbers from AyaNova are not imported into QuickBooks

Tax code in QuickBooks item is taken from QuickBooks defaults



1. Select to import/link Parts



2. Select one or more AyaNova parts as per How to import AyaNova data into QuickBooks



3. Drag and drop into the Drop here to import AyaNova item(s) which results in the confirmation question.



4. Now you need to select your QuickBooks COGS Account, your QuickBooks Income Account and your QuickBooks Asset Account so that these AyaNova parts you are importing into QuickBooks will be set with in QuickBooks.



5.  If for example, you have a bunch of parts that should have a specific Asset Account, than import only those at one time. And than import the rest that use a different Asset Account in the next batch so that you can select the specific Asset Account for those.




The fields of data that are imported from an AyaNova part object to a QuickBooks item object are:


 AyaNova part                        QuickBooks item


1.       Part Number                              Item Name/Number

2.       Part Display Format                    Description on Purchase

           (from Global Settings)                    / Description of Sales

3.       Cost                                          Cost

4.       Retail                                         Sales Price

5.       On Hand                                    On Hand

           (total from all warehouses)

6.       Restock                                     Reorder Point

           (total from all warehouses)



7.                                                        COGS Account  (set via QBI at time of import)

8.                                                        Income Account  (set via QBI at time of import)

9.                                                        Asset Account  (set via QBI at time of import)