Dynamics SL Support and Services Blog

Dynamics SL Support and Services Blog
  • Saving filtered Quick Queries

    • 0 Comments
    Be sure to change BOTH the description AND the name fields (both of the top fields on the save screen). Otherwise, it will appear that it is "overwriting" an existing filter as only the description will be changing.
  • E-Learning

    • 0 Comments
    Although created in SL 7.x, much of the following still pertains to the current version. Check it out and learn something new! http://dynamics.microsoftelearning.com/catalog/default.aspx?view=catalog&filterView=basic&productFilter=Microsoft...
  • When a company has parenthesis in its name you receive a System Message 5034 when opening the Requisitions Approval screen

    • 0 Comments
    As the title states, if you have parenthesis in your company name, you will receive a System Message 5034 when opening the RQ.520.00 screen. This has been documented as bug 25499 with the workaround of removing the parenthesis from the company name in...
  • System Message 9851 when logging into SL

    • 0 Comments
    If you receive this error logging into SL, check to ensure you're not out of disk space. Another recent case pointed to the possible presence of a virus or malware on the workstation. Free up disk space on the workstation by removing unneeded files...
  • How to determine what PVRec record a specific field is using

    • 0 Comments
    If you're trying to determine which PVRec record (from the PVRec.csv file or the PVRec table) a specific field is using -- follow these steps: Let's take for example the Reference Nbr field of the Quick Voucher and Pre-Payment Entry (03.020.00...
  • If you can't edit notes after an upgrade of Dynamics SL...

    • 0 Comments
    Try going into initialize mode. There was a change from 7.x to 2011 for security reasons and now in many screens there is a need to have initialize rights and be in initialize mode in order to edit the notes on a (released/closed/cancelled/etc.) document...
  • What ODBC connection SL uses

    • 1 Comments
    Refer to image below:
  • Application Server Error: The RPC server is unavailable

    • 0 Comments
    This type of error can be seen if Outlook is opened/closed after launching Application Server. The workaround: Don't open or close outlook after you start app server. If outlook is already running when you start app server, leave it running...
  • System Mesage 28175 Attachments

    • 0 Comments
    With Attachments configured to a UNC path, you may receive the following error when trying to access previously added Attachments. System Message 28175 SQL Error Encountered: Cannot set application role 'MSDSL' because it does not exist...
  • I can see your comments/questions

    • 0 Comments
    I want to offer an apology to those in the community who have commented on my posts (or otherwise contacted me directly) for my less-than-prompt reply. I have a new way to view and reply to your comments so please keep them coming and I will check back...
  • Quick Query (or otherwise) Grid to Excel Issues? Try this

    • 0 Comments
    At times we've seen issues exporting a Quick Query or other grid in Dynamics SL to Excel. If you're experiencing any issues with this try: In Excel go to File > Options > Add-Ins. Try disabling these (one at a time if you want to track...
  • How To Properly Add a Custom Base Query View To The Menu In SL 2011, sp1, fp1

    • 0 Comments
    If you think you may have a problem with one you've already added, here are a couple of symptoms to check for: -- Your custom base query view is not in alignment with the standard ones on the menu. They may protrude to the left when viewing them...
  • Missed Convergence this year?

    • 0 Comments
    Attend Virtual Convergence! You can view the SL-Specific Virtual convergence video here: https://presentations.inxpo.com/Shows/microsoft/MSConvergence/3-13/Registration/Registration.html You'll need to quickly register (it's free and fast)...
  • Prompt for Login running reports

    • 1 Comments
    If you find yourself in a situation where you are being prompted for a login when running reports, try the following: 1 - Run the "synchronize all ownership and security" process in SL database maintenance - take note of any error message you...
  • Using Transaction Import as a non-admin user

    • 0 Comments
    If you have a user who is not in the Microsoft Dynamics SL ADMINISTRATORS group but would like to use Transaction Import (TI): 1. Logged in as an Administrator user, grant them full rights to the TI screens (98.500.00 and 98.510.00). 2. Have them...
  • Microsoft Dynamics SL Attachments slow

    • 0 Comments
    Attachments slow to upload or to pull up in Microsoft Dynamics SL? Try adding the following to the solomon.ini file: [Miscellaneous] AttachmentPreview=No
  • System Message 10232 and network disconnects

    • 4 Comments
    It used to be that the slightest drop in network connection between SL and the SQL server would cause a succession of SQL errors (10054, 10005, etc). Most always it was a failing piece of hardware or external force such as a router, switch, NIC, squirrel...
  • (Quick Query) Adding Custom Base Query views to the menu

    • 0 Comments
    There is a very specific method to add custom Quick Query views to the menu. If you add these through Menu Maintenance and reaize they are not indented on the menu as the rest of the quick queries are, you may want to try the following steps: 1...
  • AntiVirus and Microsoft Dynamics SL 2011

    • 1 Comments
    We have had a couple of instances where SL 2011x will hang when attempting to keep AP checks or when attempting to print the GL Edit report using the print icon in the Journal Transactions screen. The Symantec anti-virus appears to be the culprit. ...
  • Tax tables posted

    • 0 Comments
    https://mbs.microsoft.com/partnersource/downloads/taxupdates/sljan13tax.htm https://mbs.microsoft.com/customersource/downloads/taxupdates/sljan13tax.htm
  • Undocumented Solomon.ini settings (part 3)

    • 0 Comments
    APPLICATIONS [SD90000] Express Mode Default Value = T Valid Entries = T, F Read by Graphical Dispatch Board (SD.900.00). When set to T, a single instance of the Service Call entry screen will be used to display any service calls...
  • Undocumented Solomon.ini Settings (part 2)

    • 0 Comments
    [Reports] User Directory Default Value = usr_rpts folder in your Microsoft Dynamics SL program files directory Valid Entries = Any valid directory on the client computer Use this setting to redirect the location of the usr_rprts folder...
  • Undocumented Solomon.ini Settings (part 1)

    • 0 Comments
    [MenuGroupVisible] <SLMenuItem.CreatedName> Valid Entries = True / False Controls whether various menu groups are visible in the navigation pane. Example: Orders=True Financial=False The above would display the Orders menu...
  • Custom Trigger in Microsoft Dynamics SL 2011 -- Set Nocount On

    • 2 Comments
    If you plan to use a custom trigger in any version of Microsoft Dynamics SL 2011, be sure to add "set nocount on" at the beginning. Some of the symptoms of a custom trigger firing without "set nocount on" are SQL Server Message 62...
  • How to handle customizations when upgrading to Microsoft Dynamics SL 2011 FP1

    • 0 Comments
    Customizations have “versions”. The newest version is 6. If you upgrade to 2011 FP1, then export customizations that haven’t been updated to version 6 yet, you won’t be able to re-import the CST you just created. You will get...