Jump to content

genious

Members
  • Content Count

    50
  • Joined

  • Last visited

  • Days Won

    1

genious last won the day on September 8 2016

genious had the most liked content!

Community Reputation

1 Neutral

About genious

  • Rank
    novice

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I want to set up a simple database for use on android devices. I’ll use web direct but would need to get customer signatures, is this possible?
  2. We are a high end jewellery business and I am about to start a project to cover the entire business. The first part of this project will be calculating stock in multiple branches. I will need to be able to calculate the stock values and quantities for different dates at all times, so for instance today is 31st January 2017, how do my stock levels compare to 31st January 2016. Most stock is made up of one off pieces although some repeating products might have 20 years of history and up to 100 sales. There would generally be up to 15,000 different articles in stock at any one time, but I feel I should be thinking about growth in this area. I know that I am asking a huge question for a forum, instead I am asking where should I look for answers to this? At the moment I imagine a movements table, that will have the fields, Date of movement Entry Qty Sale Qty Sale Return Qty Exit Qty Correction Qty (this is for when things don't give us the correct answer)
  3. genious

    WebDirect and BarCode Scanner

    A barcode scanner is supposed to just mimic the keyboard. So it should work
  4. When I try to install it on 2008 standard SP2 I get a message that Filemaker server will not install or uninstall on this version of windows. This is very strange.
  5. I have a job that I will need Filemaker to do, At the moment I would have to load it onto our old 2008 standard server till we get a new machine in the new year. For now this project will not be very intensive about 5/6 users at most. Would it work?
  6. Many thanks comment. That works perfectly, I would love to get a better knowledge of the calculations functions. Kind regards,
  7. I'm not sure if it is possible but I am trying to separate text from an imported file. A sample of the text I am given is as follows; Flicker/18/70/O I would like to be able to separate the different parts into separate fields. Field 1 = Flicker Field 2 = would be 18 Field 3 = 70 Filed 4 = O Is there some calculation I could use to do this? Many thanks for all help
  8. genious

    New Laptop

    Could anyone tell me how to move my copy of Filemaker 14 advanced to my new Laptop from my old one. Kind regards, Mark
  9. genious

    How do I relate to the last related record?

    Yes that sounds like what I will do. The relationship will be based on the Identifier of the currency and it should be less than or equal to the date of the invoice, sorted descending by date. Perfectly logical! Many thanks for your help.
  10. I need a little bit of help. I am trying to relate an invoice table to my currency rates table, I want to always get the last rate rather than all rates. How do I do this? I have two tables Invoices and Exchange rates. An Invoice exchange rate would be €1.00 is 1.1006 31st October 2015 €1.00 was 1.1201 in 1st October (this might be the last time it was updated) How do I get the system to always default to the last value entered? So if I enter a new invoice today the rates will always take the rate entered today rather than the one entered on 1st October.
  11. genious

    Odd duplicate search

    I've been having a problem this evening I was trying to find duplicate customers by finding duplicate mobile (cellular) phone numbers. I performed the find and then sorted all records by that field, my problem is that I am getting a lot of odd records amongst the dupes. I'll have three pairs of repeated records then one record that doesn't seem to match anything then another few duplicates. Why is this happening?
  12. After a long separation from Filemaker I'm back and I have a new project. I am creating an inventory system for a high end retailer where they sell unique individual products. I hope that you will be able to help me get the concept right from the beginning. Generally there are about 10,000 stock items of these half will be non repeating items that we be reported on by a style of Item. There will be about 5,000 items that will be repeated but in total there will be only about 10 shipments in for each and 20 to 30 units in total of them. Finally there will be about 300 items that would have hundreds of purchases and sales. There will be manufacturing where one piece will be made from others (I have made these systems in the past). I will need to be able to report on stock levels today but also on a date in the past. While I have ideas how to manage this I'd like to get others ideas how best to tackle this issue. I will need to keep seven years of information at least I will need to allow for growth of the business I presume that keeping quantities of and values of stock should be done on the Movements record. In other words while my stock record will have a value for qty in stock this will be a calculation from Stock (purchases and sales and manufacturing) movement lines. This record would have fields as follows; MovementID.p StockID.f Date of Movement Purchased Quantity Purchased Value Sales Qty Sales Value Qty After Movement Stock Value after Movement How would would I calculate the value qty from a previous date? Is my Schema of how I want to keep the data sound? Are there any areas that I would particularly need to consider in this type of business? Your comments are always very helpful
  13. genious

    Is Filemaker the product for my Project?

    Thanks for getting back to me Wim. What do you mean by a transactional method? I have a table called movements that catalogues the movements of stock, Date of movement:Quantity carried forward+ Returns+ deliveries - sales - exits + any corrections=stock I have the same formula for the value of stock. This way I can look up stock between dates.
  14. Is Filemaker the product that I need to create an application managing a stock of many thousands (up to 100,000 lines) of articles with many thousands of sales (100,000) in a year. Stock reports would have to be run on a basis of todays stock but also looking into past stock levels on a particular date. I have tried to make these type of systems before on previous versions FM7 but found that the calculation engine was just to slow for this, has it become faster in the last few years? M
  15. genious

    Date conversion

    Many thanks Lee, I have yet to learn this side of the calculation engine as I haven't been active for the last few years. M
×

Important Information

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