BillPaymentCheck

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtruefalsetruefalsefalse
TimeCreatedtruefalsetruefalsefalse
TimeModifiedtruefalsetruefalsefalse
EditSequencetruefalsetruefalsefalse
TxnNumbertruetrueoptionalfalsefalse
PayeeEntityRef_ListIDtruefalseoptionaltruetrue
PayeeEntityRef_FullNametruefalseoptionaltruetrue
APAccountRef_ListIDtruefalseoptionaltrueoptional
APAccountRef_FullNametruefalseoptionaltrueoptional
TxnDatetruetrueoptionaltrueoptional
BankAccountRef_ListIDtruetrueoptionaltruetrue
BankAccountRef_FullNametruetrueoptionaltruetrue
Amounttruetrueoptionalfalseoptional
CurrencyRef_ListIDtruefalseoptionalfalseoptional
CurrencyRef_FullNametruefalseoptionalfalseoptional
ExchangeRatetruetrueoptionaltrueoptional
AmountInHomeCurrencytruefalseoptionalfalseoptional
RefNumbertruetrueoptionaltrueoptional
Memotruetrueoptionaltrueoptional
Address_Addr1truefalseoptionalfalseoptional
Address_Addr2truefalseoptionalfalseoptional
Address_Addr3truefalseoptionalfalseoptional
Address_Addr4truefalseoptionalfalseoptional
Address_Addr5truefalseoptionalfalseoptional
Address_Citytruefalseoptionalfalseoptional
Address_Statetruefalseoptionalfalseoptional
Address_PostalCodetruefalseoptionalfalseoptional
Address_Countrytruefalseoptionalfalseoptional
Address_Notetruefalseoptionalfalseoptional
IsToBePrintedtruetrueoptionalfalseoptional
ExternalGUIDtruetrueoptionaltrueoptional
UserDatauser field
Operationadd,update,refresh,delete
  • RefNumber

If you want to set the RefNumber field when adding or updating a BillPaymentCheck record, the IsToBePrinted field needs to be set either to NULL or False

  • AppliedToTxnRet

Paying a bill using BillPaymentCheck:

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


BillPaymentCheck

TxnID = 123456
PayeeEntityRef_FullName = Thomas Kitchen & Bath (vendor name)
APAccountRef_FullName = Accounts PayableBankAccountRef_FullName = Checking
RefNumber = 8059
Operation = add


AppliedToTxnRet

TxnID = 5C90-1197713660 (Bill TxnID is the one that comes from QuickBooks, the real one)
TxnType = Bill
Amount = 585.00 (amount to apply no > than the total due)
PARENT_IDKEY = 123456

Create a task on LetSync Desktop “Update and Refresh” and run it. 

Powered by BetterDocs