Jump to content
Sign in to follow this  

Inventory Template

Recommended Posts

JReed1957    0

Hi everyone,


I hope someone can help me. I started a new job and wanted to create a simple inventory program whereby we have a part number, description, received quantity and picked quantity and then have it keep a current inventory level for that item.


I would probably want to create a new record each time we have a transaction. I would look up by part number and it would fill in the description automatically. I think I can do that. My problem is how to show a current stock level of that one item based on all the transactions, either positive or negative, for that item when I do a find by the part number.


So if I looked up sku 123456 I would see all the transcations for that sku and a running TOTAL based on everything that came in or went out.


Can anyone help me? This would put a feather in my cap at my new position if I could make this work.


Thanks so much in advance,



Share this post

Link to post
Share on other sites

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

Sign in to follow this  

  • Similar Content

    • By Richard Carlton
      FileMaker Inventory Resources | FileMaker 16 Videos | FileMaker 16 Training
      Get up to speed with the FileMaker Pro 16 Video Training Course! 
      Top Rated Course by FileMaker Expert, Richard Carlton.  
      Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference,Richard will teach you all the ins and outs of building FileMaker Solutions.  The course is 50 hours of video content!
      Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest 
      top tier FileMaker consultancies worldwide. 
      Richard works closely with RCC's staff: a team of 28 FileMaker 
      developers and supporting web designers. He has offices in California, Nevada, and Texas.

      Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving 
      FileMaker for Startups and Entrepreneurs, and client server integration.

      Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.

      Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.

      RCC,FileMaker Videos and LearningFileMaker.com are headquartered in Santa Clara, CA.
      FM Camera in the FileMaker Platform Playlist https://www.youtube.com/playlist?list=PLjTvUZtwtgBQk9D1JG62u4qV5EtCHlb7a

      Please feel free to contact us at support@rcconsulting.com

      FileMaker Video Training -  | FileMaker video training ... FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
      FileMaker Go is available free on the App Store and runs your FileMaker apps on iPad and iPhone
      Transform your business with the FileMaker Platform
      Free FileMaker training videos FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
      When In Doubt, Check This Out | Online FileMaker Videos https://www.youtube.com/watch?v=6DiI5p0lK2w
      A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
      watch a filemaker training review https://www.youtube.com/watch?v=reoBiKXlv54
      Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project
      Check out iPhone 6s, iPhone 6, and iPhone SE
      Here is a video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw

      For more Free FileMaker videos check out ...http://www.filemakervideos.com
      Download the FileMaker pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com
      Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php
      Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php
      FileMaker Pro 15 News-What is FileMaker 15-FileMaker Pro 15 Videos https://www.youtube.com/watch?v=gw38m01_RsQ
      FileMaker FLT Buffet Licensing | FileMaker Pro 15 Videos | FileMaker 15 Training https://www.youtube.com/watch?v=q5vdmaOKLk4
      FileMaker News | FileMaker Server 15 Performance Improvements | FileMaker Pro 15 Video Course 40 Hrs https://www.youtube.com/watch?v=BCJ3fOIVMyw
      FileMaker 16 Videos Get up to speed with the FileMaker Pro 16 Video Training Course-FileMaker 16 training.
      FileMaker 15 News | FileMaker Pro 15 Video Course | FileMaker Pro 15 Video Training | FileMaker 15 Videos https://www.youtube.com/watch?v=oRkOY-uXSag
      FileMaker Pro 16 Video Course 50 Hours-FileMaker Pro Videos-FileMaker 16-FM Pro 16 FileMaker 16 Training Videos-FileMaker 16
      Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
      Learn how to use FileMaker to create an app with the FileMaker Training Series
      FileMaker 15 introduction | Filemaker Pro Video Training https://www.youtube.com/watch?v=r2yfRnxPrjo
      FileMaker training review of learningfilemaker.com https://www.youtube.com/watch?v=9JTgI6lupD0
      FileMaker Pro is a cross-platform relational database application from FileMaker Inc
      Create custom apps with FileMaker Pro then use FileMaker Go to easily share information with your team while on the go FileMaker training videos channel.

      Please Comment, Like & Share All of Our Videos.
      Feel Free to Embed any of Our Videos on Your Blog or Website.
      Follow Us on Your Favorite Social Media
    • By sal88
      Hi all
      This has been a well discussed topic however I have struggled to find a direct answer to:
      Should the 'currenty qty' field in my stock table be a calculation that refers to related line items, or should it be modified via script when related line items are added/deleted to Invoices?
      I have looked at Todd Geist's excellent Inventory Transactions tutorial and am very excited about implementing it for this and other functions. For one it would mean I could remove a constant server script that hides/unhides stock items (from the stock list that appears when users are creating line items) depending on whether the quantity is zero or not. To be honest I'm a bit surprised that the portal that is used to display stock items that have a quantity above zero can't just refer to the calculated quantity (I'm guessing i opted for the server script method because the alternative was too slow or it was unable to see the quantity given that it was an unstored calculation). I believe that in general things would be sped up too (at the moment there are just 3000 stock records and 9000 line items).
      However I am partly confused as looking at FM15's Invoicing starter solution it would appear that a calculation field is used.
      Which path should I take?

    • By BC2015
      First-time setting up a complex (or what I think is complex) database, and really could use some help. The idea is to be able to create an inventory of Computers, Peripherals, Software, and Software Licenses, (and where each is installed/located), along with the Purchase Order information for each item, and the Vendor for each P.O.
      Here's how I sort of see it breaking down, but I'm confused as to how to setup the tables and relationships:
      One Computer can have many Purchase Orders associated with it.
      One Computer can have many Vendors/Manufacturers/Sales Reps associated with it.
      One Computer can have many pieces of Software installed on it
      One Computer may have many Peripherals
      One Computer can have many Change Log entries associated with it.
      One piece of Software (software title) can be installed on many Computers
      One piece of Software can have many Licenses associated with it
      One piece of Software can have many Purchase Orders associated with it.
      One piece of Software can have many Vendors/Manufacturers/Sales Reps associated with it.
      One piece of Software can have many Change Log entries associated with it.
      One License can be installed on only one Computer at a time
      One License can have only one piece of Software associated with it.
      One License will have only one Purchase Order associated with it.
      One License can only have one Vendor/Manufacturer/Sales Rep associated with it.
      One License can have many Change Log entries associated with it.
      One Peripheral can only be installed on one Computer at a time
      One Peripheral can only have one Purchase Order associated with it.
      One Peripheral can only have one Vendor/Manufacturer/Sales Rep associated with it.
      One Peripheral can have many Change Log entries associated with it.
      One Purchase Order can have many Licenses, Peripherals, and/or Computers associated with it.
      One Purchase Order can have only one Vendor/Manufacturer/Sales Rep associated with it.
      One Purchase Order can have many Change Log entries associated with it.
      One Vendor/Manufacturer/Sales Rep can have many Purchase Orders associated with them.
      One Vendor/Manufacturer/Sales Rep can have many Computers associated with them.
      One Vendor/Manufacturer/Sales Rep can have many Peripherals associated with them.
      One Vendor/Manufacturer/Sales Rep can have many pieces of Software associated with them.
      One Vendor/Manufacturer/Sales Rep can have many Licenses associated with them.
      One Vendor/Manufacturer/Sales Rep can have many Change Log entries associated with them.
      Change log is: A manually-created list of notes for any changes, upgrades, problems, maintenance events, etc. performed for the entire department. Needs to be filterable/sortable by Date, Computer, Peripheral, Software, License, P.O., Vendor, and/or type of event. Event types would be from a manually-created value list.
      Would be great if I could have a layout specifically for entering these events. Also, not sure how I would go about entering events if one event affects multiple computers or peripherals at the same time. I might have to just make duplicate entries (one for each piece of equipment) to link an event to each piece of equipment it affects?
      I've begun setting up tables for:
      - Computers
      - Software
      - Licenses
      - Peripherals
      - Installations (join table joining everything?)
      - Vendors/Manufacturers/Sales Reps
      - Purchase Orders
      - Change Log (not sure what fields I need in this) 
      I'm also trying to figure out the Primary Keys and Foreign Keys, how the relationships should work, and how I can create a layout for let's say Computers that will show me:
      - Computer info (computer name, location, hardware specs from the Computers table)
      - P.O. number for Computer (from the P.O. table)
      - List of installed licenses (including software name/version, license number, vendor, and P.O. associated with that license) (portal to the Licenses table, filtered by ComputerID?)
      - LIst of installed peripherals (including the type of peripheral, manufacturer, name/serial number, vendor/P.O., date of install) (portal to the Peripherals table, filtered by ComputerID?)
      - Change Log list for that computer, sortable by date and/or type of change. (portal to the Change Log table, filtered by ComputerID?)
      And a layout for Software that will show me:
      - Software name/Version
      - Type of Software (standalone software, software plugin, etc.)
      - List of Licenses associated with this Software (including software name/version, license number, vendor, and P.O. associated with that license) (portal to the Licenses table, filtered by SoftwareID?)
      And a layout for Vendors/Manufacturers/Sales Reps that will show me:
      - Vendor Contact info (sales rep name, phone, email, website, etc.)
      - List of P.O.s associated with this Vendor, sortable by date, and expandable to see the individual items within that P.O. (such as license numbers and where those licenses are installed, or peripherals and where those peripherals are installed)
      If anyone has any advice, I sure would love the help. Thanks.
    • By Jeffry.Alex
      I am looking for solution for quicklube point of sale
      The main requirements are:
      - Customer Database
      - Car Database & history record : what they serviced , when , what invoice they pay , etc.
      - Employee Database : their wage , bonus per car they do , etc.
      - Cash Drawer
      - Thermal receipt printer and normal printer with auto switching.
      - credit card (360 plugin or similar) - via mag stripe reader or manual entry
      - split payment  (ie $10 in cash, rest on card, etc.)
      - Returns, either by entering invoice # or returns without invoice.  return as cc refund, or cash
      - Gift cards  tracking (just a unique barcode on preprinted card)
      - Sales tax y/n for customers  for customers we enter all data for.
      - quick sales without needing customer info
      - sales tax reports ( we can talk about it later , but not so important right now ).
      - inventory management - of course
      - bundling on sales. Ie enter a SKU and all items in that bundle are listed on invoice but the bundle price is not the same as the sum of the individual prices.
      - quantity discounts  ie $1 each or three for $2.75 but can mix and match different pre determined SKUs for the bundle. Think favors of candy, each with a unique SKU.
      - fast item entry - either type SKU and hit return or use barcode
      - no mouse on basic sales-  tranaction including payment can be done with keyboard - OK to use macro keys on keyboard.  Complex things like returns, can use the mouse, just not the basic store sales tranaction as a mouse is too slow.
      - multiple SKU per item - hey it happens when vendors change barcodes on us
      - Open solution
      - Daily register balance reports
      - Reports not so critical as we can build as needed
      If you have or know of a robost FMP POS solution please contact me here , or pm me 
    • By mmcconnell
      I'm trying to create a simple inventory system of digital music (downloads) sales so that licenses can be properly tracked. We have to purchase a license for each song sold.
      I'm having trouble with one part of the reporting.
      I receive a CSV from the vendor that lists 2 types of transactions: single track (song 1, song 2, etc) and complete album (Album 1 which is made up of song 1, song 2, etc.)
      I can successfully report totals on the single tracks using a Summary field in the table, but I'm unsure of the best methodology on how to include the songs sold when a complete album is reported.
      I have 2 tables at this point: Digital Downloads which contains all the data imported from the vendor (and will be added to every couple of weeks). Important fields are the Artist, Album, Song, and Quantity Sold. Second table is Albums (will be updated as new albums are recorded). Fields are Album Name, Track Name, License Purchased.
      The single report I have created has a header with the Artist, A sub-summary by song (trailing) with the Song and Quantity Sum fields, and a footer with the date. There is a simple script on the front end of the report that sorts the records by Artist and Song and opens the report layout.
      When an album is sold, the CSV has an empty Song field, so I can certainly find albums by omitting records that have anything in the song field.
      Is this a portal solution, where each instance an album displays the songs that it contains? If so, how do I add those results to the other summed songs?
      Or is this a temp table solution where each time the report is run, the applicable songs are added depending on the album sold?

Important Information

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