Solved

Recover deleted history data in Great Plains

Posted on 2009-04-03
1
2,036 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
1 Comment
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Fail Over Server 3 84
Backing up Windows Server 2012 R2 Essentials to multiple external USB hard drives 2 127
SBS Disaster recovery 6 68
Bizarre hard disk problem 15 131
VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Learn how the use of a bunch of disparate tools requiring a lot of manual attention led to a series of unfortunate backup events for one company.
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

860 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