{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["To Do List by Release Date","To Do List Person","Action Tracker","Lookups","vue_tblBugs"],"not_rendered":{"images":2,"macros":1,"defined_names":12,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"To Do List by Release Date","index":0,"n_rows":73,"n_cols":10,"rows_kept":73}
[]
[]
[]
[]
[]
[null,"Priority","Impact","ID","Release","Owner","Development Goal","Status","Note","Added on"]
[null,"High","(blank)",131,null,"Ross","Fix Check 74","Complete","74 is not producing an error when the project description field is empty, presumably because it's marking them all as zero rather than null.","2022-10-12T11:20:32"]
[{"$nulls":3},132,null,"Unassigned","Add calculated field for Check 80","Complete","Check 80: \"Sum Milestone Amount By Project Must Equal Time Contract Amount\" needs a calculated field to work properly in the EVT profile.","2022-10-12T11:23:56"]
[{"$nulls":3},150,null,"Unassigned","Fix Check 90","Complete","Check produces false negatives.\r\n\r\nEdit: This has been fixed: Cannot fill validation conditions for check 90 because Project stage is a field contained within EVT_DblChk_Project but System Revenue Recognized is a field contained within EVT_DblChK_RevRec. As far as I can tell, we don't currently have a way to compare","2022-10-12T12:02:55"]
[{"$nulls":3},223,null,"Unassigned","Enable three checks on hold","Complete","CH0085 \tNeeds to address time card fields, but we need clarification exactly which fields EVT is interested in\r\nCH0087 \tNeeds to address time card fields, but we need clarification exactly which fields EVT is interested in\r\nCH0091 On hold pending enhancement; needs fields from two different reports","2022-10-12T13:44:36"]
[{"$nulls":3},516,null,"Ross","Sum Invoice Amount By Included Project Codes Broken","Complete","Sum Invoice Amount By Included Project Codes is not appearing on EVT_DblChk_Invoice as it should, and as a result is breaking checks #82, #84, and #89.","2022-10-26T16:15:09"]
[{"$nulls":3},518,null,"Unassigned","Build new calc field for #86 and #90","Complete","New calculated field needs to appear in EVT_DblChk_Rev_Rec and should be the following: Sum of Total Revenue Recognized by Project UID.","2022-10-26T16:17:28"]
[{"$nulls":3},550,null,"Unassigned","Allow users to disable specific check results","Complete","EVT expressed the desire to disable specific check results if they want the check to continue running, but don't want to keep seeing the same errors on future runs.","2022-10-31T15:16:42"]
[{"$nulls":3},562,"(blank)","(blank)","Rename calculated field \"Discounted Time Contact Amount\" to \"Discounted Time Contract Amount\"","Complete","I'm unsure which report this field lives in. I have no additional information apart from the title and Ross's notes: \"This change is easy but high risk. Gary wants to take time to ensure there are no unintended consequences\"","2022-11-02"]
[{"$nulls":3},579,null,"Unassigned","Fix Link/URL to Projecctor","Ready for Testing","When reviewing results and user selects the Link/URL, user is shown details of the error check vs a Projector Web window with the page to see/resolve the error.","2022-11-07T17:23:07"]
[{"$nulls":3},580,"(blank)","Ross","Update EVT checks from time contract amount to total contract amount","Ready for Testing","1.\tdblCheck looks to be checking UDF vs Time Contract Field vs Time + Contract Field. Thinking dblCheck should add both Time + Cost Terms\r\n2.\tdblCheck will likely error on Rev Rec vs Contract amount as well.  May be unavoidable. Good use of dblCheck “Ignore”?","2022-11-08T09:53:43"]
[{"$nulls":3},582,"(blank)","Gary","Add multi-report functionality","Complete","Checks #85, #87, and #91 require fields that are in two different reports, and Projector does not support reporting these fields in the same report. We need a way for a check to reference fields in two different reports at once.\r\n\r\nIf this can't be done by November 18th, let Ross know.","2022-11-08T10:11:43"]
[{"$nulls":3},583,"(blank)","Gary","Create dev, staging, release enviGaryments","Complete","To ensure a consistent user experience, we need to be able to test updates in a developer mode before they are pushed to all users.  Create dev, staging, and release enviGaryments that allow testing updates ahead of user release.\r\n\r\nIf this can't be done by November 21st, let Ross know.","2022-11-08T10:20:48"]
[{"$nulls":3},658,null,"Unassigned","Enable multi-report support for Check #91","Complete","Check #91 needs the following fields:\r\n\r\nFrom EVT_DblChk_Invoice_Milestone:\r\nMilestone status\r\n\r\nFrom EVT_DblChk_Invoice:\r\nInvoice amount\r\n\r\nIt will use Project UID, which is contained in both reports.","2022-11-16T08:42:05"]
[{"$nulls":3},659,null,"Unassigned","Checks #85 & 87 multi-report support requirements","Complete","Update as of 1:25PM 11/16:\r\n\r\nWhat we need for checks 85 and 87:\r\n\r\n1. Project Stage copied from EVT_DblChk_RevRec  to EVT_DblChk_Time_Card by Project UID\r\n\r\n2. Sum of Total Revenue Recognized copied from EVT_DblChk_RevRec to EVT_DblChk_Time_Card by Project UID\r\n\r\n3. Time Contract Amount in Engagement Currency copied from EVT_DblChk_RevRec to  EVT_DblChk_Time_Card by Project UID","2022-11-16T08:55:39"]
[{"$nulls":3},681,null,"Unassigned","Sort list by sort order","Ready for Testing","The list of calculated fields should be sorted by sort order instead of calculated field number","2022-11-17T09:23:34"]
[{"$nulls":3},762,null,"Gary","Cloning doesn't include new fields","Complete","Cloning a company does not include new fields such as copyToTableName.","2022-11-30T09:13:45"]
[{"$nulls":3},915,null,"Unassigned","Get Data not finishing","Complete","When I hit get data, it's stuck on \"SumTotal Revenue RecognizedByProject UID - 129 of 130 records\". I believe this has to do with an additional calculated field added in today.","2022-12-12T15:34:37"]
[{"$nulls":3},1068,"(blank)","Gary","Check #266 not ignoring blank entries","Complete","Check #266 is supposed to ignore rows where Actual Project Margin Percentage is blank. But it's not doing that; it's still reporting all these as validation errors.","2022-12-14T13:07:24"]
[{"$nulls":3},1346,"(blank)","Gary","Commissions report throws error","Complete","When I try to run \"get data\" with the commissions report enabled, it throws the following error: \"Not a valid csv file…\" The file is a CSV file, though, so this error message didn't help me identify the problem.","2023-01-10T16:03:52"]
[{"$nulls":3},1362,null,"Unassigned","Import This Report button bug","Pending","When clicking Import This Report button in the Maintain Projector Reports, nothing happens.","2023-01-12T14:51:55"]
[{"$nulls":3},1450,null,"Unassigned","Change final refresh screen status","Complete","Change the final refresh screen status when hitting \"Refresh Data\" to just \"Finished\" instead of \"Finished OK\".","2023-01-20T10:07:30"]
[{"$nulls":3},1875,"(blank)","Gary","Review Fit and Finish Checklist and Make Changes","Complete","Please review the fit and finish checklist for 1.5.6 and make the appropriate changes to the dblCheck composer. There are quite a few changes in here that would improve the look and feel of the composer and help make it a more visually attractive product. This is necessary as some sales calls may need to use the composer in demonstrations.","2023-02-21T12:54:44"]
[null,null,"Efficiency",1927,null,"Unassigned","Log when check fails","Complete","Write a record to the error log when the timer check fails","2023-02-28T09:46:50"]
[{"$nulls":3},1928,"1.6.6","Gary","Make sure insertedBy and Updated By are working","Ready for Testing","Make sure all forms fill in the inserted by fields","2023-02-28T10:16:49"]
[{"$nulls":3},1974,"(blank)","Gary","Determine where calculated field is used","Pending","Determine where calculated field is used","2023-03-01T09:30:32"]
[{"$nulls":3},2234,"1.6.6","Ross","Add test Notes Field","Complete","Add test Notes Field","2023-03-17T08:58:55"]
[{"$nulls":3},2237,"May Release","Gary","Change the add value screen so you can compare a field's value to another field's value instead of a field's name to another field's name","Pending","(blank)","2023-03-17T09:28:04"]
[null,null,"Reliability",2273,"May Release","Gary","Reconcile unique check ID#s between test and production","Pending","Look at alternative ways of keeping check identification numbers consistent between test and production. Carol and Gary suggested an internal ID number that the customer never sees, and a separate ID number for internal use. These numbers need to be identical before moving to production in April","2023-03-20T12:15:46"]
[null,null,"Customer Improvement",2197,"May Release","Carol","Write May Release Notes","Pending","(blank)","2023-03-14T09:42:05"]
[{"$nulls":3},2198,"June Release","Carol","Write June Release Notes","Pending","(blank)","2023-03-14T09:43:13"]
[{"$nulls":3},2236,"May Release","Gary","Identify and add all date functions that users would likely want","Pending","(blank)","2023-03-17T09:27:27"]
[{"$nulls":3},2272,"May Release","Gary","Research and set up self-service web portal security requirements","Pending","(blank)","2023-03-20T12:06:16"]
[null,"Medium","(blank)",547,null,"Unassigned","Complete help screen","Complete","Help Page/User Guide Needs to be Completed","2022-10-31T15:09:04"]
[{"$nulls":3},548,null,"Unassigned","Upgrade Graphics","Complete","Updated, higher-DPI graphics need to be implemented throughout dblCheck.","2022-10-31T15:09:51"]
[{"$nulls":3},549,null,"Unassigned","Connect website to domain","Complete","This item is listed as due 11/4.","2022-10-31T15:14:47"]
[{"$nulls":3},639,null,"Gary","Add \"Person Responsible\" field","Complete","January enhancement after web services, migration to rGen Azure, and Power BI implementation are done:\r\n\r\nThe \"show results\" page needs a “person responsible” field for dblCheck results, so that each team member can easily identify whether a validation error is their responsibility to fix.","2022-11-11T13:31:47"]
[{"$nulls":3},657,null,"Ross","Allow checks to evaluate RDC Budget Value when value is unnamed","Complete","1997 Has an RDC Budget, but not assigned to a specific resource. dblCheck should accommodate named and un-named Budget values.","2022-11-15T10:35:13"]
[{"$nulls":3},729,"(blank)","Gary","Change 'DblCheck' to 'dblCheck'","Complete","The options for composing an email refer to 'DblCheck' but Ray pointed out this should be \"dblCheck.\"","2022-11-23T15:35:33"]
[{"$nulls":3},733,null,"Gary","Add filter for specific projects/engagements/contracts","Complete","January enhancement after web services, migration to rGen Azure, and Power BI implementation are done:\r\n\r\nEnhancement request from Ray: we need to be able to limit dblCheck results to specific projects, engagements, and contract line items.","2022-11-28T16:18:09"]
[{"$nulls":3},825,null,"Gary","Error 3078 re: Time card report","Complete","In the rGen test instance, when attempting to access check 125, dblcheck throws the following error: \"Error 3078 The Microsoft Access database engine cannot find the input table or query 'rGen_DblChk_TimeCard.\" Make sure it exists and that its name is spelled correctly. Make sure you have run Get Data and this table is available.\r\n\r\nThis is the result of my changing the name of the table from 'rGen_DblChk_TimeCard' to ''rGen_DblChk_Time_Card'","2022-12-07T11:59:58"]
[{"$nulls":3},832,"(blank)","Gary","Add filter (CategoryLKPID) to Compose Check Screen","Complete","January enhancement after web services, migration to rGen Azure, and Power BI implementation are done:\r\n\r\nAdd filter (CategoryLKPID) to Compose Check Screen","2022-12-08T15:34:28"]
[{"$nulls":3},910,"(blank)","Gary","Add \"where\" condition to equations in \"Maintain calculated fields\"","Complete","Calculated field #72 doesn't work properly, and I think it's because it's attempting to divide by zero. I want to be able to exclude rows with \"0\" from the field's calculation. Can you add this?","2022-12-12T14:07:46"]
[{"$nulls":3},931,"(blank)","Gary","Error when entering table name","Complete","When entering \"table name\" in the \"maintain calculated fields\" screen, dblCheck throws the following error: \"Compile error in hidden module: Form_frmCalculatedFields. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.\"","2022-12-13T08:42:23"]
[{"$nulls":3},948,"(blank)","Gary","Calculated Field #73 not working","Complete","Calculated field #73 isn't actually populating in the Project report when we hit 'get data.' Are the conditions or fields it's using messed up somehow?","2022-12-13T09:11:45"]
[{"$nulls":3},1063,"(blank)","Ross","False Positive on #123 for Amaxra Projects","Complete","Ray & Margaret report that check #123 is producing a false positive for Amaxra projects. This check's description was as follows:\r\n\r\nProduces an error if a project's stage is marked \"Closed\" but the project's time contract amount is not equal to the total revenue recognized. Total revenue recognized is the sum of every month of revenue recognition\r\n\r\nThe problem here was that the calculated field for this check was using \"total revenue recognized,\" which includes negative revenue recognized when negative invoices are sent to clients. An alternative field that does not include negative revenue recognized is \"system revenue recognized.\"","2022-12-14T10:57:38"]
[{"$nulls":3},1066,"(blank)","Gary","Check #123 Conditions Not Working","Complete","Check #123: Revenue Recognition Must Equal Time Contract Amount if Project Closed is producing two false positives: each has a blank \"Time Contract Amount in Engagement Currency\" field and the check is producing a validation error for them anyway. (This should be precluded by condition 300). Any idea what's causing this?","2022-12-14T11:38:20"]
[{"$nulls":3},1067,"(blank)","Gary","Add \"Rename After Copy\" function","Complete","To implement commission checks, we'll need to be able to rename a field after we copy it from one report to another.","2022-12-14T12:26:58"]
[{"$nulls":3},1292,"(blank)","Gary","Need \"where\" condition for copied fields","Complete","dblCheck doesn't currently let you specify a \"where\" condition on copying a field from one report to another. I need this condition in order to tell dblCheck when to copy a field from one report and when not to (this is required for rGen check #271).","2023-01-09T15:11:08"]
[{"$nulls":3},1293,"(blank)","Gary","Need \"current year\" argument","Complete","Some checks require a \"current year\" argument in order to be table-driven. Otherwise I have to plug in the conditions and they will expire after the current year is out. This is relevant for rGen check #271.","2023-01-09T15:14:08"]
[{"$nulls":3},1294,"(blank)","Gary","Commissions Report Not Showing Up","Complete","The commissions report does not populate when you hit \"get data.\" This is presumably the result of the underlying report not being publicly available on Sharepoint. (It's available to anyone in the rGen domain but not publicly accessible).","2023-01-09T15:31:43"]
[{"$nulls":3},1344,"(blank)","Gary","Date Argument Not Functioning","Complete","Check #271 should only produce an error if the project start date is greater than 1/1/2023. However, it's producing errors for projects that started earlier than this. Can you debug this?","2023-01-10T12:57:48"]
[{"$nulls":3},1361,null,"Unassigned","Move Report screen needs updating","Pending","The Move Report button in Maintain Projector Reports gives the same exact screen as the Move Check button in Compose Check. This needs to be updated to have a report specific screen.","2023-01-12T14:38:27"]
[{"$nulls":3},1454,null,"Ross","Points Checks not Working Properly","Complete","When you're back from vacation, Gary, we need to figure out why checks #278 through #285 aren't working properly. They're producing false negatives right now. I imagine it's something simple in the SQL that you'd be able to diagnose pretty quickly.","2023-01-20T12:45:45"]
[{"$nulls":3},1691,"(blank)","Gary","Add Project Start Date and Project Stage to the Output dblCheck sends to Power BI","Complete","Gary R: Gary S is requesting the ability to filter for project start date and project stage. These fields aren't currently reported out to Power BI. I think that we'd be able to use it with the Power BI if you added more values beyond the existing four and I plugged these values into each relevant check.\r\n\r\nCarol,\r\n\r\nLooking now. Looks like it is displaying errors against all projects. Thinking default should be Open projects, with ability to look at all. Maybe a Start Date Slicer as well?\r\n\r\nGary","2023-02-02T16:01:36"]
[null,null,"Efficiency",2140,"May Release","Gary","Add apostrophe handling","Pending","Allow the user to use apostrophes in check names, descriptions, and error messages.","2023-03-09T09:22:12"]
[{"$nulls":3},2276,"(blank)","Gary","Delete unnecessary test calculated fields 15, 72, 91, 129, 130, and production calculated field 135","Pending","(blank)","2023-03-21T10:22:52"]
[null,"Low","(blank)",656,null,"Unassigned","Fix checks that use RDC Budget Value","Complete","dblCheck Report flagging projects that have no RDC but are Closed. 1852, 1853, and 1836. Maybe this behavior is OK and I can just hit the ignore.? Probably should discuss.","2022-11-15T10:33:44"]
[{"$nulls":3},760,"(blank)","Gary","Run-Time error 3197 when changing user to active","Complete","When attempting to switch a user from inactive to 'active,' dblcheck throws the following error: \"Run-time error '3197': The microsoft access database engine stopped the process because you and another user are attempting to cahnge the same data at the same time.\" This prevents changing a user from active to inactive or vice versa.","2022-11-30T09:06:40"]
[{"$nulls":3},761,"(blank)","Gary","Error on Refresh SQL","Complete","When the user clicks \"refresh SQL\" in the Dev instance of dblCheck, it throws the following error: \"Error: 3078 The microsoft access database engine cannot find the input table or query 'rGen_DblChk_TimeCard'. Make sure it exists and that its name is spelled correctly. Make sure you have run Get Data and this table is available.\"\r\n\r\nI think this is the result of my renaming rGen_DblChk_TimeCard to rGen_DblChk_Time_Card","2022-11-30T09:08:09"]
[{"$nulls":3},831,null,"Gary","Add check Categories","Complete","Please add a filter that can filter between different check categories: Client Info, Invoice, Purchase Order, Revenue Recognition, Milestone, Practice UDFs, and Project.","2022-12-08T15:20:27"]
[{"$nulls":3},1371,null,"Unassigned","Test","Complete","This is a test submission so I can screenshot the email send screen for the dblCheck wiki.","2023-01-17T10:54:50"]
[{"$nulls":3},1874,"(blank)","Gary","UID search results cannot be selected","Pending","When the user clicks the UID search button and enters some UID value, the system returns a list of a bunch of UIDs. However, this list is not set up so that the user can simply select one of them; it's all plain text.","2023-02-21T12:52:55"]
[null,null,"Efficiency",1878,"May Release","Gary","Fix or Remove \"IsActive\" checkbox","Pending","When you uncheck the 'IsActive' button, then click save, then navigate to a different check, and navigate back to that original check, the button is checked again. It's unclear whether this is affecting the basic functionality of the checkbox or if it is just a visual problem.","2023-02-21T13:12:29"]
[{"$nulls":3},1879,"May Release","Gary","Fix Write Conflict When Deleting Check","Pending","When the user clicks delete check, this produces a screen saying there's a write conflict. The check is successfully deleted, but requires leaving the compose check screen and going back in","2023-02-21T13:20:38"]
[{"$nulls":3},1989,"May Release","Gary","Expand Check ID Box to fit other boxes","Ready for Testing","The check ID box on the top right is smaller than the boxes below it. This should match.","2023-03-03T12:40:53"]
[{"$nulls":3},2134,"May Release","Gary","Allow dates without \"# #\" on either side","Pending","\tAllow user to write dates into the validation conditions without \"# #\" on either side.","2023-03-09T09:14:53"]
[null,null,"Reliability",2223,"1.6.5","Gary","Add a notes field to the checks changed view which allows an explanation of who requested the change, why it's been made, etc.","Ready for Testing","(blank)","2023-03-16T09:56:14"]

{"sheet":"To Do List Person","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"hidden":true}
[]
[]
[]
[]
[]
[null,"ID","Priority","Owner","Release","Development Goal","Impact","Status","Note","Added on"]
[null,2135,"Medium","Ross","April Release","Create test calculated fields for points checks redesign","Customer Improvement","Pending","The points checks need to have the SQL removed and replaced with a calculated field. Ross will need to set up test calculated fields as a proof of concept.","2023-03-09T09:16:26"]
[null,2137,"Medium","Carol","April Release","Allow users to select the number of days when you look at ignored errors on Power BI","Customer Improvement","Pending","(blank)","2023-03-09T09:18:44"]
[null,2138,"High","Gary","April Release","Automate Check Promotion Process","Reliability","Started","The check promotion process from test to production is time-consuming and error-prone. This needs to be automated.","2023-03-09T09:19:57"]
[null,2139,"High","Gary","April Release","Automate Calculated Field Promotion Process","Reliability","Started","Calculated field promotion process from test to production is time consuming and error-prone. This needs to be automated.","2023-03-09T09:21:11"]
[null,2143,"High","Carol","April Release","Replace check error ID with check ID in Power BI","Customer Improvement","Pending","\tChange Power BI output to produce a unique check ID # with each row of results rather than the unique error ID (this will assist in debugging checks).","2023-03-09T09:25:41"]
[null,2187,"High","Gary","April Release","Implement resizable and modular UI design","Efficiency","Started","(blank)","2023-03-13T14:23:30"]
[null,2188,"High","Ross","April Release","Add and test check #289: Purchase Order Required at Project Level","Customer Improvement","Started","Initially this check involved looking for contract line item PO#. But CLI PO# is not currently a reportable field. Erich forwarded this as an enhancement request. We're switching back to project level for now.","2023-03-13T14:43:32"]
[null,2191,"Medium","Magnus","April Release","Update wiki entries","Reliability","Pending","This depends on Carol writing release notes first","2023-03-13T14:47:09"]
[null,2193,"High","Carol","April Release","Create April Power BI mockup","Customer Improvement","Pending","(blank)","2023-03-13T14:49:08"]
[null,2196,"High","Carol","April Release","Write April Release Notes","Customer Improvement","Pending","(blank)","2023-03-14T09:41:13"]
[null,2215,"Medium","Gary","April Release","Create a view that details which checks have been changed","Reliability","Pending","Create a report that details which checks have been changed","2023-03-15T10:05:37"]
[null,2224,"Medium","Gary","April Release","Allow user to specify last day of month in check validation conditions","Customer Improvement","Pending","This is currently fixed via a little SQL in the validation conditions, but this is not a long-term solution. Two checks depend on this functionality: #291 and #293 (using test version check numbers)","2023-03-16T10:17:15"]
[null,2274,"High","Ross","April Release","Run April release through fit and finish checklist","Customer Improvement","Pending","Once April release development items have been completed, Ross should run through the fit and finish checklist to ensure this release is sellable","2023-03-21T10:11:04"]

{"sheet":"Action Tracker","index":2,"n_rows":12,"n_cols":10,"rows_kept":12}
[]
[null,"Owner","Supporting","Action Item","Component","Status","Priority","Related Dev ID","Due Date","Notes"]
[null,"Ross ",null,"Review list of April release items with team",null,"Complete","High",null,"2023-03-16"]
[null,"Ross ","Carol ","Share CB’s mockup for a self-service web portal for dblCheck with the team","Website","Complete","High",2207,"2023-03-17"]
[null,"Ross ",null,"Discuss adding a testing field with the team","Composer","Complete","High",null,"2023-03-17"]
[null,"Ross ","Gary ","Set up Check #294 (milestone date must be end of month)","Checks","Complete","High",2206,"2023-03-17"]
[null,"Gary ",null,"Enable last day of month in check validation conditions","Checks","Complete","High",2224,"2023-03-17","This is required for setting up check #294"]
[null,"Gary ",null,"Ensure that the to-do status can be entered in the support tool","Composer","Complete","High",null,"2023-03-17"]
[null,"Ross ",null,"Check in with Gary about development priorities for week of 3/20","Documentation","Complete","High",null,"2023-03-20"]
[null,"Ross "]
[null,"Ross ",null,"Review mockup of self-service web portal with team","Documentation","Complete","High",2207,"2023-03-20"]
[null,"Ross ","Carol ","Follow up with Projector about CLI Purchase Order #","Checks","Pending","High",2189,"2023-04-01","CLI PO # is not currently a reportable field in Projector. Erich told Ross on 3/15 that he would add an enhancement request to make it one"]

{"sheet":"Lookups","index":3,"n_rows":35,"n_cols":3,"rows_kept":35}
[]
[null,"RespId","Responsible"]
[null,1,"Gary "]
[null,2,"Ross "]
[null,3,"Carol "]
[null,4,"Ray "]
[null,5,"Jules"]
[null,6,"Magnus "]
[]
[null,"ComponentID","Component"]
[null,1,"Composer"]
[null,2,"Power BI Dashboard"]
[null,3,"SQL Database"]
[null,4,"Projector Reports"]
[null,5,"Checks"]
[null,6,"Calculated Fields"]
[null,7,"Configuration Data"]
[null,8,"Web Services"]
[null,9,"Website"]
[null,10,"Documentation"]
[]
[null,"PriorityID","Priority"]
[null,1,"Low"]
[null,2,"Medium"]
[null,3,"High"]
[]
[null,"StatusId","Status"]
[null,"ST0001","Pending"]
[null,"ST0002","Started"]
[null,"ST0003","Ready for test"]
[null,"ST0004","Complete"]
[null,"ST0005","Cancelled"]
[null,"ST0006","Future feature"]
[null,"ST0007","Denied"]
[null,"ST0008","Cancelled"]

{"sheet":"vue_tblBugs","index":4,"n_rows":102,"n_cols":25,"rows_kept":102}
["AssignedTo","ResolutionType","Status","Impact","BugID","BugType","Severity","BugStatus","BugStatusLKPID","AssignedToLKPID","PageName","BugTitle","BugDescription","Notes","FixedInVersion","Email","FirstName","LastName","ResolutionTypeLKPID","ImpactTypeLKPID","InsertedBy","InsertedDateTime","UpdatedBy","UpdatedDateTime","TestNotes"]
["Ross",null,"Complete",null,131,"Bug","High","Fixed",293,244,"Compose Check","Fix Check 74","74 is not producing an error when the project description field is empty, presumably because it's marking them all as zero rather than null.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-12T11:20:32","Ross","2022-10-12T11:20:32"]
["Unassigned",null,"Complete",null,132,"ToDo","High","Fixed",293,241,"Compose Check","Add calculated field for Check 80","Check 80: \"Sum Milestone Amount By Project Must Equal Time Contract Amount\" needs a calculated field to work properly in the EVT profile.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-12T11:23:56","Ross","2022-10-12T11:23:56"]
["Unassigned",null,"Complete",null,150,"ToDo","High","Fixed",293,241,"Compose Check","Fix Check 90","Check produces false negatives.\r\n\r\nEdit: This has been fixed: Cannot fill validation conditions for check 90 because Project stage is a field contained within EVT_DblChk_Project but System Revenue Recognized is a field contained within EVT_DblChK_RevRec. As far as I can tell, we don't currently have a way to compare","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-12T12:02:55","Ross","2022-10-12T12:02:55"]
["Unassigned",null,"Complete",null,223,"ToDo","High","Fixed",293,241,"Compose Check","Enable three checks on hold","CH0085 \tNeeds to address time card fields, but we need clarification exactly which fields EVT is interested in\r\nCH0087 \tNeeds to address time card fields, but we need clarification exactly which fields EVT is interested in\r\nCH0091 On hold pending enhancement; needs fields from two different reports","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-12T13:44:36","Ross","2022-10-12T13:44:36"]
["Ross",null,"Complete",null,516,"Bug","High","Fixed",293,244,"Maintain Calculated Fields","Sum Invoice Amount By Included Project Codes Broken","Sum Invoice Amount By Included Project Codes is not appearing on EVT_DblChk_Invoice as it should, and as a result is breaking checks #82, #84, and #89.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-26T16:15:09","Ross","2022-10-26T16:15:09"]
["Unassigned",null,"Complete",null,518,"ToDo","High","Fixed",293,241,"Maintain Calculated Fields","Build new calc field for #86 and #90","New calculated field needs to appear in EVT_DblChk_Rev_Rec and should be the following: Sum of Total Revenue Recognized by Project UID.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-26T16:17:28","Ross","2022-10-26T16:17:28"]
["Unassigned",null,"Denied",null,545,"Bug","High","Denied",296,241,"Launch","Keep Access open when dblCheck launches","If the user has an active Access instance running, launching dblCheck closes Access.","Can't reproduce","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-31T15:05:28","Ross","2022-10-31T15:05:28"]
["Unassigned",null,"Complete",null,547,"ToDo","Medium","Fixed",293,241,"Help Page/User Guide","Complete help screen","Help Page/User Guide Needs to be Completed","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-31T15:09:04","Ross","2022-10-31T15:09:04"]
["Unassigned",null,"Complete",null,548,"ToDo","Medium","Fixed",293,241,"All Pages","Upgrade Graphics","Updated, higher-DPI graphics need to be implemented throughout dblCheck.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-31T15:09:51","Ross","2022-10-31T15:09:51"]
["Unassigned",null,"Complete",null,549,"ToDo","Medium","Fixed",293,241,"N/A","Connect website to domain","This item is listed as due 11/4.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-31T15:14:47","Ross","2022-10-31T15:14:47"]
["Unassigned",null,"Complete",null,550,"ToDo","High","Fixed",293,241,"Main Screen","Allow users to disable specific check results","EVT expressed the desire to disable specific check results if they want the check to continue running, but don't want to keep seeing the same errors on future runs.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-31T15:16:42","Ross","2022-10-31T15:16:42"]
["Unassigned",null,"Cancelled",null,551,"ToDo","Medium","Cancelled",294,241,"Main Screen","Email Report Feature","EVT wants the ability to easily email dblCheck results to chosen recipients.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-10-31T15:19:58","Ross","2022-10-31T15:19:58"]
["Gary",null,"Denied",null,561,"Suggestion","Low","Denied",296,242,null,"Allow dblCheck user to pin program to taskbar","When the user tries to pin dblCheck to the taskbar, it pins Access instead","This used to be fairly easy to do, but Microsoft made some changes a few years ago to purposely make this very difficult.  They really only want users actively choosing on their own the software to pin to their taskbar.\r\n\r\nSo, the short answer to your question is no, if you want to maintain your sanity.  As with all things, where there's a will, there's probably a way, but you'd have to figure that out on your own and it's not for the faint of heart and will likely require you manipulating binary registry data where Microsoft stores this information.  This isn't an SSE Setup limitation, but a Windows-imposed one.  I haven't found any easy solution and I have noted that other installer developers have come to the same conclusion.\r\n\r\nRegards,\r\nChris Long\r\nSSE Setup",null,"Magnus.@rgenconsulting.com","Magnus",{"$nulls":3},"Magnus ","2022-11-02"]
[null,null,"Complete",null,562,"Bug","High","Fixed",293,null,null,"Rename calculated field \"Discounted Time Contact Amount\" to \"Discounted Time Contract Amount\"","I'm unsure which report this field lives in. I have no additional information apart from the title and Ross's notes: \"This change is easy but high risk. Gary wants to take time to ensure there are no unintended consequences\"",null,null,"Magnus.@rgenconsulting.com","Magnus",{"$nulls":3},"Magnus ","2022-11-02"]
["Gary",null,"Denied",null,563,"Bug","Medium","Denied",296,242,null,"Fix ctrl-a issue","When the user hits 'ctrl-a' DblCheck selects every database entry in the background instead of all of the current selection.","Need more info",null,"Magnus.@rgenconsulting.com","Magnus",{"$nulls":3},"Magnus ","2022-11-02"]
["Unassigned",null,"Ready for Testing",null,579,"Bug","High","Ready for Testing",292,241,"DblCheck Results","Fix Link/URL to Projecctor","When reviewing results and user selects the Link/URL, user is shown details of the error check vs a Projector Web window with the page to see/resolve the error.","11/8/2022 8:25:43 AM - Ross \r\nHello Gary Sack,\r\n\r\nThanks for letting us know about this. Gary has confirmed that this will be fixed in version 1.2.7. For now, you can double click on the results and that should work. If you have questions, please reply to this email and we’ll continue to look into the issue. \r\n\r\nBest,\r\nRoss\r\nThe dblCheck Support Team","","rsack@evtcorp.com","Gary","Sack",null,null,"wendy","2022-11-07T17:23:07","wendy","2022-11-07T17:23:07"]
["Ross",null,"Ready for Testing",null,580,"Bug","High","Ready for Testing",292,244,"Results","Update EVT checks from time contract amount to total contract amount","1.\tdblCheck looks to be checking UDF vs Time Contract Field vs Time + Contract Field. Thinking dblCheck should add both Time + Cost Terms\r\n2.\tdblCheck will likely error on Rev Rec vs Contract amount as well.  May be unavoidable. Good use of dblCheck “Ignore”?","11/8/2022 3:07:41 PM - Ross \r\nRoss: solved this by switching check 92 to total contract amount instead of time contract amount. This may necessitate additional changes to checks that use time contract amount.",null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-08T09:53:43","Ross","2022-11-08T09:53:43"]
["Gary",null,"Denied",null,581,"ToDo","High","Denied",296,242,"Main Page","Add email results button","EVT needs a way to send dblCheck results to designated recipients (specifically Jason and Lacey). This needs to be a button that automatically sends an email to the recipients the user chooses, without the user needing to export the results to excel, find the document on their hard drive and email it manually.","11/9/2022 2:20:19 PM - rGen Bot\r\nThis feature has been canceled in favor of a PowerBI implementation.",null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-08T10:08:39","Ross","2022-11-08T10:08:39"]
["Gary","Code Fix","Complete",null,582,"ToDo","High","Fixed",293,242,"N/A","Add multi-report functionality","Checks #85, #87, and #91 require fields that are in two different reports, and Projector does not support reporting these fields in the same report. We need a way for a check to reference fields in two different reports at once.\r\n\r\nIf this can't be done by November 18th, let Ross know.",null,null,"ross.@rgenconsulting.com","Ross",null,263,null,"Ross","2022-11-08T10:11:43","Ross","2022-11-08T10:11:43"]
["Gary",null,"Complete",null,583,"ToDo","High","Fixed",293,242,"N/A","Create dev, staging, release enviGaryments","To ensure a consistent user experience, we need to be able to test updates in a developer mode before they are pushed to all users.  Create dev, staging, and release enviGaryments that allow testing updates ahead of user release.\r\n\r\nIf this can't be done by November 21st, let Ross know.",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-08T10:20:48","Ross","2022-11-08T10:20:48"]
["Unassigned",null,"Denied",null,603,"Bug","Low","Denied",296,241,"Test Screen","Testing from within VM","This is a test bug submitted by Ross in the VM","11/9/2022 2:19:48 PM - rGen Bot\r\ntest notes\r\n\r\n11/9/2022 2:18:37 PM - rGen Bot\r\nHello rGen Bot,\r\n\r\nThank you for submitting a DblCheck support ticket. We’ve received your request and we’ll get back to you in the next 24 hours with an assessment of your issue.\r\n\r\nBest,\r\n\r\nThe dblCheck Support Team","","rGenBot@rgenconsulting.com","rGen","Bot",null,null,"rGenBot","2022-11-09T14:16:52","rGenBot","2022-11-09T14:16:52"]
["Gary",null,"Complete",null,639,"ToDo","Medium","Fixed",293,242,"Results Screen","Add \"Person Responsible\" field","January enhancement after web services, migration to rGen Azure, and Power BI implementation are done:\r\n\r\nThe \"show results\" page needs a “person responsible” field for dblCheck results, so that each team member can easily identify whether a validation error is their responsibility to fix.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-11T13:31:47","Ross","2022-11-11T13:31:47"]
["Unassigned",null,"Complete",null,656,"Suggestion","Low","Fixed",293,241,"","Fix checks that use RDC Budget Value","dblCheck Report flagging projects that have no RDC but are Closed. 1852, 1853, and 1836. Maybe this behavior is OK and I can just hit the ignore.? Probably should discuss.","11/15/2022 10:47:07 AM - Ross \r\nHello Gary Sack,\r\n\r\nI've investigated check 94, which is producing these validation errors: it wasn't discriminating between open and closed projects. I've added a condition that prevents it from flagging projects that are closed, so if you run dblCheck again, you shouldn't see those errors anymore.\r\n\r\nIf there's a different behavior you want from this check, let me know. Otherwise, thank you again for submitting a DblCheck support ticket and we hope you continue to enjoy using DblCheck. \r\n\r\nBest,\r\nRoss\r\nThe dblCheck Support Team","","rsack@evtcorp.com","Gary","Sack",null,null,"wendy","2022-11-15T10:33:44","wendy","2022-11-15T10:33:44"]
["Ross",null,"Complete",null,657,"Bug","Medium","Fixed",293,244,"","Allow checks to evaluate RDC Budget Value when value is unnamed","1997 Has an RDC Budget, but not assigned to a specific resource. dblCheck should accommodate named and un-named Budget values.","11/22/2022 1:04:26 PM - Ross \r\nHello Gary Sack,\r\n\r\nI'm writing to update you on the false positive you found last week with #94. As you noted, dblCheck was flagging a project as not having RDC budget value when that project did have an RDC budget value in the web version of Projector. This was ultimately the result of that project not having a budget assigned to a specific person, so RDC budget value did not populate in the Project report from Projector. I have solved this issue and this check should work properly in the new version scheduled for release on November 30th.\r\n\r\nTo solve it, I switched the relevant check to reference the Rev Rec report instead of the Project report, then added budgeted resource direct cost to that report. I then created a calculated field to find any instance where that budgeted resource direct cost was populated and added that to the check's validation conditions. The check should now only flag instances where a project's RDC budget value is actually missing, irrespective of whether that budget has been assigned to a specific person.\r\n\r\nIf you continue to have problems with #94, please write back here. Otherwise, thank you again for submitting a DblCheck support ticket and we hope you continue to enjoy using DblCheck. \r\n\r\nBest,\r\nRoss\r\nThe dblCheck Support Team\r\n\r\n11/17/2022 4:55:18 PM - Ross \r\nHi Gary,\r\n\r\nCarol and I emailed back and forth with Projector quite a bit today, but haven't yet resolved the problem. Projector can find the RDC budget value for project 1997 in their report, but we can't get this value reported in EVT's ginsu report. This seems to only affect 1997, and like you mentioned in your original message, the RDC budget value not being assigned to anyone is probably playing some role. We're working on squaring this circle but it may not be solved until next week.\r\n\r\nThanks again for your patience,\r\nRoss\r\nThe dblCheck Support Team\r\n\r\n11/16/2022 1:38:57 PM - Ross \r\nHello Gary Sack,\r\n\r\nJust following up on this ticket from yesterday: we're in contact with Projector about this issue and will update you on our progress within another 24 hours.\r\n\r\nThank you for your patience,\r\nRoss\r\nThe dblCheck Support Team\r\n\r\n11/15/2022 10:59:49 AM - Ross \r\nHello Gary Sack,\r\n\r\nThis second issue with check 94 will require a little investigation. I'll confer with Carol and see what we can do to solve it. You should hear back from us within 24 hours.\r\n\r\nThank you for your patience,\r\nRoss\r\nThe dblCheck Support Team","","rsack@evtcorp.com","Gary","Sack",null,null,"wendy","2022-11-15T10:35:13","wendy","2022-11-15T10:35:13"]
["Unassigned",null,"Complete",null,658,"ToDo","High","Fixed",293,241,"Compose Check","Enable multi-report support for Check #91","Check #91 needs the following fields:\r\n\r\nFrom EVT_DblChk_Invoice_Milestone:\r\nMilestone status\r\n\r\nFrom EVT_DblChk_Invoice:\r\nInvoice amount\r\n\r\nIt will use Project UID, which is contained in both reports.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-16T08:42:05","Ross","2022-11-16T08:42:05"]
["Unassigned",null,"Complete",null,659,"ToDo","High","Fixed",293,241,"Compose Check","Checks #85 & 87 multi-report support requirements","Update as of 1:25PM 11/16:\r\n\r\nWhat we need for checks 85 and 87:\r\n\r\n1. Project Stage copied from EVT_DblChk_RevRec  to EVT_DblChk_Time_Card by Project UID\r\n\r\n2. Sum of Total Revenue Recognized copied from EVT_DblChk_RevRec to EVT_DblChk_Time_Card by Project UID\r\n\r\n3. Time Contract Amount in Engagement Currency copied from EVT_DblChk_RevRec to  EVT_DblChk_Time_Card by Project UID","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-16T08:55:39","Ross","2022-11-16T08:55:39"]
["Unassigned",null,"Ready for Testing",null,681,"Bug","High","Ready for Testing",292,241,"Maintain Calculated Field","Sort list by sort order","The list of calculated fields should be sorted by sort order instead of calculated field number","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-17T09:23:34","Ross","2022-11-17T09:23:34"]
["Gary",null,"Complete",null,729,"ToDo","Medium","Fixed",293,242,"Manage Bugs","Change 'DblCheck' to 'dblCheck'","The options for composing an email refer to 'DblCheck' but Ray pointed out this should be \"dblCheck.\"",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-23T15:35:33","Ross","2022-11-23T15:35:33"]
["Gary",null,"Complete",null,733,"ToDo","Medium","Fixed",293,242,"Show Results","Add filter for specific projects/engagements/contracts","January enhancement after web services, migration to rGen Azure, and Power BI implementation are done:\r\n\r\nEnhancement request from Ray: we need to be able to limit dblCheck results to specific projects, engagements, and contract line items.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-28T16:18:09","Ross","2022-11-28T16:18:09"]
["Gary",null,"Complete",null,760,"Bug","Low","Fixed",293,242,"Manage Users","Run-Time error 3197 when changing user to active","When attempting to switch a user from inactive to 'active,' dblcheck throws the following error: \"Run-time error '3197': The microsoft access database engine stopped the process because you and another user are attempting to cahnge the same data at the same time.\" This prevents changing a user from active to inactive or vice versa.",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-30T09:06:40","Ross","2022-11-30T09:06:40"]
["Gary",null,"Complete",null,761,"Bug","Low","Fixed",293,242,"Refresh SQL","Error on Refresh SQL","When the user clicks \"refresh SQL\" in the Dev instance of dblCheck, it throws the following error: \"Error: 3078 The microsoft access database engine cannot find the input table or query 'rGen_DblChk_TimeCard'. Make sure it exists and that its name is spelled correctly. Make sure you have run Get Data and this table is available.\"\r\n\r\nI think this is the result of my renaming rGen_DblChk_TimeCard to rGen_DblChk_Time_Card",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-11-30T09:08:09","Ross","2022-11-30T09:08:09"]
["Gary",null,"Complete",null,762,"Bug","High","Fixed",293,242,"Manage Companies","Cloning doesn't include new fields","Cloning a company does not include new fields such as copyToTableName.","","","","","",null,null,"Garyr","2022-11-30T09:13:45","Garyr","2022-11-30T09:13:45"]
["Gary",null,"Complete",null,825,"Bug","Medium","Fixed",293,242,"Compose Check for check 125","Error 3078 re: Time card report","In the rGen test instance, when attempting to access check 125, dblcheck throws the following error: \"Error 3078 The Microsoft Access database engine cannot find the input table or query 'rGen_DblChk_TimeCard.\" Make sure it exists and that its name is spelled correctly. Make sure you have run Get Data and this table is available.\r\n\r\nThis is the result of my changing the name of the table from 'rGen_DblChk_TimeCard' to ''rGen_DblChk_Time_Card'","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-12-07T11:59:58","Ross","2022-12-07T11:59:58"]
["Gary","Enhancement","Complete",null,831,"Suggestion","Low","Fixed",293,242,"Compose Check","Add check Categories","Please add a filter that can filter between different check categories: Client Info, Invoice, Purchase Order, Revenue Recognition, Milestone, Practice UDFs, and Project.","","","Magnus.@rgenconsulting.com","Magnus",null,268,null,"Magnus","2022-12-08T15:20:27","Magnus","2022-12-08T15:20:27"]
["Gary",null,"Complete",null,832,"ToDo","Medium","Fixed",293,242,"Compose Check","Add filter (CategoryLKPID) to Compose Check Screen","January enhancement after web services, migration to rGen Azure, and Power BI implementation are done:\r\n\r\nAdd filter (CategoryLKPID) to Compose Check Screen",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-12-08T15:34:28","Ross","2022-12-08T15:34:28"]
["Gary","Enhancement","Complete",null,910,"ToDo","Medium","Fixed",293,242,"Maintain Calculated Fields","Add \"where\" condition to equations in \"Maintain calculated fields\"","Calculated field #72 doesn't work properly, and I think it's because it's attempting to divide by zero. I want to be able to exclude rows with \"0\" from the field's calculation. Can you add this?","12/13/2022 9:09:18 AM - Ross \r\nSuggested solution: add a \"where\" condition to equations",null,"ross.@rgenconsulting.com","Ross",null,268,null,"Ross","2022-12-12T14:07:46","Ross","2022-12-12T14:07:46"]
["Unassigned",null,"Complete",null,915,"Bug","High","Fixed",293,241,"Get Data button","Get Data not finishing","When I hit get data, it's stuck on \"SumTotal Revenue RecognizedByProject UID - 129 of 130 records\". I believe this has to do with an additional calculated field added in today.","12/12/2022 3:41:15 PM - Ross \r\nRoss says: please note that this is only affecting the rGen instance.","","Magnus.@rgenconsulting.com","Magnus",{"$nulls":3},"Magnus","2022-12-12T15:34:37","Magnus","2022-12-12T15:34:37"]
["Gary",null,"Complete",null,931,"Bug","Medium","Fixed",293,242,"Maintain Calculated Fields","Error when entering table name","When entering \"table name\" in the \"maintain calculated fields\" screen, dblCheck throws the following error: \"Compile error in hidden module: Form_frmCalculatedFields. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.\"","12/13/2022 8:43:33 AM -  \r\nAfter this error is thrown, dblCheck requires the user to log back in.",null,"","","",null,null,"Ross","2022-12-13T08:42:23","Ross","2022-12-13T08:42:23"]
["Gary","User Error","Complete",null,948,"Bug","Medium","Fixed",293,242,"Maintain calculated fields","Calculated Field #73 not working","Calculated field #73 isn't actually populating in the Project report when we hit 'get data.' Are the conditions or fields it's using messed up somehow?",null,null,"ross.@rgenconsulting.com","Ross",null,267,null,"Ross","2022-12-13T09:11:45","Ross","2022-12-13T09:11:45"]
["Ross","Check Problem","Complete",null,1063,"Bug","Medium","Fixed",293,244,"Compose Check","False Positive on #123 for Amaxra Projects","Ray & Margaret report that check #123 is producing a false positive for Amaxra projects. This check's description was as follows:\r\n\r\nProduces an error if a project's stage is marked \"Closed\" but the project's time contract amount is not equal to the total revenue recognized. Total revenue recognized is the sum of every month of revenue recognition\r\n\r\nThe problem here was that the calculated field for this check was using \"total revenue recognized,\" which includes negative revenue recognized when negative invoices are sent to clients. An alternative field that does not include negative revenue recognized is \"system revenue recognized.\"","12/14/2022 11:47:56 AM - Ross \r\nHello Ray,\r\n\r\nI've tracked down the problem with check #123. The calculated field for this check was using \"total revenue recognized,\" which includes negative revenue recognized when negative invoices are sent to clients. These negative invoices are not reflected on the revenue recognition screen of Projector's web interface. \r\n\r\nAn alternative field that does not include negative revenue recognized is \"system revenue recognized.\" I have modified the underlying calculated field to use this field instead.\r\n\r\nI have also attached the \"list of rGen checks\" which includes the description and error message for each check. Check #123's description has now been updated to reflect its new behavior. I have marked this ticket \"closed.\"\r\n\r\nBest,\r\nRoss\r\nThe dblCheck Support Team\r\n\r\n12/14/2022 11:41:40 AM - Ross \r\nHello Ray,\r\n\r\nThank you for submitting a dblCheck support ticket. We’ve received your request and we’ll get back to you in the next 24 hours with an assessment of your issue.\r\n\r\nBest,\r\nRoss\r\nThe dblCheck Support Team",null,"ray.@rgenconsulting.com","Ray",null,264,null,"Ray","2022-12-14T10:57:38","Ross","2022-12-14T10:57:38"]
["Gary",null,"Complete",null,1066,"Bug","Medium","Fixed",293,242,"Compose Check","Check #123 Conditions Not Working","Check #123: Revenue Recognition Must Equal Time Contract Amount if Project Closed is producing two false positives: each has a blank \"Time Contract Amount in Engagement Currency\" field and the check is producing a validation error for them anyway. (This should be precluded by condition 300). Any idea what's causing this?",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-12-14T11:38:20","Ross","2022-12-14T11:38:20"]
["Gary",null,"Complete",null,1067,"ToDo","Medium","Fixed",293,242,"Maintain Calculated Fields","Add \"Rename After Copy\" function","To implement commission checks, we'll need to be able to rename a field after we copy it from one report to another.",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-12-14T12:26:58","Ross","2022-12-14T12:26:58"]
["Gary",null,"Complete",null,1068,"Bug","High","Fixed",293,242,"Compose Check","Check #266 not ignoring blank entries","Check #266 is supposed to ignore rows where Actual Project Margin Percentage is blank. But it's not doing that; it's still reporting all these as validation errors.",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2022-12-14T13:07:24","Ross","2022-12-14T13:07:24"]
["Gary","Enhancement","Complete",null,1292,"ToDo","Medium","Fixed",293,242,"Maintain Calculated Fields","Need \"where\" condition for copied fields","dblCheck doesn't currently let you specify a \"where\" condition on copying a field from one report to another. I need this condition in order to tell dblCheck when to copy a field from one report and when not to (this is required for rGen check #271).",null,null,"ross.@rgenconsulting.com","Ross",null,268,null,"Ross","2023-01-09T15:11:08","Ross","2023-01-09T15:11:08"]
["Gary","Code Fix","Complete",null,1293,"ToDo","Medium","Fixed",293,242,"Compose Check Screen","Need \"current year\" argument","Some checks require a \"current year\" argument in order to be table-driven. Otherwise I have to plug in the conditions and they will expire after the current year is out. This is relevant for rGen check #271.",null,null,"ross.@rgenconsulting.com","Ross",null,263,null,"Ross","2023-01-09T15:14:08","Ross","2023-01-09T15:14:08"]
["Gary","Code Fix","Complete",null,1294,"ToDo","Medium","Fixed",293,242,"Show Ribbon","Commissions Report Not Showing Up","The commissions report does not populate when you hit \"get data.\" This is presumably the result of the underlying report not being publicly available on Sharepoint. (It's available to anyone in the rGen domain but not publicly accessible).",null,null,"ross.@rgenconsulting.com","Ross",null,263,null,"Ross","2023-01-09T15:31:43","Ross","2023-01-09T15:31:43"]
["Gary","Enhancement","Complete",null,1344,"ToDo","Medium","Fixed",293,242,"Compose Check","Date Argument Not Functioning","Check #271 should only produce an error if the project start date is greater than 1/1/2023. However, it's producing errors for projects that started earlier than this. Can you debug this?","1/12/2023 10:16:43 AM - Ross \r\nThis is fixable by adding hashtags around the date entry. However, long-term, this syntax ought to be incorporated so the user does not need to know it.",null,"ross.@rgenconsulting.com","Ross",null,268,null,"Ross","2023-01-10T12:57:48","Ross","2023-01-10T12:57:48"]
["Gary","Code Fix","Complete",null,1346,"Bug","High","Fixed",293,242,"Get Data","Commissions report throws error","When I try to run \"get data\" with the commissions report enabled, it throws the following error: \"Not a valid csv file…\" The file is a CSV file, though, so this error message didn't help me identify the problem.",null,null,"ross.@rgenconsulting.com","Ross",null,263,null,"Ross","2023-01-10T16:03:52","Ross","2023-01-10T16:03:52"]
["Unassigned",null,"Pending",null,1361,"ToDo","Medium","New",290,241,"Maintain Projector Reports - Move Report","Move Report screen needs updating","The Move Report button in Maintain Projector Reports gives the same exact screen as the Move Check button in Compose Check. This needs to be updated to have a report specific screen.","","","Magnus.@rgenconsulting.com","Magnus",{"$nulls":3},"Magnus","2023-01-12T14:38:27","Magnus","2023-01-12T14:38:27"]
["Unassigned",null,"Pending",null,1362,"ToDo","High","New",290,241,"Maintain Projector Reports","Import This Report button bug","When clicking Import This Report button in the Maintain Projector Reports, nothing happens.","","","Magnus.@rgenconsulting.com","Magnus",{"$nulls":3},"Magnus","2023-01-12T14:51:55","Magnus","2023-01-12T14:51:55"]
["Unassigned",null,"Complete",null,1371,"ToDo","Low","Fixed",293,241,"Test","Test","This is a test submission so I can screenshot the email send screen for the dblCheck wiki.","","","Magnus.@rgenconsulting.com","Magnus",{"$nulls":3},"Magnus","2023-01-17T10:54:50","Magnus","2023-01-17T10:54:50"]
["Unassigned","Code Fix","Complete",null,1450,"Bug","High","Fixed",293,241,"PowerBI Dashboard","Change final refresh screen status","Change the final refresh screen status when hitting \"Refresh Data\" to just \"Finished\" instead of \"Finished OK\".","","","Magnus.@rgenconsulting.com","Magnus",null,263,null,"Magnus","2023-01-20T10:07:30","Magnus","2023-01-20T10:07:30"]
["Ross","Code Fix","Complete",null,1454,"Bug","Medium","Fixed",293,244,"Compose Checks Screen","Points Checks not Working Properly","When you're back from vacation, Gary, we need to figure out why checks #278 through #285 aren't working properly. They're producing false negatives right now. I imagine it's something simple in the SQL that you'd be able to diagnose pretty quickly.","","","ross.@rgenconsulting.com","Ross",null,263,null,"Ross","2023-01-20T12:45:45","Ross","2023-01-20T12:45:45"]
["Unassigned",null,"Denied",null,1561,"ToDo","Low","Denied",296,241,"Compose Check Screen","Enable apostrophes for error messages","The compose check screen allows the entry of apostrophes in the error message, but dblCheck strips them out for the final report. This makes error messages look unprofessional to the user. I've rephrased the checks for now, but this should be fixed in the future.","","","ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2023-01-25T10:55:41","Ross","2023-01-25T10:55:41"]
["Gary",null,"Complete",null,1691,"ToDo","Medium","Fixed",293,242,"Power BI Dashboard","Add Project Start Date and Project Stage to the Output dblCheck sends to Power BI","Gary R: Gary S is requesting the ability to filter for project start date and project stage. These fields aren't currently reported out to Power BI. I think that we'd be able to use it with the Power BI if you added more values beyond the existing four and I plugged these values into each relevant check.\r\n\r\nCarol,\r\n\r\nLooking now. Looks like it is displaying errors against all projects. Thinking default should be Open projects, with ability to look at all. Maybe a Start Date Slicer as well?\r\n\r\nGary","2/3/2023 10:52:45 AM - Ross \r\nI think there may be a way for us to add project number to the display without needing to push another update. I’ll check with Carol about it and get back to you. I’ll mention the slicer search function as well.\r\n\r\n2/3/2023 10:52:34 AM - Ross \r\nFrom: Gary Sack <rsack@evtcorp.com> \r\nSent: Friday, February 3, 2023 10:05 AM\r\nTo: Ross  <ross.@rgenconsulting.com>\r\nCc: Support <support@rgenconsulting.com>; Gary  <Gary.@rgenconsulting.com>\r\nSubject: RE: dblCheck Support Ticket #1691\r\n\r\nThanks Ross. Those are probably good for now. Any way you can add Project Number to the Display? Also, on the Slicers there does not appear to be a search function on the drop down.\r\n\r\nGary\r\n\r\n2/3/2023 9:45:56 AM - Ross \r\nHello Gary Sack,\r\n\r\nI've discussed adding new slicers to the Power BI with Gary R and we think it's an excellent idea. \r\n\r\nTo get more slicers, we'll need to do some back-end development to redesign the way dblCheck reports out the fields to Power BI. We expect to add support for fields like project start date and project stage in the next update, which we anticipate completing at the end of next week (2/10). In the meantime, are there any other fields you'd like to be able to filter with a slicer? \r\n\r\nThank you for your patience,\r\nRoss\r\nThe dblCheck Support Team\r\n\r\n2/2/2023 4:15:35 PM -  \r\nHello Gary Sack,\r\n\r\nWe’ve received your enhancement request for additional slicers for Project Stage and Project Start Date and I've created a ticket on your behalf. We'll get back to you about it in the next 24 hours.\r\n\r\nBest,\r\nRoss\r\nThe dblCheck Support Team\r\n\r\n2/2/2023 4:05:56 PM -  \r\nHello  Gary Sack,\r\n\r\nWe’ve received your request and have created a ticket on your behalf. We'll get back to you in the next 24 hours with an assessment of your issue.\r\n\r\nBest,\r\nRoss\r\nThe dblCheck Support Team",null,"rsack@evtcorp.com","Ross",{"$nulls":3},"Ross","2023-02-02T16:01:36","Ross","2023-02-02T16:01:36"]
["Gary",null,"Denied",null,1873,"Bug","Medium","Denied",296,242,"Compose Check","\"Move Check\" dropdown fails to populate","When the user selects the \"move check\" button and selects the dropdown box to pick a company, only the current company populates that box.","2/27/2023 8:11:20 AM - Gary \r\nThis is by design. A chack can't be moved to another company because they have different reports",null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2023-02-21T12:49:37","Ross","2023-02-21T12:49:37"]
["Gary",null,"Pending",null,1874,"ToDo","Low","New",290,242,"Compose Check","UID search results cannot be selected","When the user clicks the UID search button and enters some UID value, the system returns a list of a bunch of UIDs. However, this list is not set up so that the user can simply select one of them; it's all plain text.",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2023-02-21T12:52:55","Ross","2023-02-21T12:52:55"]
["Gary",null,"Complete",null,1875,"ToDo","High","Fixed",293,242,"Fit and Finish Checklist","Review Fit and Finish Checklist and Make Changes","Please review the fit and finish checklist for 1.5.6 and make the appropriate changes to the dblCheck composer. There are quite a few changes in here that would improve the look and feel of the composer and help make it a more visually attractive product. This is necessary as some sales calls may need to use the composer in demonstrations.",null,null,"ross.@rgenconsulting.com","Ross",{"$nulls":3},"Ross","2023-02-21T12:54:44","Ross","2023-02-21T12:54:44"]
["Gary",null,"Pending","Efficiency",1878,"ToDo","Low","Pending",290,242,"Compose Check","Fix or Remove \"IsActive\" checkbox","When you uncheck the 'IsActive' button, then click save, then navigate to a different check, and navigate back to that original check, the button is checked again. It's unclear whether this is affecting the basic functionality of the checkbox or if it is just a visual problem.",null,"May Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-02-21T13:12:29","Ross","2023-02-21T13:12:29"]
["Gary",null,"Pending","Efficiency",1879,"ToDo","Low","Pending",290,242,"Compose Check","Fix Write Conflict When Deleting Check","When the user clicks delete check, this produces a screen saying there's a write conflict. The check is successfully deleted, but requires leaving the compose check screen and going back in",null,"May Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-02-21T13:20:38","Ross","2023-02-21T13:20:38"]
["Unassigned",null,"Complete","Efficiency",1927,"ToDo","High","Fixed",293,241,"Run dblCheck","Log when check fails","Write a record to the error log when the timer check fails","","","Gary.@rGenConsulting.com","Gary",null,null,301,"Garyr","2023-02-28T09:46:50","Garyr","2023-02-28T09:46:50"]
["Gary",null,"Ready for Testing","Efficiency",1928,"ToDo","High","Pending",292,242,"All Pages","Make sure insertedBy and Updated By are working","Make sure all forms fill in the inserted by fields",null,"1.6.6","Gary.@rGenConsulting.com","Gary",null,null,301,"Garyr","2023-02-28T10:16:49","Garyr","2023-02-28T10:16:49"]
["Gary",null,"Pending","Efficiency",1974,"ToDo","High","New",290,242,"All","Determine where calculated field is used","Determine where calculated field is used",null,null,"Gary.@rGenConsulting.com","Gary",null,null,301,"Garyr","2023-03-01T09:30:32","Garyr","2023-03-01T09:30:32"]
["Gary",null,"Complete","Efficiency",1986,"ToDo","Low","Pending",293,242,"Compose Check","Add extra room for check ID #","Ray would like room for 5 digits in the check ID number on the left side of the compose check screen.",null,"April Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-03-03T12:08:38","Ross","2023-03-03T12:08:38"]
["Gary",null,"Ready for Testing","Efficiency",1989,"ToDo","Low","Pending",292,242,"Compose Check","Expand Check ID Box to fit other boxes","The check ID box on the top right is smaller than the boxes below it. This should match.",null,"May Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-03-03T12:40:53","Ross","2023-03-03T12:40:53"]
["Gary",null,"Pending","Efficiency",2134,"ToDo","Low","Pending",290,242,"Compose Check Screen","Allow dates without \"# #\" on either side","\tAllow user to write dates into the validation conditions without \"# #\" on either side.",null,"May Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-03-09T09:14:53","Ross","2023-03-09T09:14:53"]
["Ross",null,"Pending","Customer Improvement",2135,"ToDo","Medium","Pending",290,244,"Maintain Calculated Fields","Create test calculated fields for points checks redesign","The points checks need to have the SQL removed and replaced with a calculated field. Ross will need to set up test calculated fields as a proof of concept.",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-09T09:16:26","Ross","2023-03-09T09:16:26"]
["Carol",null,"Pending","Customer Improvement",2137,"ToDo","Medium","Pending",290,289,"Power BI Dashboard","Allow users to select the number of days when you look at ignored errors on Power BI",null,null,"April Release","ross.@rgenconsulting.com","Carol",null,null,299,"Ross","2023-03-09T09:18:44","Ross","2023-03-09T09:18:44"]
["Gary",null,"Started","Reliability",2138,"ToDo","High","Pending",291,242,"SQL Database","Automate Check Promotion Process","The check promotion process from test to production is time-consuming and error-prone. This needs to be automated.",null,"April Release","ross.@rgenconsulting.com","Gary",null,null,300,"Ross","2023-03-09T09:19:57","Ross","2023-03-09T09:19:57"]
["Gary",null,"Started","Reliability",2139,"ToDo","High","Pending",291,242,"SQL Database","Automate Calculated Field Promotion Process","Calculated field promotion process from test to production is time consuming and error-prone. This needs to be automated.",null,"April Release","ross.@rgenconsulting.com","Gary",null,null,300,"Ross","2023-03-09T09:21:11","Ross","2023-03-09T09:21:11"]
["Gary",null,"Pending","Efficiency",2140,"ToDo","Medium","Pending",290,242,"SQL Database","Add apostrophe handling","Allow the user to use apostrophes in check names, descriptions, and error messages.",null,"May Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-03-09T09:22:12","Ross","2023-03-09T09:22:12"]
["Gary",null,"Future Feature","Efficiency",2141,"ToDo","Medium","Future Feature",295,242,"Maintain Projector Reports","Allow report download from SharePoint","Right now dblCheck can only download CSVs from Projector or from the rGen website. We need to find a way to enable downloading from SharePoint.",null,"July Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-03-09T09:23:03","Ross","2023-03-09T09:23:03"]
["Ross",null,"Complete","Efficiency",2142,"ToDo","Medium","Pending",293,244,"Maintain Calculated Fields","Identify unnecessary calculated fields","Some calculated fields were created for test purposes and should be identified and eliminated. Ross will identify and pass this off to Gary, who will delete.",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,301,"Ross","2023-03-09T09:24:26","Ross","2023-03-09T09:24:26"]
["Carol",null,"Pending","Customer Improvement",2143,"ToDo","High","Pending",290,289,"Power BI Dashboard","Replace check error ID with check ID in Power BI","\tChange Power BI output to produce a unique check ID # with each row of results rather than the unique error ID (this will assist in debugging checks).",null,"April Release","ross.@rgenconsulting.com","Carol",null,null,299,"Ross","2023-03-09T09:25:41","Ross","2023-03-09T09:25:41"]
["Gary",null,"Started","Efficiency",2187,"ToDo","High","Started",291,242,null,"Implement resizable and modular UI design",null,null,"April Release","ross.@rgenconsulting.com","Gary",null,null,301,"Ross","2023-03-13T14:23:30","Ross","2023-03-13T14:23:30"]
["Ross",null,"Started","Customer Improvement",2188,"ToDo","High","Started",291,244,"Compose Check","Add and test check #289: Purchase Order Required at Project Level","Initially this check involved looking for contract line item PO#. But CLI PO# is not currently a reportable field. Erich forwarded this as an enhancement request. We're switching back to project level for now.",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-13T14:43:32","Ross","2023-03-13T14:43:32"]
["Ross",null,"Complete","Customer Improvement",2189,"ToDo","High","Started",293,244,"Compose Check","Add and test check #290: Milestone Is Achieved But Invoice Has Not Been Sent",null,null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-13T14:44:11","Ross","2023-03-13T14:44:11"]
["Ross",null,"Complete","Customer Improvement",2190,"ToDo","High","Started",293,244,"Compose Check","Add and test check #291: Milestones Required for a Billable Project",null,null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-13T14:44:39","Ross","2023-03-13T14:44:39"]
["Magnus",null,"Pending","Reliability",2191,"ToDo","Medium","Pending",290,302,"Documentation","Update wiki entries","This depends on Carol writing release notes first",null,"April Release","ross.@rgenconsulting.com","Magnus",null,null,300,"Ross","2023-03-13T14:47:09","Ross","2023-03-13T14:47:09"]
["Ross",null,"Complete","Customer Improvement",2192,"ToDo","High","Complete",293,244,"Compose Check","Test checks that involve dynamic time conditions",null,null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-13T14:48:29","Ross","2023-03-13T14:48:29"]
["Carol",null,"Pending","Customer Improvement",2193,"ToDo","High","Pending",290,289,"Power BI","Create April Power BI mockup",null,null,"April Release","ross.@rgenconsulting.com","Carol",null,null,299,"Ross","2023-03-13T14:49:08","Ross","2023-03-13T14:49:08"]
["Ross",null,"Complete","Customer Improvement",2194,"ToDo","High","Pending",293,244,"Composer","Update check descriptions so they do not include apostrophes",null,null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-13T14:49:56","Ross","2023-03-13T14:49:56"]
["Carol",null,"Future Feature","Customer Improvement",2195,"ToDo","High","Future Feature",295,289,"Website","Self-service \"fix your own rules\" website",null,null,"July Release","ross.@rgenconsulting.com","Carol",null,null,299,"Ross","2023-03-13T14:52:24","Ross","2023-03-13T14:52:24"]
["Carol",null,"Pending","Customer Improvement",2196,"ToDo","High","Pending",290,289,"Documentation","Write April Release Notes",null,null,"April Release","Carol.@rgenconsulting.com","Carol",null,null,299,"Ross","2023-03-14T09:41:13","Ross","2023-03-14T09:41:13"]
["Carol",null,"Pending","Customer Improvement",2197,"ToDo","High","Pending",290,289,"Documentation","Write May Release Notes",null,null,"May Release","Carol.@rgenconsulting.com","Carol",null,null,299,"Ross","2023-03-14T09:42:05","Ross","2023-03-14T09:42:05"]
["Carol",null,"Pending","Customer Improvement",2198,"ToDo","High","Pending",290,289,"Documentation","Write June Release Notes",null,null,"June Release","Carol.@rgenconsulting.com","Carol",null,null,299,"Ross","2023-03-14T09:43:13","Ross","2023-03-14T09:43:13"]
["Ross",null,"Complete","Customer Improvement",2206,"ToDo","Medium",null,293,244,"Compose Check","Add and test check #292: Milestone Planned Date Must be End of Month",null,null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-15T09:05:19","Ross","2023-03-15T09:05:19"]
["Ross",null,"Complete","Customer Improvement",2207,"ToDo","Medium",null,293,244,"Website","Create final mockup for self-service portal that allows users to create check conditions","Ross created and sent the mockup to CB 3/16, the team reviewed the mockup 3/17, Ross added popout button screens 3/20. Team to review 3/21.",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-15T09:06:15","Ross","2023-03-15T09:06:15"]
["Unassigned",{"$nulls":3},2212,"ToDo","Low","New",null,241,"New Query","New Bug Query","Write a new query for Ross","","","Gary.@rGenConsulting.com","Gary",{"$nulls":3},"Garyr","2023-03-15T09:52:15","Garyr","2023-03-15T09:52:15"]
["Ross",null,"Complete","Reliability",2214,"ToDo","High",null,293,244,null,"Create PowerPoint that defines the user experience for promoting checks",null,null,"April Release","ross.@rgenconsulting.com","Ross",null,null,300,"Ross","2023-03-15T10:04:49","Ross","2023-03-15T10:04:49"]
["Gary",null,"Pending","Reliability",2215,"ToDo","Medium",null,290,242,null,"Create a view that details which checks have been changed","Create a report that details which checks have been changed",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,300,"Ross","2023-03-15T10:05:37","Ross","2023-03-15T10:05:37"]
["Gary",null,"Complete","Customer Improvement",2216,"ToDo","High","Fixed",293,242,"SQL database","Create impact type field for support tool","The field could take on three values: customer improvement, reliability, efficiency",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-15T10:06:25","Ross","2023-03-15T10:06:25"]
["Gary",null,"Ready for Testing","Reliability",2223,"ToDo","Low",null,292,242,null,"Add a notes field to the checks changed view which allows an explanation of who requested the change, why it's been made, etc.",null,null,"1.6.5","ross.@rgenconsulting.com","Ross",null,null,300,"Ross","2023-03-16T09:56:14","Ross","2023-03-16T09:56:14"]
["Gary",null,"Pending","Customer Improvement",2224,"ToDo","Medium",null,290,242,null,"Allow user to specify last day of month in check validation conditions","This is currently fixed via a little SQL in the validation conditions, but this is not a long-term solution. Two checks depend on this functionality: #291 and #293 (using test version check numbers)",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-16T10:17:15","Ross","2023-03-16T10:17:15"]
["Ross","Enhancement","Complete","Efficiency",2234,"ToDo","High",null,293,244,"frmBugs","Add test Notes Field","Add test Notes Field",null,"1.6.6","Gary.@rGenConsulting.com","Gary",null,268,301,"Garyr","2023-03-17T08:58:55","Garyr","2023-03-17T08:58:55"]
["Gary",null,"Pending","Customer Improvement",2236,"ToDo","High",null,290,242,"Compose Check","Identify and add all date functions that users would likely want",null,null,"May Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-17T09:27:27","Ross","2023-03-17T09:27:27"]
["Gary",null,"Pending","Efficiency",2237,"ToDo","High",null,290,242,"Compose Check","Change the add value screen so you can compare a field's value to another field's value instead of a field's name to another field's name",null,null,"May Release","ross.@rgenconsulting.com","Ross",null,null,301,"Ross","2023-03-17T09:28:04","Ross","2023-03-17T09:28:04"]
["Gary",null,"Pending","Customer Improvement",2272,"ToDo","High",null,290,242,null,"Research and set up self-service web portal security requirements",null,null,"May Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-20T12:06:16","Ross","2023-03-20T12:06:16"]
["Gary",null,"Pending","Reliability",2273,"ToDo","High",null,290,242,"Compose Check","Reconcile unique check ID#s between test and production","Look at alternative ways of keeping check identification numbers consistent between test and production. Carol and Gary suggested an internal ID number that the customer never sees, and a separate ID number for internal use. These numbers need to be identical before moving to production in April",null,"May Release","ross.@rgenconsulting.com","Ross",null,null,300,"Ross","2023-03-20T12:15:46","Ross","2023-03-20T12:15:46"]
["Ross",null,"Pending","Customer Improvement",2274,"ToDo","High",null,290,244,null,"Run April release through fit and finish checklist","Once April release development items have been completed, Ross should run through the fit and finish checklist to ensure this release is sellable",null,"April Release","ross.@rgenconsulting.com","Ross",null,null,299,"Ross","2023-03-21T10:11:04","Ross","2023-03-21T10:11:04"]
["Gary",null,"Pending","Efficiency",2276,"ToDo","Medium",null,290,242,"Maintain Calculated Fields","Delete unnecessary test calculated fields 15, 72, 91, 129, 130, and production calculated field 135",{"$nulls":3},"ross.@rgenconsulting.com","Ross",null,null,301,"Ross","2023-03-21T10:22:52","Ross","2023-03-21T10:22:52"]