Microsoft Dynamics SL Forum - Recent Threads

SL 2011sp1 and Windows Server 2012 Remote Desktop Services

Bob Marlow — Tue, 07 May 2013 16:47:09 GMT

Any known issues running SL 2011sp1 on a Windows Server 2012 Remote Desktop Services?

How to show accounts in dynamics crm 2011 using SL?

Mohsin Ali — Mon, 13 May 2013 11:06:40 GMT

hi m new to the dynamics CRM 2011. and i have assigned a task to add a custom button on the ribbon of accounts main page. and when a user click a new page must be open that show the accounts in the range between two dates which will be provided by the user from text box or any other way of dates.

Now, i have add the custom button on the ribbon of the page now how can i solve the remaining issue?

please help me in this regard

Thnx in advance.

Get output parameter from stored procedure in sl 2011

MDawood — Tue, 21 May 2013 15:31:12 GMT

Hi,

I have a custom stored procedure which get back an output paramter. Is there way to call it on the solomon and use the value of the output param.

I use the following code to call it with only the input parameters

SqlString = "exec xsp_CreateNew" + sparm(cType) + fparm(cBranch)

Call sql(C1,SqlString)

Thank you,

Mona

Business Portal and Browser Settings

ijet — Thu, 16 May 2013 18:50:08 GMT

I see frequent problems with Business portal resulting from Internet Explorer settings being slightly incorrect. Today a user cannot save hours when completing a timecard with more than one line. The Save Line Items button does nothing. Data that was entered disappears. This is limited to a single machine. The same user on a different machine has no problems.

1) What's the fix?

2) Where is there a document with the required settings for IE to work correctly with Business Portal?

KPI's not refreshing

Robert Houdeshell — Wed, 15 May 2013 16:36:44 GMT

I have a client who when they upgraded to SL 2011 their KPI's webpart no longer has an option to "Refresh Data". Instead, it just offers the ability to export to Excel.

I have verified the web part, the KPI Query that is connected and do not see anything that has changed. I looked at the old WebPart and the new one. Nothing looks idferent.

Any thoughts?

Unable to generate PO

Jason Lovin — Tue, 21 May 2013 14:16:45 GMT

In Invoice Entry, after opening the details screen for a specific job number, you see screen SD.203.00 which has a generate invoice button on the top of it. There are line items listed in the bottom section of this screen and if in those line items is a per diem item entered, when you hit generate invoice, it does not create the PO. It will show the message window that process is complete, but when going back into the job there is not PO generated.

Not sure where to look on this one.

Any advice?

AP Aging Report in AX

farhanarazak86 — Fri, 17 May 2013 03:59:04 GMT

May I know what other alternative can be use to compare Open Invoice Transaction?Since the normal practice, I just using external report(additional report) to compare with Open transaction.The result came out with no same amount for both report(Open Invoice & AP Aging-External Report).

Resource Assignment from MSP not Visible in SL

Coen Pretorius — Wed, 20 Feb 2013 19:35:35 GMT

Interface MS Projects 2007 and SL 7 FP1

Scenario.

One of the integrated projects, that used to work 100% , has not been receiving information (e.g. resource assignments) from MS Projects since15 Feb. Employees assigned to tasks in MS Projects prior to that date can select tasks onto timecards. Employees assigned to tasks in MSP after that date can select project on timesheets but the task is not available to select.
One can create a new task and new resource in SL and it is immediately available in MSP.

Other integrated projects are working fine.

I reviewed tables in SL and Projects_Published.

pjpentem and Pjpentemxrefmsp table does not contain tasks and resources after 15 Feb.

pjqueuemsp message contains PAEMP and PAPEM activities with status “P”, also after 15 Feb when resource was reintegrated to try and resolve the problem.

In the Project Server_Published DB the msp_tasks and MSP_ASSIGNMENTS contain records indicating that the resource assigment updated project server

I also noticed that the active directory name for the resources are not visible in the PWA Resource Center

What I tried to resolve the issue

· Reintegrated the resource

· Stopped and restarted the Project Server Queueing and Integration services

· Stopped and restarted the connector in Project Setup

· Unassigned the resource in MSP and had two different planners reasign the resource in MSP (in two different sessions)

· Googled and searched Partnersource extensively

Any assistance will be highly appreciated.

help - migration from SL 6.0 to SL 2011

rodi — Mon, 20 May 2013 02:59:27 GMT

Dear,

I just tried to migration / upgrade from SL 6.0 to SL 2011, using SL 2011's database maintenance.

