This job can be so freakin' frustrating.

As I have mentioned before, we have auditors here auditing our billing/receivables departments. Since I do cash receipts, I am subject to much questioning. Today one of the auditors came down asking about payments from certain customers. He wants the paperwork on any payments we have received from these customers for Fall 01 and Spring 02 classes.

Not a problem.

Well, it shouldn't be.

See, we have this little thing we call the billing/receivables database. It's where cash receipts are input, and bills are created. It's also where I should be able to go to search for payments that have been made.

Then why can't I find the freakin things!!!!!???!!!

I have searched the "receipts" that show the customer info, check info and invoice info. I have gone into the tables of the database and searched master records for all sorts of queries and statement info. Out of 5 customers and 20 invoices (one of which I received the check for today), I found one, uno. (And it's not even the one I did today!)

The only thing I can find for the others to show payment has been received is in the Outstanding invoice file that just shows how much money has been applied to a particular invoice. Other than that, I have squat.

This should be fun to tell the auditors on Monday. At least it's not my database or my ass that has to deal with it then.