Method Community

John M, One thing I'll add to this (since there are other non script people reading this that we don't want to freek out!) is that before resorting to VB script, you can always try to accomplish your calculations using Calculated Fields.  You can right-click on a table in the designer and add a calculated field, and then drag that ...

Josh - The new Filter Safeguard feature isn't the culprit.  That feature wasn't there when you put your original post up, and is unrelated. It's actually a great new feature, that you should try to use whenever it makes sense to do so. "Contains" may work in your scenario, but since this is a public forum and everyone ...

Josh - it sounds like it's doing what it should be doing.....so maybe the best thing for you is to: 1. Start Condition Statement - if the dropdown is empty then... 2. Generate Report - no filter, just show all records. 3. End Conditional Statement 4. Start Condition Statement - if the dropdown is NOT empty then... 5. Generate Report - ...

Hi Tim - unfortunately we're not a custom dev shop, so we wouldn't be able to take the project on. One piece of advice, create your com add-in using something old school, like VB6, and have a separate .net app for your operating code.  Don't mess around with the .net wrapper or you'll find yourself wanting to jump off a cliff ...

JKM@SA - If you do end up renaming that field value, and are using Method Field Services, be prepared to do a lot of customization in many screens.  There are *A LOT* of places that look for and use the specific value of "To be Invoiced" that will all break as soon as you rename it.  You can do it......but be prepared for a lot ...

  It was nice to wake up this morning to see Method’s name splashed on ZDNet, and Intuit’s press releases.  Today Intuit announced a new way of integrating with QuickBooks, called Intuit Anywhere.  For QuickBooks users it’s a great way to connect your favorite web apps all in one place. It’s also got a cool ...

We previewed a great new feature at the Scaling New Heights conference last week called "Reminders", and I'm happy to announce this is now live in all Method accounts.  If you turn Reminders on in your account, Method will send you an email 15 minutes before your activity is due, along with a link that takes you straight into ...

James - do any of your invoice numbers have a dash ("-") in them? If so, that could throw off the algorithm that calculates the max invoice number (it's complicated stuff since we need to efficiently figure out if an invoice # "ab123cd" is less than or greater than "122" along with thousands of your other ...

You were on the right track.  Make the screen based on the SalesReceiptLine table. But first, add a linked field to the SalesReceiptLineTable, via the SalesReceipt dropdown, to get the Customer field. Paul

Chris - we've seen this twice in the last week.  Both times it was a virus the users had on their computers blocking their computer from reading certificates, and therefore blocking QuickBooks from reading them.  I recommend doing a virus scan. I hope that helps. Paul