Method Community

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.

Lynda, How do I get the new UI? Thanks, Chris

I can publish a solution to this: tables in custom SQL quieries must be appended with view or viewacc. view is for tables that exist only in method and viewacc is for tables that came from QB. See: https://www.method.me/cs/forums/p/5538/21043.aspx The query i ran was: SELECT TagList FROM viewContacts WHERE viewContacts.EntityRecordID = ...

Hi! I understand that there are probably reasons why this is not made available, but, it would be GREATLY beneficial to me if there was a stock database diagram I could look at that detailed the Method database.  While customizing I notice that I spend half of my time wading through tables and exporting data to try to figure out how ...