Solved

Recover deleted history data in Great Plains

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
Backing up data is essential for any office small or large. Most think that a simple USB drive will suffice. Even the USB drives themselves display words like backup.   Most novices will ask themselves the question “Will this work for my business…
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

770 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