Skip to content

LetSync

QuickBooks Import - Export data | QuickBooks Online API Integration

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

Release Notes - LetSync Desktop

Release Notes

Setting up LetSync Online and QuickBooks Online Integration

Connecting QuickBooks Online Company File to LetSync Online
Disconnecting QuickBooks Online Company File from LetSync Online
Reconnecting QuickBooks Online Company File to LetSync Online
Authorization Code
LetSync Online Outbound IP
Users
QuickBooks Online – LetSync Online Data Integration Overview
SQL Server Database Schema Create Statement for QuickBooks Online
MySQL Server Database Schema Create Statement for QuickBooks Online

What is LetSync Desktop?

What is LetSync Desktop?
Watch Demo

Getting Started LetSync Desktop

LetSync Desktop setup for new clients
Activate LetSync Desktop License Key
Adding a QuickBooks Desktop Company File
Adding a QuickBooks Online Company File
Adding Databases
Adding Tasks
Running a Task

LetSync Desktop UI Operational Guide

Export QuickBooks Reports to Database
LetSync Desktop UI
Taskbar
Quickbooks Company Files
QuickBooks Company File re-Authorization
Databases
Tasks
Settings
Account
Restart LetSync Desktop
Move License to Another Computer
Quantity of records to Request per Query
Number of Days In Chunk
Populate Invoice by Range Date – QuickBooks

Log Files LetSync Desktop

Log Files

Email Notification LetSync Desktop

Email Notification

Scheduling task to run automatically

Scheduling task using PowerShell
Scheduling task to run automatically

Database Schema for QuickBooks Desktop

MySQL Server LetSync Desktop Schema Create
SQL Server LetSync Desktop Schema Create
MariaDB Settings for LetSync Desktop
Schema – Indexes
Schema – Relationships
Update to QuickBooks Operations supported by tables
QuickBooks Desktop API Reference
There are five fundamental table types in the LetSync schema. These are:
Primary Keys
Schema – Working with Items
Custom Fields
Schema – Adding Tables and Fields
Schema – Report Tables
SQL Server connection strings
MySQL Connector/Net connection strings
Oracle connection strings

Updating QuickBooks

Overview of Updating QuickBooks

LetSync Desktop Tables schema

SetCredit
Schema Differences
LetSync Desktop operational tables
Account
AdditionalContactRet
AdditionalNotesRet
AppliedToTxnRet
ARRefundCreditCard
Bill
Pay a Bill with CreditCardCharge/BillPaymentCreditCard
Pay a Bill with Check / BillPaymentCheck
Bill Custom Mapping
BillingRate
BillingRatePerItemRet
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
ExternalGUID
InventoryAdjustment
InventoryAdjustmentLineRet
InventorySite
Invoice
InvoiceLineGroupRet
InvoiceLineRet
ItemDiscount
ItemFixedAsset
ItemGroup
ItemGroupLineRet
ItemInventory
ItemInventoryAssembly
Item Assembly Subtable
ItemLineRet
ItemNonInventory
ItemOtherCharge
ItemPayment
ItemReceipt
ItemSalesTax
ItemSalesTaxGroup
ItemSalesTaxRefRet
ItemService
ItemSites
ItemSubtotal
JobType
JournalEntry
JournalCreditLineRet
JournalDebitLineRet
LinkedTxnRet
ListMerge
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

QuickBooks Desktop Reporting

Trial Balance Report
Profit and Loss Detail Report
Custom Transaction Detail Report (Payments With Invoices)
Sales by Item Summary Report
Open POs Report
QuickBooks Report Builder

What is LetSync Online?

LetSync Online Outbound IP
What is LetSync Online?

LetSync Online Register

LetSync Online Register

LetSync Online Tables schema

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

QuickBooks Online Integration

Setting up the QuickBooks Online integration

View Categories

help
Home
LetSync Desktop UI Operational Guide
Export QuickBooks Reports to Database

Export QuickBooks Reports to Database

Report: Open Purchase Orders. Read More

What are your Feelings

Share This Article :

Still stuck? How can we help?

How can we help?

Name: *

Email: *

Message: *

Populate Invoice by Range Date – QuickBooks LetSync Desktop UI