Jump to content

Search the Community

Showing results for tags 'inventory'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 20 results

  1. 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. http://learningfilemaker.com/fmpro16.php 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
  2. 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
  3. 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 w
  4. 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 tra
  5. Hello, This is my first time using this forum so please excuse any mistakes.. I have setup a standard pos system with DB for invoicing a customer, inventory and purchasing inventory from Maker. The DB is setup in such was so that I have a layout for Invoicing the customer and within the invoice are the line items for each product that I carry in the inventory. The Inventory is defined with barcode, description, prices and most importantly stock. The purchase order is setup the same way as such so the i have layout with purchase order sheet, then within are the line item with barcodes, desc
  6. 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
  7. Hello all, thanks for reading. I am using FileMaker 11.0.3, with the Business Productivity Solutions v7 (bps_Sales_Orders.fp7, bps_Inventory.fp7, bps_Contacts.fp7). There is included a report generating "Sales Numbers" which gives the sales value totals in £ per week, month, quarter, or year. However, I want to generate a report showing total inventory items sold. I have an inventory of 170 items and need to generate a report that shows, for example: October 2013: Part Number Item Quantity Sold 1172-2 Rock Teeth 1422 11
  8. Â YZY SOFT today announced the launch of Benroy Business App is an all-in-one solution for business management and higher productivity purposes. Benroy was developed using the world leading FileMaker Platform. Â Â The application is especially convenient to organize and track daily work in the following business areas: Sales, Creative agencies, Real estate companies, Construction companies, Photography, Employment agencies, Legal professionals and others. Â Benroy Business App is the ideal solution to manage your Contacts, Projects, Job Orders, Estimates, Project discrepancies, Leads, Prop
  9. I recently created an inventory solution from scratch (actually from video tutorials and from the contributions of the good people on this forum). It has been a fantastic project for me and I really appreciate all your help. Right now, I want to integrate my barcode scanner, so that i can easily make sales for customers by just scanning the barcodes of the product items. The products have barcodes already printed on them. Please how do I go about it. I am not really good in scripting, but thats the fun part for me (its all about learning) I will be attaching a copy of my file shortly..
  10. Hello All, I am using FMSP to track products and orders from suppliers. I need to track qty in from invoices as well as product variations and qty on hand at different locations. The problem I have run into is tracking products with variations. When placing an order with a supplier 1 item number can be associated with multiple UPC/barcodes. For example item number 123 includes 4 different item variations each with it’s own barcode, so the PO/Invoice from supplier shows I ordered a qty of 24 but I actually received 6 each of 4 different items. What is the best way to go about dealing
  11. Hi, my name is Mathieu. I'm relatively new to Filemaker and and new to the forum. Merry christmas to everybody and thank you all in advance for your support. I have a layout for estimates with a portal showing LineItems items: Clients------>Estimates---->LineItems<-----Products I use price lookups in lineitems to make sure that if a product price change, it doesn't change in already completed estimates. My relationships are set up so that an estimate doesn't make a change in inventory. Now, the problem is, I'd like to, when a estimate is accepted, check a radio
  12. 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 fin
  13. Hi, Hopefully I've posted this question in the right place! I'm developing a maintenance database (spares) and have came across an issue regarding data input of items. When a user creates a new record (adding new product) there could be different wording of products entered. For example 'lamp or bulb','box or crate' etc. What I want is to prevent duplicate naming of items. I'm thinking possibly some kind of buffer table that would compare say a unique manufacturers id and/or supplier and validate the item name on entry?, meaning if the manufacturer and ID was the same then there
  14. Hi all, Hopefully I 've posted this in the right place I'm new to filemaker and have been developing a maintenance inventory database. I have a 'stock transactions' portal where I can add and remove stock. I am having trouble figuring out how to put a condition on the amount in stock where there can't be a negative amount. So if there is a quantity of 2 items in stock, only 2 can be removed. (if someone trys to take 3 out of stock at the moment, the stock amount would go to -1 for example). Thanks in advance for any help/advice on this issue, I'm still learning so any feedback
  15. Dear Sir, I have created Stock Inventory file with the help of Inventory FM Solutions. Yet I have customise according to my requirements. I have two stock inventory locations one is at Go down and another is at Shop. First materials received at go down then transfer to shop. So for as this I have make each items twice but in different ID and also suffix them with location name. For example a item name as aluminium foils 162 mm (Go down) and another is aluminium foil 162 mm (SHOP) in item list. Stock transaction is maintain by month wise of each item with month wise stock transaction id.
  16. Greetings, Please don't shoot a first-timer like me... Here is the thing: I run a shop of sporting goods and I would like to create an inventory tracking system. Here are some details: - There are 4 categories: 1. Shoes, Different brands, different styles, different sizes, different colors. 2. Apparel, Different brands, different styles, different sizes, different colors. 3. Balls, Different brands, different styles, different sizes, different colors. 4. Accessories, various items, Different brands, different styles, different sizes, different colors. I would like to ke
  17. I have a very small rental arm of our theatre company and I am looking for a better way to manage my inventory. We rent items out to other companies and I need something that we can go into see what we have on hand and what is already lent out. I also need the ability to reserve an item to a company, check it out when it leaves, and check it in when it comes back. Also important is that each company has a history of what we have lent them. Since it is for internal use it does not have to look nice, just be simple and function well. Every attempt I have made never seems to get it right. The
  18. Hello everybody, I am curently setting up a database for a little vet center. But I am now stumbling on several points. My main current problem would be the following: I have set up a portal on the receipt for Inventory based products (drugs, pet stuff...) but now I need another portal for non inventory based items (vet fee, pet hairdressing, ...). My main problem is that they are uneven, some times I will have many inventory based products and few non-inventory products, and some times all the opposite. So my big question is: How can I Script a button who might extend my nu
  19. I have created a basic Contact-> Order-> Line Item <-Inventory database but am at a loss how to go about creating the next stage. Our company signs out equipment to its employees. Each Order can be made of multiple individual items from our inventory. This is basically your typical Invoice solution except we are not selling items, but rather signing them out. The trick is how to assign individual Inventory items to a “Kit number & category which then can be pulled up in an Order portal. Once that Kit number is pulled up in the portal, the line items automatically become
  20. I am having difficulty getting information based on date ranges in a portal. I have an INVENTORY database where an inventory item can be rented many times: INVENTORY -< RENTALS One layout shows INVENTORY items in a form view. A portal shows the following fields: RENTALS::rentalDate RENTALS::dateReturnedExpected RENTALS::dateReturnedActual. I want to show whether the INVENTORY item is "Available" or "In Use", so I have a field in the INVENTORY table called status. The RENTALS table may have records in the past, present, or future: Past: RENTALS
  • Create New...

Important Information

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