Solved

Recover deleted history data in Great Plains

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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

One of the frustrating downsides to using third party RAID hardware is the frequent lack of native driver support in the standard OS.  During install, Windows prompts for third party storage drivers from CD or USB so it is straightforward, but it ca…
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 …
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

695 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