GP Noob Question
Long and short I am on a new job site where they use Great Plains. A user is
currently getting this error message when trying to launch the program "You
do not have permission to open this file." it has an OK button which when
clicked the program closes. This screen is well before the login box. If
the "run as" option is used with another account the program opens properly
to the login box. Being that I have never used this program I have little
clue as where to start looking.
I have been told DBA that the user's account should have proper permission
as n...CRM Integration for GP
I have been trying to install the CRM integration for GP
7.5 but have been stuck with Error 1722 and BizTalk 2000
would not install. I have searched all MBS or MSDN and MS
knowledge base, but they were all dead ends to my issue. I
have tried removing the Namespace as one KB explained, but
my problem is that there's no previous installed BizTalk
to remove. And there is the issue with regards to terminal
server must be in Remote Admin mode. I am positively sure
that it is installed as Remote Admin twice. The
environment is that on a Windows 2000 server DC with CRM
1.2 and GP 7.5 in...Stop GP from posting
I am writing a trigger on the the Post() function of SOP_Entry form. I am
running a script before and after the execution of Post(). I do not want to
go ahead with posting if there is an error in the script that runs before
My code in that script is like this -
if err <> 0 then
Now the problem is, my code goes to the loop and executes reject script
statement. But the GP still goes ahead with its Post()
How do I stop GP posting in this case<
It probably won't work on the Post() event. At least as of 7.x
versions of GP that particular ...Total salaries in a form
I have a query with basic salary accomodation and transportation in
the query it self i have used the sum total to get total salary paid
When i opened it in a form, the total basic and total accomodation
disapeared what can i do in order to get the total to be paid for
salaries in a form
If the query gives you the correct result for each record, make sure you bind
controls on the form to the query fields. However, this is a guess, as there
is little specific information in your question, and the lack of punctuation
makes it hard to read.
It would help if you...GP 10 Trial Version
I'm trying to get the trial version of GP setup in our labs and everytime I
try to load data I'm getting an error ("An Error occurred while loading your
data. The application will close. Refer to your installation documentation
for more information about resolving this issue.")
There's nothing in the text book and nothing in the event viewer to give me
a clue. I've tried on mutliple computers where I have full admin rights so
it's not a permission issue.....
You have not told us anything about your environment. What version of SQL
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
1) Can anyone recommend a good website that will give me depth into
Money 2003 standard edition.
2) I have a reoccuring deposit setup. I put in the gross salary amount
and assign it the income category of salary. (Some of my categories may
be a bit messed up because I did an import from quicken.) I then
subtract Social Security tax, fed, state, ny, NYC, and DBL tax. The
entry will say Split/Multi and when I click on it all the correct
information is there and displays my net income.
Is this the best way to input in a paycheck? I ask because I'm having a
hard time...My Reports in GP 10.0
An end user of GP 10.0 has reported something intertesting to me on "My
Reports" on the home page.
If she switches companies (or when she first logs in at the beginning of the
day) and clicks on "My Reports", she gets an "illegal address" error.
The error is remedied by clicking "Customize this page", clicking the
expansion button next to "My Reports", and checking all of the boxes next to
Then, she does not get the error.
But, it's kind of annoying for her to have to do this all of the time.
Do you know wh...salary payment
i am trying to write a check out of my corperate checking account to myself
my accountant says the software should be able to track the ss and
withholding taxes after entering the gross salary payment and then print a
check for the Net payment as out going money.
i was able to find the "paycheck" feature but it seems to be for checks
coming into the account. Is there a way to set this up so it tracks the
taxes as discribed above as out going salary?
Check #1 amount 500 payee BOSS
expense: salary $800 memo: pay boss
expense: SS tax: 100 memo employer portion...GP Workflow and Outlook 2003
I recently saw a demo of how to use GP's work flow logic to approve a
purchase order. The person received an email about the p.o. then used
Outlook 2007 as the client to approve it.
Can this be done with Outlook 2003? What limitations exist when using
Outlook 2003 with GP 10 in general?
On Nov 26, 11:57 pm, "Jamrock" <news_jamr...@yahoo.com> wrote:
> I recently saw a demo of how to use GP's work flow logic to approve a
> purchase order. The person received an email about the p.o. then used
> Outlook 2007 as the client to approve it.
> Can this be...GP 6.0 Reports
I have a couple of modified reports in GP6.0 from a product
ServiceAdvantage. I understand that the ServiceAdvantage product is now a
part of Great Plains however a couple of their GP6.0 modified reports I'd
like to export and use in a newer version of Great Plains. The problem is
that when I attempt to export, it gives me a Memory Error an a 0 length
Is there a way around this or am I doomed to recreate the reports?
Thanks for any advice.
...Become MCSE Certified and get $43,000+ Salary per year
...Integrating with Microsoft GP
We developed a product called Sales Incentive Calculation system for which
the data comes from various other third party applications. We have included
the feature of importing and exporting into our Product from third party
some of our clients who are also using Microsoft Great Plains for their
busineess and now we have to include feature to import and export date from
Microsoft Great Plains Database.
Im in the process of exploring Microsoft Great Plains. It is a great help
for me if any
body helps me in clariflying the below things
1.What are the things required for m...What Excel formula converts hourly wage to annual salary
I need help creating a simple formula that converts an hourly wage to an
Think there's no such single function. You need to DIY. How would you
calculate it by hand? Explain it fully, step by step. This increases your
chances of getting help with the formula.
"Entre Nous" wrote:
> I need help creating a simple formula that converts an hourly wage to an
> annual salary.
"Entre Nous" <Entre Nous@discussions.microsoft.com> wrote in message
>...1 x 20' GP to Kota Kinabalu, Sabah
Dear Puan Kamariah,
Append below our all in charges to shipped your 1 x 20' GP contr.
1.Ocean frt 1 x 20' GP RM 2,200.00
3.B/L & EDI fees RM 140.00
4.Haulage RM 530.10
5.F'wdg, Doxcs & Custom's RM 325.50
6.Stuffing & Lashing RM 400.00
Total ...calculate diffence between old salary and new salary
I have to figure out the impact if a daily salary increases. How do you
calculate the difference ex: $100/day to $200/day, what is the impact on
USD 100 per day times the number of working days in the year.
If my comments have helped please hit Yes.
"Felicia Pickett" wrote:
> I have to figure out the impact if a daily salary increases. How do you
> calculate the difference ex: $100/day to $200/day, what is the impact on
> annual increase?
If A1 has the old daily salary and A2 has the new daily salary, the daily
differe...Vehicle Management for GP
does anyone know a good vehicle management solutions that can integrate with
Depending on the level of sophistication you are looking for. Trinity
Computers in UK (writers of the original Advanced Distribution module) has a
decent Vehicle Load Planning module written in Dexterity and highly
integrated into SOP.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
> does anyone know a good vehicle manage...Letter of Credit in GP
GP need Letter of Credit in Payable Managment
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
...Creating New GP Company
I am in the process of creating a new GP Data Company – normally I just go to
utilities and select “Create A Company” and I am good to go. This time
however when I create the new company not all of the Manufacturing
tables/stored procedures are created. I know that I have successfully created
new companies prior to me installing SP5.
When I log into the new company I get the following error:
SQLServer souldnot find the stored procedure
invalid object name ‘ICJC6000’
When I actually try to go into a MOP module I get a message stating that M...Upgrading to GP 10 from GP 8 SP5
We have a client who is currently hacvng GP 8 SP3 and willing to
upgrade to GP 10 SP4.
But before perform these tasks we have created the new test/live
environment with the following infra setup:
Windows Server 2008 with 32 and 64 Bit
SQL Server 2008 with 32 and 64 bit
Their current environment is
GP 8 with SP3
SQL Server 2000 with SP4
Windows Server 2003 32 Bit
We prepare the test environement and copied all the databases and
working copy of GP folder from current live to test environment
After I simulate the test enviroment on Windows Server 2008 32 bit and
SQL Se...documentation GP
Where I can find documentation and courses(years) on the managing of the
All the manuals are on the Great Plains CDs in PDF format. Not sure what
you mean by 'courses(years)'?
"Erick Sanchez" <email@example.com> wrote in message
> Where I can find documentation and courses(years) on the managing of the
> great plains
We publish independent documentation on GP. There are 3 titles available
now with more in development. Check out our web...GP 9.0 Company login error
I have installed GP 9.0 and everything work well previously, but suddenly it
not able to login when i try select login's company. The error message is "A
get/change first operation on table 'SY_ResourceActivity'".
In more info message as below:
"[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark after
the character string 'þþþþþþþ...SQL Server Express and GP 10
My client wants to user Sql Server Express with GP 10. They just
bought another user of GP 10- 2 users now. When I set up the ODBC I
get a SQL error 08001, first invalid protocal and then server does not
allow remote connections. I noticed that SQL service set to Local and
not network service. I tried to change but it wouldn't let me. I
checked the protocals and all seem to be using TCP/IP
Can someone please confirm that I can use SQL Server express in a
moulti-user envirnoment? If so, why would someone buy SQL?
Yes, you can definitely use GP with SQL Server Express in a...Contract salary sheets.
Hi there, does any one have any exmaples on websites of short contrac
salary sheets. or even holiday planners, and what can be condtiona
formatted in it? Regards
Message posted from http://www.ExcelForum.com
I need to make a Salary Reciept for my office use, i have staff here and i
have to pay them. i need a strong Salary Reciept, so i can pay staff salary
and the receipt should have all the information about the employee.
"hikmat" <firstname.lastname@example.org> wrote in message
> I need to make a Salary Reciept for my office use, i have staff here and i
> have to pay them. i need a strong Salary Reciept, so i can pay staff
> and the receipt should have all the information about the e...