?
Solved

Recover deleted history data in Great Plains

Posted on 2009-04-03
1
Medium Priority
?
2,144 Views
Last Modified: 2013-12-11
Please i need your support by tomorrow night. An employee used Tools>AP>remove history in Great Plains. She removed all of the Accounts Payable transactions that were in history status( the batch had been posted). It essentially removed every AP transaction from the begining of GP to yesterday. Please help. Is there a way to restore what have been deleted. I don't have a backup. Again please help. Thanks
0
Comment
Question by:avejep
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 1500 total points
ID: 24067115
Without a backup there is nothing you can do to get all that detail back.  Deleting history is an irreversible process in GP.  However, it does not delete everything posted.  Only transactions that are posted AND fully paid.  A small, but important distinction.

If posting to the GL from payables was set to detail, then the GL20000 and GL30000 tables store a number of fields starting with the word 'Originating', like Originating Master ID, Originating Master Name and Originating Document Number - for payables transactions these will be the Vendor ID, Vendor Name and Document Number.  So you can get to some of the detail, but most likely you will not have any apply information or other details that were only in the payables tables.

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
Employees depend heavily on their PCs, and new threats like ransomware make it even more critical to protect their important data.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question