Journal Entry Removal - GP database

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

Are we talking about journal entries recorded directly on the GL level or could originate from other modules ?

I would appreciate your help to clarify your requirement,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report

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,

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

you still didn't provide what the user requested.

Was this reply helpful? Yes No