OpenSync

Home Forums OpenSync Unable to delete credit card transactions

This topic contains 12 replies, has 2 voices, and was last updated by  Yudel Rosales 1 month, 2 weeks ago.

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • #64771

    Mark
    Premium Member

    We have a company credit card that needs to be resynced and we want to quickly purge all the transactions for a range so we can re-import.

    update creditcardcharge set Status = ‘DELETE’ where AccountRef_FullName = ‘Credit Card:Chase Credit Card’ AND DATE(TxnDate) BETWEEN ‘2018-01-01 00:00:00’ AND ‘2018-12-31 00:00:00’;

    We’ve made a ‘Update to QuickBooks’ task
    Selected Tables:
    Account
    Bill Payment Credit Card
    Charge
    Credit Card Charge
    Credit Card Credit
    Transaction

    When running the task, the following error occurs:
    —————————
    OpenSync
    —————————
    You have selected to run a task which updates records to QuickBooks but no records have their status column set. The status column must be set to either ADD, UPDATE, or DELETE in order for OpenSync to process records back to QuickBooks.
    —————————
    OK
    —————————

    #64772

    Mark
    Premium Member

    We’ve also tried doing an Update to QuickBooks task where ‘All Tables’ are selected.

    And we get the same error.

    #64786

    Mark
    Premium Member

    From your website

    “Sign up for a premium forum support and expect replies to all new topics within 23.9 business hours – although we usually respond much sooner”

    While I don’t expect a 5 minute response when paying $100 for support. You do specifically say you’ll respond within one business day and so far this is not the case and never has been since we initially paid for support. I give the current support level 1 star.

    Can we please get help here?

    Also… I would GLADLY pay $399 for your premium email support if you can provide what you say. But! The support response time has been so slow on the forums, that I fear it will be a waste of money and we’ll never hear from you even though we paid!

    Please prove me wrong and respond to our issues with at least an initial investigation.

    If you can restore your reputation on by working on all these fine folk’s issues that are waiting for responses including ours, we will immediately purchase your premium email support.

    Here are the conditions:
    – Please respond to every open issue that’s been on the forums for more than 24 hours, including those from standard customers
    – Please delete the spam located at: https://synergration.com/forums/topic/how-to-recover-google-account-password-2/
    https://synergration.com/forums/topic/cant-add-customer-notes/ needs a response
    https://synergration.com/forums/topic/opensync-browser-rows-and-columns-are-all-blank/ needs a response
    https://synergration.com/forums/topic/error-3265/ needs a response
    https://synergration.com/forums/topic/duplicate-record-problem-with-additionalnotesdetail-table/ needs a response (this issue has been open since September!)
    https://synergration.com/forums/topic/how-to-fix-google-not-working-on-android/ spam post needs to be deleted
    https://synergration.com/forums/topic/access-table-not-being-updated/ needs to be responded to
    https://synergration.com/forums/topic/application-access-to-qb-after-it-is-removed-from-the-list-how/ needs to be responded
    https://synergration.com/forums/topic/vendor-fields/ needs to be responded
    https://synergration.com/forums/topic/access-table-not-being-updated/ needs to be responded

    If this is completed within the next 48 hours, then I’ll give it a shot and try your premium email support.

    #64787

    Yudel Rosales
    Keymaster

    I don’t see that you paid for premium customer support. If you did, please provide order number to update your status. Other wide we have a week to answer your posts.

    #64788

    Yudel Rosales
    Keymaster

    QuickBooks API doesn’t support DELETE for neither credit card charges/credits table. If you click on your database on OpenSync, you will see that the delete option is blank which means that is not supported.

    #64860

    Mark
    Premium Member

    Hi

    In opensync, it does not show that a delete option is unavailable for credit card. See screen shot. There no no notations about what it can or cannot do on the interface that I’ve seen so far.

    Also.. has anything changed in Quickbooks 2019? Is perhaps a delete option available in the new version?

    #64861

    Mark
    Premium Member

    Hmm, I’m unable to upload screen shots.

    I’ve tried to upload a screenshot twice on this thread and it’s not showing up.

    Screenshot: https://i.imgur.com/N29oRci.png

    #64912

    Mark
    Premium Member

    Any updates on this?

    #65046

    Mark
    Premium Member

    A month with no reply?

    Can you please respond to my questions?

    #65047

    Yudel Rosales
    Keymaster

    I have answered your post on January 10, 2019 at 11:12 am.
    QuickBooks API doesn’t support DELETE for neither credit card charges/credits table. If you click on your database on OpenSync, you will see that the delete option is blank which means that is not supported.

    #65048

    Mark
    Premium Member

    I had asked you a new question since.

    Has anything changed in 2019?

    Also, this information is incorrect:
    ” If you click on your database on OpenSync, you will see that the delete option is blank which means that is not supported.”

    There is no ‘delete option’ shown in OpenSync that I have located thus far to indicate that it’s not supported.

    #65049

    Mark
    Premium Member

    Also, have you investigated the problem of not being able to upload screenshots to the messageboard?

    #65050

    Yudel Rosales
    Keymaster

    The information is correct. See attached

    Attachments:
    You must be logged in to view attached files.
Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic.