Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Find not working on Hosted file

Featured Replies

Hi, not sure this is the correct forum

 

we have a calc field for our Invoice total ... Sum(inv_invitm_InvoiceID::Total Sell Price) + (Amount Imported/1.1) ... which is the sum of all the invoice items records + the value of the invoice total for all the old invoices imported prior to starting with FM

 

Our file is hosted in Brisbane with nightly backups to my office in Sydney

 

So all works fine then one day doing a find on the cacl field only finds those records where the search value = Amount Imported .. it won't find any invoices where the Sum of the invoice items = the search value 

 

However, the Find still works correctly on the overnight backup files !!

 

the hosting mob reboot their server and it's fine again .. for a while then it stops working again

 

anyone ever come across this ?  the hosting mobs can't work it out  .. they host other company's files and haven't had any reported probs ? .. so far it only seems to be a prob with that field, although most of the time our finds are not on calc fields

 

thanks

Cate 

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.