Jump to content

Inventory Control


This topic is 5646 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Greetings all! I just found FileMaker after growing weary of banging my head against the wall with Access and thought I'd see if there was a premade solution before I start building my own database. I've played with the Business Productivity Package and can see how I can make it work but wanted some advice first.

I work for a small TV and Appliance store and am looking to upgrade our software from a flat file to a database structure. The most important aspect of our business is serialized tracking of inventory. For example, we can have 10 refrigerators in house that are the same model number with 10 different serial numbers. My thought is to just look the model number information up in a related table. Where I'm having a problem is working with the serial numbers. At the time of sale we know the serial numbers of all the model numbers being sold in house. Unfortunately we also sell products online and don't know the serial numbers that have been shipped until after we have already completed the sale (we receive invoice from regional warehouse).

Obviously things are a little more involved than my brief description but I thought I'd throw that out there as a starting point b/c I really have no idea what questions ya'll are going to ask :

Any thoughts or ideas?

Link to comment
Share on other sites

It's not something you should spend too much time on modifying into your needs, instead should build it yourself.

The issues you here could be dealt with these new fm8 features GetNthRecord( over a relation, the Go To Related Records from a found set of records as well as thetajoins although thetajoins have been around since fm7. Now to give you a rough idea of how you can make something in the vicinty of what you're after study this template:


...although he uses a CF instead of theta-joins, which means that there could be a speed penalty to pay.


Link to comment
Share on other sites

This topic is 5646 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Matthew R White
      My database is hosted in the cloud with Filemaker server and I have 12 FileMaker Pro users.
      I need help with a 2 page pdf document that gets generated with information for each client, sending that via API to docusign, and building a Docusign link that I can send to a customer to click and complete if they choose to with Docusign.
    • By omnia
      I am a canadian and I work with fmpAdvanced.
      if you find a solution, I'd appreciate you contacting me.
      <reply by private topic>
      I am looking at a solution for inventory.  One important request is that they need to be able to calculate the inventory for previous dates.  E.g. the beginning of the quarter compared to today or this day last year.
      My thoughts so far to be able to do this is to have an article file and a stock movements file, all values and quantities of stock will be held in the movements file.  Basically the last related record will be in the movements table will be current value, but we can also find the last related related record based on any date. 
      Will this be a fast way to calculate or slow?  I don't want to start and then find things slow down on me too much.
      After this I will also need to be able to age the stock.  
    • By wedgeman
      We are working with a medical non-profit working in Latin America, running on much older hardware.  Seeking older individual or group/site license seats of FMP & FMS 13, 14, or 15.
      We need a bunch.  We could buy site license seats, or simple 1-off licenses.   
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.