Tag: great plains
In the last couple of weeks I have seen a couple of GP consultants / advanced users try and disable products the long way, manually editing the dynamics.set file – Steps to disable third-party products or temporarily disable additional products in the Dynamics.set file in Microsoft Dynamics GP Although this works – there is a much easy way to do this! Use the Dictionary control window in Support debugging tool. I personally think, it takes letter time to install Support debugging tool, then to do this manually – plus you don’t have to worry about making mistakes.
Based on some reader requests, this new view is a combination of my All SOP Line Items view and the recently posted script showing how to get a concatenated list of serial numbers in SQL .
There are many times we see that a user removes a record from Microsoft Dynamics GP, but the Extender data is left in the database. If a new record is creating that happens to have the same Key on it, the data then links to that new record. Using the Table Links, it is possible to have the Extender data removed when the Microsoft Dynamics GP data it is linked to is removed as well. Linking an Extender Window to a table ensures that the Extender Window’s data is deleted when the corresponding Microsoft Dynamics GP table record is removed. A window can be linked to more than one table. When linked to more than one table, the Extender Window data will only be deleted when there is not a corresponding record in any of the linked tables.
SafePay allows the customer to generate a list of checks and voids (from Payables Management and Payroll) that they can upload to the bank. When a check is presented to the bank to be cashed, the bank will compare the amount and information on the check to the uploaded SafePay file, as a security and fraud prevention measure. In Microsoft Dynamics GP, the user can generate the upload file to send to the bank, if they have purchased SafePay. However, we have received several support incidents where the SafePay Transactions Upload window is blank and does not populate in Microsoft Dynamics GP. If it’s the user’s first time using SafePay, we often find they are not registered for the Bank Reconciliation module. However, if the user has been using SafePay for some time, we usually find that the check has already been uploaded and it will not upload again. The check can only be uploaded once to the bank.
Error Exporting to Excel from Business Portal 5.1 for Microsoft Dynamics GP 2010 in Internet Explorer 9
If you’re using Business Portal 5.1 for Microsoft Dynamics GP 2010 along with Internet Explorer 9 and attempt to export the results of a query to Excel you may have received the following “Results not copied to Excel” error: This generally happens when the result set you are exporting is large (~1000 records or greater).
This SQL Server tip comes from the April 2012 edition of the GP Reports Viewer newsletter. A request that we have seen many times when creating SOP invoices for Dynamics GP is to concatenate serial numbers. So if there is an item with serial numbers, instead of showing a list with one serial number per line under the item, which would look a little unwieldy with long list of serial numbers: we want to show all the serial numbers on one line, separated by a comma.