Welcome, Guest. Please Login.
10/31/24 at 17:14:29
News:
Home Help Search Login


Pages: 1
Send Topic Print
Xactions  on AP-R but not on CD & purch journ (Read 531 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Xactions  on AP-R but not on CD & purch journ
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
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: Xactions  on AP-R but not on CD & purch journ
Reply #1 - 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  
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print