Tag: great plains

Table Links in Extender

| 05/31/2012 | 0 Comments

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.

Continue Reading

SafePay Transactions Upload window does not populate in Microsoft Dynamics GP

| 05/29/2012 | 0 Comments

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.

Continue Reading

Error Exporting to Excel from Business Portal 5.1 for Microsoft Dynamics GP 2010 in Internet Explorer 9

| 05/24/2012 | 0 Comments

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).

Continue Reading

Concatenating strings in SQL Server

| 05/21/2012 | 0 Comments

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.

Continue Reading

Microsoft Dynamics GP and the Concur Import

| 05/17/2012 | 0 Comments

Concur Standard, Professional, and Premier are Web-based solutions that automate each step of the expense reporting process.

Continue Reading

Mismatched Inventory Quantities

| 05/12/2012 | 0 Comments
Mismatched Inventory Quantities

  Sometime you face difficulties in your inventories where your quantities does not match between applications forms, for example the on hand quantity does not match the historical stock status report or the item stock inquiry , and this is really annoying as the inventory reconciliation utility does not fix this and the resolution for this is a nightmare.

Continue Reading

Connection to the MAPI server not available in Dynamics GP

| 05/11/2012 | 0 Comments
Connection to the MAPI server not available in Dynamics GP

I posted about Dynamics GP and 64 bit support last year. As per the technology requirements for Dynamics GP – for the e-Email feature – E-Mail Functionality Feature Item Requirements Microsoft Office Microsoft Office 2007 32-bit Microsoft Office 2010 32-bit   Documentation Click HERE to review the SystemSetup.pdf manual for Microsoft Dynamics GP 2010.  Refer to Chapter 16 for information regarding e-mail setup. E-Mail Extended MAPI compliant e-mail application   As you can see 32 bit Office is required

Continue Reading