Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jt196

  • Rank

Recent Profile Visitors

1,381 profile views
  1. Folks we all know how useful the "unread" badge icon on your telephone can be, I'd like to try and implement something like this into my FM SP database. I've a filter on the invoice list view that allows me to see any orders that need invoicing to the customer. The search criteria is: OMIT = invoice posted = "1" FIND = Quantity Remaining = "0" I've tried to make a button on a button bar in the preferences layout using the same process as the tab formatting, namely: Let ( [ number = Count ( T14m_preferences_INVOICES||id_constant::ID_Invoice ) ; label
  2. Dude that's great thanks. All working now. Got my predictive order schedule working! Seems like that whole date thing could be sorted out in 10 minutes or so of an afternoon, but what do I know, I'm just a lowly user!
  3. Folks I'm having a bit of headache with a search script. I want to search a date range from today to 90 days in the future. Currently I've made a script with a step saying: Insert Calculated Result [Select; "date field"; ( Get (CurrentDate) & "..." (Get (CurrentDate) + 90)] Being in the UK, I'm working with a file that was created on a US computer - the month and day are the wrong way round. I've changed the text on the system to use system settings but that still doesn't solve it! Frankly, that's quite ridiculous! Surely a bug like this that has been around for a VERY lon
  4. jt196

    BOM problem

    So I got around this finally by a bit of a hacky method. Whatever it is, it works and that's enough for me! I made a field in the materials table called "Quantity Ordered" which is a global storage. The script that opens up the BOM from a line item portal sets the global storage field to match the "Quantity Ordered" on the line items with a set field calculation. That figure is then used in all the calculations for the different materials. Hope that makes some sense and is a sort of sensible workaround for this database connection thing. Couldn't figure out how to do it with regular
  5. jt196

    BOM problem

    So, I've attached the screenshot of the relationships. The idea is that I go into an order/invoice and open up a work order from each one using a "related items" script. What's happening is that the tables seem to just using the figure 1800 as the calculation, which isn't even any of the historical orders so I've no idea where that came from! You can see that on the second picture. I'm hoping to be able to open up the BOM and have the correct figure for inserts/boxes etc appear in the "Qty Per" field. In order to make that "Qty Per" figure I've chucked in an IF calculation accordin
  6. Folks been scratching my head on this for an afternoon and was hoping I could pick your brains. I've tables invoices & line items (one to many relationship) and products and materials (also one to many). Each product can have multiple materials and each invoice multiple line items. I'd like to be able to open up a bill of materials for each line item and have various calculations based on the total number of items on the line items and the weight/quantity of the various materials. So far I can't seem to get this to behave properly - the line items total quantity doesn't s
  7. Folks with a bit more brainpower and a coffee I figured this one out. I've created a new table "Pallet Pickups" with 3 sets of fields for each customer, quantity pallets and a checkbox for yes or no to select a pickup or not. There's a calculation field for total pallets and a date field as well. I built a script with 3 conditions - an IF for the 2 pallets selected, an ELSE IF for the 3 pallets and an ELSE for the 1 pallet to write either an email with 1, 2 or 3 addresses and their respective information. Hope this helps anybody and by all means if anybody has a more elegant solution I'm
  8. Intermediate FM user here but I've not much experience with variable/temporary fields, so need a bit of help. I need to make a layout for my non-email literate staff to write a collection email for our transport company. The layout would be as follows: ---- email: <transport email address> subject: x pallets pickup [today/tomorrow/specific date] body: Dear Sir, x pallets to go to: <customer 1> <customer 1 address> optional: x pallets to go to: <customer 2> etc ---- up to 3 customers. Any ideas folks or at least pointers as to what kind of fields/calculati
  9. Er, not sure if this group is very active - shall I post it to the main Q&A group?
  10. Folks, hopefully not a big issue. I've just spent an afternoon moving contacts and accounts into the FMSP database via csv. They're separate but many of the contacts belong to companies which I've entered in as accounts. The issue is that the accounts don't show up as being connected to the contacts as I'd expect. I'm assuming it's something related to the 'relookup' command but I've tried that on both the account field in the contacts and the accounts table and it comes up with the error "There are no fields based on the field..." Any hints as to how I might get this working?
  • Create New...

Important Information

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