View Source

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.

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

USE [DBSyncDB]

CREATE TABLE [dbo].[qbinvoice](
	[invoice_no] [nchar](10) NULL,
	[customername] [nchar](100) NULL,
	[item] [nchar](100) NULL,
	[itemdesc] [nchar](1000) NULL,
	[quantity] [nchar](10) NULL,
	[uom] [nchar](50) NULL,
	[salesprice] [nchar](10) NULL,
	[total] [nchar](10) NULL
) ON [PRIMARY]
GO