nav-left cat-right
cat-right

Error in calculated field using RW_GetInternetText...

Recently after upgrading reports for a client from GP 10 to GP 2013, I started getting error message for a calculated field. Error in equation ‘XXXX’ The calculated fields was using the function RW_GetInternetText. RW_GetInternetText returns Additional Internet Information Text field as for the specified Master Type, Master ID and optional AddressID. If you are not familiar with this function, please refer to following...

SOP Quote Warning -Line item quantities are not fu...

I recently came across this question in GP Community related to warning displayed while entering SOP quotes in GP. Warning Message: Message -“Line item quantities are not fully distributed. Do you want to continue?” is displayed when you enter line items in the SOP quote in Sales Transaction Entry window. Reason: Option to transfer quote to either Order or Invoice is not selected in quote ID setup. If you try to...

Warning “Sales Order Processing and Invoicin...

Error Message: “Sales Order Processing and Invoicing modules are both installed. They do not share information. Transactions should be entered in one module only.” Below I discuss how you can turn off this message using Dynamics Utilities and SQL. Reason: This message is displayed to prevent users from accidentally entering transactions in both the Sales Order Processing and Invoicing modules in Microsoft...

Modifying Reminders’ display on GP Home page

Last week, I was adding a series of reminders on the home. As I kept on adding more reminders, I noticed it was getting harder and harder to read them. I wanted to make the data displayed on Microsoft Dynamics GP home page more readable. I decided try modifying the home to accomplish this. These changes are applicable to both GP 10 and GP 2010. For some background about modifying the home page refer to following articles: How...

Error message -Could not find a part of the path &...

Error message: Could not find a part of the path ‘\\server_name\Excel Reports path\CompanyID\ CompanyID Report Name\xl\workbook.xml’ when you try to publish the report created using Excel Report builder Cause This error message is displayed when you try to publish an excel report to Report Library and report library path is not set up in Reporting  Tools Setup window (Microsoft Dynamics GP menu >>...

Tips and tricks for setting up User Security in Mi...

The questions related to security are posted often in the Dynamics GP community. Today, I am going to summarize the various resources available to help you set up roles for users in Microsoft Dynamics GP: Overview of all existing Roles and Tasks Search by Resource (Window) Name Unassigned Security Operation report Troubleshooting security privileges error message Granting access to Smartlist Builder Objects   1.  ...