Mass Item/Vendor Link

 

I got a request from one of my customers to have the ability to link multiple items with a vendor without the need to add them one by one and I have created this using the .Net toolkit, the screen will look like the below:

image

The user can filter items from the list on the left panel, click on insert and process! The system will link the selected items with the selected vendor!

I am willing to publish this tool soon, will update the article with the download link once doing some fine tuning on the utility.


Regards,

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

Advertisements

Crystal Report: Sub Report did not show up on client machine

 

I been in a situation where I had to create a report with sub-report in crystal and the report worked perfectly on my machine.

while implementing the report on the client machines I noticed that the sub-report is always empty on all machines and even on the server.

I tried everything with no luck, I even recreated the report with no luck as well, after deep investigations in the issue I have noticed that both Main Report and Sub-Report are using commands and both has the same identical name “command”, changing the command name in the sub-report to “command_1” resolved my issue!!!

Hope that this does not happen to you and helps reducing research time!


Regards,

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

Dynamics GP Workflow–Task Approval Page redirects to local server URL even if the used URL was published!!

 

Looks like the folk at Microsoft forgot to remove the local URL when redirecting from Task Approval page to the actual document behind “This workflow task applied to:”:

image

So if your workflow was published over the internet and you users tries to open a document, the system will redirect them to the local server and not to the website as shown below:

image

To workaround this, I had to use SharePoint Designer or any available scripting tool to change the redirection of the below hyperlink in (C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\Dynamics.Workflow.TaskApprovalPage.aspx):

<a href=”<%=this.DocumentUrl%>” id=”A1″ target=”_blank”
     title=”<%=this.WindowLinkTitle%>”>
     <%=this.DocumentUrlText%></a>.

Into the below modified one:    

<a href=”Dynamics.Workflow.GP.PurchaseOrderViewer.aspx?org=1&workflow=f01d80eb-d355-460c-8cb6-b2a2162a078b&PoNumber=<%=this.DocumentUrlText%>” id=”A1″ target=”_blank”
     title=”<%=this.WindowLinkTitle%>”>
     <%=this.DocumentUrlText%></a>.

And it worked Smile Hope that this helps.


Regards,

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

Dynamics GP Data Level Security

 

I am getting requests about this subject almost from all my customers, therefore we at Dynamics Innovations have decided to develop an add-on for Dynamics GP to fulfill this request a month ago and my development team is currently in the process of developing the final touches on the utility.

The add-on is basically works on creating new Dynamic lookup that replaces traditional Dynamics GP lookups, the same lookup is used for all kind of data inside Dynamics GP and the rows are filter dynamically at runtime based on user privileges which to be setup by creating a specific view for each user/role per each business entity and the system will display only data from the linked view:

image

By achieving this, the system administrator will be able to customize columns names and columns to be displayed by using SQL views or direct SQL queries and rows to be displayed, and the lookup will automatically filter rows using “like/contains” operator based on the user selection and based on the clicked column:

image

The data load were enhanced to load data into .Net data grid that pulls rows from database directly into the user interface, 250,000 records were pulled within less than 7 seconds:

image

In addition to the lookup functionality we have developed a routine that validates user inputs inside GP texts and will make sure that the user selected data is a part of the user query:

image 

The development team is currently working to enhance the navigation buttons as it might violates our security setup.

We been able to automate all the above processes and hanged with a couple of issues, the first is reports and the other is the smart list, and been able to handle smart list security by linking users view with smart list views using smart list builder, so each user will have his smart list configured, not an easy task but doable.

The last part is our challenge for the time being, we cannot figure out a solution for filtering report writer reports using available algorithms, we tried to pass restrictions fields to the reports using VBA but this wasn’t a sustainable solution, we still didn’t give up but we might not be able have this done.


Regards,

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

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

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

Item Lookup – Display Item Description Instead of Item Short Description

I got several requests to replace Item Short Description in Items Lookup with Item Description, below is the package:

Regards,

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