Help rank features for future Dynamics GP releases
Each year, we ask customers to give us valuable insight into the enhancement
of our products. When you give us your feedback and opinions, you help us
refine our software to make it even more customer friendly. Please take a few
moments to visit the URL below and complete the Product Advisory Board Survey
now. This forum is an important way for us to get your opinion on our
products, but this special opportunity is available for a limited time.
This posting is provided "AS IS" with no warranties, and confers no rights.
We w...What we mean by Assignment Field ?
Refer this URL.
What we mean by "assignment field" ?
When you apply the Task Usage view, you see the complete list of tasks, plus
the the resource assignments for each task. The resource assignments are
the names of the resources assigned to each task. In the default Task Usage
view, you see the Work column to the right of the Task Name column. This
column shows you the total amount of Work for the task, plus the Work for
each resource assignment. When you look at the ...how to add a combo box in to a excel cell using VBA dynamically?
I am trying to use a excel grid control and I need to a add a combo box in
to a cell dynamically, in an Add-In. Please provide me a VBA sample code
which I can use for this.
I am attempting to use the sample code from the CRM 3.0 SDK to dynamically
set a drop down list.
I am getting and error on this line in the code:
oTempArray[iIndex] = oSubIndustry.originalPicklistOptions[i];
Can anyone tell me if 'originalPicklistOptions is this really valid for a
...Why wouldn't a control event handler be called?
Hello to all,
I am using Visual Studio .Net and I want to create a dialog-based
appllication using C++. I have a Combo Box at the top of the dialog
with 3 items in its drop down list. Each time the user selects an item a
different layout of dialog controls will show. It is a sort of Tab Control
but instead of having three tabs, in my case, I have the Combo Box to change
between different layouts.
I did this by creating 3 modeless dialogs in my form view. The problem is
that I can't receive the control's event. For example, I have a check box
called IDC_BTN_ENABLE. I added its ev...Private assignment RV
Hello with all,
I would wish to pass a large quantity of RV into private. There would be
an automatic solution.
Thank you in advance.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Kirk" <firstname.lastname@example.org> wrote in message
> Hello with all,
> I would wish to pass a large quantity of RV into private. There would be
> an automatic solution.
> Thank you in advance.
>...Microsoft Dynamics CRM 4.0
I've a few issues with CRM 4.0 and I was wondering if you could help
I created a sample data so you can better understand my needs.
"Account Name", "Contact Full Name, Role, Primary Contact, Email
"Company 1", "John Smith ", "President", "No", "email@example.com
"Company 1", "Michael Smith", "Director ", "Yes", "firstname.lastname@example.org
"Company 2", "Wayne Smith", "President", "Yes", "email@example.com
"Company 2", "John Smith &...event handlers
I've added the following two lines to the message map of an mfc activex
control which consists of a dynamically created richedit control.
ON_NOTIFY(EN_LINK, IDR_RICHEDIT, &CSodeXRichTextCtrl::OnEnLinkRichedit)
They work fine for the EN_LINK en CHANGE event. However I would also like to
react to a user clicking inside the Richedit Control. I guess I have to react
to the WM_COMMAND message. But I can't figure out how. Could someone help
Nevermind found it, EN_MSGFILTER, one day i'll know them all o...assign permanent colors to bars/values in a pivot chart
I have a column in my source data called "TIER" so the values are 1, 2, 3
etc. when I convert to a pivot chart I want those values/bars to be
automatically & permanently assigned a specific color. Eg. Tier 1 = Green,
Tier 2 = Yellow etc.
Can you help?
The colours in a chart are taken from default settings for the data series in
the defined order. You can change these default settings in
Tools/Options/Color(tab). You see the 56 standard colours and under the thin
line the colours for Chart fills and Chart lines. The first series is the
left colour, etc up to 8 colou...In a 2 Y-Axis chart, how do I assign data ranges to an axis?
I have created a 2 Y-Axis chart with 12 data ranges. Numerically, the first
8 data ranges belong on the 1st Y Axis, and the last 4 data ranges belong on
the 2nd Y Axis, but MS is choosing to put the first six on the left Y Axis
and the last six on the right Y Axis.
I need for the chart to display 8 on the left Y Axis and 4 on the right.
I find it best to ignore the "built-in custom" types because they do what they want.
The following process works on either the normal or built-in custom types.
Double click a series, and on the Axis tab, select prim...Dynamic Charting #2
If i have a data such as:
and i want to display a chart for each branch seperatly. I know i can
display in a column chart the volume sold in all 3 branches with the
month diplayed, but i'm trying to create a scollable menu(for example)
where i can select the branch and dis...Sports team assignment
I am trying to determine how to do the following: I need to assign
players to teams in a flag football league. The number of teams will
depend on the number of players. The skill level of players must be
taken into account to insure that teams are all equally talented as
best we can. In order to measure skill level, players will be
assigned a number from 1-4 with 4 being a very skilled athlete and 1
being a beginning player. Each team should have the same number of
players. Can someone help me to do this with excel? Thanks in
...Help needed to show dynamic images on report
I have to show some images as logo in my ssrs 2008 report. Logo images
are stored in a shared folder with .jpj extension on server. Logo file
path and name is comming from the custom assembly used in my report.
Everything works fine if all the logo files present on the shared
But when the specified file is not present in the shared folder then I
my report is showing on red X icon in place of Image. I want to hide
this red X icon if the files were not present.
I have found one discussion with the same issue at
http://thecrmgrid.wordpress.com/2009/03/24/ssrs...Frx for Dynamics Btrieve/Pervasive will need a registration number
I am currently covering for the normal manager of information systems. They
currently have great plains 7.00g12 and Frx6.5. Everything was working for
years, until today. Today, when trying to use Frx, all users are getting the
Frx for Dynamics Btrieve/Pervasive will need a serial number in 27 days.
The thing is after this screen they can't use the program at all anymore,
yet on my machine I do get the error, but at least can use it. I do have an
administrative account though, while they don't.
So, I went looking through all of the managers files found...Dynamic Charting But for a Stacked Colum Chart
Hi Excel charting Gurus,
I have been trying for 3 days to adapt the dynamic Charting examples
from Jon Peltier's and TechTrax (http://pubs.logicalexpressions.com/
But I Need to chart with a Stacked Column where the dates are stacked
along the X axis
Here is a link to what I am trying to do (www.jonson.ca/2Axis Not
So that I do not have to make 12 charts, I want to allow the user to
pick a start and end dates (Via Sliders, That I get no problem!) and
have the chart update based on the selection. Basically I want the
functionality that is in t...Assigning values as codes
I would like to ask for help please. How do you assign values and make
them as codes in excel? For example, I made a list of validation in
excel (a drop-down list). Say that the list includes the gender of a
person = male, female. How do I assign a number to the gender like 1 if
male and 2 if female? Any help would be appreciated. Thanks
If you are happy to use another column: =IF(A2="male",1,2) This aaumes that
the validation ensures the enty is either male or female
But why do this? If you have entered textual values why convert to numbers.
You can summ the occurences of "mal...Assign leads by percentage
I am working on a query to assign leads by percentage available. So for
example if we have:
25 Source A
10 Source B
15 Source C
And I want to assign 10 leads by a user, it would take 5 from Source A, 2
from Source B and 3 from Source C. We have many lead sources and I want to
take up the least amount of resources when doing this. Should I use several
counts, a SQL query??
Message posted via AccessMonster.com
SELECT -int(- [Total Wanted] * Lead / (SELECT SUM(Lead) FROM tableName) ),
where ...Assignment Usage cube
I am trying to extract earned value data from Project Server 2007's
underlying databases. I believe the data can be found in the
Assignment Usage cube. In 2003, the cubes were visable in the
database. However, in 2007, I am unable to locate cube data. Any
The only officially supported data you can mine from the databases is the
Reporting db which also holds interim data for cube building. The schema for
the reporting db is in the SDK. Note that there are some very useful Views
included that automatically hold all custom fields.
Microsoft MV...Entities dynamic picklist
Is it possible to use two dynamic picklists as a subtitue to filtered lookup?
The values should be loaded dynamically from two ENTITIES.
I also read the MS code for states/Cities
But the attributes for the picklists should be records in other CRM tables.
The Master/Details is not required to enable the user to add or modify the
results, which is done by another user on other occasions, only to filter.
I read also the ServerSide code sample for (single) CrmPickListControl in the
"Programming CRM...Import Assignments Using Excel
I've exported the assignments from an existing schedule to Excel, this gives
me the proper structure; I've updated the hours leaving everything else
unchanged, and tried unsuccessfully to import the data back into MS Project
using WBS as the Merge Key. It doesn't work. What am I doing wrong? Thank
The Excel export/import looks like this:
WBS Resource Work
1.2.1 Lead Engrg 10
1.2.2 Sr Engrg 20
1.2.3 Engrg B 30
I suggest ex...Add Mfg tables to a Dynamics report in Report Writer
Can anyone tell me how to add tables and fields from a 3rd party dictionary
(like Manufacturing) to the regular Dynamics reports?
It's not difficult to do this as I've done it before but not specifically in
Manufacturing. You can read examples in the CustomerSource/Knowledge Base
for Report Writer i.e. "How to add Customer PO Number to the Purchase Order
Blank Form", for instance, and try to link the steps how it's done for your
> Can anyone tell me how to add tables and fields from a 3rd party dicti...Assigning print date / batch number to reports & invoices
I want to assign a print date to things that are only supposed to be printed
once such as invoices, statements, etc.
I have a invoice table. On the invoice table, I have PrintDate, which is
the date the individual invoice was printed. The query select all invoices
with no print date and prints them.
I will be changing the PrintDate to the BatchNo field. I'll have a
ReportBatch table (keyed by BatchNo) where I will record the date, time,
report name, and other information about the different reports that are
printed. And my query will be change to select all ...Random assignments
I am attempting to set up a staff rotation. Lets say I have anywhere
from 3 - 8 stations. I would like to randomly assign a name to a
station on a daily basis to assure faireness. Example:
Bill = 1
Jane = 2
Sue = 3
John = 4
Jane = 1
Sue = 2
John = 3
Any advise is most appreciated
...How do I Assign Macro to a button?
I have a problem in trying to assign a macro to a button in Excel 2002. When
I create the button, and then click on the button, the "Assign Macro" command
is grayed out (unavailable). I cannot figure out what's wrong.
When you click on the button, click on its border. Around the button,
you'll see a thick dotted border.
(If you click inside the button, you'll see a thick border with diagonal
lines, and you won't be able to assign a macro.)
Right-click on the button border, and choose Assign Macro.
> I have a problem in trying to assign a ...Bulk Close Campaign Responses as Complete in Microsoft Dynamics CR
I need to close several thousand campaign responses and used the bulk import
wizard to create the campaign responses but cannot close the responses in
bulk . becuasel the bulk close does not give the option of closing as
'Complete" - this is only available from 'Converst' and then only one-by-one.
Any ideas how I can bulk close these responses at Complete?