Jump to content

Search the Community

Showing results for tags 'inventory'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker 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 Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

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 21 results

  1. zissu600

    solutions wanted Looking for a Lending Library

    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 template that comes with FileMaker (the lending library) is close but does not quite meet my needs and my attempts at modifying have been unsuccessful. Any help, or if anyone already has a solution please let me know. Also please let me know if you need more info or would like to look at what I have attempted so far. Using FileMaker 10 Thank you!
  2.  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, Proposals, Contracts, Products, Warehouses, Incomes, Expenses, Payments, Documents, and Tasks, Events with Calendar, Timesheets. It’s great all-in-one business application.   On Benroy's Dashboard you have all the most important information in a single window: projects, revenue, daily tasks... The CrossTab reports let you slice you business data in the way you like it. Chosen data can be printed, saved as PDF or exported to Excel.  Benroy enables a Handy Project Management - distribution of tasks, documentation related to the project and much more. The Calendar helps you to check the availability of the teams and plan meetings. Sales management is a part of the application as well.  Benroy includes an extremely easy to use financial module with an overview of all the buying and selling activities, all in one place. You can also calculate the cost of goods or services easily. 'Benroy' also has a convenient billing module with a mailing to customers function.  Benroy key features:  • CRM: Organize your whole business in one place. • Contacts and Companies management. • Calendars and activities: Individual or multi-user calendars. • Activity Sets: Ideal feature for a perfect business process management. Prepare activity sets (Event and/or Task) and assign them easily to a Contact, Company, Project or Sales Lead. • Projects, Tasks and Job orders: the Project module allows you to define projects, tasks, and roles, track project activity; assign tasks to individuals or groups; prepare job orders and estimates; quickly prepare invoices and track project expenses. • Sales management and Quotes/Proposals: Track your leads and prospects, quickly prepare quote/proposal and send it to the customer. When leads are won prepare the contract with one click, create project and track process later on. • Product catalog, Warehouses and Inventory management: Store all your products and services, manage prices, prepare beautiful catalogs and pricelists directly for customers. Manage multi warehouses, reorder levels, quantity on hand, etc. • Invoices and Expenses: overview of all the buying and selling activities, all in one place. Convenient billing and mailing to customers. Calculate the cost of goods or services easily. • Document management: Secure document storage means everyone has access to the information they need and no one can overwrite another user’s updates. Link documents to any module within the application. • Dashboard & Reports: the Dashboard shows current business status and CrossTab reports let you slice you business data in the way you like it. Chosen sliced data can be printed, saved as PDF or exported to Excel. • Multi-platform support: Whether you have a Windows PC or a Mac, Benroy works seamlessly in all platforms, including on iPads for technicians and project teams or sales reps at remote locations. • iPad version: Full featured iPad version with barcode scanner and signature capture. Control your warehouse, sign and take clients signatures on invoice, job order or contract on the go.   Benroy Business App can run as a single-user application, especially when you start your business. But if you need a multi-user environment or want to use Benroy on your iPad you can do it with a multi-user version. You can always upgrade from single-user application to multi-user environment. Benroy was developed using the world leading FileMaker Platform, which allows running business applications as multi-platform solutions. If you upgrade to multi-user version you will be able to run Benroy on Mac, Windows and iPad. Multi-user environment requires FileMaker software.  Benroy has been approved by FileMaker technical team as a complete solution and is listed on the FileMaker web site’s showcase “Made for FileMaker”. “We are so excited about that and hope everyone will like the App as we do…” said Giedrius Godelaitis, YZY SOFT’s founder.  Pricing and Availability: Benroy Business App is just $79 as a single-user application and $899 for the 5 user multi-user version. FileMaker software is not included.  Get theApp right now and dedicate your time to business!  Useful links: http://solutions.filemaker.com/made-for-filemaker/detail.jsp?id=solution.10000004154 http://www.yzysoft.com http://www.BenroyApp.com   About FileMaker Inc. (www.filemaker.com) FileMaker, Inc., an Apple subsidiary, delivers innovative software to easily create custom business solutions for iPad, iPhone, Windows, Mac and the web. Millions of people, from individuals to some of the world’s largest organizations, use the FileMaker Platform to streamline their business processes, manage information, and boost overall productivity.   About YZY SOFT (http://www.yzysoft.com) YZY SOFT is a privately held company founded in 2010 and located in beautiful Vilnius, Lithuania. YZY SOFT focuses on the easy to use business management solutions and its add-ons.   © 2015 FileMaker, Inc. All rights reserved. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners. All Rights Reserved. YZY SOFT and Benroy are registered trademarks of YZY SOFT, Lithuania     Â
  3. 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 is greatly appreciated. Thanks Neil
  4. 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 number of total portal rows, while changing the location of the portal below. (so they don't overlap) I have a default number of portal rows of "4" but sometimes I might need "10" or "20" if I sum Inventory and Non inventory (about the maximum size for A4 paper ) I hope I have been clear enough and that somebody might come in help. Kind regards, filemakermaniac
  5. 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. I create new record of stock transaction month wise. My query is that at present I have to make two entries while transferring items from go down to shop. First in selected item portal table I make entry in Unit Out field (Say Aluminium Foil 162 mm go down) then again I have to select item (Say aluminium foil 162 mm shop)and put value (Value from UNIT OUT field) in Field UNIT IN . My requisition is that is there any script to complete this cycle with single entries. As there are at about 1000 product list which I have to transfer from go down to shop. I am attaching small file for your perusal to get rid of the result. Here is link https://www.dropbox.com/s/38ycr8kj5u75lik/Stock%20Inventory%20-%20Copy.fmp12
  6. 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 populated with all the items associated with that specific Kit/category. Additionally the Order portal would also be able to pull up individual items from the Inventory which have no kit association. Items from the established kits could not be rented out individually until that particular item in the Inventory has it’s kit number association turned off / deleted. This is to allow for upgrading, fixing, or moving equipment around to other employees which may have been assigned.
  7. 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? TIA
  8. 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, description etc... Now, the problem that I am facing is that i am using calculations to keep track of the stock where as if i order 1 item then 1 item gets added and if I see that item 1 gets deducted etc.. now the problem is that after certain length of time... I see stock for items that I didn't order. It will just appear out of the blue as stock.... I am totally stumped and urgently need of help. A POS system with wrong information on stock on hand is useless... Looking for any suggestions or comments. Regards, Young
  9. 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?
  10. 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.
  11. 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 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 http://www.rcconsulting.com/ 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 http://learningfilemaker.com/FIAS.html 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 Facebook Twitter Google+ #WhatisFileMaker16 #FileMakerPro16Training #FileMaker16VideoTutorial #FileMakerPro16Videos
  12. 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::rentalDate and RENTALS::dateReturnedActual <= Get ( CurrentDate ) Present: RENTALS::rentalDate < Get ( CurrentDate ) and RENTALS::dateReturnedActual isEmpty Future: RENTALS::rentalDate > Get ( CurrentDate ) and RENTALS::dateReturnedActual isEmpty From the perspective of the INVENTORY table, I'd like to look through the relationship and determine if an inventory items is "Available" or "In Use". I believe I can use this simple rule: RENTALS::rentalDate <= Get ( CurrentDate ) and RENTALS::dateReturnedActual isEmpty. however, I'm not clear on how I would script or calculate this (the latter in the event that I use a calculated field). It seems like it is a common enough problem. Yet, I've not been able to find a solution. Can anyone offer any insights? Thanks.
  13. 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.. thanks for your anticipated assistance shevy-INVENTORY.zip
  14. Greetings, This is a non-work related question, but any help you can offer would be much appreciated. When not fulfilling my daily role as an IT Coordinator, I indulge in the MMO EVE Online. I've been building complex GoogleDocs to check market rates on items when it dawned on me that I could do all that and a lot more with FileMaker. So here's my situation: I currently have a button in my FileMaker database that opens this URL. I then copy the content of the page and paste it into a field ("XML_Data"). I then use the custom function ExtractData to pull out the data I need for my calculations. What I would like: Each time I open the database, I would like it to automatically retrieve the XML data from the web and put it in the field. Any ideas? Thanks in advance, Commander Ben Feingold CEO of a virtual Corporation...in a virtual world of spaceships and laser guns... Here's the URL incase the link didn't work: http://api.eve-centr...nlimit=10000002
  15. 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 button in the estimate layout and automatically copy my lineitems items, at the price set previously in a new portal in a contract table that will make the change in inventory and eventually let me see what i'm missing and let me order them. I know most people put estimate and contracts(invoices) in the same table, I am also ready to do that if I can make sure estimates dont change inventory. Can you help me figure the relations and the scripts I need to achieve that? Thank you so much.
  16. 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 1172 Wood Teeth 342 1101 Tooth Bolts 205 12m Chip Guard 17 44005 Drive Belts 38 etc etc etc.... While the "Sales Numbers" report just takes a single figure from each Sales Order, this "Line Items Totals" report needs to take one or many Line Items from the inventory portal in each Sales Order. My skill with FileMaker is such that I have adapted the bps to more or less suit my needs but not much more than that. By searching for a solution it seems that maybe there is a report wizard to ease the process. It would also be helpful if the same could be done by customer, ie a report showing: Customer X, in Year Y, bought 17 Widgets, 130 Thingummies, 2 Whatsits etc etc. I'm frustrated that this must be a fairly common need yet neither my own efforts nor searching has born fruit. Please help! Many many thanks, and if this would be better in a different topic please advise thank you.
  17. 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 with product variations? I tried adding a barcode table that related to products but couldn’t figure out how to track qty out to different locations by barcode. Should I add an inventory ledger table that somehow tracks inventory in/out to different locations? Sorry for all the questions, I just can’t seem to get this figured out! Thank you in advance for your assistance! FMSP is hands down the best Filemaker Pro starter product out there!
  18. 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, Jim
  19. 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 keep track of the invetory after each operation (entry or sale). Where do I start? Many thanks for your help.
  20. 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 would only be a single possible value to enter. Not sure the best way to go about this. Any help/advice would be really appreciated. Thanks Neil
  21. Jeffry.Alex

    solutions wanted POS for Quicklube needed

    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 -Jeffry
  • Create New...

Important Information

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