BillPaymentCheck

• 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. 

FIELD NAME	FIELD NAME (old)	QUERYABLE	UPDATEABLE	REQUIRED ON UPDATE	INSERTABLE	REQUIRED ON INSERT
TxnID		true	false	true	false	false
TimeCreated		true	false	true	false	false
TimeModified		true	false	true	false	false
EditSequence		true	false	true	false	false
TxnNumber		true	true	optional	false	false
PayeeEntityRef_ListID		true	false	optional	true	true
PayeeEntityRef_FullName		true	false	optional	true	true
APAccountRef_ListID		true	false	optional	true	optional
APAccountRef_FullName		true	false	optional	true	optional
TxnDate		true	true	optional	true	optional
BankAccountRef_ListID		true	true	optional	true	true
BankAccountRef_FullName		true	true	optional	true	true
Amount		true	true	optional	false	optional
CurrencyRef_ListID		true	false	optional	false	optional
CurrencyRef_FullName		true	false	optional	false	optional
ExchangeRate		true	true	optional	true	optional
AmountInHomeCurrency		true	false	optional	false	optional
RefNumber		true	true	optional	true	optional
Memo		true	true	optional	true	optional
Address_Addr1		true	false	optional	false	optional
Address_Addr2		true	false	optional	false	optional
Address_Addr3		true	false	optional	false	optional
Address_Addr4		true	false	optional	false	optional
Address_Addr5		true	false	optional	false	optional
Address_City		true	false	optional	false	optional
Address_State		true	false	optional	false	optional
Address_PostalCode		true	false	optional	false	optional
Address_Country		true	false	optional	false	optional
Address_Note		true	false	optional	false	optional
IsToBePrinted		true	true	optional	false	optional
ExternalGUID		true	true	optional	true	optional
UserData	user field
Operation	add, update, refresh, delete, void