Skip to content

LetSync

QuickBooks Import & Export data | QuickBooks API Integration

Home
Trial Registration Forms
- LetSync Desktop/Online
Shop – LetSync Desktop
Contact Us
Forum
Help Center
My account
Cart

Release Notes - LetSync Desktop

1

Release Notes

What is LetSync Desktop?

2

What is LetSync Desktop?
Watch Demo

Setting up LetSync Online and QuickBooks Online Integration

15

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
LetSync Online Outbound IP
Scheduler
Authorization Code
SQL Server Database Schema Create for QuickBooks Online
MySQL Server Database Schema Create for QuickBooks Online

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
Number of Days In Chunk
Quickbook’s little popup “login” message

Log Files LetSync Desktop

1

Log Files

Email Notification LetSync Desktop

1

Email Notification

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
Schema – Adding Tables and Fields
Schema – Report Tables
Update to QuickBooks Operations supported by tables
MariaDB Settings for LetSync Desktop
SQL Server LetSync Desktop Schema Create
MySQL Server LetSync Desktop Schema Create

Updating QuickBooks

1

Overview of Updating QuickBooks

LetSync Desktop Tables schema

116

QuickBooks Desktop Reporting

3

Report: Payments With Invoices
Report: Trial Balance
QuickBooks Report Builder

What is LetSync Online?

2

What is LetSync Online?
LetSync Online Outbound IP

LetSync Online Register

1

LetSync Online Register

LetSync Online Tables schema

58

View Categories

help
Docs
LetSync Desktop Tables schema
Terms

Terms

< 1 min read

FIELD NAME	FIELD NAME (old)	QUERYABLE
ListID		true
Name		true
TableName		true
UserData	user field

What are your Feelings

Share This Article :

Still stuck? How can we help?

How can we help?

Name: *

Email: *

Message: *

Updated on June 18, 2021

Powered by BetterDocs

Copyright © 2025 LetSync