4POS Support

4POS Hardware & Related Questions => General Discussion => Topic started by: willempretorius on February 07, 2014, 06:53:52 AM

Title: Possible DB Error
Post by: willempretorius on February 07, 2014, 06:53:52 AM

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