Solved

Recover deleted history data in Great Plains

Posted on 2009-04-03
1
2,058 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 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FIle Recovery after ghost image 6 37
Virus clean 26 141
DR TECHNOLOGY APART FROM SRM 5 118
replicating postgresql database 4 82
First I will try to share a design of a Veeam Backup Infrastructure without Direct NFS Access backup. Note: Direct NFS Access backup transport mechanism is only available in Veeam v9 In above I try to design the Veeam Backup flow between i…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

749 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