This topic contains 4 replies, has 2 voices, and was last updated by Yudel Rosales 2 years, 10 months ago.
Hi team,
We were trying to update data in the receivepayment table. Has it been disabled, as we could do it in earlier versions of OpenSync but not now?
Also we were unable to delete payments as we received below messages:
Cannot delete the object specified by the id = “XXXXXXXXXXXX”. QuickBooks error message: Did not delete this transaction. This transaction had deposited payments.
What needs to be done to delete/ update the payments?
QuickBooks API doesn’t support ADD, UPDATE or UPDATE on paymentmethod table. Sorry for the inconveniences.
The table name is receivepayment
Note: If you wish to apply your receive payment to a specific transaction you will have to have the TxnID of the transaction you wish to apply the payment to. This can be achieved one of two ways:
By initially creating the transaction using ABU (as opposed to using the QuickBooks user interface).
By using OpenSync or AccessBooks RealTime to extract your transaction data and their corresponding TxnIDs.
The alternative is to apply the receive payment to the oldest unpaid transactions for that customer. This does not require the extraction of the specific transaction ID’s and can be performed by entering “APPLYALL” in the EditSequence field.
Supported Fields
– ReceivePayment Table
ARAccount ListID or FullName
Customer ListID or FullName (Required)
DepositToAccount ListID or FullName
TxnID (Required) Links to IDKEY from AppliedToTxn table
Memo
PaymentMethod ListID or FullName
RefNumber
TxnDate
TotalAmount
– AppliedToTxn Table
You should only have to populate the IDKEY field as all the fields in this table are transactions which already exist in QuickBooks.
Amount
TxnID
DiscountAccount ListID or FullName
DiscountAmount
RefNumber
TxnDate
IDKEY (Required) Links to TxnID from BillPaymentCheck or CreditCard table.
You must be logged in to reply to this topic.