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...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...Tractor Fed label roll gets 3.3 inch feed at end of page? How do.
Once again I begin what seems like a simple project and reality hits me with
a two by four on the back of the head.
Continuous form, custom product and serial number label for our products
that feeds a Page Break at the end of the page in letter size page. I’ve
used the Label Wizard and I defined the label as continuous, yet after 6
labels that print perfectly, I get a feed of 3.375 inches.
I’ve looked everywhere in Access and I cannot find a way to override this
Access 2002 SP3
Okidata Microline ML591, Dot Matrix 24 Pin, Rear Tra...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...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...maximize page in outlook express
I hope someone can help so that I don't need to maximize every e-mail I open
and every new message I wish to compose. I either click on the maximize
button or double click the blue name bar at the top of the page to make my
message full screen size but unfortunately when I close down they all still
come up as a half screen and I cannot find how to make them open in the full
maximized size every time. I am using Windows 95 with Word 98.
Thanks in anticipation
Moira Newman wrote:
> I hope someone can help so that I don't need to maximize every e-mai...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...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?
...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, ...How do I set up my page to print business cards on Microsoft Publ.
"Dayna Thomas" <Dayna Thomas@discussions.microsoft.com> wrote in message
Here's I do it with Publisher 2000.
Business Card from the drop down menu
Assuming you are using standard business card stock of 2 wide and 5 high;
Page options button
Print multiple copies per sheet
Custom options button
Margins = .5"
Gap = 0"
Side Margins = .75"
Vertical gap = 0&qu...Toolbar keyboard navigation
most Microsoft applications (e.g. Office 2003, Visual Studio 2008) allow to
navigate through the toolbars using the keyboard: This can be done by hitting
and releasing the ALT key, which sets the focus to the first menu item.
CTRL-TAB then moves the focus to the first toolbar, which can be navigated
using the cursor keys and enter.
I was told that this is often used by visually impaired users.
Unfortunately, standard MFC applications (at least Visual Studio 2008
Feature Pack App-Wizard generated applications) do not offer this
functionality. What do I need to do to add thi...?make 28 page booklet & have words continue onto next page
Using Microsoft Publisher. I am taking a chapter from a book I've written
and trying to put it in booklet format. There should be a way to have words
just flow from one page to the next (so I don't have to cut and paste each
page). I want to cut and past the whole chapter into publisher. When I used
the setting to let it flow to next page, the "pitcher" that is supposed to
pour. It doesn't do anything.
FYI- if it makes any difference- the finished booklet with be a regular 8
1/2 x 11 folded in half and stapled. I was using the program, in part, for
its ...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...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...Limiting results per page
I have a report that has a subreport in the footer. I need the report
capped at 28 rows per page because the subreport (rotated 90 degrees with
the rotated lable control) is going to get pushed out at 29 rows. Also 28
rows is what we want for the deposit slip. Regardless if we want it or not
though sometimes we are going to have more than 28 fields which will wreck
the way we want the report to look. How can I either limit the report to 28
rows or better yet make the 29th row start row 1 of next page (keeping in
mind though that I need the subreport to not move to the 2nd page)?
...Printing/Page Numbering in Footer
I'm wondering if I can print several sheets (eight sheets, each one page
long), however I don't want the Footer to print on the first page, but I want
it to print on
subsequent pages, starting with "Page 2."
Can I do this or do I have ot rig up some kind of macro for printing it all
You may want to take a look at JE McGimpsey's site:
> I'm wondering if I can print several sheets (eight sheets, each one page
> long), however I don't want the Footer to print on the first...Feedback on GP Time and Attendance
I am looking for some feedback on GP 9 / BP 3 version of Time and
Attendance. We are using non Payroll, Canadian version, of GP Time and
Attendance and we are experiencing many limitations.
What is your experience with this product?
Any other similar product you'd recommend?
Thanks in advance,
...Opening a page as saved
Is there a way to get publisher to open an existing page,
either at the zoom level it was saved at or say 100%. It
seems always to open as full page view ( 48%) and I have
to zoom in, it is not a major problem just annoying.
Malcolm Fowler <firstname.lastname@example.org> posted:
|| Is there a way to get publisher to open an existing page,
|| either at the zoom level it was saved at or say 100%. It
|| seems always to open as full page view ( 48%) and I have
|| to zoom in, it is not a major problem just annoying.
No there...Apply more than one master page
MS Office 2007 Small Business Publisher. XP Pro OS.
I have a 208 page instruction manual. I developed a master page with a
header, footer, page # of # to show automatic sequential pages, company logo,
etc. This master page is applied to page 2 through 208.
I developed other master pages that I want to apply to groups of pages
throughout the document. They contain graphic "tabs" that show up on the
vertical border of the document.
So as a result I would have the main master page set at 2-208, then another
master page set at page 2-9, another set at 10-16, another at 17-26, etc.
I...I want to know GP Tables Definitions
I need to know the tables for the window general transaction entry in GL
Go Tools>Resource Descriptions>Windows. Select Product/Series/View
By. You'll be able to see all the tables associated with a specific
MCP-GP, MCT, MVP
East Coast Dynamics
In addition you may want to check David Musgrave's article on resources at