everything done, but when I want to use the database, notification for Trialloc show. Why is that so? How tho fix it?

thanks.

Invalid object name 'SETUP'

Kristine Robinson — Tue, 14 May 2013 20:40:06 GMT

Receiving error when trying to print direct deposit remittance on special check printed to pay out vacation pay between regular payroll.

SQL Server Message 10215

Invalid object name 'SETUP'

Debugging info: SqlCompile - dbcursoropen

Cursor(12) SELECT CalYr, NextCheckDate FROM SETUP

Pay when Paid error 12398 when selecting a voucher for payment when linked invoice has been paid

Chris Reinert — Tue, 14 May 2013 18:48:00 GMT

Version 2011 FP1

I am trying to learn what I can about Pay when Paid for a client that wants to start using it. On a test system, I have created a Pay when Paid terms ID and have entered a voucher using that terms ID, and a basic invoice in the AR Invoice and Memo screen. I have linked the two documents using the Pay When Paid Link Assistant.

I then went to AR and fully paid the invoice in Payment Applications.

When I try to select the Voucher for payment in Edit/Select Documents for payment, I receive a System Message 12398 "Warning - This is a Pay When Paid Document that has not been fully invoiced. This will override the Pay When Paid LInk" [ok}

What am I missing? The voucher and invoice have been linked, the invoice was fully paid off. Suggestions?

Migrating SL 6.5 to SL 2011

C0ppert0p — Mon, 20 May 2013 21:16:17 GMT

Hi all,

I've installed SL2011 on a Windows 2008 standard server and want to import all the 6.5 files.

I know nothing about SL and am looking for guidance.

The first issue I ran into was trying to run SL remotely on a Windows 7 workstation, via a sharepoint. The system crashed with a "System.IO.FileNotFoundException".

Any help would be appreciated.

Thanks in advance

Help!! New to SDK - Small sample on how to create new screen?

karmar — Thu, 04 Apr 2013 02:48:38 GMT

I am new to the SL 7.0 SDK. I am using VStudio 2008. Anyone with a small example on how to create a new .exe (screen) from scratch ? (it is a screen that will mainly display data from several tables but has some data entry in custom tables)

Also, I need to be able to pass parameters to other screens, i.e from my screen call another module in SL and preload that screen with data (i.e call order entry passing order number as a parameter, so it brings the order entry screen with a particular order).

Thank you so much!

Management Reporter System Message 9898 on Client Workstation

Deb Lashua — Thu, 16 May 2013 12:05:15 GMT

Installed MR on client workstation. Client is able to open application, but then receives system message 9898 - The application cannot be found<MR LOCATION>\client\ReportDesigner.exe. Any assistance would be appreciated.

9829000 local system registry does not contain needed information

9829000 — Fri, 17 May 2013 17:50:57 GMT

Hi. We have installed Dynamics SL 2011 SP1 with the hotfix for the database maintenance screen. We are receiving the error: The local system registry does not contain needed information to identify the location of Microsoft Dynamics SL. To update this information, please install Microsoft Dynamics SL. We have completely uninstalled Dynamics SL and reinstalled it. We are still receiving this error. I made sure that tcpip and named pipes are enabled on the server. We are running Microsoft SQL Server 2008 R2. Does anyone have any suggestions?

Thanks,

Serena

The grid to excel button is disabled

cesar_t — Mon, 14 Jan 2013 15:21:07 GMT

I have a Microsoft Dynamics SL 2011 client running on a terminal server, but the grid to excel feature is disabled for every user, even SYSADMIN. I don't have this issue if the user work direct in a client installed in a workstation.

What do I miss in the setup?

Greetings

FRxConfig.xml File

Angela Schatz — Thu, 16 May 2013 22:55:34 GMT

Hi,

How does FRx copy the FRxConfig.xml into the user profile? Where is the data coming form to update the profile?

Thanks,

Angela

Generate straight to PDF (Management Reporter)

Dan Hough — Tue, 23 Apr 2013 20:56:02 GMT

Is there any update which includes this functionality? I belive I am still using the first release of 2012, I do not have RU2.

Thanks

System message 6816 for all reports

Wendell Jones — Mon, 13 May 2013 15:07:33 GMT

I just installed MD SL 2011 FP and I am getting System message 6816 for all reports stating that they are not found. The reports are there. The non-report screens open for the modules and perform the way I expect.

Any help would be appreciated.

Thanks in advance.

Wendell

Role Center disappears when company is changed.

TriciaC — Mon, 13 May 2013 16:26:33 GMT

