#timestamps on the edits and fucked orders causing these messes

[pancakeke]

at work the delta for our inventory totals compared to last week was suspicious so i went to review problematic inventory. I thought the issue would just be that people were receiving shit to the wrong stock locations so I focused on serials stocked in what is treated like a default location (it is NOT) yet had certain attributes that made it likely they should reside elsewhere.

I found misplaced serials to transfer right away, but then started finding all these fucked up part numbers with conflicting attributes and histories that made it impossible for me to determine what details were correct and which needed to be changed.

So I noted a bunch of those and looked on to all the items I noticed that had $0 values, cause what is going on there? why did so many items have no value, and how did they end up in stock?

i checked a couple dozen of those and they were like free samples, stuff "found" in the warehouse (what?) and added to stock without costs because they weren't purchased, items that accidentally had their costs overridden to zero by bad inventory transactions, and customer-owned products (no value to us) received to company owned part numbers because salespeople cant follow directions or read.

but then I came across one part number that said we had 3 units on order. when I checked our open orders to confirm why this was so since we didn't need any, there were zero open orders for the item. the order line table in our database had zero open lines as well.

it turned out the table containing summary inventory data like total units on hand, on order, and allocated per part number per location is dogshit and doesn't update right so it'll just say we have negative units allocated or whatever sometimes. I put together three queries using serial and order data to determine the real sums for all items and then compared that with what the inventories table said and only listed the fucked ones as results.

i sent that data to development and asked them to please fix this stuff cause they're ruining reports again. then I was like yay it's quittin time. I'm done with work for today. except there were still 300 suspect part numbers to review just within the narrow scope i had focused on.

so I was like "well I'll take a break from that by checking my tickets" and the salesperson who had asked me to update a report by the end of the day still hadn't responded to me asking her for additional info that i need to complete the report. at this point I closed my laptop.