Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 4
Next »
DBSync – Database to Quickbooks Integration
- Setup your Database for Integration with your Quickbooks file. For this Tutorial I will be using SQL Server Database Named "DBSyncDB".
- Create tables "qbcustomer" and "qbinvoice" in Database with following script.
CREATE TABLE [dbo].[qbcustomer](
USE [DBSyncDB]CREATE TABLE [dbo].[qbcustomer](
[name] [varchar](50) NULL,
[phone] [nchar](20) NULL,
[fax] [nchar](20) NULL,
[billingstreet] [varchar](200) NULL,
[billingcity] [varchar](50) NULL,
[billingstate] [varchar](50) NULL,
[billingcountry] [varchar](50) NULL,
[billingcode] [nchar](10) NULL,
[id] [nchar](50) NULL
) ON [PRIMARY]
GO