Method Community

Hi. I will run this down for you. I can't commit an ETA at the moment I will look into it and if there are any updates I will reply to this post.  Thanks for reaching out. 

Hi Matt.  Not at the moment. I will make a note of your request for dev team. While I will make sure your request is sent to the team I can't give you an ETA on the resolution at the moment.  Thanks! Chris

HI. Apologies for the delay in responding to you.  Can you try again and see if the issue is still occuring?  Thanks Chris 

Hi.  Sorry you where having troubles this morning.  I’m not sure this is really an API issue, since you are generating reports rather than using the API, but the syntax of the SQL should be the same regardless.  We have applied no patches to the DB server that would have caused this stop working.  Most likely, there ...

HI All. Thanks again for posting on the forum. We've pushed an update to fix the US sales taxes issues listed above. If you find other issues or something comes up regarding sale taxes you can reply to this post or create another one. Thanks again for your patience as we iron out these issues. Chris

Hi Vic. Can you send me a private message with your account name?  Thanks Chris

Apologies for the delay. The query functions are for specific tables.  You cannot join tables directly in the API.  However, in reality, the tables you see in Method are actually Views behind the scenes, and you can add Linked Fields (via Customize > Tables / Fields) that show values from other related tables.  For example, on ...

HI Jason, sorry for the delay.  The table InventoryAdjumentLine has never been tied to QuickBooks. It is legacy from the old Method Warehouse app that has been discontinued.  The Inventory Adjustment screen is also legacy from the Method Warehouse app. Thanks! Chris

Hi.  Best not to use that table. It is legacy from a warehouse app we discontinued. It will be retired over the long term, or be repurposed to work with QuickBooks Enhanced Inventory (no immediate plans for that).  Thanks! Chris

HI Mark.  If it is an accounting table, you should be able to use the “TimeModifiedAccounting”, which is the modified time according to the synced record from QuickBooks. If it is a non-accounting record, there is no automatic timestamp feature. But if you place a “LastModifiedDate” field (spelt exactly that way) ...