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.