Microsoft Dynamics SL

Forum Post: RE: Add key field to existing screen

The Cubist — Tue, 21 May 2013 22:29:00 GMT

I see; I thought I must have misunderstood something. Thanks for the clarification.

Is there any reason why you couldn't just create multiple Customer ID records? You could then use a user field in Customer maintenance to tie the customer records together under one parent customer ID (assuming that you need this type of correlation for reporting purposes).

Thanks,

Forum Post: RE: Get output parameter from stored procedure in sl 2011

Barry Flynn — Tue, 21 May 2013 21:50:00 GMT

I almost had to do this a few years ago.

The theory I was going to use was:-

- Have a stored procedure with an output parameter

- Have a second stored procedure which (a) runs the 1st proc, then (b) does a "select the_variable"

- The SL code then does a conventional SQLFetch1 to run the 2nd proc.

The idea is that the 2nd proc looks and behaves just like any other proc that SQLFetch1 deals with.

That sounds to me like it should work, but I can't recall if I tried it (vefore the spec changed, and we did it a different way.)

Barry

Blog Post: Taking Your Financial Reports to the Next Level with Management Reporter – Statement of Cash Flows (6 of 8)

Dynamics CPM Team — Tue, 21 May 2013 20:35:00 GMT

The sixth report in the “Taking your Financial Reports to the Next Level with Management Reporter” series is the “Statement of Cash Flows.” There are often multiple financial or strategic opportunities available to a company, but not a lot of cash for those opportunities. The need for sufficient cash to cover operating expenses needs to be balanced against opportunities to pay off debt or to make operating investments. The Statement of Cash Flows report helps in evaluating past operations and in planning future investing and financing activities.

This video contains how to create a Statement of Cash Flows report for your business.

(Please visit the site to view this video)

In summary, the key features included in the “Statement of Cash Flows" report were:

Account modifier in the Row Definition to return beginning balance or year-to-date amounts for the cash accounts rows
Non-Printing rows and columns used for calculations
Advanced cell placement for calculating the beginning cash balance

Links to other posts in this series:

Quarterly Revenue by Business Unit - Are we making a profit?
Weekly Campaign Revenue - Are we being effective?
Weekly Material Usage - Are we being efficient?
Budget to Target - Are we hitting targets?
Postings Audit - Are we entering transaction accurately?
Statement of Cash Flow - Are we making the right investments?
Quarterly Tax Form - Are we getting the data needed for taxes?
Financial Matrix - How are we performing?

Forum Post: RE: SL 2011sp1 and Windows Server 2012 Remote Desktop Services

Blaine Bryant — Tue, 21 May 2013 16:41:00 GMT

Bob,

We have not heard about anyone having any issues with running SL 2011sp1 on a Windows Server 2012 Remote Desktop Services. Maybe if someone else has been using this setup they could chime in.

Forum Post: RE: How to show accounts in dynamics crm 2011 using SL?

Carolyn Kolpien — Tue, 21 May 2013 15:45:00 GMT

Hi MOHSIN,

It might be better if you ask this question on the CRM forum rather than the SL forum.

Forum Post: RE: Business Portal and Browser Settings

Blaine Bryant — Tue, 21 May 2013 15:15:00 GMT

IJET,

What Version of IE are you using? Is it the 64-bit or 32-bit version of IE?

There is no Document that states all the IE settings for each situation. IE settings are adjusted on an as needed basis. This is because some machines work just fine with the Default IE settings while others need adjusted slightly due to proxy settings and security policies. Unfortunately due to the wide scope of problems that concern IE settings we cannot publish a document with a guaranteed set of IE settings that will work in every situation.

Forum Post: RE: KPI's not refreshing

Carolyn Kolpien — Tue, 21 May 2013 14:44:00 GMT

Hi Robert,

When you click on a value in a KPI, you should have an option to Recalculate Data. Do the users not have this option?

Forum Post: Unable to generate PO

Jason Lovin — Tue, 21 May 2013 14:16:00 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?

Forum Post: RE: AP Aging Report in AX

Carolyn Kolpien — Tue, 21 May 2013 14:13:00 GMT

Hello,

You posted this question in the Dynamics SL forum. You may want to ask your question in the AX forum instead. Thanks.

Forum Post: RE: Resource Assignment from MSP not Visible in SL

Coen Pretorius — Tue, 21 May 2013 12:16:00 GMT

Hi, should have given feedback. The issue was that the planner duplicated SL Task ID's in MSP. He created new tasks in MSP and linked them to SL Task ID's that already existed in MSP. The Addin was not installed on his machine.

Mark assisted - meaning he did all the work! - to clean up the database.

Forum Post: RE: help - migration from SL 6.0 to SL 2011

rodi — Tue, 21 May 2013 09:11:00 GMT

Do you mean I need ask to my vendor?

normally, is it include on maintenance fee or there is add-on fee/charge for upgrade and get new registration keys?

Just look another opinion. thanks.

Forum Post: RE: Invalid object name 'SETUP'

Elaine Rettig — Tue, 21 May 2013 00:53:00 GMT

Hi Kristine,

Would you look at the rptcontrol table in the system database.

select Module,ReportNbr,* from RptControl where ReportNbr like '0263%'

Are any of the module fields blank? If so , update it to PR.

Update rptcontrol set module = 'PR' ReportNbr like '0263%'

Forum Post: RE: Pay when Paid error 12398 when selecting a voucher for payment when linked invoice has been paid

Elaine Rettig — Tue, 21 May 2013 00:43:00 GMT

Hi Chris,

I tested this and have the same message. I think you probably always get this message when you select a Pay-when-paid terms voucher in the Edit/Select Documents for payment screen. When you make the selection of the voucher in Edit/Select, the system will allow you to select and pay a pay-when-paid voucher even if the invoice isn't paid.

Make the payment selection in the Payment Selection screen choosing by refnbr and the system will select the document without error. If you need to pay the PP voucher even when the invoice hasn't been paid, you can do so in the Edit/Select Documents screen.

Forum Post: Migrating SL 6.5 to SL 2011

C0ppert0p — Mon, 20 May 2013 21:16:00 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

Forum Post: RE: Help!! New to SDK - Small sample on how to create new screen?

Juan Navarro — Mon, 20 May 2013 16:20:00 GMT

This's the link

skydrive.live.com/redir

Blog Post: If you can't edit notes after an upgrade of Dynamics SL...

Adam Leonard — Mon, 20 May 2013 15:51:00 GMT

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.

Forum Post: RE: Management Reporter System Message 9898 on Client Workstation

Deb Lashua — Mon, 20 May 2013 12:56:00 GMT

It does not matter if we try to run it inside or outside of SL. The client has the same issue and gets the same message.

Forum Post: RE: 9829000 local system registry does not contain needed information

9829000 — Sat, 18 May 2013 15:10:00 GMT

Thanks! It is running off the server but I can try a fresh download. FYI, they are running on windows server 2008 r2.

Forum Post: RE: The grid to excel button is disabled

scasey1106 — Fri, 17 May 2013 23:38:00 GMT

Great! Thanks. Hopefully, our systems office will do that for us. Seems like a really great feature.

Forum Post: RE: FRxConfig.xml File

Angela Schatz — Fri, 17 May 2013 19:44:00 GMT

Where is the user settings stored? in the user profile or in a registry somewhere?