Monday, April 4, 2011

Integration of Quick Books Pro 2011 with OpenERP V6.0


Quick Books Integration Process
==========================
  • I have created a module named "quickbooks_ippids" .
  • This module will import the customers and vendors data in to openerp.
  • Following are the steps to import the data.
Step 1 :
======
  • First of all , install this module in to the system.
  • Click on the Start Configuration when installed the module and set the token and realm id for the company.
  • For test purpose you can use :
    •        Token = 'd573nmwdnmfki9dwhs49rchv8csa'
    •         Realm ID = '199646053'
Step 2 :
======
  • Now click on Administrations->QuickBooks->Import Datas (Wizard)
  • Enter the workplace login and password and also select the option for import the datas.
  • For test purpose you can use :
    •         login = apa@tinyerp.com
    •         password = 9879123679
  • Select the options those you want to import the data from quickbooks.
  • Now click on import button.
About fields map :
===============
  • I have created this module and it will automatically installed when you install quickbooks_ippids module.
  • Here,you have to define a dictionary which maps quickbook's fields with openerp fields.
  • you have to written this dictionary in map_fields.py file
  • For example,
            {'res.partner':
                 {'name':'Name',
                     'active':'Active',
                     'qb_ref':'Id',
                     'address':
                         {'Address':
                             {'name':'Line1',
                               'street':'Line2',
                               'street2':'Line3',
                               'city':'City',
                               'state_id':'CountrySubDivisionCode',
                               'country_id':'Country',
                               'zip':'PostalCode',
                               'partner_id':'ShowAs',
                               'type':'Tag',
                               'phone':'Phone',
                               'mobile':'Phone',
                               'fax':'Phone',
                               'email':'Email'
                               },
                           },
                   },
              }









4 comments:

  1. where is the download link for this module?

    ReplyDelete
  2. I installed the module, but it reported an error when i had used.

    Does it work with quickbooks online?

    ReplyDelete
  3. was anyone able to find this module?

    ReplyDelete