How to eliminate the Reversals (DR & CR Net to Zero) in Journal entries

8 posts / 0 new
Last post
hady mohamed
Offline
Joined: 09/28/2019 - 11:26
How to eliminate the Reversals (DR & CR Net to Zero) in Journal entries

 
 
 

Hope you are well I'm constantly following your posts in the site and your idea-scripts  and im searching for idea-script or procedure to do with this issue ( Removes reversals of Dr & Cr in GL) if you can help me im thankfull to your appreciate Thanks,Hady
 

 
 
 

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

I have tried to create a script but this is highly complex, it is not as easy as just removing all debits and credit that equal.  The user would have to define the fields that would be the same in the reversal and the script would also have to figure out what to do it there were mutiple reversals for the same amount.  So this is not a simple script to create.  Unfortunately I don't have the time right now to try and create it in Python, this is a project that I have pegged for the future.

hady mohamed
Offline
Joined: 09/28/2019 - 11:26

Thanks for your response and your effort 

scotchy33
Offline
Joined: 09/05/2012 - 15:51

Hi Brian,
Attached is what I came up awhile ago.  If you ever improve upon it, let me know. 
Scott

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

Hi Scott, thanks for sharing, I enjoyed looking at your script.  You are coming at it from a different way then I was and I like it.

hady mohamed
Offline
Joined: 09/28/2019 - 11:26

Hi scott , Thanks for sharing the script , please can you show it to me how it works and i have attached for you GL for example includes Acc No. & Acc description & debit & credit & amount coloumn (Dr + Cr) and each account seperatly have reversals in it so please can you gudie me to eliminate these by your script because i have try it and i didnt get it 

Files: 
scotchy33
Offline
Joined: 09/05/2012 - 15:51

Hi Hady,
I have attached 5 screenshots.
1) Shows a potential reversal 
2) Run script - first parameter select AMOUNT
3) Index by ACCOUNT_NUMBER and ACCOUNT_DESCRIPTION (these are the fields that have to be the same for script to consider it a true reversal -- usually you would have a date/month field)
4) A few new files are created - the file with the Reversal Indicator ends with Reversal Flag.  One observation is that the file names get pretty large.  I believe IDEA/Windows has a 256 character path limit, so may cause script to fail if file names get really long.  File naming might need to change in next version of script.
5) The "Reversal Flag" file has a field called IND_REVERSAL_FLAG.  This field is the indicator of a potential reversal. If you don't want the reversals in the file-- do a direct extraction IND_REVERSAL_FLAG <> "X" or    IND_REVERSAL_FLAG  = ""  
Hopefully this is clear to you, best of luck.
Scott

Images: 
hady mohamed
Offline
Joined: 09/28/2019 - 11:26

Thanks scott for your effort and your wondeful script