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...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, ...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?
...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, "firstname.lastname@example.org"
&g...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...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,
...I want to know GP Tables Definitions
I need to know the tables for the window general transaction entry in GL
Go Tools>Resource Descriptions>Windows. Select Product/Series/View
By. You'll be able to see all the tables associated with a specific
MCP-GP, MCT, MVP
East Coast Dynamics
In addition you may want to check David Musgrave's article on resources at
M...Deactivate MS GP
We are in the process of migrating our data from MS Great Plains to Dynamics
AX. Once is all converted we still need to keep GP at least read only for
about 7 years
I was wondering if anyone has any idea what steps should I take to
I would setup one user class called 'Inquiry Only', set security
settings for this class so that only Inquiry and Reports can be
accessed, then assign all users to the Inquiry class.
Hope this helps,
MCP-GP, MCT, MVP
East Coast Dynamics
ge...Help for upgrade process from GP 7.5 to GP 10.0
I have recently completed my certification in GP 10.0 Inventory.
I've managed to get some hands-on experience with the product.
There is a requirement from a client for upgrading his system from GP
7.5 to GP 10.0. The client happens to be from the hospitality
Could someone guide me on this?
I would also greatly appreciate if anyone could point to blogs and
articles on the subject.
Mariano Gomez's blog is a good place to start:
Dynam...Generate Controls Dynamically,FormView-Scroll,Default,MFC
I am looking to generate Edit controls Dynamically in a FormView and when
the no of edit controls increases the Size Of the Horizantal ScrollBar
increeases and should be able to scroll and is there any other way of doing
other that "SetScrollSizes" as i want the FormView to handle that scrolling
and not forcibly
Thanks and Regards
suresh at his best wrote:
> I am looking to generate Edit controls Dynamically in a FormView and when
> the no of edit ...GP
Dynamic security console is corrupted or have invalid data.
How to solve this issue
It would help if you let us know how and when you get this error (as in doing
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> Dynamic security console is corrupted or have invalid data.
> How to solve this issue
...Socket relared problem (getting free port number dynamically) #2
i have one problem related to thread. i am having my main thread
running which will
on some event create a thread for validation purpose and then will
and now this validator thread will create a socket and it will bind to
and then will wait for client to connect.
but before waiting for client to connect it will send a message to the
main thread that
validation is done.
but in this way i need to stick with port 20111.which i really don't
Is it possible for me to get a free port from operating system or from
library and then i should bind t...GP 10.0 download
MS announced that GP 10.0 will be available for download in May. Does this
mean a download of the full 10.0 CDs? Or a download of the VPC demo image?
It will be a demo of the VPC image. Full version is expected by end of June.
"Mike Muscarella" wrote:
> MS announced that GP 10.0 will be available for download in May. Does this
> mean a download of the full 10.0 CDs? Or a download of the VPC demo image?
...Dynamic Getpivotdata in Excel XP
I urgently need help with this function.
I'm trying to make this function dynamic, i.e.
depending on some condition, make some members disappear or otherwise.
=getpivotdata("Loads",'Pivot Plan'!$a$3,"SHIPTO",A1,"MILL",B1 &
If cell D1 has value "ALL" then both "Product Line" and its value
("LINE1") are not used, if otherwise they should be used.
I...Dynamic allocation of memory for array of objects
I would like to do something like following:
int n = total(); // total returns the number based on
// which i instantiate the no. of objects
Is it possible? And if yes could you please reply as soon
One way is to Declare a static int variable in your class. Increment it in
the constructor and decrease its value in destructor. If you want ordered
access to the list of these objects, you can use std::vector, which will
give you count and much more.
Ajay Kalra [MVP - VC++]
"Tushar Mishra"...Renaming a GP 9 server
My question is that if I rename a GP 9 server - does great plains and MSDE
200 0 work fine ... in terms of data access etc?
You will need to recreate all of the ODBC connections to the server
(including the one on the server if you are using the server name to connect).
> My question is that if I rename a GP 9 server - does great plains and MSDE
> 200 0 work fine ... in terms of data access etc?
Not quite correct. You'll find that no user besides sa can log in. The
reason is the name of...Problem with Analysis Cubes for GP 10 FP1
I got it installed but when I try to run the SSIS packages I get an error.
Error: Error 0xC0014049 while preparing to load the package. Cannot find
What did I setup wrong or how do I fix?
Microsoft SBF Specialist
Is the folder, in fact, there?
I recently installed it using as much of the default settings as possible
and had no problems.
Charles Allen, MVP
"Japheth Nolt" wrote:
> I got it installed but when I try to run t...restoring GP 10.0 32-bit into GP 10.0 64-bit
We are going to install GP 8.0 on a 32-bit server in-house and restore a
client's 8.0 data into these SQL databases. Pretty cut and dry.
Next, we will upgrade this in-house server from 8.0 to 10.0.
Continuing, we will install GP 10.0 on the client's new 64-bit server.
Finally, we will restore the upgraded 10.0 databases from our in-house
32-bit server to the client's 64-bit server.
Here's the question. Is there anything "wrong", from a technical
standpoint, in restoring SQL databases from a 32-bit environment into a
Does anyone know if its possible to map over say the CRM Account Number
field to become the new Debtor ID in GP when an Account is created?
We are in the process of setting up CRM-GP Integration, and just realised
that this otherwise will make it fairly messy as we use a standard debtor
naming convention (ABC001), and when CRM Integration creates the customers
in GP it just uses the entire name....
...Dynamics GP 11.0
Is GP 11.0 beta available for download? We are a gold certified partner. We
would like to test the GP 11.0 beta, be a beta site or learn more about GP
11.0. Please let us know how to go about this. Thanks, VJ
If you are interested in receiving more information on the GP 11.0 "beta
program" please email your partner information to email@example.com.
"This posting is provided "AS IS" with no warranties, and confers no rights."
> Is GP 11.0 beta available for download? We are a gold certified p...Dynamics CRM 4.0 re-install issue
Due to certain issues, I had to uninstall and reinstall our Dynamics
CRM 4.0 installation.
The install went fine and the deployment Manager allowed me to create
a new organization. But when I try and browse to the site I get the
"Record is Unavailable - the requested record was not found or you do
not have sufficient priveleges to view it".
I've looked at the few logs that have been raised about this topic and
installed the CRM4diagTool.
(can't see really what this does!)
I've also set up tracing. I can see the underyling error "CrmKey With
Id = 00...GP Reports NOT displaying full Account Number
My GP financial trial balances for some reason does not display the full
account number. My account structure is XXXX-YYYY, but reports only show
XXXX-YY, in other words 2nd segment the first two account numbers don't
display on reports.
I'm on GP 10 and had this same problem pre-upgrade. I have tried running
checklinks on Reports. I have tried expanding the display width in Account
Format setup but still no luck. I switched from the modified report to the
default un-modified GP report, but still the full account number is not
Does anyone know how to fix this proble...Hosted GP to In-House GP
I need some help. I am trying to put together a project plan to move from a
hosted environment to a in-house environment and was wondering if anyone has
done this? I know the general dynamics of the move, but I am sure there are
things I have not thought of. Can someone tell me where I can find
documentation or can someone send me documentation that will help me put this
What MGP products do you want moving? (MGP SQL databases, CRM, Business
"John" <John@discussions.microsoft.com> wrote in message