Moon Moon Strikes Again

[trickykitty]

One of the tasks I took on was counting the number of files Moon Moon managed to delete in a span of two hours two weeks ago so that our supervisor can record it as part of his write up. New Girl was finishing something up when I started, and then got distracted as I counted and started counting with me.

130 files, 3 of which we restored immediately when I first discovered the issue while needing those specific files at the time.

I sent off an email to the supervisor with the info. New Girl finished up what she was doing, and so we were ready for me to show her a new month-end JE. I decide on the Repairs & Maintenance entries which are still needing corrections for Sept-Jan.

There's two reports that we pull after the close of each month, the Labor report, where the maintenance guys record their time and how it should be allocated to which department, and the Misc Costs report, which shows the materials used, location allocation, and supplier. My supervisor was only pulling these for Building repairs, when she should have been pulling for both Building and Vehicle, and neither of us knew to split out the Inventory Stock "supply house" from the other vendors on the materials. So 1 building entry for inventory and 3 vehicle entries for everything went undone for Sept-Jan, hence the corrections.

In February, the supervisor re-ran all of the reports to include the vehicle repairs and placed them in the February close folder, so that's 2 reports per month times 5 months.

I found out that there's a third category called ALL that is used on top of BUILD and VEH, because for some reason their system does not allow [Build-# plus date] or [Veh-# plus date] to be entered by the user more than once (which from a DB standpoint I thought meant that combination was the record key, but someone can enter them manually as duplicates on the back end, so it's just a setting on the user interface side for some reason). So the ALL entries got pulled out of those files and emailed over to the Maintenance Manager for her to tell me the correct allocations. She sent that back and also informed me that her assistant also went back into the database to correct them manually. So rather than enter them one at a time back into the original reports, I asked my supervisor to rerun them once again. 10 more reports were saved to the February folder, this time with the ALL category properly distributed between BUILD and VEH.

In addition to those files, the entries that I made in February for February's stuff were also in that folder. When New Girl and I went to that folder, only two files were in there. Sure enough, 30 of the 130 files were specifically my R&M files, so I did a snip of the screen and replied to my previous email that I would be restoring 30 of the files now.

I looked at the list after restoring them and decided I'd work on renaming them after New Girl left for the day, and that we could work on that tomorrow. We could instead work on Client Record Fees, the nominal fees that are charged when client records are accessed for which the JE handles the department allocations. We just inherited this JE, so it requires some understanding and backtracking itself. I asked her to go to the March Client Records folder just to make sure I hadn't already saved any backup in there, which I was pretty sure I hadn't.

In the Client Records Fees folder was a JE backup for Flex Fees (aka FSA health spending cards) that was saved there literally 3 minutes before. This JE is listed on the month-end checklist as "Vendor - [Vendor Name] - Flex Fees". It's surrounded by other JEs like, "Vendor - [Vendor Name] - long distance" and "Vendor - Office Depot" and "Vendor - Verizon Wireless". Oh, and there's a folder in the Month- End folder called Vendor Invoice Allocations, where for some reason we kind of expect to see the vendor JEs.

So I took a snip of that Flex Fees JE in my Client Records Fees folder and replied again to the same email chain already started.

Since we were backtracking the Client Records Fees, we went back into the Sept close folder to open the JE backup from then. We opened the Excel file, and I noticed that it said the person who processed it was a name I kind of recognized but not one I excepted to see for entries made around that time. SOAB. The JE in the files was dated 2020-09 (instead of 2021-09), and sure enough, that's also the date on the Excel file. So when Moon Moon was assigned the menial task of going and getting the backup for the JEs and storing them into the new SharePoint system, he somehow managed to pull one from over a year ago.

Snip - Reply to Email - Send.

Approximately 30 min of my life was doing nothing but clicking on a folder, cursing, snipping an image, sending it to the supervisor, and counting how much more of my soul was just devoured by the Stupid Monster.