dahkter Posted August 18, 2004 Share Posted August 18, 2004 Hello, I know there are some sharp computer people on this forum, possibly someone can lend a hand. Is there a program or method in Microsoft Office that can create and manage Purchase orders? Not sure if good old Excel can handle all of this or if I need some additional program like MS Access to put it all together. Thanks for any input, I've been entering data the old fashioned way and it's really eating into my family (and music) time. Hoping to get things running more efficiently without digging too deep into heavy computer languages and programming. Appreciate it, Dahkter PS - done the google thing (too many returns) and the MS website sucks to navigate. Possibly someone has some experience of business organization with the regular MS office suite. Option of buying new software is a bit slim too. Thanks again Link to comment Share on other sites More sharing options...
Dak Lander Posted August 18, 2004 Share Posted August 18, 2004 Go HERE! It ain't that hard to navigate the site. Just look at the different templates and choose the one you want. I've used a couple of Microsoft's templates and they work very well, and are easy to customize. Our Joint "When you come slam bang up against trouble, it never looks half as bad if you face up to it." The Duke... Link to comment Share on other sites More sharing options...
zeronyne Posted August 18, 2004 Share Posted August 18, 2004 You can do it in Excel, but I'd highly recommend Access or some other db if you need it to be robust. "For instance" is not proof. Link to comment Share on other sites More sharing options...
Lee Flier Posted August 18, 2004 Share Posted August 18, 2004 dahkter, when you say you're "entering data the old fashioned way" what do you mean exactly? What would you like your PO system to be able to do? Link to comment Share on other sites More sharing options...
dahkter Posted August 18, 2004 Author Share Posted August 18, 2004 Hi All, Lee - hope NY and the Little Steven festival treated you nicely!!! Anyway, back to the story. At this point I type in data on a global spreadsheet with thirty tabs sorted by customer. I'd like to have one area to enter info and have it automatically go out to the thirty tabs. This would be easy if I had only one order, but for orders 2-2000 not sure how I can keep everything updated. Basically looking to get info in, assign it a #, be able to manipulate it, then be able to close it out.... Sorry if too vague and thanks again for the writings, Dahkter PS - Zeronyne - I think you have it, database looks to be the key word and solution here... Link to comment Share on other sites More sharing options...
Lee Flier Posted August 18, 2004 Share Posted August 18, 2004 Originally posted by dahkter: Hi All, Lee - hope NY and the Little Steven festival treated you nicely!!!Oh man, it was awesome! Been wanting to do a little writeup about it, but haven't had the time yet, still catching up on stuff. Anyway, back to the story. At this point I type in data on a global spreadsheet with thirty tabs sorted by customer. I'd like to have one area to enter info and have it automatically go out to the thirty tabs. This would be easy if I had only one order, but for orders 2-2000 not sure how I can keep everything updated. Basically looking to get info in, assign it a #, be able to manipulate it, then be able to close it out.... Ahh... yeah you really need to have a database to do that. Excel ain't gonna cut it. If you have Access I might be able to set ya up with a little somethin... seeing as I am a database apps programmer and all. Email me if you want. Funny thing, that is exactly how I became a database apps programmer... from trying to do everything in Lotus 1-2-3 spreadsheets and BASIC. Link to comment Share on other sites More sharing options...
dahkter Posted August 18, 2004 Author Share Posted August 18, 2004 Hi Lee, Thanks for the friendly info, and yeah you should definitely put together a few sentences about your trip, would be nice to read. I'll do some research into database applications, are there any good books or websites that I could look at to demystify the process? At least now I have a better idea at what I'm looking at, thanks everyone Later Dahkter Link to comment Share on other sites More sharing options...
deanmass Posted August 18, 2004 Share Posted August 18, 2004 Quickbooks Lite www.intuit.com Link to comment Share on other sites More sharing options...
Steve Force Posted August 18, 2004 Share Posted August 18, 2004 I second the Quickbooks suggestion. Steve Force, Durham, North Carolina -------- My Professional Websites Link to comment Share on other sites More sharing options...
Lee Flier Posted August 18, 2004 Share Posted August 18, 2004 Yeah, Quickbooks is great. I thought dahkter said he doubted he could buy any new software. But if you're running a small business, it really is the way to go. Link to comment Share on other sites More sharing options...
dahkter Posted August 18, 2004 Author Share Posted August 18, 2004 Sounds very interesting, I'll definitely take a look at the intuit site, thanks... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.