Posting Out of Balance

[prog_0927]

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.

 

[rinzana]

Hello, The database tables are different between Macola versions. What version of Macola are you running?
Rich

 

[dgillz]

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.

 

[dgillz]

Hello, The database tables are different between Macola versions. What version of Macola are you running?
Rich

he/she said 7.9.310

 

[prog_0927]

Hello, The database tables are different between Macola versions. What version of Macola are you running?
Rich

Progression. thank you for your quick reply!

 

[prog_0927]

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.

 

[dgillz]

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?

 

[prog_0927]

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.

 

[prog_0927]

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.

 

[dgillz]

OK Can you recreate this issue in a test company?

 

[dgillz]

The other thing I would do is run file validation reports in Macola and fix EVERY error. Are you familiar with these reports?