Data Migration #4
Hi, i can't migrate from sage line 50 into GP 10.o
Microsoft Dyanmics GP 10
Did you have a question or just wanted to make that comment?
East Coast Dynamics
i am asking for solutions on Migration from third party products to GP (Sage
Line50,Line 500, Peachtree and Simply Accounting)
Microsoft Dyanmics GP 10
"Frank Hamelly, MCP-GP" wrote:
> Did you have a question or just wanted to make that comment?
> Frank Hamelly
> MCP-GP, MCT
> East Coast Dynamics
> www.eastcoast-...Storing Credit Card Inormation
I am on the prowl for a well designed addon for RMS 2.0 that allows the users
to store their customer's credit card information so they are able to
recharge their customers credit cards on a monthey basis or whenever they
need to depending on the business.
does any body know of a PCI Compliant addon that will allow for this? This
seems to be a tool that customer's regularly ask me about and I sadly have to
tell them that it is not available. Please advice me if you know differnent.
Thanks in advance.
We are in the final stages of testing such a tool. If yo...Sql Server 2005. Best configuration and parameters.
We have a website (.NET 2.0 on IIS 6.0) and a Sql Server 2005 (9.0.4035)
running on the same machine, a Windows Server 2003 R2 Service Pack 2 with 8
GB RAM (Xeon E5405 2 Ghz). The website works with stored procedures. And max
20 users at the same time.
We are wondering the best following parameters for this particular
configuration... So, we have 2 questions:
Firstable, what is the best configuration for the 8 processors (0 --> 7) for
the processor affinity and the I/O affinity ?
Today we have:
Id Proc Proc Affinity I/O Afiinity
0 1 ...No blank lines in text files #2
When opening a comma delimitted file, I don't get blank lines anymore. In
Excel 2000, if a line in the text file was empty I would get an empty row in
the new spreadsheet. Now all non-blank rows are jambed together in one
column! How do I get Excell2003 to opoen Comma Delimitted files properly
(including empty lines?)
Oops, managed to send the same question twice! How can one delete a subject?
"Charlie Gotwald" wrote:
> When opening a comma delimitted file, I don't get blank lines anymore. In
> Excel 2000, if a line in the text file was empty I would get an empt...I want to buy the best book of office 2003
I want to buy the best book of office 2003, what is the name of it?
> I want to buy the best book of office 2003, what is the name of it?
"The Best Book of Office 2003." (Just kidding!)
"Best" is subjective. Check out former Access MVP Jeff Conrad's lists of
recommended books and find the ones for Access 2003, then go to your
bookstore and look at each one to see if it's "for you" -- and your learning
Notice that these books are all Access databas...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Defragmenting information store on Exchange 2000
This is a multi-part message in MIME format.
Since this is the first time for me doing defragmentation, have a few =
questions if you're so kind ...
Our company Exchange 2000 Server is running out of disk space. The =
priv.stm is 6 GB and priv.edb is 4 GB size.=20
Free space on drive is 4 GB. Is that enough to run eseutil to defragment =
the database? Are there any 'tricks' that I must be aware of ? And =
approximately how lo...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Macro referencing data validation doesn't work
Operating System: Mac OS X 10.4 (Tiger)
Hi - New to VBA & the forum. <br><br>When I create a macro that references a data validation cell, the code does not acknowledge the value selected from the pull down menu. But, if the value is manually typed into the data validation cell, the code works fine. Any ideas? I've had PC users try the code with no problems. <br><br>I'm using the following code: <br>
[Code]Private Sub Worksheet_Change(ByVal Target As Range) <br>
If Not Intersect(Target, Range(&qu...Create Batch file for laptops to copy templates
I am new to batch file programming and need an expert help to find out
something. I want to create a batch file that runs at login and compares a
local copy of the templates to what we have on the network. We have templates
on a mapped network drive in h:\clients\templates, and on the laptop in
c:\apps\data\clients\templates. When the laptop is offline it substitutes
c:\apps\data to appear as h: drive, that way the files appear to be in
h:\clients\templates. Here’s the basic steps what I need the batch file for:
1. first it checks to see if the computer is on th...Cell formatting when importing data
When I import data from a delimited file into Excel 2000, even though I have
pre-formatted a column as text, entries such as 12-5 and 1-4 -- which are not
dates display as dates. When I reapply the text formatting I get a number:
38691. How can I get 12-5 to display as is when I bring the data in?
Rename the file to *.txt and use the text import wizard, just click next
twice and in step 3 select text from column data format for this particular
column and click finish
"cjay" <email@example.com> wrote in message
news:90AAB750-BF9F...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...Excel Icon for files
I am running Windows 2000 professional on my PC and connected to a LAN. I
am running the MS office 2000 Professional suite. When, I save a worksheet
from Exel 2000 it does not save the file with the common Excel file
Icon(green X). The file is displayed with the default Windows Flag Icon.
When I double click on this default Windows Flag Icon the system tries to
open the file with Word not Excel.
Word and PowerPoint both save with their common Icons. The Excel program
saved fine a couple of weeks ago. I have not installed any new software and
our server takes care of Virus protection thro...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...I need a macro to find cut and paste data to new cell
I have data that I have exported to excel that I need to reformat to be able
to create a pivot table to check for duplicate entries.
On importing the data which is in the form of journal entries the memo line
is stting above the journal numbers in column D. I need to find all of the
comments and cut and paste them to column C. The comments are not all the
same but do contain the same word "To" in the comment. The journals are not
all the same size and so the comment line does not appear at regular
intervals. Any help appreciated as I am very new to VBA
...How do i change my file from a 2003 office doument to a 2000 docu.
i have done this before with a word document but i dont seem to be able to
figure out how to do it with a publisher document.... can anybody help??
File, save as, files of type, expand the menu to Publisher 2000.
Mary Sauer MS MVP
"me" <firstname.lastname@example.org> wrote in message
>i have done this before with a word document but i dont seem to be able to
> figure out how to do it with a publisher document.... can anybody he...Vlookups to Excel Version 3 files.
I use a system that on a daily basis creates an Excel
version 3 file containing cost centers and their budgets.
When I do vlookups from other Excel 97 files to this file
it takes a long time for the sheet to calculate. If I save
the Excel V3 file as Excel 97 its OK, and if the Excel V3
file is open before the 97 file its OK. I don't want to
have to constantly save the V3 file as 97 (I may not be
around to do that always)
Does anyone know how to resolve this.
...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...HQ and Store Collation
we have a serious issue here.
I upgraded several shops accross europe to V1.3.1006 and SQL Server 2005.
I used the 1.3 refresh for that.
In germany and the netherlands everything went fine and we can use the HQ
Client to send the data to the german and dutch HQ databases.
In France, Switzerland and Spain however the HQClient stops in the middle of
the WS 250 saying that the database collations are different although i
checked both collations and they are the same (as far as Store Op Admin, HQ
Admin and Server Management Studio says).
You may have the correct c...Linking Table Data by Form Actions
I have a form that contains record number information and alittle bit of data
based on this record number. Each "record number" is linked to a couples
information. This couples information is things like name, address, city,
etc. When I'm on the first form, we'll call "Protocol_Index", I hand type a
protocol number to designate this unique record. Once I've placed this
protocol number in the "Protocol_Index" form, there's a button that takes me
to another form, we'll call "Couple_Index". Once I get to the "Couple_Index...Register a file extension
I would like to allow my users to register my apps file extension from within
the app. I have managed to register the extension but the description isn't
being shown in explorer on xp or 7, I can not also get the icon to display.
Below is the code I found on the internet:
Private Declare Function RegCreateKey Lib "advapi32.dll" Alias
"RegCreateKeyA" (ByVal hKey As Long, ByVal lpSubKey As String, phkResult As
Long) As Long
Private Declare Function RegSetValue Lib "advapi32.dll" Alias "RegSetValueA"
(ByVal hKey As Long, ByVal lpSubKey ...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...LIST option missing in DATA Menu
A user has the LIST option missing in the DATA submenu of Excel 2003.
What would cause this and how do I help her correct it
cccgsmith's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1524
View this thread: http://www.excelforum.com/showthread.php?threadid=26873
Perhaps she has short menus enabled. To change this --
Select the Options tab
Add a check mark to 'Always show full menus'
Or, to use short menus, and see commands that haven&...Transfer files from money 99 to money 2003
We have a new computer with money 2003, old computer has
our records in money 99. We tried to import export but
the records to not come across correctly. What should we
You shouldn't have to export or import. Just move across your .MNY data file
and open it with the newer version. See http://umpmfaq.info/faqdb.php?q=68.
"Michelle" <email@example.com> wrote in message
> We have a new computer with money 2003, old computer has
> our records in money 99. We tried to import export but