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 ...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...How can I show U.S. country code (+1) in my contacts?
I've moved to Italy, and would like to have the U.S. country code show in my
Outlook contacts (as the code for other countries currently does). I've
changed my default location in the Windows 7 control panel, but this hasn't
had the desired result. Any option settings I'm missing?
Which location did you set, and to what? Did you enable the option to
automatically add country code to your Contacts?
"Matt D." <Matt D.@discussions.microsoft.com> wrote in message
> I...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...Account list headings
Of the headings in the account list: Account; Last Updated; To Review; Bank
Balance; and Adj. Balance. I only have details in the Account name column and
the adjusted balance column.
Could someone tell me how/when the other fields are used?
I would like to show balance at the bank at the last point I reconciled my
transactions (last updated?) against the adjusted balance, all in the one
Just to note that the adjusted balance includes items that I have yet to
reconcile, ie items after my last bank statement
I hope above is clear, and appreciate help
...finding a sum from a list
I have a list of 10 numbers in column A.
I am given a number and told that there are a combination of numbers (2 or
more) from column A that sum to that number.
Is there anyway I can set up a formula for this?
Take a look at Tom Ogilvy's solution for this problem.
"SBUMP2" <firstname.lastname@example.org> wrote in message
> I have a list of 10 numbers in colu...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...Array problem? List comparison?
Let me set up what I'm trying to do. I have 3 columns with the
A: 10, 20, 30
B: X, Y, Z
C: 28, 8, 1
Now, I have a last column, D, which I'm trying to figure out the
correct formula for.
I want D to return the following:
Look at column A, find the smallest number that's greater than the
adjacent cell in column C, and then return the adjacent cell in column
So, in this example, column D should read:
D: Z, X, X
I can't figure this out. I think it has to do with arrays, but I'm not
too sure. If anyone has any insight on how to ...How do I create an A3 size document using Windows 7
A3 is not listed in the pre-set schedule of document sizes in Windows 7
(unlike previous versions of Windows).
How do I create such a document using Windows 7?
Does your printer support A3? Word/Windows will display the paper sizes
supported by the default (or currently active) printer.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"A3 documents in Windows 7" <A3 documents in Windows
email@example.com> wrote in message
> A3 is ...If statement #10
Could someone help me write an if statement saying that if the current cell
has no data in it to place a o in the cell but if there is a number do
"Jeremy" <Jeremy@discussions.microsoft.com> wrote in message
> Could someone help me write an if statement saying that if the current
> has no data in it to place a o in the cell but if there is a number do
> Thank you
is [basically] what you want but will most likely produce a looping error.
I...Custom Page Headers
I want to show the contents of a cell in the page header when I print the
document. Does anyone have a solution for this?
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterHeader = ActiveSheet _
Place this macro in the "ThisWorkbook" module.
>I want to show the contents of a cell in the page header
when I print the
>document. Does anyone have a solution for this?
...Only showing images when Netmeeting open?
Hi, hope someone can help as I'm stumped on this one.
I've upgraded to Office SP 2 but now images do not display in Publisher
files. The strange thing is that the images do show if Netmeeting is open at
the same time!! I've checked the show images settings in options and they
are fine. Keeping Netmeeting open at the same time is a work around but not
very practical as I'm sure you can imagine.
Any suggestions would be great.
...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...Adding non-domain emails to distro list
Is there a way to add a external POP3 Address to a
Create a custom recipient (in Exchange 5.5) or if your running Exchange
2000 create a contact in Active Directory, then you'll be able to add the
contact to the distribution list.
Hope this helps,
"James Panegasser" <firstname.lastname@example.org> wrote in message
> Is there a way to add a external POP3 Address to a
> distribution list?
...opening an excel document in word
Does anyone know if it is possible to open an excel document from word? I
am trying to copy information from a word document to excel but cannot
figure out how to open the excel document from word.
Thanks in advance
You seem to be contradicting yourself. First you say "Open Excel file from
Word" and then you say "Copy information from Word to Excel". Which is it?
Yes, you can open an Excel file from Word, but you're likely to get a couple
of warnings while you do it. Just File-->Open and change the Files of type
at the bottom to All Files, and cho...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...Creating a Distribution List in OUTLOOK 2007
Is there a way to create a DISTRIBUTION LIST in OUTLOOK 2007 that contains
contacts with a specific feature WITHOUT adding members one by one?
E.g., I need a distribution list of all contacts whose e-mail address is in
a particular domain.
The following sequence DOES NOT work:
CONTACTS ---> ACTIONS ---> NEW DISTRIBUTION LIST ---> SELECT MEMBERS ---->
SEARCH (MORE COLUMNS)
When I entered the domain name in the search window, I got no results. Thus,
OUTLOOK did not search the entries of the e-mail addresses.
Thank you for your help.
"...delete row contains specific word in an macro
Hi, Im trying to delete row that contains specific expression like:
In row 444 column b contents (ESSO PRODUITS) i want to delete that row but i
have more then one row to find and delete.
Try this on a spare copy:
Do a Data > Filter > Autofilter on col B
Select from the droplist: ESSO PRODUITS
Select all the filtered rows (select the "blue" row headers)
Right-click > Delete Row
GMT+8, 1� 22' N 103� 45' E
Jean-Francois <JeanFrancois@discussions.microsoft.com> wrote in mes...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, ...Moving the Show Desktop to the Left Side of the Screen?
Has anyone tried this posted at the following link? If so, if it does not
work or you don't like it, can you get back:
Restore classical Taskbar in Windows 7
1. Right-click on a blank area of the taskbar and, remove the checkmark
from the item "Lock the taskbar; if there is"
2. Right-click on a blank area of the taskbar and select "Properties" from
the context menu
3. Put the checkmark next to "use small icons"
4. Select "Never combine" from the drop-down menu located...My e-mails will not show
When I open up my outlook express,
I do not see my e-mails in any of
the boxes except the spam one.
When you right click on the account
you see in the window the number of
mails that are there, but when you
double click on the inbox for instance
Check your view settings on that folder. Also note:
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program, despite its similar name..
You will probably get a faster and more expert answer if you post this to a...Auto Fill using a list of students
How do you type in a list like days of the week, months so you can auto fill
...Custom message on department
I was wondering if there is a way to get the POS to popup a message saying
that customer details are required to be filled in when an item belonging to
a particular department is rung up at the POS?
Store Ops Manager allows you to assign an item message to items in inventory.
Go to database - items - properties - special
You will see a field on the left side that allows you to assign an item
message popup when the item is rung up at the POS
First you need to create the item message - go to Database - Item Messages -
New - enter "Customer Required" in Title and Me...Deleting a Custom Shortcut Menu
I've created a few custom shortcut menu's in Access and I noticed a typo in
the name of one of them. Maybe I'm missing something, but how do I rename a
SHORTCUT MENU? (not a toolbar or menu bar...I realize there is a "Rename..."
button for those)
Also, for future reference, how do I delete custom shortcut menus that I've
If I go to customize the toolbars and check "Shortcut Menus" (to show the
shortcut menu bar) then go to the "Custom" button I can see the shortcut
menus I've created and add/remove buttons to them. It even ...