Announcements
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
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
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
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.
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.
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.
Can you void it? When you say 'unpost', do you really mean that it is posted?
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
