Skip to content
LetSync

QuickBooks Import & Export data | QuickBooks API Integration

  • Home
  • Trial Registration Forms
    • LetSync Desktop
  • Shop
  • Contact Us
  • Forum
    • Register here
    • Password Reset
  • Help Center
  • My account
    • Privacy Policy
    • End-User Subscription Agreement (EULA)
    • Refund Policy
Release Notes

Release Notes

1
  • Release Notes
What is LetSync Desktop?

What is LetSync Desktop?

2
  • What is LetSync Desktop?
  • Watch Demo
Getting Started LetSync Desktop

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

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

Log Files LetSync Desktop

1
  • Log Files
Email Notification LetSync Desktop

Email Notification LetSync Desktop

1
  • Email Notification
Scheduling task to run automatically

Scheduling task to run automatically

1
  • Scheduling task to run automatically
Database Schema LetSync Desktop

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

Updating QuickBooks

1
  • Overview of Updating QuickBooks
LetSync Desktop database schema. Alphabetical listed

LetSync Desktop database schema. Alphabetical listed

115
  • 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
Tables Functions Summary SDKQBConnection DLL

Tables Functions Summary SDKQBConnection DLL

24
  • Events
  • Accounts
  • Customers
  • Employees
  • Estimates
  • InventoryAdjustments
  • Invoices
  • ItemDiscounts
  • ItemFixedAssets
  • ItemGroups
  • ItemInventories
  • ItemInventoryAssemblies
  • ItemNonInventories
  • ItemOtherCharges
  • ItemPayments
  • ItemReceipts
  • ItemSalesTaxes
  • ItemSalesTaxGroups
  • PurchaseOrders
  • TimeTrackings
  • Vendors
  • ItemListObject
  • Preferences
  • SDKQBConnection DLL set up for new customers
QuickBooks Reporting

QuickBooks Reporting

2
  • Report: Payments With Invoices
  • Report: Trial Balance
  • help
  • Docs
  • Getting Started LetSync Desktop

Getting Started LetSync Desktop

  • Starting LetSync Desktop
  • Adding a QuickBooks company file
  • Connecting your database
  • Adding Tasks
  • Running a task
  • LetSync Desktop set up for new customers
Copyright © 2023 LetSync