Who’s editing this transaction?

 

Dynamics GP manages transactions locking by saving the “ID” of the transaction’s being edited in the SQL (SY00800, SQL00801 and DEX_LOCK in tempdb) to avoid any deadlocks in the database.

However, when a user tries to open one of the locked transactions, it will be notified that the transaction is currently locked by another user:

Michael D Johnson posted a solution for this. Now, you can download the free Record Lock Tracing add-on for Dynamics GP (Tested on v10 and GP2010) that will replace this generic message with a message that includes the specific user that has the record locked:

Well done Michael!

Regards,

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

Advertisements

Creating Dynamics GP Installation Package

Andy Nifong posted an article on how to create Dynamics GP installation package with screenshots per steps, checkout his post here.

Regards,

Mohammad R. Daoud – CTO
MVP, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Currency Exchange Rates Feed (Importer) for Microsoft Dynamics GP 10.0

Long time ago, I have developed a service that loads currency exchange rates from the internet directly into Dynamics GP, I am willing to share the tool for free if you are interested to send me your information and willing to be on my company reference list!

Worth mentioning that the current source of the rates is this free online web service that provide currency rates on daily bases, if you wish to change the source of rates, feel free to change the configuration.

Regards,

Mohammad R. Daoud – CTO
MVP, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Playing Sound when starting Dynamics GP!!!

Interesting article by David, just add a wave file and rename it to “GPSSystemStart.wav” in your windows folder to get it played upon starting GP! Checkout his post here.

Regards,

Mohammad R. Daoud – CTO
MVP, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Filter Lookups By Predefined Smart-list Favorite “Simple data level security method”

Sometimes you might need to restrict access to some items in your store for certain machines, which is currently not possible out of the box, this method is not totally restriction but it could help, I am using the smart list favorites to filter lookups, follow steps below to implement:

1. Go to smart list and add some filters on the inventory items smart list then save it as a favorite smart list.

2. Go to Items lookup and add the form to VBA, then add “ViewAll” button to the VBA.

3. Write the following code segments in VBA to disable the “ViewAll” and “Advanced Search” buttons after selecting the needed favorite:

Private Sub ViewAllItemNumbersbyItemNumber_AfterUserChanged()
ViewAllItemNumbersbyItemNumber.Enabled = False
PBAdvancedSearch.Enabled = False
End Sub

5. After loading the window we’ll need to register a macro that selects the needed favorite, the code will look like the following:

Private Sub Window_AfterOpen()
    ‘Dim CompilerApp As New Dynamics.Application
    Dim CompilerApp As Object
    Dim CompilerMessage As String
    Dim CompilerError As Integer
    Dim Commands As String
    ‘ Create link without having reference marked
    Set CompilerApp = CreateObject(“Dynamics.Application”)
    Commands = “”
    Commands = Commands & “local integer l_file_id; ” & vbCrLf
    Commands = Commands & “local string pathname; ” & vbCrLf
    Commands = Commands & “pathname = Path_GetForApp(1) + “”TEMP.MAC””; ” & vbCrLf
    Commands = Commands & “l_file_id = TextFile_Open(pathname, 0, 0); ” & vbCrLf
    Commands = Commands & “TextFile_WriteLine(l_file_id, “”  ActivateWindow dictionary ‘SmartList’  form ‘IV_Item_Number_Lookup’ window ‘IV_Item_Number_Lookup’ “”); ” & vbCrLf
    Commands = Commands & “TextFile_WriteLine(l_file_id, “”  MoveTo field ‘ASI_LU_View_Button’ item 5  # ‘Restricted List…’ “”); ” & vbCrLf
    Commands = Commands & “TextFile_WriteLine(l_file_id, “”    ClickHit field ‘ASI_LU_View_Button’ item 8  # ‘Rams’ “”); ” & vbCrLf
    Commands = Commands & “TextFile_Close(l_file_id); ” & vbCrLf
    Commands = Commands & “if File_Probe(pathname) then ” & vbCrLf
    Commands = Commands & ”  run macro pathname; ” & vbCrLf
    Commands = Commands & “end if; ” & vbCrLf
    ‘ Execute SanScript
    CompilerError = CompilerApp.ExecuteSanscript(Commands, CompilerMessage)
    If CompilerError 0 Then
        MsgBox CompilerMessage
    End If
End Sub

6. Give your use the access to the modified form instead of the original and enjoy having your form looks like the below:

image 

Hope that this helps.

Regards,

Mohammad R. Daoud – CTO
MVP, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Business Portal Terminal Services Error: null-CWTSSession.openCannes:’oWTS’ is null or not an object

After installing the business portal and configuring the terminal services for Dynamics GP, you might get the following error upon trying to open GP form:

“Null-CWTSSession.openCannes: ‘oWTS’ is null or not an object”

Through the business portal installation steps, you will need to adjust some settings on the internet explorer options as mentioned in the installation guide, below are the required steps, complete the steps and the error will no longer exist:

1. Start Internet Explorer and open the Internet Options window.
Tools > Internet Options

2. Click the General tab. Under browsing history, click Settings.

3. The Temporary Internet Files and History Settings window is displayed. Be
sure the Check for newer versions of stored pages option is not set to Never.

4. Click OK to close the settings window.

5. Click the Security tab, highlight Trusted Sites, and click Sites to open
the Trusted Sites window.
If Business Portal doesn’t use Secure Sockets Layer, you must clear the Require Server verification (https) for all sites in this zone check box. If you can’t clear the check box, you must change the security settings for the Local Intranet zone instead of adding Business Portal to your Trusted Sites list.

6. In Add this Web site to the zone, enter the Business Portal URL and click Add.

7. Click OK to close the Trusted Sites window.

8. In the Internet Options window, be sure Trusted Sites is still selected and click Custom Level to open the Security Settings window.

9. In the ActiveX controls and plug-ins section, select Enable for the following
settings:
• Download signed ActiveX controls
• Initialize and script ActiveX controls not marked as safe for scripting
• Run ActiveX controls and plug-ins

Changing these options will allow ActiveX controls to run automatically on all
web sites in your Trusted Sites zone. This zone contains sites that you
believe you can download or run files from without worrying about damage to your
computer or data. The security level for trusted sites is typically lower than the
general Internet or Intranet security level.

10. Click OK. An alert message will be displayed, asking if you’re sure that you want to change the security settings for the zone. Click Yes.

11. Click OK to close the Internet Options window.

Finally if you followed the above steps and still getting the problem, change the compatibility level in the internet explorer and it should no longer exist.

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Integrating Microsoft Dynamics GP With SQL Reporting Services

Interesting method in GP 10.0 to have customized reports developed on SQL Reporting Services launched from GP, follow steps below to complete the installation:

1. First you need to run the Reporting Services setup wizard from GP CD2:

image

2. After having the wizard installed, we need to define the reports and web services path in “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Reporting Tools Setup”:

Fields need to be set as documented in Help:

Report manager URL

Enter the Report Manager URL for SQL Server Reporting Services. Report Manager is a report server administrative web page that enables you to manage (create, edit, delete) data sources.

The URL should follow this general syntax:

http://<>/<>/Pages/Folder.aspx

If you do not know this information, contact your system administrator.

Report Server URL

Enter the Report Server URL for SQL Server Reporting Services. This is the location of the reporting server site that hosts the Web Service. You specified this location when you installed SQL Server Reporting Services.

The URL should follow this general syntax:

http://<>/ReportServer/reportservice.asmx

image

3. Go to Administration tab and find “Custom Report List”:

image

4. Enjoy having your reports in the list:

image

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com