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 ...Assign Activity to Queue in Workflow
In the regular user interface we can assign an activity to a user or queue,
however in a workflow we can only assign an activity to a user. Why is that?
Is there any workaround other than an assembly?
You can assign an activity in CRM 3.0 to a queue via workflow. If the primary
entity of the workflow is an activity, add an "Assign entity" step to the
workflow. In the Assign Entity dialog, you will see a three radio button and
the bottom one for Queue should be enabled. Click that and then click the
"Assign to" button
"Dynamics" wro...Lookup cell above next value >0
I have a table with two rows, 33 columns long. Top row has Years (2004
to 2036) in it and the row below is intended for the inputing of values
in percentage form. Some of the cells in bottom row may be left blank
or with 0 value.
Elsewhere on my spreadsheet I want to create formulas that will return
the top row value (year) for each year where the value in bottom row is
greater than 0.
For example, if
A1 = 2004 A2 = 2005 A3 = 2006 A4 = 2007
B1 = 0 % B2 = 5 % B3 = blank B4 = 20%
What formula in cell C1 will return value "2005" and in cell C2 the
next year ...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...OAB issue #2
Can you help me in fixing the 2 errors related to Offline address book.
OALGen will skip user entry 'user1,test' in address list '\Global Address
List' because the legacyExchangeDN 'ADCSuppressReplication' is invalid.
- ABC Offline Address List
Entry 'user2,test' has invalid or expired e-mail certificates. These
certificates will not be included in the offline address list for '\Global
- ABC Offline Address List
Expired certs are fine and you dont need to worry about them. For the users
that are being...Detailed Sales Reort time issue
When you run the HQ detailed sales report, it does it by 12:00am to 11:59pm
(24hrs)by default. I have a customer needs to run this report from the time
of 8:00am to 7:59am. How do I get the report to change for that particular
time instead of using the default 12:00am to 11:59pm?
Thanks for your support
This will get you started. There is a Detailed Sales Report by Hour on
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file atta...CRM 3.0 Currency symbol
No matter what i do i cant get the currency symbol to stay changed from $ to £
As soon as i exit the organisation settings form it changes back.
I have full admin rights on the network/crm/world etc
I am facing same problem.
Do let me know if the case gets resolved.
Thanks in advance.
"Brian McFarland" wrote:
> No matter what i do i cant get the currency symbol to stay changed from $ to £
> As soon as i exit the organisation settings form it changes back.
> Please help
> I have full admin rights on the netwo...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...MRMS 2.0
I am using MRMS 2.0 and my log files size is multiplying very fast.
Tried doing the database shrinking and making the recovery mode to simple.
Still the log files size is mulitplying.
Is there any fix for this from microsoft.
Thanks in Advance
1) With both the original .MDF and .LDF files located where they supposed to
be, run RMS Admin and select the database you want to shrink.
2) Issue this query to find the log device name: SELECT FILE_NAME(2). This
will return the name of your log device (in our case, we called the database
SS1 and the log device name is Store1...Re: Problems sending e-mail from CRM 4.0
sorry, replied to the wrong post.
"Dave Ireland" <firstname.lastname@example.org> wrote in message news:...
> There's one for 500 concurrent here:
> Dave Ireland
> "Esteban GN" <email@example.com> wrote in message
>> Hi, group, I have problems to send e-mail from CRM 4.0
>> I have the e-mail router and the test is OK.
>> I see the folowing error in ...Pivot Table Count Issue
I'm using Excel 2003. I'm a high school guidance secretary. The
administrators are constantly asking for data relating to course failures.
From our school's student management program, I've exported a listing of all
course grades for the year and used the data to create a pivot table.
Right now, I'm only using row fields: StuName, GradeLVL, TermID, StoreCode,
I've filtered the data to only show records with a TermID of '1901' &
'1900'. (Semester 1 Final or Year Long). I've also filtered the StoreCode to
only...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...Data Validation Issue
Excel 2003 under Windows XP SP2
I have two cells A20 and B20 both contain date info provided by a popup
It is necessary for the date in B20 to be greater than that in A20,
otherwise calculations performed on the two cells provide negative numbers.
Any help would be GREATLY APPRECIATED! :)
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "B20" '<== change to suit
On Error GoTo ws_exit
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A20")) Is Nothin...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, ...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...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...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...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...Outlook 2003 Smart Tag Integration with MSN Messenger 7.0 vs Windows Messenger
Is there a way to use MSN Messenger 7.0 with the Outlook 2003 Smart Tag
integration instead of useing Windows Messenger?
Seems really silly that Outlook 2003 would use Windows Messenger a
older product with less features then use MSN Messenger which is a
newer product with more features.
I've search all over the net for this answer and all I find is others
asking the same questions but never and answer.
...Money login issues
Any news on the broken Microsoft Money login and passport issues?
...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...