Method Community

Great instructions as always Jason!  Thanks. I have another question about a potential field I woudl like to add.   I would like to add a field to the vendor table called "Total Orders" and I would like this field to automatically calculate the # of purchase orders that exist for that particular vendor and would ...

In one of the recent QB upgrades for Enterprise 13.0, QB added a tab for secondary contacts on the customer information card.  How do I get these contacts to sync with CRM?

Hi David,  We'll focus on your Supplier Classification field. First thing you need to do is to add a dropdown field to your Vendor table. You can do this on the Customize>Tables/Fields tab link. Your Field Type should be Dropdown and then you will probably have to choose the Create a new Table option if your dropdown ...

Hi Juliet, This appears to be a Support question, and I would recommend contacting us directly for any sync related issues like this.  Since you have included your contact information in our signature here, someone from Support will contact you shortly to troubleshoot this with you.  Without knowing your company's setup and without ...

Andy, In my screenshot above, you'll see that I included the filter: Where IsDetailLine equals 0. IsDetailLine is a field in the Transaction table that determines if a transaction is a line item or not. This might be all you need. Jason

Great information, thanks Adam.  Follow up questions:  1) You say that i can view the report as an HTML page.  Do i have the option to export to Excel?  My goal of setting up this report is to pull information from Method into excel and then pull information from UPS (in a separate system) into excel and merge the files to show ...

Method on my computer is no longer syncing with Quickbooks on our main computer. The last sync date was July. Can you please let me know how to fix this? Thanks, Juliet

Hi Adrian, You can easily update the Opportunity related to each Activity by exporting your Activity table and change your Opportunity number, from the Opportunity Column to the correct one.  When all of your records have been updated, just import this saved file back to your Activity table, and ...

Hi David, You can actually sync in some QuickBooks reports into Method, including the Open Purchase Orders report. We have a screen under the QuickBooks tab that allows you to import/sync over your scheduled reports from QuickBooks.  These are standard QuickBooks reports that you can setup to sync over into Method at specific time periods. ...

Jason, one final query. My transactions are listed under the detail section of the report (using the detail report the report doesn't display correctly). Can this be filtered in any way? I don’t want to include invoice line items. Thanks.