calculate land area
will excell calculate square footage of an odd shaped lot. (not a square)
Yes. The simplest way to to divide the area into rectangle and triangles.
> will excell calculate square footage of an odd shaped lot. (not a square)
...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 ...Receive new email notification for Inbox only
I have a number of rules operating in my Mailbox (Outlook
98), but I only want to receive the yellow envelope in the
system tray when a new email arrives in my Inbox, not for
the ones that are redirected to other folders.
Anyone know how to do this?
JGP <firstname.lastname@example.org> wrote:
> I have a number of rules operating in my Mailbox (Outlook
> 98), but I only want to receive the yellow envelope in the
> system tray when a new email arrives in my Inbox, not for
> the ones that are redirected to other folders.
Since the messages come into your Inbox first,...new to windows mail
i am purely trying to use this program to respond to ads in craigslist. I am
new to this program and have no idea how to set it up. When i click on the
address of the ad i would like to respond to an error message pops up saying
"the host 'yahoo' could not be found. Please verify that you have entered the
server name correctly." Well how do I change the server name. Honestly, I
just want to get this thing working so please help this not so computer savvy
You may be asking the wrong question.
Do you really want to get Windows Mail working, or do you just...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...Force default view for new users
Exchange 2003 SP1, Outlook XP. Each time we create a new user we would
like that by default all the folders get displayed when he logs in (at
least at the first logon).
Any idea ?
Is it a registry key ? Or a group policy ?
Thanks for your help !
It is possible to force Outlook to open with a particular navigation =
pane displayed, by adding this registry entry and setting the =
Value name: BootModule
Value type: REG_DWORD
Value: 0 to show the Mail folder...Worksheet().Range.Calculate Problem
I am having a major problem with these two lines of code in my otherwise
great reporting tool:
These 2 lines freezes up my computer to the point that I can't use any other
application on my computer. It takes forever (over an hour, the last time I
let it run complete) to calculate one sheet in the workbook. I need to find
out if there is another way to get this done faster.
Any help will be appreaciated.
There's no need to select the worksheet in o...How do you calculate effective interest
Here in Canada we calculate interest on mortgages semi-annually. How can
I do that in an excel workbook?
I am guessing you want the monthly interest rate so that you can create a
A1=5% annual interest
B1 monthly interest
So if you have a 10 years, you now have 120 months. You can use your
financial formulas with your monthly rate.
Does that answer your question? If not, please provide more detail.
"Connie Walsh" <walshclan@_no_spam_primus.ca> wrote in message
news:2p49lf...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...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...Cannot apply new security patch
Our Exchange admin is no longer with our company and I need to install the
new security patch but am getting a message saying that I don't have
permissions to apply the Exchange patch. I have the Exchange Full Admin
rights at the root level and am a domain admin. Server is Exchange 2003 SP2
running on Windows 2003 SP1 in a 2 node failover cluster.
When I go to apply the patch (either through Microsoft Update or via
download) I get a message saying "You do not have permission to update
Security Update for Exchange Server (KB916803)"
What else do I need to apply this patc...Automatic Calculation #3
In Excel 97, does anybody know why the setting for
Calculation - Automatic or Manual changes on its own?? A
colleague of mine has Excel 97 and every so often, he has
to keep changing the setting back to Automatic because it
reverts to Manual of its own accord.
Can anybody help with this and advise me how to prevent
excel takes its initial calculation setting from the first workbook opened,
so if you open a manual workbook and then open an automatic one, excel will
still be in manual.
Fa...Recreate a new PST file
A friend of mine seems to have a corrupted Outlook setup.
His 500Mb or so PST file appears twice on the left-hand pane, and when he
tries to view properties on either of them he gets an error. I've verified
for sure that only one PST file physically exists on the PC. This also
causes problems with his address book, and he gets an error when he tries to
access it. Although he can cancel this and then it works.
I've tried moving the PST file, but when Outlook starts it cannot find it
(of course) and exits. It doesn't give the option to create a new PST file.
I was ...Automaticaly reading in NEW emails
I have searched high and low and I can not seem to find anything to do this.
Is it possible to have CRM read in new emails automatically using a
contract number as a pre-defined requirement.
For example. John has a contract number 0123654 and wishes to send an email.
I want CRM to pick out the standard field CONTRACT NUMBER: 0123654 and assign
it directly to the Case queue.
There is no supported way to do this. The email router is a closed module and
you have no control over it like this.
MVP - Microsoft CRM
---------------------------------...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...calculate overtime & doubletime
I am having a hard time calculating over and double time.
I am making a list and i have this columns:
Start time Finish Time Reg time Overtime Double time Total hrs
8 AM 7.30 PM
To calculate the regular time I have used this formula:
To total Hrs
And I am having trouble doing the Double time...
And I think the 3 formulas I have used aren't correct, because Regular time
cannot be more than 8h, and overtime can...Calculation Speed #2
I am having a lot of trouble with increasing the speed of my workbook
calculations. I have queries, outside links and many INDEX and MATCH
formulas that I do not want to eliminate.
After I run a query and have the main page of the workbook calculate, is
there any way that I can continue to calculate the rest of the workbook
without the main page recalculating? All of the worksheets rely on the main
page and some of the worksheets rely on other pages as well. Therefore, calc
sheet is not thorough enough. I need to calculate entire workbook except
I am wondering if ge...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...Notify new mails in OWA
outlook web access: I want to be alerted when new mail arrives.
Must I configure internet explorer settings?
Damb0 <Damb0@discussions.microsoft.com> typed:
> outlook web access: I want to be alerted when new mail arrives.
> Must I configure internet explorer settings?
> thank you
What version of Exchange? OWA for E2000 and 2003 should already have this
E2003 with no sp1
"Lanwench [MVP - Exchange]" wrote:
> In news:202E8B5B-0D17-44F8-97FA-A69657035...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?
...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, ...MS Money 2006 from old computer to new with Vista
I currently have MS Money 2006 on an old computer. I have purchased a new PC
with Vista. I have also purchased new MS Money 2007 on CD.
What is the best way for me to proceed in loading MS Money 2007 onto the PC
with Vista, and to get my old Money files. Do I load Money 2207 software and
then transfer .mny file, or should I trnasfer .mny file and then load Money
The order probably doesn't matter. Since it's a new machine and a new Money
install, it will have no knowledge of "most recently used" files. Note that
some of your settings will also not transfer in the...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...