how to restore v7.5 GP DB into a 9.0 company
We use a backup company in our system for testing purposes. From time
to time we restore a recent backup of our live company into it.
Sometimes though, we restore an old backup into it in order to view
the status of the company prior to some change or another.
We are just now upgrading to 9.0 from 7.5. The upgrade is going onto a
new server and most issues have been resolved. One issue I have not
figured out is as follows. Let's say that a month into running 9.0 we
realize something is funky in our GL. We decide to take a look at
things as they were from a couple months before the...Re: ��������������� 06-09-10
1) ����� ������� ������� ������ ��������� ������� ��� ����������� ��������,
������ ����� �������, ���� e-mail, ����� ������� ������ ��������.
2) � e-mail ������ ������������ � ������������, � � Usenet ����� ���������
���� ����, �������� �� ������ ���� ��������.
3) ��������� ������� ���� � ������ ���� ����� � ����������� ����.
4) ��������� ������� ������ � ������ ����� ���������.
5) ��������� ������� ���� � ������ �����������.
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5183 (20100608) __________
The message was checked by ESET NOD32...Modifier with VBA in GP 9.0
Hi all ..
I am 8 months old in the Greate Plains......Now i want to write a
certification on "Modifier with VBA in GP 9.0".
Plz anyone can give suggestions,tips etc to me to pass the exam.
I have only one manual which will come with GP installation.Is it enough ?
If any body have any other document or article let me know..
Thank you all,
Begginer in Dynamics
Vijay Kumar Kashetty
If you are customersource / Partnersource then you will have access to
training material from your above accounts that is a best reference to
prepare for you exams, but still the manual which come...MEMORYSTATUSEX structure doesn't exist on Visual C++ 6.0 SP6
I want to use GlobalMemoryStatusEx function in order to get the total size
of physical memory (ullTotalPhys attribute of the MEMORYSTATUSEX structure).
The reason is that all the platforms we use are, at least, Windows 2000, and
some of them can have the maximum RAM size allowed by the motherboard, so
GlobalMemoryStatus function can give a bad size.
But I have a big problem, I use Visual C++ 6.0 with the last service pack,
and the compiler says that MEMORYSTATUSEX structure is undeclared. This is
also undocumented on Microsoft webs and I need a solution.
How can I use ...GP 8 Analyses Cubes
Evaluating Analyses Cubes for Excel module in Fabrikam and am having
some problems generating excel pivot from GP. Able to get the data by
using Excel Add-In, so I guess everything is fine the OLAP db and cubes.
In GP, from Excel Pivot Table Creator window am able to connect to the
server, get the list of cubes, dimensions and measures, but when I want
to generate the pivot or save the definition I get the:
Unhandled object exception:
Initialization of the data source failed.Check the database server or
contact your database administrator. Make sure the external database is
available, ...how do I stop Access from dropping 0 on zip codes starting w/0?
I'm running reports in Access from an Excel database which includes zip codes
starting with 0. Access drops of the 0 because it's in the first position.
If I change the zip code to text in Excel, then Access doesn't show the entry
at all. How do I get a zip starting with 0 to show in Access (Example 03492).
> I'm running reports in Access from an Excel database which includes zip codes
> starting with 0. Access drops of the 0 because it's in the first position.
> If I change the zip code to text in Excel, then Access doesn...Payroll
Has anyone done a conversion from Achieve Payroll to GP? We have a client
that is looking for a reference.
...Payroll checklist 2008 payroll close
I have a question on the procedures for 2008 payroll close
1. We already created our year end wage file, step 7, step 8 we did our back
up, step 9 is in process, on steps 10 and 12 if I do this does this affect
the year end wage file already created?? We did not print w2s yet, when i
clear in active employees in step 12 does it just affect process going
forward and not the wage file I already created, I am new at this and this
ism our first gp 10 payroll close.
...GP 8.0 help, corrupted datbase?
Hello techies.. I am very new to Great Plains so I need some assistance and
hopefully someone can help. We are using GP 8.0, and for some reason this
week we have started have problems with our Dynamics database, on SQL 2000.
When a user logs in to GP, then they select their company it the window then
says "initializing Great Plains" then quickly changes to "applying personal
settings". On occasion, before it begins the "applying.." we get errors
associated with some custom modules that were created months ago. This
problem only started happening this w...Allocating Tips in Payroll
In one of the forums, someone asked me several questions regarding tip
allocation using GP Payroll. I posted an article to my blog that goes
through the entire calculation, but now I cannot find the thread where the
question was posed.
So, if you are still out there. . . the article was posted to :
...CRM 3.0 fresh install, Outlook Client unable to connect w/o VPN
After reading over and over the newsgroups, it appears that Outlook
clients should be able to connect to CRM without a VPN; however, I
have failed to do so.
Here is the current setup.
SBS2003 w/ Exchange 2003 running CRM router service
2003Server running CRM and SQL and SRS
Internal LAN - Outlook and Web-Based crm (http://crm) functions
External WAN - passing through Cisco Pix 501 (opened all neccessary
TCP and UDP ports)....Outlook clients (on and off-premise setup) work
without issue via the Microsoft VPN to the SBS2003 server.
BUT, turn off the VPN, and I am unable to co...IM and GP close on Payables Integration
GP10 (Ver 10.00.1193) and Integration Manager both close after executing
integration that has destination of Payables Transaction. It will run for a
few minutes then close and no error messages. FYI, I can successfully run an
integration that has destination as general journal. I login to GP thru
Check the event logs on the citrix server. I've seen this once before, and
the event log error related to .Net Runtime 2.0. Sorry, I can't remember
what resolved it - I think it may have been a repair install of .Net
> GP10 (Ver 10.00...Explorer 8 04-18-10
Thanks to Windows Internet Explorer 8 I have lost all my restore points.
Hopefully, when I remove it I'll get them back, but I doubt it.
Why didn't I lose my restore points when I upgraded to IE 8?
Errare humanum est
> Thanks to Windows Internet Explorer 8 I have lost all my restore points.
> Hopefully, when I remove it I'll get them back, but I doubt it.
Always state your full Windows version (e.g., WinXP SP3; WinXP 64-bit SP2;
Vista SP1; Vista 64-bit SP2; Win7; Win7 64-bit) when posting in a forum or
newsgroup. ...GP MRMS integration
We have GP and MRMS installed.
Due to specific business requirements, we need to keep inventory in GP and
use MRMS only for sales.
This means that POs and Receiving has to be in GP and these need to pushed
into MRMS. For sales it is vice versa.
Any suggestions for this?
Thanks in advance
Your best bet for integrating the two applications is to use eConnect and
eConnect Requester. The former will allow you to integrate data from the MRMS
application to GP, the latter allows you to specify XML documents that are
published to an MSMQ queue, where they can be retriev...Item Variants in Gp 9.0
how can I handle item variants in GP 9.0?
Widget 1 has a part number of "A100". It comes in three colors (Red Blue
Widget 2 has part number "B2000". It comes in two finishes (brushed and
In another MBS Dynamics product I only enter item "A100" and item "B2000". I
can then add variant codes for the colors on item A100 and other variant
codes for the finishes on item B2000. This is handled from a single item
card. WHen items are sold or purchased, the variant code is entered in a
separate field from the item number.
I have Microsoft Money 2004 and cannot figure out how to
enter a payroll expense. I need to have gross pay- taxes
and net pay showing as the actual amount of check.
Please help- email firstname.lastname@example.org
Have you tried the special category Paycheck? Look in the sample file or
read in help about Paycheck.
<email@example.com> wrote in message
> I have Microsoft Money 2004 and cannot figure out how to
> enter a payroll expense. I need to have gross pay- taxes
> and net pay showing as the actual amoun...excel 2003 05-27-10
Hi I am using excel 2003 and everything was goin g fine until I tried to open
a file (which was working ok) but now won t open and just comes up with the
"Time Sheet 09-10.xls:file format is not valid" any ideas on how I can
either re save so it will open or any other ideads on how I access the info
You may want to try it on a different computer -- or even a different version of
Or you may want to try OpenOffice.
A few people have said that OpenOffice.Org has been able to open files that
http://w...O Cedar Pro-Scrub Mop Refill, 10 Inch
Best price found: http://bestdeallocator.info/index.php?id=B001A5S2MC
Beware that the hardware attachment on this refill may not fit your O'Cedar mop. This refill does not fit my O'Cedar mop. Unfortunately, the photo description did not provide accurate cues much less a part number to let me know this before ordering. This is my last O'Cedar mop. Using my own ingenuity, I will redesign the mop refill I was sent in order to make it work, to avoid more landfill or additional hassle in returning and re...GP 10 Startup Performance
Hi all, I'm looking for some advice, as I'm pulling my hair out with this.
This was the way on 9.0, and I was really hoping 10 fixed it.
Upon starting on 10.0, the performance with the startup is just absolutely
horrible when reminders, tasks, and metrics are turned on. Turning them
off, we get satisfactory performance, but that completely defeats the
purpose of having them up and running.
Has : A: Anyone seen this
B: Resolved it any other way than shutting them off
The client currently has over 10,000 open A/R documents, does approx 7-800
invoices and another 300 orders...Upgrade to 8.0/Upgrade FRX
When upgrading Great Plains (from 7.5 to 8.0) do you suggest installing over
the 7.5 client or uninstalling 8.0 fresh?
How about FRX? (6.5 to 6.7)
I like to keep the GP installation clean but I've had success installing over
the existing client. Just make sure you export all modified reports and forms
to package files.
For FRx, it will give you options during the installation process. I would
keep the existing version and install in a new directory.
> When upgrading Great Plains (from 7.5 to 8.0) do you suggest installing over
> ...GP 8.0 new customer
Our company purchased GP 8.0 and we are having difficulty with the amount of
time it takes to reconcile the daily cash receipt. Does anyone do
approximately 1500 to 2000 invoices in one month - varied $ amountf from as
little as 3.49 to more than 2500. When we post a batch it gives us numerous
pages of "cash sales" that we have to deposit. It just seems to be time
consuming and we would like to streamline this process. Any suggestions?
With a little more information I think I can help with your issue. Please
feel free to call me at 407-660-0059 x 109 if you would li...Does CRM 4.0 handle Partner management?
We are a software shop and we are currently using CRM 3.0, with the
expectation to upgrade to 4.0 in the very near future.
One of our newest directives is to manage our partners, and their
accounts using CRM and we are wondering if 4.0 will be better at
I realize this is kind of vague, but its something that the sales staff
is asking of me.
Microsoft released a CRM accelerator for Partner Management in
October. take a look at it here:
You could be interested in our CRM @Comme...Payroll corrections after Payroll Year is closed
I have a client who closed their payroll year and issued W2s. Now,
they've realized that because the last payroll of 2008 was printed on
12/31 but not distributed until January 2nd, it needs to fall into
2009 for wage reporting purposes.
My first thought to correct this was to void the checks from the last
payroll and re-issue them but I've discovered GP won't let you do this
once the payroll year has been closed.
Has anyone ever run into this scenario and if so, how was it
MCP-GP, MCT, MVP
East Coast Dynamics
blog: www....Pie Chart not showing 0%
Using Excel 2003 sp3, is there a way to tell the chart not to display 0%
I have various tables where the values are 0 and they are showing up on the
Pie chart as 0% (since I am telling it to display the data as percentages).
It shows a thin line and the number 0%.
Is there a way to tell it not to display the 0 values in both the legend and
the Pie chart?
You can create helper columns with formulas that will exclude the zeros. You
can then base the pie chart on the helper columns. The example below shows
http://www.cellmatrix.net/index.php/site/analysi...Cannot print from GP
We are getting following error message when user tries to print.
The stored procedure glpBatchCleanup returned the following
result DBMS: 0, Great Plains: 20820
We are running GP 8.0 in user workstation.
This GP has worked in the past and recently error pops up.
This user workstion is the following:
Server: SQL Server
GP version: 8.00g44
DB server is running on MS Server 2000 8.00.760.(intel 86)
also following error occurs in user workstation event log.
Event Type: Error
Event Source: Dexterity
Event Category: None
Event ID: 1000