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:
GeoCache Pro for HanDBase GeoCache Pro for HanDBase - GeoCaching has been around for a while, but I was just turned onto it recently. This applet makes it very easy to track, log, and help in the very mobile hobby of GeoCaching. For more info on GeoCaching try this website, then use my applet to get you organized!
Ease of navigation, and mobility of a pda makes this a useful tool in geocaching
Aromatherapy for HanDBase Aromatherapy for HanDBase - Over 60 Aromatherapy Recipes including bath salts, inhalation, household usages, and mood enhancers, to name a few. Will continue to add more in the future.
If you are new to Aromatherapy, take some time to browse the web for useful information on the types of oils, usage, carrier oils, etc., and most importantly, the do and do nots
OB Log for HanDBase OB Log for HanDBase - Allows for easy input and tracking of obstetrical patients. Gestational age doesn't update until you select the record. When viewing in the list view, you may want to put the EDD in the first few fields and the weeks and days fields to the end so as not to be confused
Project Assignments for HanDBase Project Assignments for HanDBase - Simple database for tracking assignments for any project. The applet is much better than the TO-DO list, because it allows you to track your own work as well as the work of others. I use this applet to keep track of what I've been assigned and what I need to do to complete each assignment
CustomerNumber CustomerNumber - This program allows you to assign a number to each of your customers. When a customer gives you their number you can view the profile card for the customer.
This program requires that you have both the 'BeanDLL.dll' file ** and ** the runtime files for Visual Basic on your PocketPC computer
Special Events for HanDBase Special Events for HanDBase - Simple Applet to allow you to track the number of days till that special event. Tells you how many days you have to procrastinate! I hope this will be useful, but try to use it to help you get things done not to put them off. Have fun
Type II Tracker for HanDBase Type II Tracker for HanDBase - Applet to track Blood Sugars and other issues as you manage your type II diabetes. Enter Blood Sugar test, select check box if test was after fasting (most of mine are). Activity and Comment fields included as note types to enter information like exercise, lab test results, medication changes, etc
IUSM MS3 Skills Checklist for HanDBase IUSM MS3 Skills Checklist for HanDBase - This is a checklist of the Basic Clinical Skills listed in the Indiana University School of Medicine Third Year Procedures Log Book. I made this to use along with the iusm_procedures.pdb that is also listed on this website
Bowling League Score Tracker for HanDBase Bowling League Score Tracker for HanDBase is for league bowlers to keep track of their progress throughout the league season. Just input the date and week number along with your scores for each of the 3 games for that week and Bowling League Score Tracker will keep track of your stats
Other Software by developer «Dave Haupert»:
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
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)
Cases for HanDBase Cases for HanDBase - Keep track of trials and cases with this Database. Could be useful for Attorneys, Judges, and law enforcement personnel.
This is a good starting point for using this in your case-tracking work. There is a database for keeping a listing of Judges, one for Attorneys, and also a linked action list to keep track of what was done, and what's left to do
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
Real Estate for HanDBase Basic applet for Realtors and/or prospective buyers to keep track of houses and properties
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