SL2011 FP1 When I first log in to SL the Role Center is there. If I change companies it disappears. I have to completely close and reopen SL to see the Role Center again. Access rights for the role center actions are for all companies.

FRx istallation

Abbey — Thu, 16 May 2013 07:27:26 GMT

Hi there, actually I had once posted something about active directory access right, but I found a way around it and got the problem resolved, but another issue am having now have to do with FRx on workstation, before we changed our environment everything was working fine but since we changed our environment to have a centralizes AD that control our entire network I could not install FRx on the work station but everything working fine on the server, the issue is that the server that host the MBS and RFx is now joined to the AD but before that it was the same server that server as AD and MBS server nd since we had a general AD now is given error anytime I try to run the client installation of FRx that FRx has stop working and the installation will not continue, any assistant will be well appreciated.

Thanks

Saf Control VS 2010

Javier Frank — Mon, 31 Oct 2011 02:22:29 GMT

Anyone know what happened to the safdate for the vbtools version control for Solomon 2011 for VS2010. because I am not I shown in the toolbox

Exporting SL2011 FP1 Report to Excel 2010

Asoka R Perera — Mon, 13 May 2013 17:17:12 GMT

When you export from SL2011 to Excel 2010 the save as type dropdown does not have MS Excel 2010 listed. It has only MS Excel (97-2003). Is this SL2011 issue?

Asoka

Receive Message that FRx Drilldown Viewer Failed to Start New Page

Deb Lashua — Fri, 10 May 2013 14:59:25 GMT

Occassionally receive message that the drilldown viewer failed to start new page. Do we know what might casue this to occur?

Thank you,

Deb

SL is not creating some Shippers for Returns created in the SO (40.100.00), PO and Services.

IA — Wed, 08 May 2013 18:08:00 GMT

SL is not creating some Shippers for Returns created in the SO (40.100.00), PO and Services.

There is no error message given. The Next Step field in the Other Information tab stated, “In process (see Shipper). However, the system did not the shipper.

The Shipper Creation Log Viewer (40.450.00) contained the batches with the error message explanation “Create Shipper' not next step on sales order.” apart from for other batches with “A shipper ID cannot be generated.”

There are some P0 batches and Service batches with the same message in the Shipper Creation Log Viewer (40.450.00)

I have checked the following:

There are no messages in the Shipper Update Log Viewer (40.460.00).

There are no Event Logs created for the batches in question.

Right Order Type were selected.

There is enough quantity to in stock

The Process Manager is turned on.

Data are not in the future.

I have also tried the following resolution suggestion:

support.microsoft.com/.../913414

support.microsoft.com/.../844568

support.microsoft.com/.../868510

Help, I would greatly appreciate any help or suggestion on resolving this issue.

Thank you.

Managment Reporter - Web Viewer does not allow drill down (Report Viewer Does)?

Stephen Veldhuis — Sat, 11 May 2013 01:30:46 GMT

I have built an income statement that rolls up certain accounts using TOT (ex TOT 200:220) to summarize certain accounts (summarized accounts are set to NP in print control).. In the Report Viewer I can select the rolled up field an it will drill down to the summarized accounts and then select one of the summarized accounts to drill down to the transactions. The same report in Web viewer does not allow me to drill down when using the TOT function. Is there a way in Web veiwer to accomplish the same thing?

Blank Menu in SL 2011 at Login

Angela Schatz — Tue, 07 May 2013 14:52:44 GMT

Hi,

We are just in the process of migrating to SL 2011 and in the process of testing. Some of our users are encountering issues with no menus when logging in either on a local install or Citrix. When you look at the users group permissions everything has migrated over correctly. Has anyone encountered this? Your assistance is greatly appreciated.

Thanks

Kit explosion on SO & POs

oki_jin — Fri, 03 May 2013 19:51:51 GMT

Is it possible to use the explode kits functionality on auto-generated POs without listing out the kit components on the sales order ack and shippers? The only way the auto-generate POs seem to work from Sales Order entry is if I explode the kit on the sales order documents as well. We don't need the customers to see the line items of the kit itself. Thank you.

Alternate PNs for Obsolete items

oki_jin — Fri, 03 May 2013 19:10:43 GMT

What is the actual functionality of creating an alternate PN in the Item Cross reference section for obsolete items? I see that it brings up the new, recommended PN when creating a PO, but otherwise, it still allows the PO and receipt to be created for the item marked as Obsolete.

Does anyone know if Dynamics SL is supported on SQL 2012?

