Universal Data Model for FileMaker One way to approach the data structure of an inventory management system is to use concepts from the Universal Data Model (UDM). The premise behind the model is that entities that have many of the same attributes may be combined to create one table instead of multiple tables. I think […]
(Ed. note) If you haven’t been following Danial Shanahan’s Inventory Resources website, you are missing out on a lot of free, great methods for handling a myriad of inventory challenges. Here’s the latest from Daniel: Acceptable Levels of Goods Received What if you bought apples buy the US ton? You’d expect your supplier to deliver 1 […]
Inventory Magic: Product Variants If you’ve ever tracked inventory in any system, you may have run across the scenario where you’d like to add another record that is just slightly different from an existing record – also known as a product variants. Take the example of shirts. You may have a medium, white, short sleeve, […]
Units of Measure Can you imagine filling out a sales order for 7 butters? 7 butters doesn’t make any sense. It would need to be 7 ounces of butter or 7 packs of butter or 7 cases of butter. Ounces, packs, and cases are all examples of units of measure. When working with inventory, there […]
FileMaker Inventory Resources When I started developing in FileMaker full-time I soon acquired a customer who wanted an inventory management system. I didn’t know that at the time. I knew he wanted to keep track of camera kits that his company rents out. Not long after that I spoke with a distributor who needed to […]
Grid Tool for FileMaker Pro 12 – YouTube. Daniel Shanahan, New Leaf Data.
Lee Smith: Where do you find the sample files? Every link I clicked here is like a loop.
Daniel Shanahan: Hi Lee, Sorry about that. The form on the website was incorrect. It should work now. Once you fill out…