Method Community

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() ...

So I have another one that I could use some help on.  I want to be able to compare the current time to the requested start date and then color it red if its late.  Here was my idea, but it returns "error generating grid" CASE WHEN [DueDateStart] < GETDATE() THEN '<font color="red"><b>' ELSE ...

In case anybody is interested,  I figured out my own solution: CASE WHEN [ActivityPriority] = '1-Emergency' THEN '<font color="red"><b>' WHEN [ActivityPriority] = '2-24 Hour Response' THEN '<font color="blue"><b>' ELSE '<font ...

I'm trying to create a new dispatcher's dashboard and wanted to color code the Work Order grid based on the priority of the activity.  I figured I could do something along the lines of: CASE WHEN [viewActivity.ActivityPriority]='1-Emergency' then '<font color="red">' ...