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.
