Setting up LetSync Online and QuickBooks Online Integration 13 Reconnecting your QuickBooks Online account to LetSync Online Connecting your QuickBooks Online account to LetSync Online Disconnecting your QuickBooks Online account from LetSync Online Databases Tasks Reports Settings Users QuickBooks Online – LetSync Online Data Integration Overview Run Tasks/Reports On Demand
Getting Started LetSync Desktop 6 Starting LetSync Desktop Adding a QuickBooks company file Connecting your database Adding Tasks Running a task LetSync Desktop set up for new customers
Setting up LetSync Desktop 12 LetSync Desktop UI Taskbar Quickbooks company files Databases Tasks Settings Move License to another computer Restart LetSync Desktop QuickBooks company file re-Authorization Quantity of records to Request per Query
Scheduling task to run automatically 2 Scheduling task to run automatically Scheduling task using PowerShell
Database Schema LetSync Desktop 16 MySQL Connector/Net connection strings SQL Server connection strings Oracle connection strings There are five fundamental table types in the LetSync schema. These are: Primary Keys QuickBooks Desktop API Reference Schema – Relationships Schema – Indexes Schema – Working with Items Custom Fields
LetSync Desktop Tables schema 116 Account AppliedToTxnRet ARRefundCreditCard Bill BillingRate AdditionalContactRet BillPaymentCheck BillPaymentCreditCard BuildAssembly CashBackInfoRet
QuickBooks Desktop Reporting 3 Report: Payments With Invoices Report: Trial Balance QuickBooks Report Builder
LetSync Online Tables schema 51 Account Bill Bill Payment Class Company Currency Company Info Credit Memo Customer Customer Type Department