Method Community

I've noticed that the response time from the API has gone in the dumps since last week. I'm thinking this may have something to do with the revised server setup, but I've been keeping a close eye on the speed over the last several days and it does appear that INSERT and UPDATE statements are taking way longer than they ever have in the ...

We've been back & forth on this numerous times. Every time I try to update our item database using the IMPORT tool, the lack of speed is worsened by the fact that Method somehow creates a duplicate/ghost UnitOfMeasureSet entry, haphazardly, and for no apparent reason, for random products (in this case, so far about 763 of them -- last ...

So, rather than simply creating a LEFT JOIN or INNER JOIN query, I create an entirely new field that links to the table in question. Unfortunately this would result in about 30-50 hours of sync time every time I need to create a new association given the size of our database. You guys need to make JOIN available or at least a pseudo JOIN available ...

The consulting team appears to be backed up, and we’re looking for some pretty high-level customization… well, essentially, wrapping up some customizations that I’ve been working on in the background for the greater part of the last twelve months. Coming to a point where we just need to get it done, and I do not have the time ...

delete

What exactly are the limitations of this function? Is it somehow possible to perform a more complex query... for example, to query the ItemReceiptLineItem table for created line items where ItemReceiptRecordID does not exist in the RecordID column of the Item Receipt table? Currently we are just querying both, creating temporary versions of each ...

[quote user="retrotel"] Amen!! I was told they are very busy.  Well, this is one way to fix that! [/quote] Likely busy adding infrastructure. 

1) I've been having the same problem all week. Try the February version. Much faster. 2) When in doubt, try the forums. 3) Nope 4) Never had a critical problem that was not rectified in 24 hours or less. If our business was larger, truly critical to the U.S. / Canadian economy, we probably (definitely) wouldn't even ...

Chris, Thanks for the quick and very helpful response. I did have a previous understanding of how inventory is handled with QB / Method. Sounds like this should be no problemo. I'll play around with it and report back with results as they become available. Appreciated. F.W.

See below: http://www.sleeter.com/blog/2011/09/quickbooks-2012-enhanced-inventory-receiving/ We are considering migrating to enhanced inventory receiving in an attempt to help weed out unnecessary conflicts with item receipts, as they are converted to bills (we have figured out a complex way to do this using the Method API, but it produces a ...