Re-open Fixed Asset Year to un-do disposal (unofficial steps)

1.  Run a Select * from FA40200 and note the CURRFISCALYR of the books.
2.  From SQL studio, update the FA40200 table and set the CURRFISCALYR to the year that the asset was retired in.
3.  Go back into GP and undo the retirement.  Interface the transactions to the GL and delete or post them as necessary. 
4.  Go back to SQL studio and update the FA40200 to set the CURRFISCALYR to what is was before you updated it the first time.
Voila.

Unable to connect to GP

When testing ODBC connectivity the following error is obtained.

[Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Resolution:
Start the SQL Browser service
Turn off firewall.

Unable to add user to SQL when installing eConnect

Use solution 1 if you are installing econnect for the first time.

This issue happens if the user you are entering on the installation does not have DYNGRP role assigned to them for every GP database.

Go to SQL>>Security>>Logins
Add the user, give them sysadmin role
Give them access to the GP databases and also assign the DYNGRP role to each GP database.


Use Solution 2 if you are installing econnect on another machine or reinstalling.

During the eConnect Install
Mark/Tick the box 'Do not add service user to SQL' in the SQL Connection Information window.
This will prevent SQL from trying to re-add the user which gives the error that it cannot add the user.

Virtual machine could not start because the hypervisor is not running.

Ok so if you're not techy you can do the following:

1. Run cmd as admin and then paste this in
2. bcdedit /set hypervisorlaunchtype Auto

          then click enter.
     3. Then restart computer and your vm will work again.

This apparently has to be done every time your computer shuts down.


The long term fix is:
Cause

The Data Execution Prevention (DEP) setting is not enabled in BIOS. For HP server, it is called "No Execute Memory Protection"

Resolution

To fix the issue, enable the DEP setting in BIOS

SSRS add in for SL

Originally found on page - 

http://ajitkannan-erp.blogspot.com/2013/12/add-ssrs-report-in-dynamics-sl-2011menu.html

Add SSRS Report in Dynamics SL 2011Menu

This post is an effort to the various operating steps which helps to adding the SSRS Report under SL menu

   Step 1: Create New SSRS Report or use existing Report (.rdl) 

   Step 2: Include the report in SL root folder under Usr_Rpts

   Step 3: Open SL 11 -> Administration->Maintenance -> Report Control Maintenance  (98.300.00)

       Enter the Report information Report number, Report format name, Report format into the Report 

       Control  maintenance .

   Step 4:  Open SL 11 -> Administration->Maintenance -> Screen Maintenance (98.330.00)

       Enter the Report number, Report name, Module and Type 

   Step 5: Open SL 11 -> Administration->Maintenance -> Menu Maintenance (98.350.00)

1. Select the relevant Group in “Menu for Group”.
2. Select the Screens tab in the Menu Maintenance (98.350.00). 
3. Select ALL- Show All Screen from the Drop-down “Show Screen Access for Group”.  This will show up all the SL screens in the Screens tab.
4. Select the exact Report  from the Screens tab. Drag and drop the Report into the “Navigation pane work area” under  Inventory -> Report .
5. After add the report to menu exactly as a normal crystal report,but rename  the program ROISRS.EXE replacing from ROI. EXE.Report as shown in the below figure. 
6. Save and close the screen.

  Step 6:  Close the Solomon and launch it.

SSRS Trial Balance not sorting account numbers

So you try to print a GL Trial Balance but when you select the from and to accounts they are not sorted correctly.

Easy fix - change the sort order in stored procedure.

Edit the stored procedure that populates the drop down list (seeglSRSAccountListing in the company database) to end with this:
select * from #accountsegment order by segmentlisting

Originally it does not sort.

Also, you can technically change the drop down lists to text boxes and type in account segments instead of using that pre-populated drop down list if you want.

Management Reporter Crash when Importing Reports

You click Building Block Groups and go to import some reports, when you navigate to the file and click import everything freezes.

This is an issue caused by a microsoft update. It was resolved in versions of Management Reporter 2012 CU13 and higher. If you are unable to use a version higher then all you have to do is not place your mouse icon into the area where the reports are on the import window.

Hence, just click import, navigate to the location and click select all and then proceed with the import, do not put your cursor in the top window or anything as this is what causes the application to crash. Seems to be some pop up message issue cause by a microsoft windows update.