Page 1 of 4912345678910...2025303540...Last »

How to enable the Projection button in the Depreciation Projection window for Fixed Assets

Hi Guys..
Found a very important KB article on enabling Fixed Asset projections button in the Depreciation Projection window..
Check it out..

To make the Projection button available in the Depreciation Projection window for Fixed Assets, follow these step.

Note  The following steps require you to run delete scripts by using the Microsoft SQL Query Analyzer tool. We recommend that you create a backup of your data before you follow these steps.

  1. Make sure that all users exit Microsoft Dynamics GP.
  2. Use one of the following methods to start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio depending on the program that you use:
    • Method 1: SQL Server Desktop Engine (MSDE2000)

      Click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

    • Method 2: SQL Server 2000

      Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    • Method 3: SQL Server 2005

      Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

    • Method 4: SQL Server 2008Click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    • Method 5: SQL Server 2008 R2
      Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.
    • Method 6: SQL Server 2012
      Click Start, point to All Programs, point to Microsoft SQL Server 2012, and then click SQL Server Management Studio.
  3. Run the following commands against the Company database:

    DELETE FA40203
    DELETE FA41900

    Notes

    • FA40203 is the Fixed Assets Depreciation Book Setup table (used for tracking projections and depreciation).
    • FA41900 is the Projection Report Master table.
  4. Start Microsoft Dynamics GP.
  5. Verify that the Projection button is available. To do this, follow one of these steps, depending on the program that you are running:
    • For Microsoft Dynamics GP 10.0 and later versions:

      On the Microsoft Dynamics GP menu, point to Tools, point to Routines, point to Fixed Assets, click Projection, and then verify that the Projection button is available.

    • For Microsoft Dynamics GP 9.0 and Microsoft Business Solutions – Great Plains 8.0:

      On the Tools menu, point to Routines, point to Fixed Assets, click Projection, and then verify that the Projection button is available.



Applies to
  • Microsoft Dynamics GP 2015
  • Microsoft Dynamics GP 2013
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0, when used with:
    • Fixed Asset Management

Follow this link:
How to enable the Projection button in the Depreciation Projection window for Fixed Assets

March 23, 2015 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 13

Dynamics GP 2015 – Printing Arabic Text

If you are planning to upgrade to GP 2015 and currently having Arabic text in your database need to be printed using report writer, make sure NOT TO UPGRADE to GP 2015.

Normally for printing Arabic text in report writer, if your keyboard was language the text will be displayed as rubbish data as below:

In order to get this printed properly, we used to switch the keyboard language to Arabic and the text will back to normal as below:

However for GP 2015, the system will automatically switch the keyboard language to English upon the generation of the report, and unfortunately the same switch is occurred upon hitting the print button, therefore the Arabic text will never be printed in Arabic and customers will start nagging!

Hope that Microsoft could resolve this soon!


Regards,


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

See original article:
Dynamics GP 2015 – Printing Arabic Text

February 1, 2015 ·  · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 54

12 Ways to become a better CRM Developer

Vaidhyanathan Mohan:

Nice post up there on Ben Hosking’s CRM Blog…

Originally posted on Hosk’s Dynamic CRM Blog:

Now and again I get asked how to become a better CRM Developer, so I thought I would create a blog to point people towards and here it is.

1.  Decide you want become a better Developer

Improving and becoming a better CRM Developer is a state of mind/attitude, you have to want to get better, you have to strive to be better every day.

It’s like trying to get someone to read a book you like, you can’t make them read that book no matter how good you say it is, it’s only when the person wants to read it.

2.  Make a plan

A plan is like a map, if you don’t use a map it’s very difficult to get to where you want to go.  A plan is the same for careers and learning skills, you need to identify the skills you want to learn and make…

View original 985 more words

Filed under: Uncategorized

View article:
12 Ways to become a better CRM Developer

December 10, 2014 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 69

Dynamics GP Web Client: Kill all web client sessions

A customer has reported an issue with web client that many sessions are open while no body is working, they wanted to kill all these sessions without restarting the server, few researches over the internet returned the following CMD commands that did the trick, just Right Click the cmd.exe and run as administrator, then paste the following commands:

Taskkill /F /IM Microsoft.Dynamics.GP.Web.Services.Runtime.Process.exe
Taskkill /F /IM conhost.exe

Viola! You saved an hour of manually killing these in your task manager or session manager.

Note: To make sure that the windows cleans all sessions at night, I saved these commands into Batch.bat file and scheduled this with windows scheduler to run every night 4 AM, so users can find a clear log next morning.


Regards,


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

Read more here:
Dynamics GP Web Client: Kill all web client sessions

December 7, 2014 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 53

Microsoft Dynamics GP 2015 RTM – Available Now

With more than 120 new features, Microsoft Dynamics GP 2015 RTM is now available to download for partners.

Screen Shot 2014-12-02 at 6.55.03 PM

Quite obviously, a PartnerSource account is required to get the new version.

Excited to see GP 2015 being released earlier than expected. Will get to learn about all new features soon.

VAIDY

Filed under: #MSDYNGP, Dynamics GP 2015, GP 2015, Microsoft Dynamics GP, Microsoft Dynamics GP 2015, Product Releases, RTM

Original post:
Microsoft Dynamics GP 2015 RTM – Available Now

December 2, 2014 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 62

Dynamics GP Purchase Order Workflow: Approver requires A Full User not Limited

 

If you are looking to implement the Purchase Order Workflow, you must keep in mind that limited users will not be able to approve Purchase Orders, user should be FULL user to be able to process orders, I am not sure why Microsoft folks designed it this way but I got one of my customers to purchase additional 5 users to get this implemented!

I have requested this enhancement from Microsoft and kindly asking for your votes to get this fixed, below is the article on MS Connect:

https://connect.microsoft.com/dynamicssuggestions/feedbackdetail/view/1030936/purchase-order-approval-to-work-with-limited-users

Happy ordering!


Regards,


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

See the original article here:
Dynamics GP Purchase Order Workflow: Approver requires A Full User not Limited

November 16, 2014 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 78

Dynamics GP Purchasing – Request for Quotations module

Thinking about this subject, can’t find a company who does not follow the standards in their procurement process, everyone brings 3 quotations from 3 different suppliers and selects the best fit from requirements and pricing!

I found this process on Connect requested since 2010 with very limited votes! I would kindly ask for your help in voting and getting this scheduled soon, below the description of the product suggestion:

I think Dynamics GP is one of the few applications in the ERP world that does not have the request for quotation functionality, the process is like this: – RFQ (enter details for items willing to purchase) – Select one or more vendors and the system should print separate RFQ for each (and prepare the system to receive responses from each) – Receive quotes from Vendors and update on system – Compare vendor’s prices against same lines in RFQ – transfer one of the quotes to Purchase order Note: The is the simplest cycle possible and there are many other advanced consideration that can be added later on like: – Issuing PO against more than one vendor quote for same RFQ – Ability to update quotation with new discounts and data maintaining original information and changes (quote version control). – Ability to make the budget commitment from RFQ point rather than PO point (and this will be major advance for the application as most of the people in business or government would like to reserve budget before knowing the vendor and not after like it is currently acquiring in GP) – Specify a minimum number of quotations if the RFQ estimated price is more than a specific value. – Include in GP workflow if possible – Link to specific one or more requisitions created in Business Portal.

Below the link for the connect article:

https://connect.microsoft.com/dynamicssuggestions/Feedback/Details/537585

Happy voting!


Regards,


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

More:
Dynamics GP Purchasing – Request for Quotations module

November 15, 2014 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 63