Method Community

Hi Stewart, "Only distinct values" does what you'd probably expect and only loop through the distinct values in the table/grid you are looping through. For instance, if you're looping through your Estimate table and want to count the number of customers you've created estimates for, you can loop through the esimtate table, ...

The following updates are now live for users of Method.  Features: View QBO Sync Status and Results from QuickBooks Preferences page (PL-3500) Prevent website conflicts on incomplete web addresses (PL-3504) Updated QBD sync video on QBD sync steps page. (PL-3635) Minor improvements to Invite user. (PL-3231) Users now have the ability ...

Hi Ying,  Unfortunately, there's no way to do this through customization. That said, there might be a possibilty through the API but i'm not familiar enough with it. I would suggest posting to the API forum to see if its possible. - Adam

Hi Justin, This shoud be part of the stock estimate templates in the report designer. I suggest looking at the cost field of your template and the "Before Print" label script. See below: You should have a script that takes the "Amount" field and divides it by the quantity. That would give you the Sales price and put that ...

Hi Justin,  Can you clarify what you mean by banking info? Is it the AR Account of the invoice? Also, are you referring to the invoice print template or is there another report template you are using? Adam

I found SQL Override examples on the forum which allow me to change color/font of cells of a grid based on a condition.  It works great.  However, in the example below, the condition is against GETUTCDATE().  I would like the condition to be against a date field on the screen called 8DaysAway.  How do I reference screen fields ...

Hello Method! We are still having sync issues with our accounts table. Also we are having problems with our Received Payments not syncing with QB. Any reason why this is happening? Thanks

Hi Rick, Glad to hear you've figured this out! Adam

Hi Sixtel, Understand your points and pain. Names is prob. the most difficult part and most important part to get. It really helps to understand how QB uses and then its easier to translate to Method. It is an art at times.  As partners, we all have struggled a bit with this area, so don't feel bad. But I know, it would be ...

Is there an issue with chart objects?I  tried adding another chart to a screen that already had some existing charts. Could not get it to work. So I copied an existing chart and even switched the table it was pulling from and it worked fine.