Method:Classic General Q&A

Re: Need to understand sync behavior regarding Transaction History

Method_Paul — Fri, 23 Mar 2012 17:39:42 GMT

"Does Method include all transactions for a given client when any of the client transactions are synced?"

Nope. Transactions are synced what transaction type at a time, and are mutually exclusive of each other's open status.

Paul

Re: Need to understand sync behavior regarding Transaction History

viret56 — Fri, 23 Mar 2012 17:19:45 GMT

Thank you Paul,

The information you gave me helps. Now that I have compared the transactions within Method to the QuickBooks reports, I do find several invoices and half a dozen received payments outside the Transaction History range we set and not listed in the QuickBooks "Open Invoices" report. All invoices and payments represent two clients, which have other transactions within the Transaction History range.

My question is: Does Method include all transactions for a given client when any of the client transactions are synced?

Despite these few transactions, we do feel we have a much beter understanding of how the sync is working. Thank you again.

Re: Need to understand sync behavior regarding Transaction History

Method_Paul — Fri, 23 Mar 2012 02:22:39 GMT

@viret56 - It should be consistent with the standard (I might venture to say essential) reports you see in QuickBooks directly for open transactions.

For Invoices, Charges, Received Payment and Credit Memo, we're pulling the data from the "Open Invoices" report in QuickBooks.

So for Invoices, it's any invoice that isn't paid. For Received Payments, it's payments that haven't been allocated to an invoice, statement charge or other transaction (balance remaining is not 0). For Credit Memo it's everything that hasn't been applied to an invoice or charge yet.

For Sales Orders we're pulling the "Open Sales Order By Customer" report from QuickBooks. This is anything that IsManuallyClosed=False and IsFullyInvoiced=False.

For Purchase Orders we're pulling the "Open POs" report from QuickBooks. Here's it's any PO that doesn't have all it's items fully received.

Paul

Re: Need to understand sync behavior regarding Transaction History

viret56 — Thu, 22 Mar 2012 20:36:59 GMT

That explains the Sales Orders I see, they are all open (at least the ones I have checked in QuickBooks).

What would constitute an open invoice?

An open Received Payment?

An open Credit Memo?

An opem Purchase Order?

Those are the tables with transactions outside the 60 day window we are using. The other tables have transactions within the 60 day window.

Re: Need to understand sync behavior regarding Transaction History

Method_Paul — Wed, 21 Mar 2012 22:10:56 GMT

Any table in particular that you are seeing this in?

For example, Sales Orders would be anything that is open. Open means that IsManuallyClosed=False and IsFullyInvoice=False.

Paul

Need to understand sync behavior regarding Transaction History

viret56 — Wed, 21 Mar 2012 21:46:26 GMT

We have a new account and set the Transaction History to 60 days with transaction options set to default. I understand that 'open' transactions will be brought over to Method. But we are seeing transactions outside the history setting as far back as 7 years. Aside from 'open' transactions, for what other reasons would the sync engine bring a transaction over that is outside the history setting?