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 ...!!! Outlook 2000 v18.104.22.16811 !!!
I am using Windows XP Pro with sp1 and outlook 2000 for e-
mail. I am going to be updating, when available, to
xpsp2. Questions I have:
Will this new update to xpsp2 interfere with the way my
Outlook now works?
Are there steps I need to take beforehand?
Do I have to make sure I have all necessary updates for
Outlook before install of xpsp2?
How do I know if I have all necessary updates for
outlook? I used Windows Update and have all critical
updates that I need. There are 12 optional updates but I
am going to download only 6.
1. Windows update does not touch Office. You will need t...Dynamic range in chart
I have created a named range called Net_CLI which has the following
formula =INDIRECT("Trends!$C$4:$" &
VLOOKUP(COUNTA(Trends!$B$4:$V$4),'Legend Sheet'!$B$31:$C$50,2,FALSE) &
Presently I expect the vlookup part of the above formula to return H,
so in all I expect the named range to give me ----> Trends!$C$4:$H$4
If I use the above named range in Data Validation, then I get the
relevant values in drop down.
But If I have a chart (in the same worksheet) in which for the first
series in place of existing entry in the values textbox as
=Trends...MSCRM 3.0 database
Does anybody about the MSCRM 3.0 database, does it use the same schema
as 1.x? In other words will there be any data conversion needed when
upgrading? I browsed through the MS whitepaper about upgrading but I
did not see anything about upgrading the DB or data migration. So I
assumed that just the application will be upgraded (as well as email
router etc.) and the 1.x version database will remain the same. But on
the other hand, since for example there will be a possibility in the
3.0 to create custom entities, I'm not sure if they can handle
everything with the old schema.
If anybod...percentages #6
i can not seem to get the sum of $33.00 - 7% (it equals $30.69) ho
do i do that on an excel worksheet?
johnsmith's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2635
View this thread: http://www.excelforum.com/showthread.php?threadid=39620
I dont get it... its probibly the most simple function... but I cant
figure it out. Please Help
johnsmith's Profile: ...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...Business Portal 4.0 install Dynamics GP10
I am having the same problem that states:
The following selected items are not registered or are not installed in the
Key Performance Indicators
Project Time and Expense
I have followed the TK to run the repair on Dexterity, I checked the
SY01500, SY03500, DB_Upgrade, and DU00020 tables and all are fine. I also
checked in GP under Options and verified the modules listed above are all
What else do I need to check?
Thanks for using the newsgroups. Here are a couple things to check.
1. ...DHCP on fresh 2008 install.
I have disabled the router DHCP. If I do ipconfig /all (after restarting
it) on the server amongst the stuff is: DHCP Enabled = no. I have
restarted a PC on the network (server has no PCs connected yet) and it
seems to have a correct address 192.168 3 x. Is the DHCP server really
off and is so how do I start it?
Note I have only just loaded SBS2008 on the server so little config has
been done. Slowly does it!
happyhacker's Profile: http://forums.techarena.in/members/188993.htm
View t...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...Re-Installing Excell 2000 on new computer
I purchased Excell 2000 and installed on Dell 8200
w/windows ME. Hard drive crashed. Aquired new Dell 8300
w/ windows XP. Trying to install but windows will not
except product key. "Can't find previously installed
program on system". Any help would be greatly
You are presumably using an Upgrade version which requires that you ca
prove ownership of a prior version. You can use any setup disk (CD o
floppy disk 1) containing a qualifying Microsoft product and refer th
new setup to that. I think you get the option to browse with the "no
found" message...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...Installing MSCRMv3 SBE in a non-SBS scenario
Is it possible to install Microsoft CRM 3.0 Small Business Edition onto
a setup where Small Business Server Premium does NOT exist, and where
fully licensed products of Windows 2003, MSSQL and Exchange Server are
If this is possible (technically), are there license restrictions on
the CRM Licensing side?
CRM v3.0 SBS Edition is written specifically for SBS Server and will not
install on any other version of Windows Server. It has hooks for things
like faxing, etc...
Don't know about the license restrictions, but I am sure they are in the
fine print someplace.
&...Unable to install 11.3.6 update...
This is really odd. When I try to install the 11.3.6 update for
Office Mac (either from auto update or from download on Microsoft
website), I get the standard error that I don't have the correct
I have verified from the Read Me file as the error message says that I
do have version 11.3.5 installed.
I've verified my specs. Here are my specs:
PowerBook G4 1.25 Mhz
Mac OS 10.4.10
Office 2004 11.3.5
The only thing the Read Me recommends to do is to trash Office and
reinstall from the disk and reapply updates. I REALLY don't want to
have to do that. Any ideas o...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...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, ...Sample Data install
Got CRM up and running okay. Added a few records but then decided to take the
tutorial and so load the sample data. Followed the instructions located @
There were no errors whilst following these instructions. Now the system
appears to have no data present, though the databse appears to still contain
the records I had previously created.
Any idea how I access the sample database?
We did have five users available in AD and did not get the message that the
system was overwriting...Can't install Server 2008 Service pack 2 (x64)
i keep getting error code 800F0826 with no other info.
trying to install on my sbs 2008 premium box.
This is a multi-part message in MIME format.
Are you using the Microsoft tool to make this installation possible?
"BadBoy House" <firstname.lastname@example.org> wrote in mess...Vlookup returns "0"
I am using the following formula
and it is returning a zero if there is no data found in
that cell. If there is no data found I would like it to
How can I do this?
There are a couple ways so do this. One is to test it, which makes for
doing the VLOOKUP function twice.
=if(VLOOKUP($A$1,'Data Sheet'!$A$11:$BH$15,3,FALSE)=0, "" ,
This gets a little messy. Better yet, and simpler is to hide the original
cell (column, whatever), an...Importing OE 6 folders from ME to XP?
My question is in regards to importing Outlook Express folders from a
machine with Windows ME to a machine with Windows XP. The XP machine
already has folders set up with many ancestry mails that cannot be
lost. If I export from the ME to the XP machine will the current XP
folders and mail be deleted from the XP machine or just added to the
current XP OE folders? Sorry if this is confusing but I have been
unable to find any answer on this. I just am not sure if the old OE
folder contents will be added to the new OE folder contents without
deleting the new OE folder mail. Thanks
Ka...Security Update for Windows Server 2003 (KB956744) Cannot Install.
For Windows Server 2003.
This is a standard Windows Update that I try to install but get a message
that it failed to install. I can't find any source to tell me why it won't or
what I can do about it. I am not getting an error code of any sort - it is
just listed under "not installed" when I get my update installation screen at
the end of the installs.
Can anyone help please?
I downloaded the update manually from:
Ran it, and then ran Check U...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...How do I catch orchestration exception using eConnect 8.0
Hello, the exception I am getting in Biztalk Health & Activity Tracking:
Microsoft.GreatPlain.eConnect.eConnectException: Sql procedure error codes
Error Number = 7149 Stored Procedure taRMTransaction Error Description = The
entered(SLPRSNID) does not exist in the Salesperson Master Table.
How do I catch "Microsoft.GreatPlain.eConnect.eConnectException" in my
Thanks in advance for your help.
We do not suggest, nor supp...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...