Method Community

I've installed the Outlook plugin on my machine running Office 2010.  However, when I try to install on one of my employee's machines running 2007, the install seems to go fine but no add in is installed.  No buttons or set up prompt.  We have tried to install twice, restarted machine, etc.  It's odd.

Hi Robert, Makes sense and thanks for sharing your solution. You're right, 2 users would have to run the report at the same instant for one user's where script to show on another's report. -Russell

Hi Retrotel, By removing the main filter, do you mean you removed the resultReportFilter action result? Did you also remove it from the Where Script in the Generate Report action settings? If you post the full error message here I might be able to give some insight. However if the only filter you need is on the date field, you should be ...

Is there a way to link Employee Entity rows to SalesOrder and SalesOrderLine rows to determine who created them and who last editted them?  I am looking at the Transaction table as a possible source for this data.  Thanks.

Hi Retrotel I'll add to Russell's post. In addition to support from Method directly there is a community of Certified Solution Providers.  Here's a link http://method.me/solution-providers/

Solution: Repurpose Company.CompanyType.  Its 255 characters that are not used by us in Method or Quickbooks.  Since Company is always available in Report Designer, just before generating a report, I update Company.Company with resultReportfilter where RecordID = 1. Then I put Company.CompanyType on the report.  Bingo. I ...

Sure - basically, salespeople need to assemble a list of records to call.  On any given day they will want to call on records that had invoiced two weeks ago.  Another day they may want to look at invoices from last week.  I have gone so far as to copy the report screen (new name  RT_CustomerReports).  I removed the main ...

Is there a way to upper case a value on a screen, such as a state code?  Upper() is not in the character function list.  Thanks.

Hi Retrotel, First off, sorry for missing your reply in the post I think you are referring to. It's answered now. If you think we may have missed a reply in a forum post, feel free to "bump" that post by posting a comment in it, it will jump back to the top of list. Here at Method we're quite busy these days, including an ...

Hi Retrotel, Sorry for the delay in my reply. Filters can be applied by the screen or the Report Designer, it depends on how you want to filter the report. One limitation with the Report Desinger is that it cannot filter based off of values on the screen that is generating it, only by values in the database. So for example if you wanted ...