Tips & Tricks Dynamics GP

Problem : Last night my FRx users emailed me about FRx strange behavior. Showing splash screen and stops without showing any error. Solution : I search a lot on internet but I could not find any suitable or reliable answer to solve this error. I delete all .G32 files but problem does not solved, so I delete all .lck and .idb files but no solution. When I replaced the Frxsys32.mdb file with old my recent backed up file then runs without any problem. Please always take backup of sysdata10 folder every week/monthly. Thanks Arif

To test certain issues, a troubleshooting technique may be to copy the Live Company database to a Test Company database. This article describes how to set up a test company that has a copy of live company data by using Microsoft SQL Server. MORE INFORMATION Notes If you use  Record Level Notes  - in your existing live company and plan to use them in the test company, you must run the NoteFix utility. For more information, contact the Microsoft Business Solutions System Technical Support team by telephone at (888) 477-7877. If you are using  Human Resources   for Microsoft Dynamics GP, the Attendance Setup information appears to have not been copied over. To open this window, click  Tools , point to  Setup , point to  Human Resources , point to  Attendance , and then click  Setup . This table (TAST0130) is copied over, but it contains a field that still references the Live Company database. To correct this issue, you can simply r...

Solution: Financial > Utilities > Book Select the Depreciation Book and select the current fiscal year, which is open now. If you have closed June 2015 and now working in July 2015 and trying to post the depreciation then the above error will be shown. Just go to Book in financial of Assets and select Dep. Book and change it to 2016 ( which is the current Fiscal Year)

When you try to open a purchase order entry window in Microsoft Dynamics GP, you receive the following error message: Solution Microsoft Dynamics GP 2010 and 10.0 On the   Microsoft Dynamics GP   menu, point to   Tools , point to   Setup , point to   System , point to Security , and then click   Alternate/Modified Forms and Reports . In the   ID   box, type the user ID. In the   Product   list, click   Project Accounting . In the   Type   list, click   Windows . Expand the   Purchasing   folder. Expand the   Purchase Order Processing Setup   folder. Click   Project Accounting . Click   Save . On the   Microsoft Dynamics GP   menu, point to   Tools , point to   Setup , point to   Purchasing , and then click   Purchase Order Processing . Click   Project . Make the appropriate selections. Click   OK .

Scheduling, Scheduling, Scheduling Payments in Dynamics GP | Dynamics GP Insights Scheduled payments are not used extensively in Microsoft Dynamics GP , but they can be quite helpful if you need to record scheduled invoices to post over time. If you want to pay off an invoice in installments, in payables management, or if you have negotiated with a customer to allow them to pay a large bill over time, scheduled payments can be helpful. They are available in both the receivables and payables management modules and work similarly in both. We’ll look at this feature in Payables Management. 

DynamicAccounting.net: Weekly Dynamic: Receivables Scheduled Payments

Microsoft Certification Tutorial by Snack Owner

Microsoft Certification Tutorial by Snack Owner

WAQAS BUTT - Microsoft Dynamics ERP'S Blog: Dynamics GP – Multicurrency Exchange Rate Updating... : Dynamics GP – Multicurrency Exchange Rate Updating Tool We came across so many requests from our customers asking for a utility which ...

WAQAS BUTT - Microsoft Dynamics ERP'S Blog: Using SQL Server Reporting Services(SSRS) with Mic... : In Dynamics GP we have a ...

With the experience of IT, data and information security from small startup to complex and challenging projects. I have been involved in the exciting Information Security, Identity & Access, and Systems Integration technologies. #1 Rank in MVA from Pakistan

Problem :   When you transfer a payment to the history tables in Receivables Management in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you cannot un apply the payment.   To work around this problem, use one of the following methods.   Method 1: Remove the payment and the applied documents from the history tables 1.      Use the Remove Receivables Transaction History window to remove the payment and applied documents. To do this, use one of the following methods: o     In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Tools , point to Sales , and then click Remove Transaction History . o     In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Utilities on the Tools menu, point to Sales , and then click Remove Transaction History . 2.      Reenter the payment and the ap...

Question: When I go into the Revaluation window and choose Current Year, I receive the message Year does not exist . If I choose Other Year and enter a period, I receive the message, Period does not exist. I have verified or done the following: 1. Renamed my fiscal period setup files and re-setup all of my fiscal period. 2. Verified that the user date falls within a valid fiscal period. What else can I do to resolve this issue? Answer: Go into Audit Trail Codes Setup (Setup - Posting - Audit Trail Codes). In the Financial series, verify that you have an audit trail code for Revaluation. If you do not have an audit trail code for Revaluation, clear data on the Audit Trail Codes file to recreate the audit trail codes with Multicurrency audit trail codes. Before you clear data on this file, print out the Audit Trail Codes report (Reports - Company - Setup - Audit Trail Codes), then after you have cleared data, reenter the Audit Trail Codes based on this report. Article ID: 86...

Microsoft Dynamics CRM and Office 365 – Powered Productivity - Executive Insight - Community Home - Microsoft Dynamics Community If you look closely at any successful company you will find productivity is the engine fueling growth. When business leaders think about improving the effectiveness of their people, they look to remove barriers that constrain knowledge sharing and empower confident decision making. In order to do this, organizations need technology solutions that are cost-effective, and deliver the latest innovations. ......

Customers Choose Microsoft Dynamics When Investing in Business Applications - Executive Insight - Community Home - Microsoft Dynamics Community

To restore a full backup of the Company database or the DYNAMICS database, follow the appropriate steps.   Using Microsoft SQL Server 2000 1. Click Start , point to All Programs , point to Microsoft SQL Server , and then click Enterprise Manager . 2. In the navigation pane, expand Microsoft SQL Servers, expand SQL Server Group, expand (local) (Windows NT), and then expand Database. 3. Right-click the database that you want to restore, click All Tasks , and then click Restore Database . 4. In the Restore as database box, select the database that you want to restore. 5. In the Restore area, click From device . 6. In the Parameters area, click Select Devices to open the Choose Restore Devices dialog box, and then click Add . 7. Click the File name field lookup (…) button, and then select the backup file ...

If you have SmartList Builder and GP 2010, you have access to a new feature called Navigation List Builder.  This tool enables you to create your own lists that appear on the Navigation Pane.  What are navigation lists, and why would you want to create your own?  Let’s look at an example of a navigation list that’s a standard option with GP for viewing sales documents. Click the Sales button on the Navigation Pane. Click “Sales Order Transactions” in the Shortcut Bar. You can filter this list and save your filter as a favorite. For example, you can filter the list to display only invoices and exclude historic invoices. The only problem you may have is that the system can be slow to display your data. Using Navigation List Builder, you can create a list that automatically displays just the data you want and the columns you want. Go to Microsoft Dynamics GP menu >> Tools >> SmartList Builder >> Navigation List Builder. Enter List ID, List Name and Navi...