Lookup field for Current User
current logged on user, then pull a couple fields from that users entity to
populate part of a http string used for an IFrame. I already have the
dynamic depending on who is logging in.
Thanks in advance for the help.
Where is your code running? As part of the CRM web (below the /isv folder)?
If yes and if it is an ASP.NET application, you can use the SDK assemblies
to impersonate and get to all information you ...Going Live with GP
I plan to start using GP Sept 1. We have not transferred any historical
transaction from the old accounting system.
All of our Vendors, Customers, Inv Items etc. are entered and we have tested
all functions of AP AR GL.
Does anyone have a checklist of things to do when starting with a new GP
I understand the basics things such as
Enter open invoices in AP and AR
Enter open POs
Enter begining GL account balances fromt the old accounting system
Begining bank balances and so on.
I just want to make sure that I'm not overlooking something so a check list
from someone ...2010 charts will not move or resize
tried out the office 2010 and in excel:
cannot move charts that are created on the worksheet
cannot resize charts that are created on the worksheet using handles
is this a bug or a feature?
sorry if this is the wrong newsgroup, i have not found one specifically
for excel 2010 or office 2010.
regards to the group,
Where, how did you get a copy of Office 2010 ?
Portland, Oregon USA
wrote in message
tried out the office 2010 and in excel:
cannot move charts that are created on the worksheet
cannot resize charts that...Activiate a report for invoices?
I duplicated the "SOP Long History Invoice" form, and made a number of
modications to the duplicated version.. Now I wish to use this form... How do
I go about telling Great Plains to use my version and not the standard
Using Great Plains 7.5.
You must give yourself (and other users) permission to use the modified
Click on Setup > System > Advanced Security
"brother52" <firstname.lastname@example.org> wrote in message
> Good day,
> I duplicated the &q...Migrating data from GP to GP
I have a GP7.5 installation when all data is, and a new GP8 installation on
a different server.
I need to migrate inventory data from the GP7.5 to GP8.
I know that i should use the integration manager. But using it means that i
should know the data source structure which is GP, and this is very complex
because i need to migrate all inventory module, not a few data.
PS: i don't what to make an upgrade because other modules are different in
the 2 installations.
Does anyone have any idea on this issue?
Have tried just using DTS within SQL Server choosing your 7.5 s...GP concurrent user and SQL 2005 CAL
assuming a 10 con-current licenses being installed on 15 workstation, with 15
users in GP.
How many SQL 2005 CAL is needed ?
Server plus user client access license (CAL) licensing requires a separate
Server license for each server on which the software is installed, plus a
user CAL for each user accessing the server.
The user CAL model will likely be more cost effective than device CALs if
there are multiple devices per user (for example, a user has a laptop and
handheld computer accessing SQL Server).
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business...adding yes/no field
How do I add a check box field to my query field name to be "Active"
I Tried Active:=yes/no,checkbox DIDN't WORK can you fix for me or is it
not able to do this THANKS MARSMAN
You would add the check box (binary) field to the table the query is based on
then it will show in the field list of your query. Name it "active" in the
State of Arkansas
> How do I add a check box field to my query field name to be "Active"
> I Tried Active:=yes/no,checkbox DIDN't WORK ...What is the Cost Center field?
In PWA 2007 SP2 and in Project Pro 2007, in resources views we can insert
the Cost Center field. There is no Help about this field. How does it work?
Thanks for your help
Cost Center is a free entry alphanumeric field that is one of the default
fields in the Microsoft Project 2007 desktop application. Oddly enough, as
you already know, this is one of the fields that has absolutely NO Help
information about it. If your organization tracks Cost Center information
about each resource in your Enterprise Resource Pool, I suppose you could
use this default ...Questions about GP Client upgrade configuration
I'm getting ready to install a Service pack for GP7.5 and my ultimate goal
is to get ready to upgrade to GP8.0. However right now upgrades are very
tedious and below is the whole story.
All the users/clients are identical!
Let me describe what we have done in the past to upgrade and what I want in
In the past we sat down at each client machine performed the install. Then
we logged in as an administrator (Ethoseries required this I think) so the
product can finish loading what it needs. Again we do both steps on every
In the future what I would like to do is in...Fabrication and GP
I need to know how to process a transaction in GP. We are a sales -
distribution center. We do some light fabrication. We need to find a way in
GP to take one part or more parts, do fabrication work with them, then put
them back into the system as a new part. For example, we take drum rollers
and send them to a local fabricator who drills holes in them, inserts
"brushes", then sends them back to us as a brush roller. They charge us for
labor and the additional material and we have a new part.
Currently, we either treat it as a parts sale / purchase. That part is
clean, but a...Upgrading from GP 9 to GP 10
While trying to upgrade from GP 9 to GP 10, I get an error when selecting
the instance of the already installed GP 9: "Index was outside the bounds of
the array". Any ideas?
...GP 9 Upgrade and SQL Server 2000 sp4
per microsoft's documentation sql server sp4 must be installed before
upgrading to GP 9. does anyone know if the sql server sp 4 install is
necessary for the GP 9 upgrade? microsoft's documentation indicated that all
service packs for GP 8 must be installed before upgrading to GP 9, but after
speaking with support, they said the GP 8 service packs aren't necessary.
bottom line: i'd like to avoid the sql sp4 install if necessary as i had to
rebuild my test server after installing sp4 last week.
Since the database requirements for GP 9.0 list SQL 2000 SP 4 a...How do I add up prices on an Invoice?
I am trying to add up all my prices for an invoice without having to figure
them out by hand. Is there some sort of sum command on microsoft publisher? I
also would like to have it calculate the GST automatically. If you could help
me out that would be great.
Not in Publisher... Windows comes with a calculator. Have you installed it? You
can do adding in Word, Excel and Access; copy and paste into Publisher.
Mary Sauer MSFT MVP
"Johnny S" <Johnny S@discussions.microsoft.com> wrote...Payroll GP 10.0
Got this from a client and not sure what they are doing, but never heard of
this any help would be great.
As I am reviewing the Payroll Deduction Journal from the payroll I just ran
yesterday, I have identified 5 employees whose deductions & benefits did not
calculate. I happen to be one of the 5. There is $$$$$ that did not come
off my pay as deductions; including my 401K. The common denominator seems to
be when employee changes are made, deductions & benefits are made inactive;
even though those benefits & deductions have no part in the changes being
made. Pardon me, ...Moving Pivot Chart Fields on a chart sheet
Does anyone know how I would move a field after my pivot chart is created?
The value button is right in the way of my pie chart and the program is not
allowing me to move it out of the way of the % w/leader lines.
You can hide the field buttons:
On the pivot toolbar, choose PivotChart>Hide Pivot Chart Field buttons
> Does anyone know how I would move a field after my pivot chart is created?
> The value button is right in the way of my pie chart and the program is not
> allowing me to move it out of the way of the % w/leader lines.
&...MS CRM integration to GP
Can any one update me wheather the mutiple company
databases can be integrated to MSCRM.
The senario is this.
a company has mutiple entities using GP 7.5 and unique sql
databases,require to integrate mscrm with gp.
The integration that is supplied by MS only allows you to integrate
with 1 company DB. You could probably use some of the components that
are provided, but you will need to develop some of the integration
logic yourself to address this.
On Sat, 24 Jan 2004 05:34:31 -0800, "email@example.com"
&g...Publisher 2010 Web Tools
Generating simple web sites was a great feature in Publisher. Why did they
remove it? I can't even find any installed templates for a Web page now.
I heard a rumor that you weren't going to be able to create websites with
Publisher. HOWEVER I have only just installed it and haven't had the time to
check that out.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Joy Starks" <JoyStarks@discussions.microsoft.com> wrote in message
news:861D11D9-D0FD-4F40-B574-9A8C59F144...SOP Blank Invoice form
I'm hoping someone out there can help w/ this. I'm having problems
aligning this report to the left. It seems easy enough as dragging
every field to the left, but I'm hoping there's an easier way...also, I
don't want to comprimise the layout.
If it's a graphical report, you should be able to drag a circle around all
the fields in a section or use <Ctrl-Click> to select a bunch of fields and
move them together.
Charles Allen, MVP
> I'm hoping someone out there can help w/ this. I'm ...error in GP
When I try to generate a Historical Aged Trial Balance my computer freezes
then gives me this error message. "The stored procedure
pmHistoricalAgedTrialBalance returned the following results DBMS:208, GP:0
This is path I use to get to the report: Reports/Purchasing/Trial
Balance/Historical Aged Trial Balance.
We have been having problems with other reports because of the change from
2005 to 2006.
I appreciate the assistance.
This is Lisa. Thank you for your inquiry on the Historica...GP General Ledger Distribution Reference Field Length
Is there a way of expanding the field length of the Distribution Reference
field beyond 30 characters?
No, I'm afraid it is not possible.
"Pam" <Pam@discussions.microsoft.com> wrote in message
: Is there a way of expanding the field length of the Distribution Reference
: field beyond 30 characters?
Just curious, why do you need a longer field length - for drill down purposes
or for report printing purposes?
> Is there a way of expanding the field length of the Distribution Refer...Business Portal (BP) and Great Plains (GP)
We do not have all the fields in the Ledger Transaction Summary History Table
(BP) available as we do in the Account Transaction table in GP i.e. can't
find TRX Date in BP but have it GP. Is there any control when installing the
BP software with respect to what fields for a table will be displayed and can
be used in constructing queries in BP? How do we get access to additional
fields in BP?
Thanks for using the newsgroups. The Ledger Transaction Summary History
entity maps to the Account Summary History table. The Account Transaction
History table is not exposed th...What is the purpose of the Link Master and Child Fields?
I have a form which contains tabbed subForms, each subForm pulling data from
their respective tables. However, none of these forms talk to each other and
I don't really know the purpose of the Link Master Fields and Link Child
Fields sections. But i'm pretty sure this has something to do with it.
Can anyone shed any light or post me a link to where this is explained?
"SparkyMark" <SparkyMark@discussions.microsoft.com> wrote in message
>I have a form which contains tabbed subForms, each subForm pulling d...Custom fields in Email Templates
I have created a custom field on the case form, which I have also included in
an email template that is triggered by a manual rule. When I save my Case
with the custom field filled in and then run the manual rule, the email that
is delivered does not include the value from my custom field.
Should this work?
This should work. Please provide more info. What type of field is it? Did you
add the field to the template manually or using the template editor's
Insert/Update Dynamic Data button?
Another Matt W,
"MattW" ...int field type
In the CRM, the only integer number field is int. I wanted to know what is
the maximum length (highest number) this field can be. I use MS Access and
there Microsoft has an integer field and a long integer field (the long
integer field is used for keys (autonumbers). I don't remember what the field
types are in SQL Server.
CRM use the standard SQL integer to store number values. This is a 32-bit
value which can store values from -2147483647 to 2147483647
Patrick Verbeeten (MCPD)
Tools for CRM Developers and Administrators
http://...Feedback on GP Time and Attendance
I am looking for some feedback on GP 9 / BP 3 version of Time and
Attendance. We are using non Payroll, Canadian version, of GP Time and
Attendance and we are experiencing many limitations.
What is your experience with this product?
Any other similar product you'd recommend?
Thanks in advance,