Lisa Smith — Tue, 06 Dec 2011 16:07:52 GMT

Windows 8 and Dynamics SL 7

MMaafs — Wed, 08 May 2013 16:19:27 GMT

Does Dynamics SL 7 SP3 support Windows 8 on clients?

Should we go to SQL 2012 or stay with SQl 2008 with SL 2011 FP1 upgrade?

Tasneem Nomani — Wed, 08 May 2013 13:01:39 GMT

Currently we are on SQL server 2008 R2 and Dynamics SL 2011.

We are in the process of upgrading to FP1.

Is there any benefit in upgrading SQL to 2012 or can we just stay with SQl 2008 R2.?

AP Voucher Closure

CV_NYC — Wed, 08 May 2013 14:20:17 GMT

Is there a way to close or delete a voucher that has been released without processing a Debit Adjustment ? Unless you create a 'zero' check for a VR and the related DR Adj VR the transitions never appear closed , they continue to appear on the Aged AP Report. Help?

40100000 Error 2147221504 (80040000)

Mario Chavez — Fri, 10 May 2013 17:18:26 GMT

I get Microsoft Dynamics SL 6.5

In Sales Orders Screen (40.100.00) when I am trying to open

I am receiving error:

40100000 runtime error 2147221504 (80040000)

Missing Database Information.

Programming bulletproof error 20000.

Can some body to help me?

Management Reporter SL ERP Integration

Deb (Davis) Lashua — Wed, 01 May 2013 18:30:13 GMT

Receive errors when attempting to enable integration in Management Reporter 2012 Configuration Console. Fiscal Year to Fiscal Year has encountered an error. Processing will be aborted. Error Text Year, Month, and Day parameters describe unpresentable DateTime.

SL is not creating Shipper for SO, PO and Services

IA — Wed, 08 May 2013 17:59:29 GMT

I have a situation where Shippers are not create Returns created in the SO (40.100.00) screen are not been process through the SL system.

There is no error message given. The Next Step field in the Other Information tab stated, “In process (see Shipper). However, the system did not the shipper.

There are some P0 batches and Service batches with the same message in the Shipper Creation Log Viewer (40.450.00)

I have checked the following:

There are no messages in the Shipper Update Log Viewer (40.460.00).

There are no Event Logs created for the batches in question.

Right Order Type were selected.

There is enough quantity to in stock

The Process Manager is turned on.

Data are not in the future.

I have also tried the following resolution suggestion:

support.microsoft.com/.../913414

support.microsoft.com/.../844568

support.microsoft.com/.../868510

Help, I would greatly appreciate any help or suggestion on resolving this issue.

Thank you.

How does Domain name change affect Dynamics SL?

Tasneem Nomani — Wed, 08 May 2013 12:54:36 GMT

Our company is going to do a domain name change in few weeks. How will this affect the Dynamics SL environment.

We are Dynamics SL 2011, with windows authentication.

We are in the procee of upgrading to FP1.

Should we wait for FP1 upgrade untill after the domain name change? Or it does not matter?

SL 2011 - AP Check MICR Font Issue

Kimberly D. Morris — Fri, 06 Jan 2012 19:29:13 GMT

We are unable to print a AP check using the MICR Font. We have it narrowed down to the crystal/Business Objects report engine. Has anyone ran into this issue?

Below is the server specs and what we have tried.

· Software installed on KCSLAPPWSV4

o Full Microsoft SL 2011 installed

o Crystal reports is installed

o Troy printer and MICRO fonts are installed

· Testing conducted on KCSLAPPWSV4

o We can print from Word using the troy font and the MICR front prints correctly.

o We can print preview the SL Crystal report and print to the troy printer and the MICR Font is correct.

· We print a AP Check within SL using the the same Crystal report above to the troy printer the MICR Font is INCORRECT,plain text.

Reprint AP Batch Control Reports not authorized

japruim — Thu, 02 May 2013 20:17:15 GMT

This is my first post, so please be nice :) What permissions would someone need to be able to print out the "Reprint AP Batch Control" reports? The screen number is 03.410.00. From what I can see, my user has the proper permissions but it won't let him print it. I don't want to just give him admin access

Sql Server Msg 93 - connection is busy with results for another command

Kim Huggins — Mon, 27 Aug 2012 22:26:38 GMT

We've just gone into production on our upgrade to SL 2011 and have begun to get a variation of the following error. We didn't see anything like this in the test environment, only began once we went live and it seems to be intermittent.

Sqyl Server Message 93,

Microsoft Sql Sever Native client 10.0] Connection busy with results for another command.

