Method:API Q&A

Re: Clearing items from ountingConflicts / QB Sync Error table via API

Method_Audisho — Thu, 05 May 2016 16:27:31 GMT

Hi furrywombat,

This is something we plan to look at in the future, but as I understand, it's a very large task. As such, I can't yet give you a timeline for when this will be available or what it will look like when it is. Sorry for the inconvenience.

--Audisho

Re: Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 15:14:09 GMT

Audisho, the only thing that's preventing us from making that move is the lack of SQL override. And we've been itching to make the move. I'm sure we are not alone in this... are you guys going to be souping it up a bit? Is that why it's taking so long?

Re: Clearing items from ountingConflicts / QB Sync Error table via API

Method_Audisho — Thu, 05 May 2016 15:09:17 GMT

Hi furrywombat,

Unfortunately, not yet. You can use the expression builder for more basic things like showing multiple fields in a single column or basic math calculations, but it's certainly not as flexible as the SQL override feature in classic.

--Audisho

Re: Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 15:01:09 GMT

Thanks, Audisho. Quick question regarding Method New -- have you implemented custom SQL fields yet?

Re: Clearing items from ountingConflicts / QB Sync Error table via API

Method_Audisho — Thu, 05 May 2016 14:50:07 GMT

furrywombat:

Would be nice if we could do a Clear All on a filtered list or checkbox selection, rather than having to click, click, [...]

This is already a feature on the Method New sync conflicts screen. You might want to try resolving these conflicts from there instead.

--Audisho

Re: Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 14:41:29 GMT

Well, it's just kind of a pain to have to sort out the DeleteFromDesktop conflicts from actual conflicts requiring attention. Would be nice if we could do a Clear All on a filtered list or checkbox selection, rather than having to click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click. I'm sure it's not a priority for Method, just wanted to throw it out there.

Re: Clearing items from ountingConflicts / QB Sync Error table via API

Method_Audisho — Thu, 05 May 2016 13:38:15 GMT

Hi furrywombat,

The ountingConflicts (AccountingConflicts) table does not support modifications via the API, so this is not possible. In my experience, any DeleteFromDesktop conflicts resulting from transactions being archived are cleared up on their own once a full sync has completed. If this is not the case, I suggest getting in touch with our support team so that they can investigate. I hope this helps.

--Audisho

Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 13:19:30 GMT

We are archiving certain transactions older than a year, and we get over a hundred "DeleteFromDesktop" errors per day for transactions that are in the process of being archived. The current procedure is to clear all of the false-positives, but wondering if there is a way to do this programmatically.