Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Posting Out of Balance

prog_0927

Programmer
Jan 3, 2022
55
US
7.9.310

We have 2 x days in a row that we are out of balance in AR and AP. Not seeing any issues with the SQL connection on either day, event logs and performance is great. Where do i begin troubleshooting this? What DB tables can i look at for issues (and what am I looking for). Did ticket with ECI but would like to do what I can as well.
 
Hello, The database tables are different between Macola versions. What version of Macola are you running?
Rich
 
You are seriously out of balance with both? As in you post from subledger and it will not let you because the entry is out of balance? If not, please explain.
 
You are seriously out of balance with both? As in you post from subledger and it will not let you because the entry is out of balance? If not, please explain.
We moved it to an offset account to troubleshoot. We were out of balance yesterday for AP only and today for AR and AP. Thank you for your quick reply.
 
I have a couple of crystal reports that will find where - as in what transaction(s) - the out of balance took place, but it will not really troubleshoot it much beyond that point. Have you gotten this far at least?
 
I have not, that is where we are at, trying to determine where the out of balance took place. We are struggling to find it in the tables or existing crystal reports we have.
 
I have a couple of crystal reports that will find where - as in what transaction(s) - the out of balance took place, but it will not really troubleshoot it much beyond that point. Have you gotten this far at least?
We found the problem transaction for Monday. All but one line of the PO was received (5 of 6 total lines), and it shows they were vouched when we look at the individuallybut the money only moved on 2 of the 5 lines received during the posting process.
 
The other thing I would do is run file validation reports in Macola and fix EVERY error. Are you familiar with these reports?
 

Part and Inventory Search

Sponsor

Back
Top