Keeping track of inventory data is a monumental task. And there are plenty of tools to help organizations. Tools range from enterprise systems for large organizations to pre-made solutions accessed via the web (Software as a Service or SaaS), which might be perfect for small businesses. Of course, not all companies fit into these two categories. Fortunately, there are a number of rapid application software platforms that can be used to affordably create custom inventory solutions.

One of those tools is the FileMaker Platform. The software has been around since the early 80’s, having been owned by both Microsoft and Apple (at different times, of course). The FileMaker platform runs on Windows, Mac, iOS (iPhone, iPod, and iPad) as well as the web. It is currently a subsidiary of Apple.

This site is a collection of articles on building Inventory Management Systems (IMS) with the FileMaker Platform. It is written specifically for two primary groups:

  1. Citizen developers (e.g. business owner, operations manager, IT director, etc.) who want to use FileMaker’s ease of use and rapid development environment to create their own IMS.
  2. FileMaker Pro developers who haven’t yet built an IMS.

Check out the supporting videos on New Leaf Data’s YouTube channel. Make sure to subscribe to be notified of new videos.

Articles

Inventory Types
6 common inventory management types.
Read More
Inventory Processes
A succinct list of the processes within an inventory management system.
Read More
Quantity Fields
5 common inventory quantity fields.
Read More
Receiving Goods
5 ways in which your organization might receive goods.
Read More
Bill of Materials
A Bill of Materials is a recipe for creating other products.
Read More
Kitting
Kitting is the process of taking finished goods and bundling them together to make a new product offering.
Read More
BOM Tree
A Bill of Materials (BOM) tree structure that enables users to see all products components at once.
Read More
Lots and Batches
A discussion about product that is created in lots (or batches).
Read More
Serial Numbers
How to handle product serial numbers
Read More
The Purchasing Process
8 Scenarios you may experience with Purchase Orders
Read More
Transactions
Creating a life cycle for your inventory
Read More
Updating Inventory Quantities
Methods for updating inventory quantities
Read More
Transferring Inventory
Tracking internal inventory movements
Read More
KPIs
More than just for dashboards
Read More
Unit of Measure
Understand the meaning of item quantities
Read More
FMP Inventory Starter Solutions
Inventory Starter Solutions from FileMaker Pro v11-15.
Read More
Variants
Creating product variants in FileMaker Pro
Read More

Files

Purchase Order Process
Purchase Order Process demo file in FMP 15.
Read More
Purchase Order Process v2
A technique for receiving from multiple tables.
Read More
IMS Data Model
A Data Model PDF document of an Inventory Management System (IMS).
Read More
Updating Inventory Quantities
A zip file of 6 FileMaker Pro files that demonstrate various methods for updating inventory quantities.
Read More
Demo File - Unit of Measure
A demo file to support the Unit of Measure article.
Read More
Variant-Demo
A demo file to support the Variant article.
Read More

Updates and Downloads

Keep updated on new articles, videos, and files by joining the newsletter list. A monthly newsletter is scheduled for the 4th Monday of the month. Download links for the files on this site are sent via the welcome email. If you didn't receive your welcome email after submitting this form, please contact me at daniel@newleafdata.com

Your emails are never shared.

  • Should be Empty:
  • Can you write about...

    Do you have requests for future articles? Fill out the form and I'll do my best to address the issue in an upcoming article.

  • Should be Empty: