Tag: sql server 2008

Currency Symbol is incorrect for some GP forms

| 06/05/2014 | 0 Comments

After updating the currency index field across all database, one of the users has reported that currency symbol does not match the functional currency symbol defined in the currency setup, and for some screens multiple currencies are shown as below: After looking for this I have found this in MC40000 table, the Currency ID field represents the correct functional currency but the index was referring to another currency, updating the currency index field fixed the issue. Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Consolidating multiple Dynamics GP Companies into single DYNAMICS database

| 06/05/2014 | 0 Comments

Recently I had an interesting project with one of my customers, they had the following environment: Server I: Dynamics GP 9 RTM with 14 active companies. SQL Server 2005 (Collation is Arabic_CI_AS)

Continue Reading

Disable “Remember Company” checkbox

| 05/21/2014 | 0 Comments

I got a request from one of my customers to disable the flag of “Remember Company” that exists on the company login form below: I have made this using VBA, please download the code using the link below: http://di.jo/Files/RememberCompany.zip Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Simulate DEX_ROW_ID in a SQL View Using ROW_NUMBER() – #MSDYNGP

I have a requirement in which I have to access a SQL view from within my customisation dictionary, in order to create a custom lookup for users to select a value based on an Extender form and an Extender lookup. Easiest option is to create an Extender view (which in turn creates a SQL view for us)

Continue Reading

Dynamics Innovations – Careers Opportunity

| 03/03/2014 | 0 Comments

I am proud to announce the availability of the following positions for talented candidates, if you feel that you are qualified to fulfill these positions, please feel free to submit your resume and we will be contacting you immediately. I would kindly ask only “ready” people to send their resumes, honestly  we cannot look into resumes without having enough qualifications, we are looking for candidates to start working on projects from day five, the first 4 days will be an orientation to get introduced to our standards and how we do business.

Continue Reading

Unable to start execution of step 1 (reason: line(1): Syntax error)

| 03/02/2014 | 0 Comments

This morning I worked with one of the customers on configuring the database backups, and stuck with an issue that after finalizing the Maintenance Plan the job been generating an error, getting into the job history I have seen the below dumb message: Unable to start execution of step 1 (reason: line(1): Syntax error) Luckily I found the below articles about this subject and it helped: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/dc52e0d9-af14-46b9-9904-29b9afa798cd/syntax-error-executing-maintenance-plan-job?forum=sqldatabaseengine http://www.sqlserver-expert.com/2011/08/unable-to-start-execution-of-step-1.html I found few difficulties while looking into the “package” mentioned in the resolution and therefore I though I would share a screenshot, adding a slash “” to the beginning of the text worked like a charm: Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

#MSDYNGP Extender View Involving Extender Window/Form – Strange “Add Link” Issue & Reason.

Firstly, I am not sure whether I should categorise this as an issue. Let me explain this with an example.

Continue Reading