Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About lizzie

  • Rank
  • Birthday 07/05/1980

Recent Profile Visitors

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

  1. Greetings! A problem I have noticed in our stock system is that very often the shipping costs of items are not allocated to the invoice for the product shipped in. This obviously pushes up our overheads. What I'd like to do is flag those records in stock that have a shipping cost attached to them. The common denominator will be the Order Number. My logic thus far says: find the records related to shipping/courier fees (as these are entered into the system when booking in stock), extend the found set of each shipping record so as to show the matching product records and then flag
  2. Greetings Would love to hear suggestions as to how to solve the following problem: Everybody prints to a networked printer. As such, it is imperative that we have stock of all consumables at any one time. I thus created a subsummary report which identifies the unused consumables in stock. The next step is to identify those consumables that aren't in the subsummary report so as to flag those as "super urgent" stock to be ordered. My mind is completely obsessed with combinatorics and I cannot see another way of identifying what consumables are missing from the subsum report
  3. The question was posed for two main reasons, both of which have been identified by yourself... a) merely to see HOW to perform such a calculation being in the technology industry, forecasting generally looks at a 90 day history before projecting out and yes, one can make use of weighting in the analysis to give more recent data more weight... Thus, I'm curious to see how one would do it and am not necessarily concerned with the "why"... I hope this clarifies things? E
  4. Greetings I have created a subsummary report to assist with product forecasting. I seem to have hit a brick wall. The subsummary report is based on product code and then "month as number", allowing one to view the purchases related to a product over x specified months. Some products are clearly not purchased on a monthly basis. While one generally takes the number of products purchased and averages those over the number of months being analysed, I would like to be able to flag those products that have been purchased in consecutive months. Thus, if I am looking at data for April - Jul
  5. Greetings! Wow! I didn't realise that my (what I thought was a) small and insignificant post could attract so many brilliant minds! LOL! Thank you to you all for assisting with my learning curve! Much appreciated!
  6. You made it sound so simple *blush*. Thank you! I have used your calculation and it works beautifully. Last question is how would one add comma's between the t-shirts where multiple t-shirts of various sizes are ordered? Just helps the reader else one gets: T-Shirts: 20 x Small 36 x Medium 46 x Large 36 x X-Large 15 x XX-Large (as an example)...
  7. Greetings! Please help! We assist with the email send for an events company and we have been supplied with a database from which we extract each race entrant's data and send them a personalised email. Included in this data is whether or not the entrant has purchased a t-shirt for the race. The client has supplied us with an Excel spreadsheet which includes separate fields for small, medium, large, x-large and xx-large t-shirts. The fields contain the number of t-shirts ordered by the entrant. The extraction of data becomes more complicated as there are cases where on
  8. Greetings I am busy analysing our stock control processes and have written a basic script which alerts sales consultants when the stock that they have ordered has arrived. The problem is that one order can have multiple line items (or the parent can have multiple children). When creating an email, only the first record's data is included in the email. With reference to the following post: http://www.fmforums.com/forum/showtopic.php?tid/191192/pid/271786/ a) is there any way that one can send one email which includes all the line items (so as to avoid sending multiple e
  9. Greetings Am on FM 9 (must update my profile)... Where do I get hold of ESS? Will review in the meantime and see what I can come up with! Mucho gracias!
  10. Greetings Is it possible to run a script in Filemaker which accesses a SQL table, runs a SQL query and posts that data back into Filemaker? If so, how would one do this? Our developer has left us and unbeknown to us, converted our Filemaker DB to SQL... our online orders are now housed in a SQL table and while I have learned how to run a SQL query, it would be much easier to execute the script from FM so as to draw the data back into the system that our company runs on... Any help/advice would be greatly appreciated.
  11. Greetings I am in the middle of quoting for a potentially massive deal. The project, thus far, has 7 very extensive quotes. My first quotes were submitted in November and since then we have experienced changes in the exchange rate as well as changes in product pricing. I have a huge meeting on Wednesday (which I was only told about today) and I am hoping that there is a simpler way to duplicate my quotes instead of copying and pasting each line item into a new quote. I specifically do not want to make the changes to the original quotes so that I have a "Quote History" to fall back o
  12. Greetings I am in the process of adding final touches to my Scorecard: a system which marks and measures sales performance. Before Scorecard was implemented, we incentivised sales consultants based on sales targets hit AND margin made every month. With the addition of Scorecard, I now have to add a new criteria to the calculation which calculates the incentive value that a consultant has earned. The below statement works perfectly until I add a line (indicated here in red) which specifies that Scorecard points earned have to be higher than or equal to "First Scorecard
  13. Greetings I am in the process of creating a subsummary report which specifically looks at our sales team's pipeline deals. While our sales consultants might quote clients on various options (all listed in one quote), it is imperative that we only take into account those items or options on the quote which we know are an almost guaranteed sale. Each quote has children which can be flagged as a pipeline item or not. I have then added these flagged items up to get a total per quote. In the sub-summary report, I then want to show a total per category (as we have various categories
  14. Thank you for the assistance! I really appreciate the learning curve! My attempt landed me with the following which works: Case ( Created < 733062; Work Days to Date Month Calc * 5; Created ≥ 733062 and Created ≤ 733072; Work Days to Date Month Calc * 10 - 65; Created > 733072; Work Days to Date Month Calc * 10; ) But I think I could certainly improve on thanks to your suggestions!
  15. If (Created < 1/1/2008 ; Work Days in Month * 5 ; "" ); Greetings I am going around in circles and feel like a puppy chasing her tail. . . Our sales consultants had to do 5 CRM calls per day. As of 21/01/2008, the MD upped that total to 10 CRM per day. We are tracking each sales consultant's progress with the aid of a ScoreCard. However, I now have to take into account that the "total required CRM to date" up until 21/01/2008 was "No. of work days past x 5". Thereafter, the calculation changes to ("No. of work days past x 10") + 65 (which is the number of CRM that was to be
  • Create New...

Important Information

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