 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / August 2005Accounting
Anybody had experience with the commerical (or open source) Access based accounting packages out there. I'm looking to replace a small business accounting package (Peachtree) that I can't customize enought to do what I need Take a look at what Tony Toews has at http://www.granite.ab.ca/accsacct.htm  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Anybody had experience with the commerical (or open source) Access based > accounting packages out there. > > I'm looking to replace a small business accounting package (Peachtree) > that I can't customize enought to do what I need > Take a look at what Tony Toews has at http://www.granite.ab.ca/accsacct.htm He has a nice long list. I wonder how many of them provide source code and for what added cost?? Bob If you provide him with that information, he might well want to add it to his page. -Tom. >> Take a look at what Tony Toews has at http://www.granite.ab.ca/accsacct.htm >> >He has a nice long list. I wonder how many of them provide source code >and for what added cost?? > >Bob I alread looked at this list -- it's pretty old. Most of the software listed hasn't been updated for a year or two. The demos I downloaded were'nt much help That's why I asked if anyone has personal experience > Take a look at what Tony Toews has at > http://www.granite.ab.ca/accsacct.htm [quoted text clipped - 4 lines] >> I'm looking to replace a small business accounting package (Peachtree) >> that I can't customize enought to do what I need >I alread looked at this list -- it's pretty old. Yup. If you know of any new ones please let me know and I'll add them. Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm >Anybody had experience with the commerical (or open source) Access based >accounting packages out there. > >I'm looking to replace a small business accounting package (Peachtree) that >I can't customize enought to do what I need Have any of you tried to export into Quickbooks? We have had quite a few requests from clients and get many inquiries from potential ones to get data from our lodge software into Quickbooks. Our application basically just tracks revenues. I have no idea how to do this. I have also thought about offering a 3rd party accounting system as a module they could purchase (would have to be customizable most likely), but QB seems to be the way to go (although we aren't big fans of QB, especially because of their expensive and required web only updates, etc....). I will certainly check into the ones listed at this web site. I don't see any advertised any more in Access Advisor (just FMS tools). -pw use paulwilliamson at spamcop dot net for e-mail Yes I have experimented with Quickbooks Pro The problem is, like Peachtree, it gets me 80% there and there is no way to customize some of the forms or add some of the fields I need in invoices, quotes, etc. Like Peachtree, Quickbooks appears to be set up for a products (inventory). I sell services and need a system the recognzies this and allows me to customize it. >>Anybody had experience with the commerical (or open source) Access based >>accounting packages out there. [quoted text clipped - 20 lines] > > use paulwilliamson at spamcop dot net for e-mail QB provides for the ability to import transactions. See the help file "importing data, IIF file format" for information on the file format. However the client needs to run the File - Import menu option from QB. Steven Zuch <snip> > Have any of you tried to export into Quickbooks? We have had quite a > few requests from clients and get many inquiries from potential ones > to get data from our lodge software into Quickbooks. Our application > basically just tracks revenues. I have no idea how to do this. That's one option, but QB now promotes a more direct xml-based option. They have an SDK with the details. -Tom. >QB provides for the ability to import transactions. See the help file >"importing data, IIF file format" for information on the file format. [quoted text clipped - 8 lines] >> to get data from our lodge software into Quickbooks. Our application >> basically just tracks revenues. I have no idea how to do this. The SDK for Quicbooks works well and is a free download from the Intuit site. An excellent product for working with Peachtree data can be found at: http://www.multiwareinc.com/pawcom.htm I have found both to be excellent for getting data in and out of Access and/or Excel. > That's one option, but QB now promotes a more direct xml-based option. > They have an SDK with the details. [quoted text clipped - 13 lines] > >> to get data from our lodge software into Quickbooks. Our application > >> basically just tracks revenues. I have no idea how to do this. Tom, Thanks for the info. When you say direct, does that mean the end-user does not need to import the file into QB? If all they are doing is changing the format of the import file from IIF to XML, from an end-user point of view, why would they care? Steven > That's one option, but QB now promotes a more direct xml-based option. > They have an SDK with the details. [quoted text clipped - 13 lines] >>> to get data from our lodge software into Quickbooks. Our application >>> basically just tracks revenues. I have no idea how to do this. Correct. There is more to it than that. Happy studying the SDK. -Tom. >Tom, > [quoted text clipped - 25 lines] >>>> to get data from our lodge software into Quickbooks. Our application >>>> basically just tracks revenues. I have no idea how to do this. Hi Paul ! How do you do? tell me what do you want to customize in Peachtree (which is not available in it). I am programmer of VB, ACCESS and EXCEL. Take care Bye MASQ. > Anybody had experience with the commerical (or open source) Access based > accounting packages out there. > > I'm looking to replace a small business accounting package (Peachtree) that > I can't customize enought to do what I need Basically I resell services at an hourly or daily rate to large defense contractors. I need the customize invoices to show dates and hours worked. I need to customize the time tracking feature so I can pay subcontractors based on the time entered in the time tickets. I need to have additional fields in the inventory tracking that are unique to labor, not material. I used to be a programmer (a long time ago) and have written a few VBA access programs, so I figured Access would do what I want. My evaluation of some of the commercial MS access programs ( People's Choice, etc.) doesn't impress me so far. I also looked at Microsoft's newsmall business accounting. Very disappointing. It's a warmed over version of Quickbooks > Hi Paul ! > How do you do? tell me what do you want to customize in Peachtree [quoted text clipped - 10 lines] >> that >> I can't customize enought to do what I need Paul, Don't know how you are keeping track of your time tickets but why not A.) Build an application in Access to keep track of the time. B.) Use pawcom (for Peachtree) to post the time/billing data from Access to Peachtree. This way you can use all the accounting features of Peachtree but customize your billing in the Access application. I thought of that, but it requires me to fool around with 2 program. And it doesn't help the poor choice of fields for incoices and payments to subs I was trying to find an canned Access program that was close and provided the source code so I can create the forms and reports I need > Paul, > [quoted text clipped - 7 lines] > This way you can use all the accounting features of Peachtree but > customize your billing in the Access application. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.