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 ...Stupid question regarding reports
I am a former Quicken user switching to Money and I have what seems to me a
very dumb report question. How do I create a new report? I've looked in
the help file and in the online tutorial and users guide and find plenty of
references to customizing an existing report but nothing about creating a
new one. I realize that it must be there somewhere. Someone please help
this dummy (it would be nice if they gave you even a 5 page manual though).
Had me guessing for a while also. Just click on "reports"
and select which one you want. Don't forget to
use "custom...Group sending of Reports via Fax
I know this might sound simple but I was wondering if there was a
way to send a group of reports via Winfax as follows.
The catch here is it is not sending a batch of reports which are the same,
but sending different reports at the same time to different fax numbers.
I have a report based on a query which looks at all the outstanding accounts
for a client.
Instead of opening one query at a time and going through the proceedure of
sending via Print - Winfax each report, I was wondering if there was a way
to send all the reports at once for all my clients. Mind you each report
...Gainskeeper in trial and patches needed
I have MS Money 2004 Premium and i've signed up for
Gainskeeper.I supposed to get one yar subscribtion but my
account is shown as 30 days Trial.
I contacted GK and they say that i need to download
patches and GK Token from Microsoft website,however i
never found such downloadable files.
Will somebody help me please ?
While gazing at the Money Central site to see what all the problems were I
saw that Gainskeeper trial is now just for 30 days. I got a years trial
last year when I bought $2004.
Aside from that I find Gainskeeper VERY worthwhile. Having over 100...Reports
I've finally finished testing and installing a new report for client.On my development machine, the report - with thanks to all who have helped with the footer issues and PDF conversion - works just fine. The header format fits, the detail section fits, the footers print in the correct place. In 99% of the cases, all data fits on one page. The conversion from report to PDF places all text in one page and saves the file in the correct location.On the client's machine, the report splits into two pages. Now, before you say the usual: "Have you checked the margins", "wh...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...Activiate a report for invoices?
I duplicated the "SOP Long History Invoice" form, and made a number of
modications to the duplicated version.. Now I wish to use this form... How do
I go about telling Great Plains to use my version and not the standard
Using Great Plains 7.5.
You must give yourself (and other users) permission to use the modified
Click on Setup > System > Advanced Security
"brother52" <firstname.lastname@example.org> wrote in message
> Good day,
> I duplicated the &q...Error: Serial Numbers and item's extended quantity do not balance
While using GP 8.0 with no service packs. Any suggestions on how to fix?
In Sales Transaction Entry - I had created a repeating order and transfered
it to an invoice, after clicking post is when I get the error message.
"Susan L" wrote:
> While using GP 8.0 with no service packs. Any suggestions on how to fix?
...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...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...Start Report Writer
I'm kinda a newbie to MS Dynamics GP but I'm looking to write a custom report
as the report I need isn't built. I would expect that the Report Writer
would be the way to go but when I click the Tools Menu, select Customize, the
Report Writer is grayed out. Can anyone tell me how to get the RW started?
By default, a user is not given access to Report Writer.
In security, select the Product: Microsoft Dynamics GP, Type: Customization
Tools and Series: Customization Tools to give access to your user.
If you are using Advanced Security, Report Writer can be found under Tool...restart trial?
I had previously installed the trial version of Money Plus Deluxe, but never
had time to actually try it out before it expired. Now I would like to try
it and it keeps telling me that my trial has expired. I have tried
uninstalling and reinstalling. I have also tried deleting the old .mny file.
I even trie using a different Microsoft Live account. Nothing is working to
reset the trial time. Is there anything I can do? I want to try it out and
show it to my wife for a couple of months before we pay for the software.
Is there anything I can do to reset the trial period and start ...Access 2003 Report generation
I have a report that contains the .Line method to draw a series of boxes
around controls that can vary in size depending on their data content. I
would like to have each box shape filled with a colour suitable to its
control data, rather than have a back-fill for the control data. Can you
please give me an idea as to how to code it. I have tried the .FillColor
property but without success. Thanks.
It would have helped if you had provided your existing code. However, I have
been able to shade a background with code like:
Private Sub Detail_Print(Cancel As Integer, PrintCount As...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...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...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...merge existing report into an excel spreadsheet
Hi! We receive monthly reports from other companies and other resources, is
there a simple way to merge these reports into an excel spreadsheet or access
database? Thanks in advance!
Almost certainly, but you'll have to give us more to work with.
Gromit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=92
View this thread: http://www.excelforum.com/showthread.php?threadid=31995
...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, ...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...Convert 2002 D/B to 2000 shows no details
When I attempt to use the [Tools];[Database Utility]; to
[Convert Database]; to Access 2000 format from Access XP,
the resulting database doesn't display anything in the
Detail View. All tables and queries appear to be present
in LIST View and ICON Views but when DETAIL View is
selected the entire display is blank.
Is there a "Select Details" option in Access as there is
in Windows Explorer?
"Tom" <email@example.com> schrieb im Newsbeitrag
> When I attempt to use the [Tools];[Database Utility]; to
> ...Can I still get Visio 2003 trial download?
My computer has all Office 2003 products on it, but no Visio. I'm not wild
about downloading a trial of Visio 2007 due to possible conflicts & issues
with my 2003 products, plus the added learning curve.
Is Visio 2003 still available anywhere for download? I haven't been able to
I'd suspect you'll have no luck in getting the 2003 trial version.
"ScottH" <ScottH@discussions.microsoft.com> wrote in message
> My computer has all Office 2003 products on it, ...Balance problems
To start I manually enter all transactions. I'm having troble with balances
on the screen everthing is good then when I go to print I get a very
different running balance. It started a couple month ago. I even started from
scratch and after balancing last months checking account it is doing the same
thing. I have been using money for many years and this is the first time I've
seriously thought of changing programs
In microsoft.public.money, tvan wrote:
>To start I manually enter all transactions. I'm having troble with balances
>on the screen everthing is good then wh...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...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...