How to stop the transaction log of a SQL Server database from growing unexpectedly?

Great article by Microsoft Support, check it out here.

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

Advertisements

Dynamics GP Manufacturing Integration with GL

Another useful article by Waqas, he did explain the manufacturing cycle on the GL part and the accounts affected per each transaction, he did cover both periodic (standard) and perpetual (actual) workflows.

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

Manufacturing Simple Workflow

Waqas posted a new article about Manufacturing, he did draw a simple workflow for manufacturing related modules in GP, checkout the workflow below or refer to this post for more details:

Manufacturing_Flow_Chart

Yes it needs some enhancements but indeed its useful.

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

Answers you must have before posting a question.

While reading in one of the application manuals, I found an interesting questions that we all must consider having its answers before calling the support specialist, it would be great if you could include those questions answers in your question posting to get a best reply:

 

“  Before you call support

If you are experiencing a problem when installing Microsoft Dynamics GP, have answers ready to the following questions to help your support specialist narrow down the source of the problem you’ve experiencing.

• What is the exact error message?

• When did the error first occur?

• What task were you attempting to perform at the time the error message was displayed?

• Has the task been completed successfully in the past?

• What is the name of the window you are you working in?

• What have you done so far to attempt to fix the problem?

• If you are using more than one company, does the problem occur in another company?

• Does the problem occur on another workstation?

• What versions of software are you using?

Verify the version numbers for Microsoft Dynamics GP, your Microsoft SQL Server, and Microsoft Windows®. Also note service packs for each product.

• Are you using an integrating product with Microsoft Dynamics GP?

• Does the problem occur for the sa or system administrator user?

• Does the problem occur at the database server?

• If you use Windows Server® 2003 Terminal Services or Windows Server 2008 Terminal Services, does the same issue happen at the Terminal Server?                                       

Hope that this helps.

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

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

Holidays

Dear All,

This post is just to wish you a Merry Christmas and a happy new year!

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

Password Expiration Prompt

MichaelJ2 posted a good solution for password expiration notifications in this post its a .net based customization that could handle this feature, you can download it for free.

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