Method Community

Ben, Yes we are syncing with QuickBooks Desktop. No I have not been able to recreate the problem.  We created the invoice originally in Method.   We modify invoices only in Quickbooks.   This invoice was created and then the discount line was added at a later time. The quantity is not input for the discount ...

Ben, Thanks for the great example.  It will help as I work with it further.  Understand about making sure the names and parameters are exact. Stuart

Hi Stuart, I created an example of using the "Call WebService" action in my own account. Hopefully you will find this helpful, I actually used a public web service offered by w3schools for this example, so technically you could recreate this yourself in your own account. For more information on the specific w3Schools web service I ...

Is it possible to creat a field or fields that show the total amounts billed per job, to date without the payments applied and broken down into 0-30 days, 30-60 days 60-90 days etc??

Hi Stuart, I have a couple of follow-up questions that should help as I look into this for you.  Are you syncing with a QuickBooks Desktop account?  Have you been able to recreate this issue again, if not, can you try, using the same discount item, would it happen if you created this in Method?  Did you enter any quantity for the ...

Your second "fancy" solution did the trick.  I think without converting to character was causing the issue.  Once it was converted, worked like a charm. Thanks!!! Shawn

if you want to get fancy, and dance around the date conversion a little..... (CASE WHEN [DueDateStart] < GETUTCDATE() THEN '<font color="red"><b>' ELSE '<font color="black"><b>'  END)  + CONVERT(varchar(10), DateAdd(HOUR,-5,viewActivity.DueDateStart), 20) + ...

In that case you want: (CASE WHEN [DueDateStart] < GETUTCDATE() THEN '<font color="red"><b>' ELSE '<font color="black"><b>'  END) + viewActivity.DueDateStart + '</b></font>' 

Paul, If I move the END to the end of the statement, the case will not display the requested field unless it results in the ELSE portion of the CASE I did try your suggestion but ended up with the same error. I'll keep playing

Try: (CASE WHEN [DueDateStart] < GETUTCDATE() THEN '<font color="red"><b>' ELSE '<font color="black"><b>'  + viewActivity.DueDateStart + '</b></font>' END)  - I haven't tried this, just a first glance attempt. - better to use GETUTCDATE() ...