Home Forums OpenSync Unable to update receivepayment table

This topic contains 4 replies, has 2 voices, and was last updated by  Yudel Rosales 2 years, 10 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
  • #63412

    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?


    Yudel Rosales

    QuickBooks API doesn’t support ADD, UPDATE or UPDATE on paymentmethod table. Sorry for the inconveniences.


    The table name is receivepayment


    Yudel Rosales

    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 TxnID’s.
    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
    PaymentMethod ListID or FullName

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

    DiscountAccount ListID or FullName
    IDKEY (Required) – Links to TxnID from BillPaymentCheck or CreditCard table.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.