What kind of inventory are you doing?
This has worked wonderfully for me in the past. http://www.ptshome.com/pocketpc_tracerpluspro.htm --- On Sun, 8/10/08, MB Software Solutions General Account <[EMAIL PROTECTED]> wrote: > From: MB Software Solutions General Account <[EMAIL PROTECTED]> > Subject: Need for handheld scanner app > To: "ProFox Email List" <[email protected]> > Cc: "MB Software Solutions Support Team" <[EMAIL PROTECTED]> > Date: Sunday, August 10, 2008, 2:16 PM > I've got a great client of mine for years who wants me > to expand one of > my software's that I did for him years ago to hook into > a new inventory > system he wants me to write. > > I'm a bit busy at present but this guy is very > accommodating for my > schedule. Nonetheless, I wondered if anyone here was > interested in > writing the handheld scanner app to do what we need. I can > write the > other stuff. I'd *REALLY* love to use Christof's > Guineo project (see > http://guineu.foxpert.com/) or even Dabo > (http://www.dabodev.com), but > of course will allow DotNet or others for consideration. > The important > thing is that it work well on the handheld scanner within > the existing > environment. > > It's VFP9 dbc-contained tables at present. I had > pitched the idea to > him of letting me upsize it to MySQL as I've done for > the apps I > designed for him the last 4 years, but not sure if > he'll go for that or not. > > Here's the doc on it so far: > ****************************************************************** > > Inventory System Profile: > > 1.Using Hand Held Scanners with data input > 2.Bar Code Labels: Attached to bundle > 3.Enter Lumber Received: Into scanner then transmitted to > the computer > 4.Enter Lumber Consumed: Scan bar code label for bundles > being removed > from inventory and put on the saw lines for cutting > 5.Enter Lumber moved from one location to another > 6.Inventory Inquiry: Specific screen views of inventory > items showing > data, pieces, board feet and totals so we can schedule > cutting and make > and other decisions > 7.Inventory Maintenance: Add, Change, Delete to adjust or > correct inventory > 8.Reports: Specific reports for information and decision > 9.Physical Inventory process > > NOTE: The inventory system profiles above is only for long > length and > precut that we buy. At this time, I am not considering an > inventory of > the cut to length lumber. I feel this would be the next > step and will > use the same database and programs for long length. > > > Inventory Data Base Elements: > > Master File Lists of Required Information: > Lumber Species Locations Suppliers > Size W x H x L Hardwood Cants Deer Park > Type Cant Bass Boards Cornerstone > Board Hemlock Precut RGM > Precut Pine Random Kheops > BF Per Piece ##.## Eucalyptus Plateau Beaver Springs > Cost Per BF Aspen Etc. Etc. > Per Piece Poplar > > Michael: The Lumber and Suppliers can come from the Lumber > Tracking > program (*** THIS IS THE EXISTING VFP APP ***) > > > Inventory Daily Processing: > > When we receive lumber from a supplier – Suggested Entry > Routine on the > Scanner > 1.Select Supplier > 2.Select Size > 3.Select Species – Hardwood is the default > 4.Enter Date – today’s date is the default > 5.Enter quantity > 6.Enter Location – Can agree on default location > 7.Enter Comments if needed > > Then > Staple on bar code > Scan the bar Code > > > When we consume lumber for cutting - Entry Routine for > Lumber Cut > 1.Scan Bar Code Label – Computer deducts inventory based > on the bar code > number > > > Inventory Record - Example > 1.Size 3 1/2x6x10 > 2.Type Cant > 3.Species HW > 4.Supplier Deer Park > 5.Date Received 07/24/08 > 6.Quantity 42 > 7.Location Cants > 8.BF Per Piece 17.5 > 9.Total BF 735 > 10.Cost per BF $0.37 > 11.Comment Say up to 50 characters > 12.Bar Code Label Number > > Screen Inquiry: > 1.By size showing all inventory record(s) for that size. > Be able to > sort the screen view by Supplier, Species, Date, Location, > Comments > 2.Select by one size or a range of sizes > > Reports: > 1.Report of what is in inventory by item with costs > 2.Inventory valuation report > > Physical Inventory: > 1.Count sheets for quarterly inventory > 2.Make adjustments for actual physical counts > > ****************************************************************** > > If you're interested, email me offline and we'll > discuss. > > THANKS! > --Michael > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: > http://leafe.com/mailman/listinfo/profox > OT-free version of this list: > http://leafe.com/mailman/listinfo/profoxtech > Searchable Archive: http://leafe.com/archives/search/profox > This message: http://leafe.com/archives/byMID/%(listmsgid)s > ** All postings, unless explicitly stated otherwise, are > the opinions of the author, and do not constitute legal or > medical advice. This statement is added to the messages for > those lawyers who are too stupid to see the obvious. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/%(listmsgid)s ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
