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

Account
AppliedToTxnRet
ARRefundCreditCard
Bill
BillingRate
AdditionalContactRet
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
CashBackInfoRet
Charge
Check
Class
Company
ComponentItemLineRet
ContactsRet
CreditCardCharge
CreditCardCredit
CreditMemo
CreditMemoLineGroupRet
CreditMemoLineRet
Currency
Customer
CustomerMsg
CustomerType
DataExtDef
DateDrivenTerms
DefaultUnitRet
Deposit
DepositLineRet
EarningsRet
Employee
Estimate
EstimateLineGroupRet
EstimateLineRet
ExpenseLineRet
InventoryAdjustment
InventoryAdjustmentLineRet
InventorySite
Invoice
InvoiceLineGroupRet
InvoiceLineRet
AdditionalNotesRet
BillingRatePerItemRet
ItemDiscount
ItemFixedAsset
ItemGroup
ItemGroupLineRet
ItemInventory
ItemInventoryAssembly
ItemInventoryAssemblyLineRet
ItemLineRet
ItemNonInventory
ItemOtherCharge
ItemPayment
ItemReceipt
ItemSalesTax
ItemSalesTaxGroup
ItemSalesTaxRefRet
ItemService
ItemSites
ItemSubtotal
JobType
JournalCreditLineRet
JournalDebitLineRet
LinkedTxnRet
OtherName
PaymentMethod
PayrollItemNonWage
PayrollItemWage
PrefillAccountRet
PriceLevel
PriceLevelPerItemRet
PurchaseOrder
PurchaseOrderLineGroupRet
PurchaseOrderLineRet
ReceivePayment
ReceivePaymentToDeposit
RelatedUnitRet
Report
SalesAndPurchaseRet
SalesOrPurchaseRet
SalesOrder
SalesOrderLineGroupRet
SalesOrderLineRet
SalesReceipt
SalesReceiptLineGroupRet
SalesReceiptLineRet
SalesRep
SalesTaxCode
SalesTaxPaymentCheck
SalesTaxPaymentCheckLineRet
ShipMethod
ShipToAddressRet
StandardTerms
Template
Terms
TimeTracking
ToDo
Transaction
Transfer
TransferInventory
TransferInventoryLineRet
UnitOfMeasureSet
Vehicle
VehicleMileage
Vendor
VendorCredit
VendorType
JournalEntry
LetSync Desktop operational tables
ListMerge
Schema Differences
Pay a Bill with CreditCardCharge/BillPaymentCreditCard
Pay a Bill with Check / BillPaymentCheck
ExternalGUID

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

Account
Bill
Bill Payment
Class
Company Currency
Company Info
Credit Memo
Customer
Customer Type
Department
Deposit
Employee
Estimate
Exchange Rate
Invoice
Item
Journal Entry
Payment
Payment Method
Purchase
Purchase Order
Refund Receipt
Reimburse Charge
Sales Receipt
Tax Classification
Tax Code
Tax Payment
Tax Rate
Tax Service
Tax Agency
Term
Time Activity
Transfer
Vendor
Vendor Credit
LinkedTxn
BillLineDetail
TxnTaxLineDetail
BillPaymentLineDetail
CreditMemoLineDetail
OtherAddress
ContactInfo
DepositLineDetail
EstimateLineDetail
InvoiceLineDetail
StatusInfo
ItemComponentLine
JournalEntryLineDetail
PaymentLineDetail
PurchaseLineDetail
PurchaseOrderLineDetail
AccountSubType
Item Type
ItemCategoryType
ItemServiceType
SpecialItemType
PaymentType
PaymentMethodType

View Categories

help
Docs
LetSync Online Tables schema
SpecialItemType

SpecialItemType

< 1 min read

FinanceCharge

ReimbursableExpenseGroup

ReimbursableExpenseSubtotal

What are your Feelings

Share This Article :

Still stuck? How can we help?

How can we help?

Name: *

Email: *

Message: *

Updated on March 12, 2025

Powered by BetterDocs