Microsoft Dynamics GP (Archived)

TRYING TO UNPOST GL TRANSACTION

(0) Share

Report

Posted on by Community Member

Hello,

I am trying to unpost and delete a GL batch so I can post the right batch that is coming from a third party software.

I went to Victoria Yudin GP tables but I cant find the table taht allow me to do this

Please help.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

Can you void it? When you say 'unpost', do you really mean that it is posted?

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

Hi

If the batch is unposted you should be able to go to Transactions > Financial > Batches, select the batch and then delete the batch. This is provided that you have the GL setup option to allow Deletion of Saved Transactions.

If your batch has been posted you should not delete the transactions from the tables but rather go to Transactions > Financial > General to open the Transaction Entry window.

Next click on Correct to open the Correct Journal Entry window.

If you want to completely remove the original posted entry select the Back out a journal entry option and then post the reversal of the original entry. This gives you a complete audit trail for your GL. Your auditors will like this.

If you need to correct the journal entry then select Back out a Journal Entry and Create a Correcting entry.

The first transaction to appear will be the reversal, post that, the second entry will be a copy of the original to which you can change amounts and/or GL accounts.

If your original batch contained more than one GL journal entry you will have to repeat the above process for each journal entry.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Jeffery, while you are correct on the suggestion to use the CORRECT button on the GL Transaction screen, I need to point out that this is a feature that was not available in version 9.0 of Dynamics - which if the tags on the posting are correct is the version under discussion.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

Pat, if you have an unposted transaction - you can still see it in either of the Series Post or the Batches windows under the Financial Transaction menu - then you can delete that batch from the system and it is gone.

However, as I fear, you have posted and the only way you can deal with this is to now do Reversing entries for each of the transactions.

In later version of GP, there is a way to enter the JE Number and 'reverse' the transaction, but back in Version 9 that was not the case.

Do you have access to the SQL Server back end of the system? Do yo understand what you are looking at in the SQL Tables of GP? Would you be comfortable in SQL Studio and developing and testing a script to remove the data?

Post more information and I am sure someone in the community will be able to assist.

Was this reply helpful? Yes No
Suggested answer

Heather Roggeveen 9,146 on at

Like (0)

Report

Hi

Definitely if posted do not "undo and delete" - and certainly not via the tables. If as Bill noted you are indeed on GP 9, then simply create a new manual journal that you reverse all the entries in.

If you have integration templates, copy it to an integration template and reverse everything before importing.

Also as a complete side note, if you truly are on GP 9, you really need to consider upgrading.

Cheers

Heather

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

Bill

I didn't notice the 'tags' that said they were on v9.0. So if that is the case then yes, they have to manually enter reversing entries. Again I don't recommend deleting from the tables in this case as there is no audit trail.

Entering reversing entries keeps a nice record of transactions

Was this reply helpful? Yes No