ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Xactions on AP-R but not on CD & purch journ
http://www.istechforum.com/YaBB.pl?num=1422569816

Message started by Laura Oliver on 01/29/15 at 15:16:56

Title: Xactions on AP-R but not on CD & purch journ
Post by Laura Oliver on 01/29/15 at 15:16:56

I found an issue as I reconicled the end of the year. I am embarrssed that I dont do this on a more regular basis, but in my 16 years of using DBA I have never had this happen.

In years past the calandar year run total from AP-R matches the calendar year run total accounts payable trade from both the Cash Disbursement Journal and the Purchase Journal. It doesnt not match this year. I ran them by month and narrowed the problem downt o May 2014. Both the Check Register from GL-I and payment history from AP-R show a good bit more than the Journals GL-D.

The journals are wrong and so is the detail trial balance for. They do not reflect the transactions. Xactions. I think that these are the only thing wrong, but I am not sure?
The check registers GL-I and AP-R are correct.
I think the Income statement is correct.

This has effect about a 1/3 of May Transaction. It is as if when the May transactions were being posted in GL-O, they didntwent to the twighlight zone. Some how they didnt make it to the Journals. But I am pretty sure they are reflected on both the balance sheet and income statement.

I dont know if this is a clue, but I recently realized that i have not been able to see anything in maintain database. This may or may not have anything to do with it,

I have a call into support. I will update later.

Thanks
Laura

tag: missing transactions in CD and purchase journal. actions show on AP-R but not on CD&purch journal

Title: Re: Xactions on AP-R but not on CD & purch journ
Post by Laura Oliver on 02/06/15 at 11:53:59

For future reference....
There were differences between the detail trial balance accounts and the corresponding account on the Income Statement.

I subtracted the difference between each GL account from the detail trial balance and its corresponding account on the income statement and made the necessary corrections via UT-A >EDITGL per your instructions. After completion I confirmed that the detail trial balance accounts had been adjusted and now matched the income statement. This worked perfectly thanks to Lynn’s good instructions.

There was never a difference between the balance sheet numbers and the detail trial report.

The problem I had was that the accounts receivable account on my my purchase journal and CD journal need to be adjusted. So I had to use editgl to adjust the accounts payable gl account for the CD and the purchase journal and then I had to use editgl to make adjustments to all 3 of my bank accounts so that the last summary page of the CD journal would be correct.

Thanks
Laura