A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access to quickbooks - looking for consulting help



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2010, 02:46 PM posted to microsoft.public.access
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Access to quickbooks - looking for consulting help

I'm looking to pay for some consulting help from someone with knowledge of
Quickbooks and specifically
creating an iif file for importing data into Quickbooks.

I have software that is used for collecting donations and the user would
enter a batch of donation (say 20 donations) and then click a button in my
Access database to create an iif file which they could import into
Quickbooks.

Hoping to just get an hour or couple hours of help to figure out the exact
format needed of the iif file. I'm fine with doing the work to make the
file myself just looking for someone with some Quickbooks knowledge to
quickly get me there. I just purchased Quickbooks but have never used the
product.

If interested jump over to my web site and send me an email with your hourly
rate and provide a brief history of how you have used Quickbooks.

Thanks,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

  #2  
Old May 27th, 2010, 08:46 PM posted to microsoft.public.access
James A. Fortune
external usenet poster
 
Posts: 903
Default Access to quickbooks - looking for consulting help

On May 26, 9:46*am, "Mark Andrews"
wrote:
I'm looking to pay for some consulting help from someone with knowledge of
Quickbooks and specifically
creating an iif file for importing data into Quickbooks.

I have software that is used for collecting donations and the user would
enter a batch of donation (say 20 donations) and then click a button in my
Access database to create an iif file which they could import into
Quickbooks.

Hoping to just get an hour or couple hours of help to figure out the exact
format needed of the iif file. *I'm fine with doing the work to make the
file myself just looking for someone with some Quickbooks knowledge to
quickly get me there. *I just purchased Quickbooks but have never used the
product.

If interested jump over to my web site and send me an email with your hourly
rate and provide a brief history of how you have used Quickbooks.

Thanks,
Mark Andrews
RPT Softwarehttp://www.rptsoftware.comhttp://www.donationmanagementsoftware.com


A decade ago when I had to create such a file from a totally automated
e-commerce application, I manually exported the files from Quickbooks
into something like Tab Delimited format in order to view their
schemata. That gave me all the information I needed to create proper
import files from Access. Sadly, the import of the files into
Quickbooks part was not automated, but that was not much of a burden
for the administrator. I don't know if Quickbooks can be automated or
not from Access.

James A. Fortune

  #3  
Old May 27th, 2010, 09:01 PM posted to microsoft.public.access
Daniel Pineault
external usenet poster
 
Posts: 658
Default Access to quickbooks - looking for consulting help

Mark,

I would scrap the idea of create an intermediary file (iif file) and use
QB's SDK to create a direct link. This avoids, creating a file (one more
thing your users could mess around with ...) and the need to have the user
perform import operations altogether.

The SDK comes with several examples and if you require further help, QB has
a decent forum. You could always contact me through my website (since this
newsgroup will soon be a thing of the past) and I'd be more than willing to
guide you as best I can. Be sure to download the SDK for the QB version you
are working with (2007...2010, US...CAN)!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Mark Andrews" wrote:

I'm looking to pay for some consulting help from someone with knowledge of
Quickbooks and specifically
creating an iif file for importing data into Quickbooks.

I have software that is used for collecting donations and the user would
enter a batch of donation (say 20 donations) and then click a button in my
Access database to create an iif file which they could import into
Quickbooks.

Hoping to just get an hour or couple hours of help to figure out the exact
format needed of the iif file. I'm fine with doing the work to make the
file myself just looking for someone with some Quickbooks knowledge to
quickly get me there. I just purchased Quickbooks but have never used the
product.

If interested jump over to my web site and send me an email with your hourly
rate and provide a brief history of how you have used Quickbooks.

Thanks,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

.

  #4  
Old May 28th, 2010, 01:37 AM posted to microsoft.public.access
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Access to quickbooks - looking for consulting help

My application is used by many users who I don't know and have no control
over how things are setup on their computers.
I also don't have control over what version of quickbooks they are using.

My export and import into quickbooks would be like a once a week thing.

I found a website that creates iif files and think I am just going to dig
into the example iif file I have and try and reproduce it in the same
format. It does customers, Income accounts, classes and sales receipts all
in one file.

For some reason that seems much easier and less error prone to me (I could
be wrong).
I just write a routine to make a text file using the right format.
The user takes the file and imports it into quickbooks.

So no setup of any kind and the user just needs to know how to choose
file/utilities/import/iif files... and pick the file.
Also no extra libraries in the application etc....

Thanks for everyone's input!
Sorry if I am too set in my ways,
Mark





"Daniel Pineault" wrote in
message ...
Mark,

I would scrap the idea of create an intermediary file (iif file) and use
QB's SDK to create a direct link. This avoids, creating a file (one more
thing your users could mess around with ...) and the need to have the user
perform import operations altogether.

The SDK comes with several examples and if you require further help, QB
has
a decent forum. You could always contact me through my website (since
this
newsgroup will soon be a thing of the past) and I'd be more than willing
to
guide you as best I can. Be sure to download the SDK for the QB version
you
are working with (2007...2010, US...CAN)!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Mark Andrews" wrote:

I'm looking to pay for some consulting help from someone with knowledge
of
Quickbooks and specifically
creating an iif file for importing data into Quickbooks.

I have software that is used for collecting donations and the user would
enter a batch of donation (say 20 donations) and then click a button in
my
Access database to create an iif file which they could import into
Quickbooks.

Hoping to just get an hour or couple hours of help to figure out the
exact
format needed of the iif file. I'm fine with doing the work to make the
file myself just looking for someone with some Quickbooks knowledge to
quickly get me there. I just purchased Quickbooks but have never used
the
product.

If interested jump over to my web site and send me an email with your
hourly
rate and provide a brief history of how you have used Quickbooks.

Thanks,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.