Monday, February 28, 2011

Undefined Symbol Errors When Upgrading from a version to another

 

This morning, a customer reported the following error while printing their checks remittances:

Undefined Symbol F01343D00789 Sequence Num

image

Last week I have upgraded this customer from Microsoft Dynamics GP Version 10.0 with Service Pack 4 to Microsoft Dynamics Version 2010 with Service Pack 1, when the customer sent me the package, I found that the package they sent is mapped to a table called "PM_Payment_WORK" while the original reports is mapped to "pmRemittanceTemp" then I figured out the reason behind this, this was due to the enhancements applied to this feature in GP 2010.

To resolve this, the hard way of doing this is by re-implementing the customizations on the original report. However there is always a workaround!

Below the steps I followed:

  1. I exported the report to a package file.
  2. I opened it using Notepad.
  3. Pressed CTRL+H to find and replaced PM_Payment_WORK to pmRemittanceTemp.
  4. Saved and imported the report.
  5. Regenerated the report and found 2 missing fields, replaced the missing fields with an alternative from the new table and it worked!

Enjoy fixing your reports without re-implementing your customizations!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Friday, February 25, 2011

Add Purchase Order Line Account Number to PO Workflow

My customer requested to setup the workflow step based on the account (expense or inventory) assigned to the line items, this account is loaded from the e-requisition module when generating the purchase order and it represents the cost center of the requested item.

They wanted to have this for their projects which is currently managed using an account segment, unfortunately the workflow does not integrates the line account number where I had to find another alternative solution.

image

One of the fields I found in the workflow was “Requested By” which was unused by most of users nor was used by e-requisition module, so I created a trigger to copy account number from the original field to the requested by field and created the workflow on the requested by field.

Below the trigger I used:

-- =============================================
-- Author:        Mohammad R. Daoud
-- Create date: 24-02-2011
-- Description:    Trigger to copy Account Number to
-- requested by field in PO Details
-- =============================================
CREATE TRIGGER POP10110RequestedBy
   ON  POP10110
   AFTER INSERT
AS
BEGIN
DECLARE @PONUMBER    VARCHAR(500)
DECLARE @ORD        BIGINT
DECLARE @INVINDX    BIGINT
DECLARE @REQSTDBY    VARCHAR(5000)

SELECT @PONUMBER = PONUMBER, @ORD = ORD, @INVINDX = INVINDX FROM INSERTED

SELECT @REQSTDBY = LEFT(LTRIM(RTRIM(ACTNUMST, 20))) FROM GL00105 WHERE ACTINDX = @INVINDX

UPDATE POP10110 SET REQSTDBY = @REQSTDBY WHERE PONUMBER = @PONUMBER AND ORD = @ORD

END
GO

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Management Reporter–Load Database is not loading my database?!?

 

I been in a situation were I have upgraded to GP 2010 and migrated FRx to Management Reporter, during the installation I wanted to configure my company and setup the Dynamics GP data provider.

I filled all fields in the form several time to make sure that I used the correct information and pressed “Load Databases” a dozen of times with no luck!

image

I ran profiler to get a clarification with no luck, then did an internet research that resulted in to the below article answered by Cory Severson from MS support team:

http://community.dynamics.com/product/gp/f/32/p/46091/84925.aspx

It was the Dynamics database name, the name at the customer SQL was “Dynamics” it should all be in caps “DYNAMICS”  Smile

Enjoy.

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Friday, February 18, 2011

Customer / Vendor Consolidation

 

I got many questions on the customer vendor consolidation module where I have decided to print few screenshots that details the module process, below is a simple process:

Customer Invoice:

clip_image002[4]

Link Customer To Vendor:

clip_image003[4]

Vendor Invoice:

clip_image005[4]

Customer Vendor Setup:

clip_image006[4]

Consolidation Process:

clip_image008[4]

Consolidation Preview:

clip_image009[4]

AR Inquiry:

clip_image011[4]

AP Inquiry:

clip_image013[5]

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
me@mohdaoud.com
www.mohdaoud.com

Friday, February 11, 2011

Introduction to Microsoft Dynamics CRM 2011

 

I would like to welcome you guys to an introduction session about Microsoft Dynamics CRM 2011logo_dynamics_crm_featured

 

Introduction to Microsoft Dynamics CRM 2011

 

Time

Wednesday, March 2 · 6:30pm - 8:30pm


Location
Princess Sumaya University for Technology - Laoy Shammout Hall


Created By

Jordan Dynamics User Group, Mohammad R. Daoud


More Info:


Part of the Community Technical Talks series (JordanRuns.NET)
Introduction to Microsoft Dynamics 2011
By Ahmad Nimer, CRM Specialist
When: Wednesday Mar 2nd
Where: Princess Sumaya University for Technology - Laoy Shammout Hall

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
me@mohdaoud.com
www.mohdaoud.com

Related Posts:

Related Posts with Thumbnails