|
|
|
|
|
|
|
|
|
|
|
|
|
|
PROGRAMMING POWER
Managing expenses with Palm and Notes
By Mick Moignard
Filling in expense forms is a pain. Even if you use a spreadsheet to fill in the forms, it's still a pain. You have to try to remember what all those receipts jammed in your wallet were for, find the notes you made of all the mileage that you've traveled, and then write up a claim form from it all. And if you have to do it in multiple currencies, as well, it just gets too hard. Fortunately, I managed to crack this whole problem using a Palm IIIc, the Pylon Conduit, and some Notes development. In this article, I'm going to show you how you can do it too. While this Programming Power article is ideal for Notes and Domino users, it'll provide insights into development techniques for all you techies out there.
All I do now is make a quick entry on my Palm device when I incur an expense and keep the receipt. I HotSync my Palm device and then create a regular Unipart (my employer) company expense form in Notes. It takes just a few clicks before it's ready to sign. I then attach the receipts and submit. And it's always right the first time. Since I developed this application, I have submitted over 15,000 UK pounds (maybe $25,000) of expenses with it over about 16 months, and I haven't had one single claim rejected.
So how does it work?
The starting point is the standard Palm Expense application. You can use this to enter expense items, as shown in Figure A, right at the point where they happen.
FIGURE A
The Palm Expense application records your expense items.
By tapping on Details, you're taken to the Receipt Details screen, pictured in Figure B, where you can add more information regarding each Expense.
FIGURE B
On the Receipt Details screen, you can add more information.
The only thing I do differently is that I use the Vendor field to write a word or two of description if I feel I need to. As you will see later, this is entirely optional.
You should then HotSync your Palm device with your computer (I HotSync with my ThinkPad) using Pylon Conduit from what used to be Globalware. That company is now part of Avantgo, and you can find Pylon Conduit at http://chicago.avantgo.com/home/home.html. You don't need the whole PylonPro product, the standard Pylon Conduit will do.
You should then configure Pylon, as shown in Figure C, to synchronize expenses with a separate Notes database, rather than with your mail.
FIGURE C
 
Here's the Pylon configuration for Expenses in my personal address book. Roll over picture for a larger image.
Pylon creates and synchronizes one Notes document in this database for each entry on your Palm device. When you're ready to make a claim, you just go into the Notes database, select the items you want, recalculate them to work out mileage and currency conversions, and then make a claim from them, as shown in Figure D.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
ONLINE GROUP CALENDAR - FOR UP TO 100 OF YOUR CLOSEST FRIENDS
Stay organized and in control with 24/7 access to all of your important events, projects and files --whether you're at work, at home or on the road.
You can share your calendar, projects and files so everyone in your office is up to date. Plus, search your entire group to find times when everyone is available to meet, manage company resources and much more.
Organize your entire team for as low as $9.95 per year (and yes, that's where the decimal place is supposed to be!)
Tap here to get started right away. |
-- Advertisement --
Write for Computing Unplugged!
Share your experience and expertise with other handheld device users. There are new opportunities at ZATZ for contributing authors and editors.
Write about something you're an expert on and get your name in lights.
For Writers' Guidelines and to discuss topics, contact Staff Editor Steve Niles. This is your opportunity to shine in front of your peers, your clients, and friends.
Click for more info! |
|
|
|
|
|
|
|
|
|
|
