Hi Guys,
I have a client where everything was stolen, we did however had a backup, and restored.
We had some major power issues in between, now it seems like we have a DB error. (I Think)
- If you view a customer history, the account is 0 (if you add all the sales and payments by hand.)
But, the statements show most of the clients in credit!
- What is odd is here and there I see invoices with two digits less than most. (one client this is the exact outage amount)
- Some clients just is out purely based on balance brought forward from over 6 months ago!
- One client even adds every months balance brought forward to each outstanding period! ,e.g. 1420 outstanding before monthend, 2840 outstanding after monthend.
I have no idea where to start looking, I have run DB compact and repairs. as well as an upgrade.
Let me know if anyone has any ideas!
Cheers.
Willem
