How to fix variances in QB POS v.13 between current and available balances for charge accounts?

Hey, we have been having a strange problem with our Quickbooks POS ver 13 multi user installation in a club setup (4 machines). Customers have to recharge their accounts before ordering and the big problem we have is discrepancies between current and available balances. However,the sale transactions are posted in real time but the balances take seem time to synchronize(happens  to a random member account irregularly ) and we have changed the LAN routers and cabling and the problem is still persisting. The charge to account is posted after some delays of a few hours. We have integrated the solution to Quickbooks premier for financial exchange. Our company file is 500MB big and the connectivity tool doesn't post any errors. The environment is available for remote access any time. Any pointers?
Adela RodriguezBusiness Development ExecutiveAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Our company file is 500MB and … The environment is available for remote access any time.

Do you use a Terminal Services approach for Remote Access?  QB is a very chatty database and so you should not attempt to run a QB remote client against a networked Company File.

Copy the Company File to a local machine and do a verify / rebuild to find and correct database errors.
When done, restore the Company File to its normal location and test transaction syncing again.
Adela RodriguezBusiness Development ExecutiveAuthor Commented:
Hello John and thanks for the comment. I meant i can avail the system for remote troubleshooting but the setup is only on an Internal LAN for 4 networked users without any Terminal services configured.
JohnBusiness Consultant (Owner)Commented:
You should not use QB this way as you can easily damage the database.

So now do a verify / rebuild as suggested above.
Adela RodriguezBusiness Development ExecutiveAuthor Commented:
Thanks. Will rebuild and revert with the findings.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.