Method Community

Andy, Please email me your Company Account name as our Forums are seperate from our Customer database so I won't be able to locate your account info. Also provide the best contact number to reach you on. - Ashur

Mike, Actually you won't be able to delete them if they have any transactions.  I was wrong there.  Your way would work, however over the long run what would happen if they become dormant again?  You might end up with a number of Company ABC - Dormant1, Dormant2, etc.  If that's okay, you can certainly do that but ...

Ashur, sorry for the delay. This has now been activated.

Understood, you'll still need to add a record into your custom table for each customer. You can do this by looping through your Customer table, retrieving the FullName field from your Certification table, use a conditional statement to check whether or not the customer name already exists in your Certification table, and finally insert the ...

OK, but if I delete the customer from QuickBooks, what happens to historical transactions? Any problems there? Wouldn't it be better to change the customer name in QuickBooks to be somethinng like: "Company ABC - Dormant" and then make the lead name in Method the same as what the customer was before it was dormant ...

I'm looking to have a series of actions where I loop through an invoice table and sum up sales for a quarter. I'll define the following variables: CurrentQuarter - A date function that takes the current month number, divides by 3 and rounds up. CurrentYear - A date function that takes the current year. Let's just say for now ...

I will give this a try and get back to you with my results.

You can do this in Method by adding a new field to your Customer table, for example, named PrinterInfo. Then make copies of and edit the applicable Customer (and possible Lead) screens in order to add this field to the screens for use: CRM_EditCustomer CRM_NewCustomer CRM_EditLead CRM_NewLead To edit a table go to Customize > ...

James, The fix for this issue has been released in the May version of Method.  To switch to the May version, log out of Method.  On the sign in page, look to the bottom and you'll see an option to "Swith to the May version".  Click that and then sign in as you normally would. The group items should display as intended ...

Hi Mike, You won't be able to keep the same customer name unless you delete the customer record.  The only difference between a Lead and a Customer is the IsLeadStatusOnly field.  They are actually both records in the Entity table.  The Entity table is a special table in Method that syncs Customers, Employees, Vendors and ...