You’re offline. This is a read only version of the page.
I'm aware of the ability to back out of a Journal Entry. However, what I'd like to know is if its possible to remove these Journal Entries that have been backed out from the GP database. Or at least into some archive object that will remove the entries from my GL.20000 table, which is the table we look at for our job processing. Any help or comments are appreciated, thank you.
*This post is locked for comments
Hi Allie,
It's been a long time since the original question was asked. Please give me the opportunity to respond to your question. Please tell me what the user requested that you do not think was addressed and I will try to fill in the gaps.
Kind regards,
Leslie
you still didn't provide what the user requested.
Frank
I said it all, if your case is like the scenario I described above, then you are fine to delete them from the GL20000 or GL30000 as illustrated above, remember to run the financial reconciliation.
Just in case, don't forget to have a back up. Let us know if you need any further assistance,
Hi,
The entries will just cease to exist. If you are using posting numbers is GL, you'll find a gap. Make sure you do not have any 3rd party products that are counting on those journal entries. If it's just GP stuff, you should be in good shape. Of course, test it and make a backup.
Kind regards,
Leslie
Hi Mahmoud,
I understand the risks of this action, as well as why it would not be a recommended solution. In this case, we'd be diligent and perform the procedure within our test environment first, and then analyze it's effects.
Currently the entries only exist in GL.20000, and not GL.30000. My question now is, is it just a simple delete statement on the entries in GL.20000? Or are there other tables to take into consideration? Will there be a profound effect on the rest of the system? or will the entries just cease to exist, as our goal.
I appreciate all the insight you've provided thus far.
I would very much not recommend removing a journal from the GL20000 or GL30000 tables.
You've already backed out the journal so the effect on the balances has already been reversed.
Okay, we are clear now
Actually, deleting a transaction from the database level is not a recommended solution and no one would ever give you a green light to go for such a solution, regardless of the scenarios and current case of your business. Although, I have done it several times, where I had to clean out a specific range of journals recorded directly on the general ledger level, such delete should encompass either GL20000 or GL30000 depending on the year (closed or open), then running a reconciliation is a must in order to get account summary re-calculated accordingly. Remember, this considers that the JE is recorded directly on the GL level with no originating source document and no associated analytical details.
Keep in mind, this is not a recommended solution and not supported by Microsoft. If you don't have the know-how and required knowledge to handle such a task, it is a must to revert to your partner for in-depth analysis and evaluation of the case you are having.
Your feedback is highly appreciated,
The methods you describe for the recorded journal entry are correct, so at the General Ledger level directly. And no analytical accounting or MDA analysis are recorded for these journals.
So the journal entry is recorded directly on the general ledger level (Transactions > Financial > General Journal Entry), right ? Then the journal entry was backed out (reversed) on the general ledger level as well, right ? That means both transactions were recorded on the general ledger directly. One more question, do you analytical accounting details or MDA analysis recorded on these journals ?
Your feedback is highly appreciated,
If possible it'd be very helpful to explain the differences/possibilities in both scenarios.
In our particular case, the entry was booked (manually) directly through GP 2010 and then reversed with a corresponding back out entry later. Our end goal would be to 'erase' these entries from existence by removing them from the GL.20000 table altogether.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (