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 ...upgrade
I have the Money98 Financial Suit Version 6. Can I
upgrade to Money 2004 Deluxe without physically reentering
all the data now in Money 98?
If you stay with the same localization, (i.e., no M98UK->M04US) M04 is
**supposed** to be able to upgrade your data file seamlessly. Some people
have been less fortunate.
"Manfred" <firstname.lastname@example.org> wrote in message
> I have the Money98 Financial Suit Version 6. Can I
> upgrade to Money 2004 Deluxe without physically reentering
> all the data now in Money 9...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...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...Upgrade to 1.3
We are contemplating upgrading to Version 1.3 of MS RMS.
We have been told that we cannot have HQ and Store running on different
versions whilst they are making connections.
So this would mean stopping the connections until HQ and all stores are
Is this correct?
If this is correct, suggestion to MS - make it possible to keep the business
running whilst doing an upgrade - e.g. allow upgraded HQ to support
connections from Stores that are still to be upgraded?
This is not true. I am currently going through the upgrade process. I have
7 stores on 1.3 while HQ is running 1.2. ...upgrade CRM 3.0
I try to upgrade CRM 3.0 to CRM 4.0, but the upgrade fails.
I get this error message in Log file:
System.Exception: Action Microsoft.Crm.Setup.Server.ImportDefaultDataAction
failed. ---> System.ArgumentException: An item with the same key has already
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value,
at Microsoft.Crm.Metadata.LabelCollection..ctor(XmlNodeList nodes, String
collectionName, String labelName)
Microsoft.Crm.Tools.ImportExportPublish.Import...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, "email@example.com"
&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:
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
...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?
...Can't see Public Folders after upgrading to 2003
I was able to view public folders through Outlook on my machine when it was
running Outlook 2000. Then I upgraded to 2003 and now I can't see a public
folders node to the tree hierarchy in the Folder List pane.
Any idea why?
that you are looking at the Mail folder structure. In Outlook 2003, when you
click the Mail icon in the Navigation Pane, you see only Mail based
folders... Public Folders are not included.
One of the smaller icons at the bottom of the Navigation Pane on the left is
labeled Folder List. This displays the entire folder list... an...Upgraded from OL98 to 2003
I just successfully upgraded my OL98 to 2003 and I'm pleased that for
the few things I've looked at so far everything is functioning the
same or better!
But I have found one behavior that is different. I send email in a
plain text format and I used a hard return to start a new new line. I
see in OL2003 that when I start a new line the first word is
capitalized (I guess OL2003 thinks it is a new sentence/paragraph.)
Is there a way to turn off this behavior?
OK, afte poking around I think I found my answer: autocorrect in the
Thanks,...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...