Unable to delete credit card transactions

[MarkPremium 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
—————————

[MarkPremium Member]

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

And we get the same error.

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

[Yudel RosalesKeymaster]

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.

[Yudel RosalesKeymaster]

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.

[MarkPremium 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?

[MarkPremium 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

[MarkPremium Member]

Any updates on this?

[MarkPremium Member]

A month with no reply?

Can you please respond to my questions?

[Yudel RosalesKeymaster]

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.

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

[MarkPremium Member]

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

[Yudel RosalesKeymaster]

The information is correct. See attached

Attachments:

You must be logged in to view attached files.

[Author]

Posts