Debugging info:Batch_mod_rlsed '030224', 'AP'

Cursor(c_batch) Batch_Mod_Rlsed'030224', 'AP'

optional info: SqlState = HY000 Native Error = 0 ErrorMsg = Microsoft Sql Sever Native client 10.0] Connection busy with results for another command. pcbErrorMsg = 93

ODBCRowNumber =-1 Column =-1 SSrvrLine = 0 SSrvrMsgState=0 SsrvrSeverity = 0 SsrverProcname = SsrvrSrvname =

Thanks in advance,

Kim

note button in grid

Tax — Mon, 06 May 2013 09:33:54 GMT

Dear Expert,

Is it posible to add note button at key field inside grid?.

i make customized screen in vb.net (visual studio 2010) we can add the note button at the properties, there are only 3 type : None, Left side, Right side

i have tested in header level (level 0) for 1 key field, i choose properties note button : right side, it looks succesfull view the note button after running the form.

When i tried the same way, for key field (which is have grid (level1)), i don't know why the note button can't viewed.

could some one tell me is it posible?, if can, is there anything i missed when setting the properties?.

Thanks for your help.

Best Regards,

Musa

What would make VBA stop working in Dynamics SL 2011?

Bev Kaufman — Wed, 01 May 2013 18:23:52 GMT

A customization that is several years old has just stopped working, because it doesn't recognize the VBA function Trim. What could do this? In case anyone asks, of course we installed the VBA version of the customization module. We haven't worked with BSL for years.

What are the database tables associated with Vendor setup

Doug Brown — Tue, 30 Apr 2013 12:42:12 GMT

I have upgraded the e-Banking module in SL7 to provide a new ACH\Wire Plus payment format. Each vendor now has to be setup to use the new format and I would like to be able to script the change through the database. Does anyone know all of the database tables that have to be updated with vendor/e-banking information?

Management Reporter- Default Base Year in report definition

Seth Woolley — Thu, 06 Dec 2012 19:08:55 GMT

Hello,

I have a client who recently installed Management Reporter. It is not the newest build. When they open a report definition, there are the dropdown lists for the Base Period and Base Year in the date information not saved with report definition section. In the dropdown for base year, the list stops at 2011. Since their current fiscal year is 2012 I would expect this list to at least show that. What am I missing here? How is this list populated or what is it based on?

Thanks,

Seth

Where do I find the Check #, Check Date and Check Amount fields in the database

Last Jedi — Wed, 01 May 2013 17:51:13 GMT

I have a report and I need to pull the Check #, Check Date and Check Amount fields into the report.

I Currently have the reference number from ARDoc table.

Which tables can I pull these fields from?

Web Services / API

jmawebtech — Fri, 03 May 2013 19:49:17 GMT

Hi,

Does Microsoft Dynamics SL have web services? If so, how do I access them and use them in C#?

SL7.0 Inventory Item Usage Report

Keidonn Noel — Wed, 01 May 2013 16:29:17 GMT

Hi, Does SL7.0 include a report I can use to view summarized information regarding inventory items and their movement (Invoices, Issues etc) over more than one period?

Business Portal 4.0 Project Center TimeCard Entry

Christopher Chaney — Fri, 03 May 2013 00:00:54 GMT

When entering Timecards in Business Portal I notice there is no ability to enter daily detail (PJLABDLY) like we can using the Time Detail (TM.DLY.00) screen in SL. Is this just a limitation in BP 4.0 or is there a configuration option or something I can change to enable this ability in BP?

Grid to Excel errors out with "TM - Company Expense Reconciliation has stopped working"

Mark Beasley — Thu, 02 May 2013 17:36:41 GMT

When trying a Grid to Excel for the company expense reconciliation a message comes up saying "TM - Company Expense Reconciliation has stopped working" and Excel does not open. This happens only on a couple of client computers and works on others. When connected via a terminal server connection for the same user it works.

Cash Manager Bank Reconciliation out of balance to GL

SandyF — Wed, 01 May 2013 22:04:42 GMT

Bank Recon for the current month show the GL balance as 29554.17, if you look at the GL Trial Balance and Detail report the GL balance is 4554.17. Which balances to my CASH Manager and Bank Statement. If I run the Bank Reconciliation report and look at the wrkcabalances the glbalance is 4554.17 but the curyglbalance is 29554.17. This is consistent with entries I found in the CATRAN table that did not have a CURYIID. The question is how to fix? what tables should I be updating and rebuilding to get the correct CURYGLBalance in the wrkCABalances table.