Importing Purchasing Transactions
We receive a file from our bank containing all of our wire payments. We
would like load this information into a batch so that all Vendors listed in
the file would added to the batch with the dollar amounts an document
information d from the file being brought over as well.
Anyone know of a way to import this information into Great Plains 8?
You can use Integration Manager to accomplish this. There are a number of
items that need to be looked at such as matching the vendor to a vendor id.
Are there new vendors to be added? multiple checkbooks, gl posting accounts,
etc. If...How do I import sent mail from Gmail?
Like the title says... I imported my emails from my Gmail account-- synched
it with gmail, usual stuff-- but it didnt send any of the mail i sent using
Gmail to the outlook account. (I am specifically trying to get the emails I
sent from another account-- my business email-- that I used gmail to manage.)
I checked the "sent" box & everything... suggestions??
Carol <Carol@discussions.microsoft.com> wrote:
>Like the title says... I imported my emails from my Gmail account-- synched
>it with gmail, usual stuff-- but it didnt send any of the mail i sent using
>...SQL Auto 250 worksheet
I'm sure this has been mentioned before, but I can't find it anywhere.
People not doing 250 worksheets (and others) is a real problem for me. Is
there a SQL command that can be run every day at say 23:00 to perform a 250
to send all data to the shops?
This is a multi-part message in MIME format.
Content-Transfer-Encoding: quoted-p...Importing from Word #3
I am trying to import a faily large document from Word, and want to retain
the original formating - specifically the margin settings. When using the
'Import from Word' facility much narrower margins are set no matter what I
do. I have also tried pasting the whole document from the clipboard to a
pre-drawn text box, and letting autoflow produce new text boxes, but this
removes much of the original formating.
New, from the Publications for Print menu select Import Word Document, select
one of the templates, insert the Word Document. The document will come in with
an on...how do I connect data between 2 worksheets
I have to worksheets with in an Excel file. I want the 1st sheet to
pick up informaion from the 2nd sheet which is the description page.
I only want to key the number on page one and the description be
automatically read from the 2nd page. example
when I key 504319095 I want the description column and the size column
to pick up "red" and "small" from the second page.
I have inserted formulas before, but never for data always for
Thanks for your help
Hoping this is clear enough
~~ Message posted fr...Two Email Accounts not able to reply out of one of them
I was wondering if someone here has ran into this problem. I
currently have two email accounts setup in Exchange I can receive
email in both of these accounts and view the email in Outlook 2003.
In my default account if I receive an email I can reply back. But in
my secondary mailbox if I receive an email I cannot reply back I get a
error message which is listed below. On the secondary account I have
added my username under permissions and gave it full access but I am
still getting the below error. Anything will help thanks.
Your message did not reach some or all of the inten...Putting database data into a combo box...
I have a working databse query thar returns a list of names. I want to
put this into a combo box. Currently I am inserting the database data
into a range on my spreadsheet (A1) and it uses as many rows as there
are names. In my combo box properties I can specify the ListFillRange
as A1:A5 or whatever and this works okay, but the thing is, as names
are added to the database, I want the range A1:A5 to update
Q1. Can I send the QueryTable data directly to the combo box
Destination:=ComboBox1.Lis...importing dataset beyond 256 columns
Might anyone be aware of a Q article on this issue?
The third hit I got searching on "256" returned this:
"Arturo" <Arturo@discussions.microsoft.com> wrote in message
| Might anyone be aware of a Q article on this issue?
...move multiple data labels
Is there a way to move multiple data labels on a chart?
Rob Bovey's Chart Labeler allows you to move all the labels on a series
together. It's a free addin from http://appspro.com. It also lets you
use a range of cells for the data labels.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> Is there a way to move multiple data labels on a chart?
>Rob Bovey's Chart Labeler allows you to move all the...after reconfiguring hard disk i'm not able to send/receive mails
i'm not able to send/receive emails from new outlook 2003 server, before
configuration i had Windows vista with 2007 server and now i have Windows XP
and 2003 server(outlook).
Wondering what could the issue?
"Santu" <Santu@discussions.microsoft.com> wrote in message
> i'm not able to send/receive emails from new outlook 2003 server, before
> configuration i had Windows vista with 2007 server and now i have Windows XP
> and 2003 server(outlook).
> Wondering what could the issue?...Problem with quicksell import tool
I've managed to import a list of products into RMS using the Quicksell import
tool. The description, lookup, barcode format, price, cost and supplier all
work perfectly. Only problem I'm having is setting the 'Item tax' field. I've
tried entering the code and description from the Item taxes list, but it
always creates a new form of item tax.
I've also tried runnig a query on an item that has the same tax status as
I'd like to set for my new products
Select TaxID from item where itemlookupcode = '001594'
This query resulted in the number 2 for the Ta...Importing QFX files
One of the financial institutions that I deal with provides downloads only
in QFX format, not OFX. Is there anyway to import QFX into Money 2005 Standard?
On 2005-04-29, firstname.lastname@example.org <email@example.com> wrote:
> One of the financial institutions that I deal with provides
> downloads only in QFX format, not OFX. Is there anyway to import
> QFX into Money 2005 Standard?
I don't know the answer to this question, but this guy seems to
think that it doesn't really matter. According to him, QFX is OFX
with Quicken extensions. I don't know whether Money will ...Grouping data #2
I have the following senerio:
where 1,2,4 are grouped and 3,5,6.... These patterns will repeat in random
order for 50 lines. I know I can vlookup these items but is there anythine
else that would group them and drop down all of the categories contained?
Since the grouping's random, how do you expect Excel to know which items
should be grouped?
"Newbee" <Newbee@discussions.microsoft.com> wrote in message
news:3E6480C6-A06F-47F6-84D1-2CEB9AE3EEDD@m...extracting data from a pivot table
I have a need to use data from a pivot table on other worksheets in my file.
The problem is that when a pivot table changes the data in the cells do not
update to my other parts of the spreadsheet accurately.
...Cant find xml source pane in data menu
Just upgraded to Excel 2003 (Student & Teachers Edition). Been trying the
Microsoft training on xml. In one of the seesions it tells me to point to XML
on the data menu and then click XML Source. I dont seem to have the XML
option. I've looked in toolbar options etc. but nothing there. Is it to do
with the version?
...Importing Contact DL's into DL's on the GAL
I'm trying to find out how to import distribution lists located in Contacts
in an exchange mailbox into exchange so that they are available for everyone
on the GAL
There are about 1000 DL's so it is not possible to do this one-by-one. The
DL's contain Display name and smtp address as members.
Please - suggestions :D
Brendon B <BrendonB@discussions.microsoft.com> typed:
> Hi Everyone
> I'm trying to find out how to import distribution lists located in
> Co...How to scrape web page data in VBA
I need EXCEL to open a web address and parse out a few data items from that
web location. What EXCEL macro function(s) can be used to open a web URL and
parse the page source?
The web pages in question are not set up to allow the external date
functions to find the needed data.
Use joels dump sub to ascertain the tag name or ID for the data you want:
with worksheets ("sheet1")
RowCount = 1
for each itm in IE.Document.all
Range("A" & RowCount) = itm.tagname
Range("B" & RowCount) = itm.classname
Range(&...User not able to login
I have a user (1 of my 5 licensed users) that each time he logs into CRM, the
browser seems to accept his credentials, but then it closes all-together.
What is this and how can I solve it?
Figured it out.. It was popup blocker.
> I have a user (1 of my 5 licensed users) that each time he logs into CRM, the
> browser seems to accept his credentials, but then it closes all-together.
> What is this and how can I solve it?
...lookup and transfer data
I have multiple spreadsheets that I want to move certain information from to
get all my info into one spreadsheet. Is there anyway to search mutiple
spreadsheets by a column like "Part Number" and tell it to retrive another
column like "Qty" then post it into a corresponding column in another
worksheet by matching "Part Number"??
some questions upfront:
- how are your sheets named exactly
- columns IDs
- Are you searching for a numeric value only
- Is there only one occurence of each part number
ExcelDummy wrote...trouble importing customizations onto a the Demo version of Virtua
I have fully customized a client installation of CRM 3.0 including custom
entities. I am trying in import these customizations onto a Virtual PC 2004
running the CRM 3.0 Demo image from May 2006. I have not touched this
virtual image. It is the demo system with no changes. I’m getting an error
that my mappings are not right.
The message reminds me of the Mapping restrictions
1. The source and target attributes must be the same type.
2. The source attribute length must be < or equal to the length of the
3. The target attribute must not have a mapping relations...I am not able to do this...
I apologise cause of my lack of knowledge to do this.
I have 2 questions
1) I need to copy all my excel files to a pen drive or CD. so, i
searched them by using
XP search function. I selected all, copied and pasted to pen drive
but a prompt was immediately received "cannot read from source file
or disk "
2) When a Excel file is generated and saved, can it be automatically
saved in a different file
in order to have all xls files duplicated in one XLS Folder ?
Can I received some help to solve this matter ? I will be very
#2. You could have a m...Import Access Database info to Excel???
I have NO idea how to accomplish this feat.
I have an access database. In this database, I have a very large query that
I need to export to excel.
1. Do I export from query, form or report?
2. Once in excel, I need all but 2 columns and then I will email to
3. Customer must enter info in those 2 columns and email back to me.
4. Once I get this information back, I would like for the info to flow
'back' to my access database.
5. The excel worksheet will be updated again when another action
a. Can the access info be entered and update...reading textual data from CMemFile
I am trying to read textual data from a CMemFile, line by line. It works,
but it is too slow. Is it possible to do it faster?
Thanks for ideas
//return FALSE if we reached the end of the file
//else return TRUE and fill the parameter with another line
BOOL QCommonStorageReadMem::GetToken(CString &rString)
while (m_memFile->Read(&ls_temp, 2))
if (ls_temp == _T('\n'))
rString += ls_temp;
You might want to try reading more than 2 bytes at a time and just...Anyone running SQL 2005/08 under vSphere?
We have been running SQL 2005 Enterprise on vSphere for approx 3
months now. On the whole everything has been fine, but I have noticed
some strange behaviour surrounding the io performance.
We moved from a physical box due to suspect hardware. A previous
vmware capacity planning exercise suggested the sql server could be
virtualised as long as the hosts had sufficient ram. We therefore
ensured our vSphere hosts had plenty of ram (50GB each) and created a
virtual sql server to the same spec as the physical box. The
underlying storage is a dedicated raid 10 RG on a clariion cx4. All
c...IFD Assistance Please
I have a virtual environment that is on a separate domain than the
rest of the company. I have installed CRM 4.0 in this location without
issue and have enabled IFD. I had two IP addresses that worked before
enabling IFD. One was for when I was here in the office and the second
could access the environment externally.
In addition I can use a friendly URL to access CRM when I access the
server via remote desktop. The DNS checks out OK when I test if from
the IFD configuration tool, I have also added this friendly URL to the
DNS however I still cannot use IFD? http://servername/organizationname...