165
The advice from previous posts in this forum is not to delete but to edit the JE.
However, the user who created the JE doesn't want to edit the JE but wants to jjust delete it from the system. Are we able to delete it with no consequences to the Audit ? That means, it's recorded in the Audit the reason for the deletion of the JE.
The question is how do we do such deletion?
Thanks!
*This post is locked for comments
Apparently, I went too far assuming that you want to delete a fully posted journal entry :D
Thank you Frank, you put it back on the right track.
Ahhhh, then there is a different fix you may need to apply - support.microsoft.com/.../en-us
First, check Batch Recovery (Administration>>Routines>>Batch Recovery). Check that the batch is sitting in this window. If it is, then try to recover the batch from this window. If it is not there, then apply the fix referenced in the link above.
Let us know how it goes.
Thanks a lot Mahmoud for your indepth explanation.
For further information and to address Frank's query on why the user wants the JE to be deleted, please see below:
The user created the JE but did not post it. Apparently, GP system crashed during this time (we're running GP on Citrix XenDesktop and there have been system crashes at times). When the user logs back into GP, the user is unable to access the JE that was created. Instead, a pop-up window appears indicating the batch is being posted. And, everytime we open this JE, the same message comes up. There is no options to delete the JE too.
This is the problem and the user wants to delete the incomplete JE because the user has already booked another entry.
Mahmoud's excellent and thorough advice notwithstanding, I would want to know why the user wants the JE deleted instead of reversing it. Do they want to cover their tracks for some reason?
It is doable, and can simply be done but not on the Application Level. It's not an advise not to delete a journal entry once it is posted, you simply can not delete a journal entry after posting, rather you can correct it through a reversing entry.
Initially, I would like to know whether we are talking about a journal entry that has been created on the General Ledger level directly or it has originated from other modules. In case it originated from other modules, your deletion will cause a mismatch between the GL and the original module. Otherwise, the delete shall keep no trace and cause no mismatch at all.
Now in order to delete a journal entry, you need to consider primarily GL tables. In case you use Analytical Accounting, you need to further delete the trace of this journal entry from the AAG tables as well. Now the important question is, which tables should my delete statement hits ?
Fortunately, you don't need to reinvent the wheel. Microsoft has came across a similar task when they provided the new feature or "Reverse Historical Year". Because to reverse a historical year, they had to "delete" the closing journal entry affecting P&L balances. They have developed a stored procedure called "GLReverseHistYear" which go through the GL and AAG tables and delete the journal entry then recalculate account balance in the GL summary tables accordingly. If you have a considerable knowledge in SQL, you can simply check this stored procedure and mimic its behavior.
Anyone performing such a step should take a full back up of Dynamics GP database which is a must. If you don't have the required SQL knowledge, don't consider the proposed solution.
In summary, tables to consider are:
Never hesitate to share any further inquiries,
#1
André Arnaud de Cal...
292,886
Super User 2025 Season 1
#2
Martin Dráb
231,768
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
