Platforms: Symbian OS, Pocket PC, Palm, Series 60, BlackBerry, Smartphone
Categories: Databases
Upload date: 20 Sep 11
Developer: Dave Haupert
License: Freeware
Downloads: 86 File Size: 8 Kb
Orders for HanDBase - Order entry applet using multiple groups of DB popups.
There are three files in this archive: orders.pdb, accounts.pdb, and products.pdb. All three are used for this applet. Here's how it works: Accounts.PDB - has accounts info- ie, your customers, their account number, their price rate, which is a discount rate that you could set for each customer. For example, a company might receive a 20% discount off the price, so this value would be 0.80. Products.pdb - information about each product you are selling, including product numbers, prices, description, etc. Orders.PDB - the main entry point once everything is set up. Open orders.PDB and add a record. You can choose the customer making the purchase by either writing in the value or, better yet, selecting the customer popup, where you will be taken to the Accounts database and you will be able to select one from the existing accounts. This will also bring over the account # of this customer. You can now fill out the quantities for up to 3 items (which was all I could fit in the 30 fields with all of the other stuff), and select the product by pressing the Item x Desc field and selecting the product from the Products database. The price will come over and be factored in along with the quantity, and the 'discount rate' or 'price rate' as it is in the accounts database is factored as well. At the bottom the tax is calculated, which I put in at 6%, which is Florida's rate, but you can easily modify this by adjusting the Tax field property, and a total is given. I hope this is a useful starting point for you. If you need more products to be purchased, you can either take away some of the other extraneous fields and try to squeeze one or two more in, or redesign the database as follows: Make each record be part of an order. You can use the new 'prev record' calculated fields to keep a running sum. Then you can use the Filters to limit the view to the current customer's current order only, and have a good subtotal!
Like it? Share with your friends!
If you got an error while installing Themes, Software or Games, please, read FAQ.
Requirements:HanDBase v.2.7x or greater
Supported operating systems:
Palm OS 3.x, Palm OS 4.x, Palm OS 5.x, Pocket PC 2002, RIM BlackBerry OS 4.2, RIM BlackBerry OS 4.3, RIM BlackBerry OS 4.5, RIM BlackBerry OS 4.6, RIM BlackBerry OS 4.7, RIM BlackBerry OS 5.0, RIM BlackBerry OS 6.0, S60 1st Edition, S60 2nd Edition, S60 3rd Edition, S60 3rd Edition FP1, S60 3rd Edition FP2, S60 5th Edition, Windows Mobile 2003, Windows Mobile 2003 Smartphone, Windows Mobile 5.0, Windows Mobile 5.0 Smartphone, Windows Mobile 6 Classic, Windows Mobile 6 Professional, Windows Mobile 6 Standard, Windows Mobile 6.1 Classic, Windows Mobile 6.1 Professional, Windows Mobile 6.1 Standard, Windows Mobile 6.5 Professional, Windows Mobile 6.5 Standard
Similar Software:
Day Calculator for HanDBase Day Calculator for HanDBase - This will calculate the "Julian Day" for any date and will work for any valid Julian date. Calculating this number enables the user to find the number of days between 2 (or more)dates
BetaTest for HanDBase Applet template from which to maintain developer-specific beta testing issues
Easy Mileage Tracker for HanDBase Easy Mileage Tracker for HanDBase - Another one of my attempts to make things SIMPLE. I made this database to satisfy employers and the IRS. Date, destination, odometer start, odometer end. Mileage calculates automatically. "For" field lets you keep track of whom you're driving for that day
Law & Order Episodes for HanDBase Law & Order Episodes for HanDBase - Track Law & Order episodes for all spin-offs: Original, Special Victims Unit, Crimminal Intent, Crime & Punishment and Trial By Jury. Make it easy to keep track of episodes viewed, great for filtering your TiVo against the hundreds of repeats airing on various channels
HBMoney for HanDBase HBMoney for HanDBase - Small applet to help you balance your check book and keeps track of your checking account by showing all the transactions been made to that account. I added Four more buttons to this applet allow you to go to next , last, previous and first record of your data base from within the form, its much easy to have everything you need on the form
Yellow Pages for HanDBase Yellow Pages for HanDBase - Applet consists of Yellow Pages, Business Contacts and Departments databases linked to one another. Yellow Pages extends the usual phone application that comes with your cellphone by allowing you to record the contact phone numbers of departments within individual business locations of a major business
Xbox 360 Game List for HanDBase Xbox 360 Game List for HanDBase - This database will allow you to keep track of your Xbox 360 games. Support for Tracking Achievements, Xbox Live Arcade Titles, and Disk based games.
This was something I created so I could keep track of My Collection. Updated Version. You will know what your Achivement Point percentege per game
HoliDates UK HoliDates UK is a calendar application that not only adds holidays to your Palm OS device, but allows you to see upcoming, past and distant future holidays all in one place. Even if you already have some holidays within your Date Book, this feature is worth the price alone. No more having to go through your Date Book one day at a time to see what's coming up next month
Weather Tracking for HanDBase Weather Tracking for HanDBase is the preliminary version of a paid project. Weather Tracking was written with HandBase V3.0i and its companion forms utility. The applet consists of one parent database and five child databases. The relational, db-popup and calculated field types are used throughout the applet
Other Software by developer «Dave Haupert»:
Password Manager for HanDBase Password Manager for HanDBase - Keep track or all of your passwords, account numbers, logins, etc.
If you are searching for a certain item, you can set the 'Type' filter to show only the type of account you are looking for
Time Log for HanDBase Time Log for HanDBase - Keep track of the projects you are working on. Lots of room for customization in this one! You can change the 'Charge to' field to be a DB Popup, and have it point into a database of customers you may have. You could add in a rate calculation and have it figure out the rate charged by calculating (rate * duration)
Phone Calls for HanDBase Phone Calls for HanDBase - Keep track of your messages, and phone calls. Good one to customize to suit your needs. If you are using the Addresses database for your phone book, you could change the name field, and/or the phone field to be DB Popups looking into the address book
Recipes for HanDBase Recipes for HanDBase - This is a great way to jot down a recipe when you are over a friend's or relative's house and like something they are making! It requires very little handwriting, as most of the popup's have useful values defined already
Real Estate for HanDBase Basic applet for Realtors and/or prospective buyers to keep track of houses and properties
Teacher's Aid for HanDBase Teacher's Aid for HanDBase - Database for keeping track of students. This is a good starting point for teachers to use for tracking students. You first define your students, by opening the Teacher's Aid database, with their related info, and then you can take attendance and track test and homework scores with it
Archery for HanDBase Archery for HanDBase - Archery scoring system. This is a good demo of how to do some fancy calculations using the basic calculations available. The program will let you enter the three scores, and HanDBase will automatically calculate which values are non-zero and total the # of hits. It also keeps a running total, and also a score for that round
