Method Community

Hey Ben, Great question. Using documentation I was able to put it together correctly. Firstly the functions: DATEDIFF() GETUTCDATE() And the code: SELECT DATEDIFF(day, Max(viewaccInvoice.TxnDate), GETUTCDATE()) FROM viewaccInvoice WHERE viewaccInvoice.Customer = viewContacts.Entity Layman's terms: take the difference in dates between ...

Help!   I have successfully customized our company's Estimate template with Report Designer.  However, I need to have the “item” field view/print only the "child" name/number and not the full "parent" name/number details.  Does anyone know how I could accomplish this ...

Hey Mortaza, Thank you!!!  What a wonderful welcome to the Forums.  Your code worked like a charm. A quick follow-up question:   How would you use SQL to retrieve "Number of days since most recent invoice"," if that is even possible? Thanks a again! Ben

Hey Kelly, It has been assigned to a Support member; it's in queue and they will reach out. I do notice we do not have a contact number for you to be reached at. When you get a moment please shoot me an email with that information and I'll update the case. -- Mortaza

Hey Greg, In order to be able to do this, you need to create a Generate Report action immediately followed by a Send Email action to send the PDF on a button on a copy of the original estimate screen.  You can reverse engineer how Work Orders are emailed in Method Field Services to see how that happens. Try that and let me know if you ...

Hey Ted, Instead of going through the trouble of customizing the screen, you can: - Click on Fill list with Contacts In there you have under Tags: "Include contacts" in your case you would choose the Tag 'wormer.' That will take you right into Step 2 which will show you the list of Customers that fit the conditions in the ...

Hey John, I was able to replicate the issue on my end. I have created a ticket for our developers to take a look at the error. As soon as I hear back from them, I'll update our thread. -- Mortaza

Thanks. It's just confusion mainly. Technically, sales tax is figured and updated properly...it's just slow for Sales Orders. I addressed it for my team by putting a label with hover text explaining the situation and that it's been reported to Method.

Hey Blake, Thanks for the video! I'm still having issues replicating the error. I did try to change my TaxCode but still unable to get it to "0" out. I do see how this can be an issue for your SalesReps. I have created a Support case for you and a member from Support will reach out ASAP. They will be able to further disect the ...

Hey Ben, Welcome to the Forums! There are a few ways to retrieve that data into a Grid, here is one way: SELECT Count(viewaccInvoice.RecordID) FROM viewaccInvoice WHERE viewaccInvoice.Customer = viewContacts.Entity Using SQL Count function we retrieve the total number of unique Invoice RecordIDs related to Customer. -- Mortaza