We are running 7.5.103f-SQL and I have an account that seems to have some hidden or duplicated transactions. When I run the G/L - with Detail for this account it shows the true activity, however when I run the G/L - with no Detail for this account I get a higher total debits amount (exactly double the amount of a recurring entry that hits this account)...HELP!!! This makes me out of balance!![/red]
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
G/L detail report doesn't agree with G/L summary report
- Thread starter TXejh
- Start date
maccrystal
Technical User
- Thread starter
- #3
I checked the calendars and they seemed to be fine...then in looking through the G/L transaction file I saw that the recurring entry had already reversed itself, I checked the other 2 accounts that had auto-reversing entries and they were off in the same manner so I'm thinking it is some kind of bug in the summary report catching those entries in the new year since we haven't done any temp or final y/e processing yet. Thoughts?
Running the GL trial balance report with detail reads from the GL Transaction table (GLTRXFIL). Running the same report not showing detail reads from the GL Balance table (GLBALFIL). The balance table usually matches the transaction table. The recalculate account balances function under GL - Processess will reset the Balance table to match the transactions based on the dates you have in your calendar.
In your previous thread, you didn't mention whether you had run that function or not. I would do that first.
Kevin Scheeler
In your previous thread, you didn't mention whether you had run that function or not. I would do that first.
Kevin Scheeler
- Status