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:
Patient Encounter for HanDBase Patient Encounter for HanDBase - This software is perfect for the Medical Student or Resident in Medicine. It allows one to keep a record of all experiences one participates in during ones clinical experiences. This applet was originally designed for the new Florida State University School of Medicine. With the exception of a few minor fixes, this is the final product
Field Information Tracking for HanDBase Field Information Tracking for HanDBase - Tool for tracking field contacts. Cleaned up a little and added new age at time of contact feature. If you contact this person, then just enter data normally, using popups for gang, height, weight, eye color, hair color, etc. After you enter dob, it will show accurate age at time of contact
Life or Something Like It for HanDBase Life or Something Like It for HanDBase - A set of linked tables to track many of the sorts of things you need to know (phone numbers, passwords, car info, dog vet records, etc.). This started out when I tried Brian H Maskell's "My Life". But that set of tables was just too much. I either modified or recreated several of those tables, and added my own
LDS Tithing for HanDBase LDS Tithing for HanDBase - Quickly and easily keep track of your tithing: where you earned your dollars, the date and if you've paid. It will also automatically calculate the total unpaid amount by using the filter. The applet is fully customizable so you can add fields or change them as you see fit. I hope you find it useful. I welcome any suggestions or comments
Louis L'Amour Books for HanDBase Complete listing of Louis L'Amour books that can be used for tracking a collection, looking up descriptions of stories, etc
PunchCard Calc for HanDBase PunchCard Calc for HanDBase - Keep track of employer record, punch card ins/outs and calculate weekly hours and gross pay (reg. & overtime). Total hours field in PC-week has to be entered manually after entering the daily ins/outs. You should enter daily data in chronological order to maintain consistency with cumulative total hours
Cnd City for HanDBase Cnd City is a HanDBase applet of 1600 cities in Canada by provinces for the business traveler
Software Keys for HanDBase This applet provides a simple utility to store license key information for software applications
Xena Episode Guide for HanDBase Xena Episode Guide for HanDBase - Xena Episode Guide updated through Season 5, Episode 8 - "Little Problems." Complete guide to actors, characters, writers and directors for all episodes of Xena: Warrior Princess including the original HTLJ Warrior Princess Trilogy
Pediatric Advanced Life Support for HanDBase Pediatric Advanced Life Support for HanDBase - Pediatric Advanced Life Support, based on the 2005/6 update. Algorithms include Bradycardia, Tachycardia and Pulseless arrest. Also included are the Rapid Sequence Intubation meds and drip rate calculators, PALS toxins, seizure, hyperkalemia
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
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
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)
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
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
Real Estate for HanDBase Basic applet for Realtors and/or prospective buyers to keep track of houses and properties
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