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.

Report: Search by month BUT ignore 1 charge type?

Featured Replies

I make a report of client charges, there are several kinds of charges, one of which is a flat $75.00. The report is a simple alpha list by client name of the charges and a summary total. How would one make a report of client charges in a particular month BUT ignore the $75.00 ones?

If each of the charges has a consistently entered "type" then it might be easy to find all those records within a date range and exclude the Type.

  • Author

That's exactly the nature of my question, how to exclude something, the charge I need to exclude is "Attorney fee" "75.00." The other way that it would work would be to include the fees in the report but subtract them in the total in a footer that had a field that would count the number Attorney fees in the report (fees_found * 75), if I had that it would be easy to subtract them out of the total. Any ideas?

If manually doing it, then in FIND MODE, first put your criteria in for the month you want to find on. Then before you hit enter or find, add a new Request. Then new request should have 75 in the amount field and Attorney in the tye field. Now check the 'Omit' checkbox in the Status Area.

Now perform your find.

You can also script this.

Create an account or sign in to comment

Important Information

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

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.