Dynamics GP Customer or Vendor Master files recovery

Feb 25
08:49

2011

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

There might be unpleasant situations, when you realized that you cleared master table cluster in production company, while being under impression that you are working with test environment. Plus, unfortunately your SQL Server Agent was not started and backup is not an option.

mediaimage

What to do?  Probably,Dynamics GP Customer or Vendor Master files recovery Articles compose resignation letter?  Well, there are other options to consider.  Let’s review what is recoverable and how.  Here we assume that you would need to do data recovery on SQL scripting level, so be prepared or find experienced consultant:

1. If Customer table is lost, SOP Scenario.  First of all, find out if you are using Sales Order Processing module.  If you are, then you can recreate customer IDs, Names and Addresses from SOP30200 table – Sales Header History.  If you are generating invoices from SOP module, then you are lucky IT manager and you can turn the issue into opportunity to proof your corporate management, that you did something close to impossible.  In GP: Tools -> Resource Descriptions -> Tables, switch series to Sales, find SOP30200 table and open it.  As you can see – customer ID, Names, Address, Ship to Address with details and other Customer master file related records are here.  We do not recommend you to get into the rush and try to do SQL insert statement to move customers back into RM00101 table.  Instead, consider exporting them into the text file, and use Integration Manager to recover the customers.  If you feel comfortable, you can base your IM integration directly on the table mentioned above.  You are not done yet.  The last small touch is to recreate customer summaries.  This is done in Utilities -> Sales -> Reconcile.  This Reconcile utility should recalculate fiscal and calendar period summaries

2. Customer Table Lost RM scenario.  Here the situation is not ideal.  But at least you may recover customer IDs.  Unfortunately customer name is not saved in RM20101 (Receivable transaction open file).  Here you probably have to print out customer IDs and have your Sales department to fill in customer names from their paperwork and archives

3. Vendor master record is lost.  Situation is symmetrical.  If you use Purchase Order Processing module, consider getting customer records from these tables: POP30100 (on the Purchase Order level) or POP30300 (if you are only doing receipts without purchase orders).  If POP module is deployed, you can recover the majority of vendor master records details.  Again consider Integration Manager to be the recovery vehicle.  Simplest way is to export POP30100 or POP30301 relevant fields into the text file and then build vendor integration in the IM

4. What is you are only using Payables Management module?  Then we recommend you to extract vendor IDs from PM20000, place VNDCHKNAME filed on the form (this is likely to be your vendor company name).  Vendor addresses are likely to be recreated from paper printed documents

5. What to do if you are not SQL programming savvy?  First step is to call you GP VAR, maybe they have technical resources to reconstruct your customer or vendor master files.  If your already done that and got a feeling that your reseller is rather CPA oriented and not too good in the technology layer, consider to call Microsoft Business Solutions technical support.  Another option is to search Google, Yahoo, MSN – chances are high that somebody already got your issue and somebody from the consulting world posted and answer or recommendations

6. Support domestically in the USA, Canada, Mexico and internationally.  This option is possible via Web Sessions, Skype or Phone conferences and direct visits onsite (in the case of the large scale project).  Our consulting team speaks English, Chinese, Portuguese, Spanish, Russian, Filipino.  Feel free to call us 1-866-304-3265, 1-269-605-4904, or email help@efaru.com