Dynamics SL ROI

Ever wondered what ROI stands for in Dynamics SL?

Well have no fear, you are in the right place sir/ma'am!

ROI stands for - Report Operations Interpreter

What is it - it is the screen you see immediately before running any SL Crystal Report. The purpose of the screen is to filter or group the report the way you want it to show at run time.

Company Restored but data missing

You restored a live database to the test company and found that your data is missing in the existing live company.

Reason - the database name in the company maintenance window of SL is incorrect.
Have all users exit the system and manually update the Company table in the system database to reflect the correct application database name.

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.

Dynamics SL Backups Required

 Here’s what should be backed up daily:

1. The Dynamics SL application database
2. The Dynamics SL system database
3. The FRx 6.7 folder in the Dynamics SL installation area (if you are still using FRx)
4. The Usr_Rpts folder in the Dynamics SL installation area

Backing up Custom Dynamics SL Reports

If there are any customized reports in the system they will be located in the Usr_Rpts folder in the SL Program Files.

Typically, this path is something like C:\Program Files (x86)\Microsoft Dynamics\SL\Applications.

To back them up - Make a copy of the Usr_Rpts somewhere and put it in a different location than the SL program files.