Your final application framework

Visit QuickBooks

qb Access – uses the versatility of Intuit Developer Network (IDN), the Intuit Software Development Kit (SDK), the power of Microsoft Access Database and the flexibility of VBA class objects/code to provide you a roadmap & “real life”  samples of how to Read & Write to your QB data.  

Common uses of qb Access  includes:

• Data Conversions – Accounts, Customers, Vendors, A/R, A/P and Banking Beginning Balances.
• Special Reports – Create reports from your user defined fields.
• Data Fixes – Sales Tax fix, Remove Duplicate Transactions, Merges.

Your final application is the full qb Access framework stripped down to your unique needs.

Objects:

The full qb Access framework  includes the following QB Objects:

•           Account List and Entity Lists

Account, Customer, Vendor, Employee, Other Names

•           Item Lists

Inventory, Non-inventory, Inventory Assembly (Premier Edition and above), Service, Group, Payment, Discount, Sales Tax, Sales Tax Group, Other Charge, Subtotal, Fixed Asset

•           Simple Lists

Sales Tax Code (U.S. Edition), Class, Standard Terms, Date Driven Terms, Ship Method, Payment Method, Sales Rep, Job Type, Customer Type, Vendor Type, Customer Message, Template, To Do, Currency

•           Payroll Lists

Wage Payroll, Non-Wage Payroll

•           Accounts Receivable Transactions:

Invoice, Credit Memo, Receive Payment, Charge

•           Accounts Payable Transactions:

Vendor Credit, Bill, Bill Payment Check, Bill Payment Credit Card, Item Receipt, Sales Tax Payment

•           Non-Posting Transactions:

Purchase Order, Estimate, Sales Order (US Premier Edition and above)

•           Bank Transactions and Sales Receipts:

Check, Deposit, Sales Receipt

•           Credit Card Transactions:

Credit Card Charge, Credit Card Credit

•           Journal Entry

•           Time Tracking

•           Inventory Adjustment

•           USER DEFINED (Custom fields) access

Operations

qb Access  supports the following operations:

•           Query - obtains information about one or more objects according to specified criteria

•           Add - adds an object to QuickBooks

•           Modify - modifies an existing QuickBooks object

•           Delete - removes the list or transaction object from QuickBooks

•           Void - changes the transaction amount to zero but leaves a record of the transaction in QuickBooks (does not apply to list items)

qb Access Contents:

QB Object Tables, Query Request Tables and Return Data Tables and Queries – Quickbooks in a Relational Data Structure.

QB Object classes, Query Request classes and Return Data class samples – Table to Class, Form to Class, Class to Form, and Class to Table sample functions.

            QB to Access Sample Object Re-Sync Form and Routines

            Access to QB Sample Object Re-Sync Form and Routines

Class Creation Tool – turns a Table into a powerful Class Module with Table to Class, Form to Class, Class to Form, and Class to Table functions

What QuickBooks products does qb Access support?

qb Access supports QuickBooks Pro and above, Release 2002 and beyond