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.
What to do? Probably, 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
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
