Method Community

Having recently gone into the Pro version, we've added some new columns.  I need to know what the ORIGINAL CASES table definition was in the out-of-the-box CASES table (pre Pro).  There are linked fields into Entity, CaseStatus, LastCompletedActivity, NextPendingActivity and Contacts.  I need to know the original ...

I had the same thing yesterday and found a solution.  I changed the incremental sync timing from 15 minutes to 20 minutes, saved my settings, waited 30 seconds then set my sync timing back to 15 minutes and saved my settings.  Soon there after the incremental sync time stamp started updating.  Hope that helps.

I have a sales order report that needs a "flag" indicating if the customer had no other sales orders within the last 6 months.  If they have none (or none ever), I need to do custom reporting on their SalesOrderLine.Rate amounts.  I've been searching for something in the DevExpress.XtraReports.UI ...

Thanks!  I am now finding my Portal login data.

What table are the PortalUsername and PortalPassword values stored in?  I have looked in Customer, Entity and Contacts.  Each of these tables has PortalUsername and PortalPassword columns but none of them contain values for "accounts" I know have used the Customer Portal.  Help!  Thanks.

Is the proper login url for the July version https://app.methodintegration.com/stage/login.aspx or  https://app.methodintegration.com/Method/Login.aspx I think the latter is the new production July version.  In the July login, using the bottom url, there is no option to switch back to another version.  I assume this is ...

Greg, Thanks!  That worked.

I need to add a filter to the Sales Order Line grid in the sales order screen.  When I enter the Item column's Advanced dialog in the grid Wizard, the 1st column value is empty.  After I add the filter I need then hit the Save & Close button, Method says: "Please select a value for 1st Column".  There is no ...

I figured it out!!  Thankfully I am a DBA and knew where to look.  There must have been a SQL Server patch applied today in Methods DB that started strongly enforcing datatypes in SQL WHERE statements.  I had a X > 0 on a TEXT (varchar) column that started breaking the WHERE.  I checked the data types and found X was TEXT. ...

I figured it out!!  Thankfully I am a DBA and knew where to look.  There must have been a SQL Server patch applied today in Methods DB that started strongly enforcing datatypes in SQL WHERE statements.  I had a X > 0 on a TEXT (varchar) column that started breaking the WHERE.  I checked the data types and found X was TEXT. ...