I have given the auditors a list of our journal entries for the year. They want to know how to tell the reversing entries from the originals. I have used the following in the file given to the auditors:
BatNbr LineNbr Acct Balancetype Sub CpnyID jrnltype refnbr lupd_datetime perent perpost dramt cramt trandesc crtd_user lupd_user
Any help is appreciated!
*This post is locked for comments
This does not sound like you case but, in case others follow this post, Butch's suggestion could give you too many entries because the OrigBatNbr field is also populated on any batches created by the generate recurring entries.
One other possible thought would be to run a query on gltran where the account, sub-account and cramt or dramt match but are opposite. In order to do that you would have to alias gltran since you are trying to match up two transactions that are the same except one is a debit and the other is a credit. Your query would look something like:
select drside.batnbr, drside.acct, drside.sub,drside.dramt, crside.batnbr,crside.acct, crside.sub,crside.cramt
from gltran as drside inner join gltran as crside on crside.acct = drside.acct and crside.sub = drside.sub and crside.cramt = drside.dramt and crside.fiscyr = drside.fiscyr
where drside.fiscyr = 2013 and crside.fiscyr = 2013 and drside.module = 'GL' and crside.module = 'GL' and drside.dramt <> 0 and crside.cramt <> 0
This query will, at least, find the same amount debited to an account and also credited to that same account. that is not a guarantee that it is a reversing entry but is an indication that the two batches involved should be examined. The other issue with the above query is that, as written, it will only find these potential reversing entries when both are posted to the fiscal year 2013. If the original was posted to 2012 and reversed in 2013, the query will not find it unless you expand the criteria of the query.
Anyway, this may get you pointed in the same direction. In the future, I highly suggest that you use the note capability on the journal transaction screen (if you are not) to add a note on any batch that is a reversing entry batch. That way you would be able to query on the content of the note field.
Good luck.
If you are using the "Auto Reversing" checkbox to create a batch that automatically reverses itself in the following period, the reversing batch that gets created will have the "AutoRevCopy" field in the batch table set to "1", and it will have the "OrigBatNbr" field populated with the reversed/original batch number.
-Mark
Hi
Have you used / tracked the parent journal entries reference number or any other description in the corrected entries ? to identify easier..
Thanks
Apparently, we do not use that button. When I run the SQL query, I get nothing in that colomn for Original batch number.
The OrigBatNbr Field in the Batch table (if you used the little "Correct Journal Entry" button) will be populated with it.
Share
Report
All responses (
Answers (
4,763