Navigator User Forums
  Transaction Reports
  Transactions by Account Report

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Transactions by Account Report
FNuser029
Member 		posted 04-01-2008 10:49 AM     Click Here to See the Profile for FNuser029   Click Here to Email FNuser029     Edit/Delete Message
When I run the Transactions by Account Report, for more than 1 of my accounts, it is showing MOST (but not all) entries posted twice. In each report, there is also a Changes in Account Balances figure. I have tried running the Test and Correct Files under 'Utilities' and this does not rectify the problem.

IP: Logged

David
Administrator 		posted 04-02-2008 08:06 AM     Click Here to See the Profile for David     Edit/Delete Message
I wonder if the duplicate entries are real or just being displayed twice. Since there is a change in account balances, I would guess they are real.

A common cause of change in account balances is when a transaction is entered on the Transaction Entry screen but the other half of the transaction doesn't appear on the other account's Transaction Entry screen. This happens if the Transfer Clearing account is not used.

  1. Back up your data.
  2. Run Software Update to make sure you have the latest version.
  3. Compare the Transactions by Account report with the Transactions Entries report for the same account. You may find the one of the transactions is missing from the Transactions Entries report.
  4. For each duplicate transaction, run the same reports for the account on the other side of each transaction. You may find the one of the transactions is missing from the Transactions Entries report.
  5. Run Transactions by Account report for the Transfer Clearing account. See if any of the duplicate transactions are there. Also verify the ending balance is zero.
  6. Turn on Transfer Clearing account if it isn't already, delete one set of duplicate transactions, and reenter the transaction. Do Test & Correct Balances again and run your reports again to see if the problem is fixed.
Let us know if this helps find the problem. If it doesn't, let us know what the results are so we can investigate further.

- David
FNI Technical Support
Case #38-10638

IP: Logged

FN_User
Member 		posted 04-02-2008 09:23 AM     Click Here to See the Profile for FN_User     Edit/Delete Message
David:
The duplicate entries are NOT real, they are just being displayed twice.
How can a Transactions Entries report be created for an Expense Report?

IP: Logged

David
Administrator 		posted 04-02-2008 09:31 AM     Click Here to See the Profile for David     Edit/Delete Message
Try turning off any sorting in the expense account report (Data | Sort Report | uncheck all boxes).

Do Software Update. Navigator 8.2.8 has a fix for a similar problem.

Please select Post Reply on this Web page and let us know if that helps.

- David

IP: Logged

FNuser029
Member 		posted 04-02-2008 10:59 AM     Click Here to See the Profile for FNuser029   Click Here to Email FNuser029     Edit/Delete Message
SUCCESS! Thanks so much David...I was getting SO frustrated! Your 2nd set of instructions resolved the problem. FNuser011 should know this....sounds like he's experiencing the exact same problem I was.

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e