OpenSync

Home Forums OpenSync Unable to update receivepayment table

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

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

    tech.support
    Participant

    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?

    #63413

    tech.support
    Participant

    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?

    #63415

    Yudel Rosales
    Keymaster

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

    #63416

    tech.support
    Participant

    The table name is receivepayment

    #63417

    Yudel Rosales
    Keymaster

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

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

You must be logged in to reply to this topic.