In order to downgrade SQL for a move of GP data files to an unsupported version you must perform this task to rebuild the GP database in an earlier version. https://support.microsoft.com/en-gb/help/875179/how-to-use-the-bulk-copy-process-bcp-to-export-microsoft-dynamics-gp-d Vince
DYNAMICS GP & SQL Server and OS Versions Dynamics 10 (Off Support) Windows Server 2008 R2 , 2003 Microsoft SQL Server 2000 SP 4 Microsoft SQL Server 2005 SP 2 or SP 3 Microsoft SQL Server 2008 with or without SP 1 Microsoft SQL Server 2008 R2 NOTE: Service Pack 5 or later for Microsoft…
Open Powershell Execute Invoke-Sqlcmd Execute $output = "d:\ScheduledJobs.sql" Execute Remove-Item $output Execute Set-Location SQLSERVER:\SQL\localhost\DEFAULT\JobServer\Jobs Execute # loop through jobs appending output Lastly Execute dir | %{$_.script() + "`n`nGO`n`n" | out-file -append $output} Do the above one line at a time then take the output ScheduledJobs.sql go to the new server and open Management Studio and…
How to Manage Custom Crystal Reports In the RMServer\NET\Updates folder there is a new folder named CustomReports. This folder is where customized versions of the reports should be kept. A check is done each time System Manager is launched, this check will copy any updated reports from RMServer\NET\Updates\CustomReports to the client machines C:\Exact\RMClient\EFW folder. This…
Troubleshooting Exchange Integration (checklist) Introduction The integration between Exact Synergy Enterprise and Microsoft Exchange (2010 and higher) is based on Windows Services. The background job used in the previous Microsoft Exchange application is no longer applicable for Microsoft Exchange 2010 (and higher) integration. Two Windows Services can easily be installed via MSI installation process. For…
Here are the steps to duplicate an existing Company: 1. Have all users exit Great Plains. 2. In Great Plains, go to the Create Company screen (Setup | System | Company). 3. Give your Company a name, a unique Identification Code, and set the path to the data. The path is the root of your…
Dynamics.set – List of Dynamics GP Products Product Code Main Dictionary Forms Reports Microsoft Dynamics GP 0 Dynamics.dic Forms.dic Reports.dic Project Accounting 258 PA258.DIC PAFORM.DIC PAREPT.DIC Fixed Assets 309 FAM.DIC F309.DIC R309.DIC Manufacturing 346 ICONMFG.DIC ICONFRMS.DIC ICONRPTS.DIC Human Resources 414 HR.DIC HRPFROM.DIC HRPRPTS.DIC FieldService 949 SRVSADV.DIC FRMS949.DIC RPTS949.DIC Interfund Management 1042 IFUND.DIC 1042FORM.DIC 1042RPTS.DIC Revenue…
Scheduled to be released in Q3/Q4 of 2018, here is a summary of the improvements you’ll see in Version 10 of KnowledgeSync – as well as how those improvements compare what’s currently available in version 9: Feature Version 9 Version 10 A r c h i t e c t u r e User Interface…
You use the Advanced Shipping module to assign sales order line items to a bill of lading, add all specialized information to the bill of lading and print it. If you use Electronic Data Interchange (EDI) to send Advanced Shipment Notices (ASNs) for your products, you can use the Advanced Shipping module to add to…
MAX 5.5 Key Enhancements Manual Sales Pricing Alternate BOM and Routing Enhanced Lot and Serial Tracking Sales Consignment Module Stock Revaluation for Inventory and WIP (New Default Accounts for Distributed Reval) Unlimited Cost Sets Average/Last Purchase Price Automatically Updated in separate cost sets for PO Received. Decimal Places in Currency Maintenance Ship To and Bill…