BillPaymentCreditCard

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtruefalsefalsefalsefalse
TimeCreatedtruefalsefalsefalsefalse
TimeModifiedtruefalsefalsefalsefalse
EditSequencetruefalsefalsefalsefalse
TxnNumbertruefalsefalsefalsefalse
PayeeEntityRef_ListIDtruefalsefalsetruetrue
PayeeEntityRef_FullNametruefalsefalsetruetrue
APAccountRef_ListIDtruefalsefalsetrueoptional
APAccountRef_FullNametruefalsefalsetrueoptional
TxnDatetruefalsefalseoptionaloptional
CreditCardAccountRef_ListIDtruefalsefalseoptionaloptional
CreditCardAccountRef_FullNametruefalsefalseoptionaloptional
Amounttruefalsefalsefalsefalse
CurrencyRef_ListIDtruefalsefalsefalsefalse
CurrencyRef_FullNametruefalsefalsefalsefalse
ExchangeRatetruefalsefalsetrueoptional
AmountInHomeCurrencytruefalsefalsefalsefalse
RefNumbertruefalsefalsetrueoptional
Memotruefalsefalsetrueoptional
ExternalGUIDtruefalsefalsetrueoptional
UserDatauser field
Operationadd,refresh,delete
  • AppliedToTxnRet

Paying a bill using BillPaymentCreditCard:

I am using the Sample Rock Castle Construction company sample file.

CreditCardCharge

TxnID = 123456
AccountRef_FullName = QuickBooks Credit Card
PayeeEntityRef_FullName = Thomas Kitchen & Bath (vendor)
RefNumber = 8059 (ref no of the bill)
Operation = add

ExpenseLineRet

AccountRef_FullName = Accounts Payable
Amount = 585.00
CustomerRef_FullName = Thomas Kitchen & Bath (CustomerRef must refer to a vendor (not to a customer))
PARENT_IDKEY = 123456

Go to LetSync Desktop and run Update and Refresh on CreditCardCharge

BillPaymentCreditCard

TxnID = 123456
PayeeEntityRef_FullName = Thomas Kitchen & Bath (vendor)
APAccountRef_FullName = Accounts Payable
CreditCardAccountRef_FullName = QuickBooks Credit Card
RefNumber = 8059 (ref no of the bill)
Operation = add

AppliedToTxnRet

TxnID = 5C90-1197713660 (bill original TxnID from QuickBooks)
Amount = 585.00
PARENT_IDKEY = 123456

SetCredit

CreditTxnID = 28CC0-1702698121 (creditcardcharge original TxnID from QuickBooks)
AppliedAmount = 585.00
Override = true
PARENT_IDKEY =5C90-1197713660 (TxnID that was put on the AppliedToTxnRet table)

Go to LetSync Desktop and run Update and Refresh on BillPaymentCreditCard

Powered by BetterDocs