Skip to content

LetSync

QuickBooks Import & Export data | QuickBooks API Integration

Home
Trial Registration Forms
- LetSync Online
- LetSync Desktop
Shop
Contact Us
Forum
- Register here
- Password Reset
Help Center
My account

Release Notes

1

Release Notes

What is LetSync Desktop?

2

What is LetSync Desktop?
Watch Demo

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

Operations Guide LetSync Desktop

11

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

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

14

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

Updating QuickBooks

1

Overview of Updating QuickBooks

LetSync Desktop database schema. Alphabetical listed

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 Reporting

2

Report: Payments With Invoices
Report: Trial Balance

help
Docs
Database Schema LetSync Desktop
QuickBooks Reporting
Report: Trial Balance

Report: Trial Balance

You have to create a QuickBooks Report Task

What are your Feelings

Share This Article :

Still stuck? How can we help?

How can we help?

Name: *

Email: *

Message: *

Updated on December 17, 2021

Powered by BetterDocs