Skip to main content
Solved

Generic Inquiry


Forum|alt.badge.img

I am trying to make a generic inquiry of appointments for the current month and past months so I can add a widget to my dashboard of a bar graph on how many hours are being used with each of our customers. I still struggle with making GIs...

Best answer by Nilkanth Dipak

Hi @CAMORRISON ,

You need add filters from the Filters screen in Acumatica for the date range you required.

Like for current month you can use predefined filters line @MonthStart and @MonthEnd for current month appointments and for previous you can use @MonthStart-1.

For Current Month
For Previous Month

Hope, it helps!

View original
Did this topic help you find an answer to your question?

5 replies

dsimmerly
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 114 replies
  • January 16, 2024

@CAMORRISON Is there a specific issue you are having ?


dsimmerly
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 114 replies
  • January 16, 2024

@CAMORRISON The standard menu provides you a GI with a list of appointments (the Primary list).  You can start by making a copy of this GI and add conditions to only shows the desired date range 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 31 replies
  • January 16, 2024

I am not sure how to make the conditions?


vdiaz
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 82 replies
  • July 27, 2024

@CAMORRISON Hi! Were you able to solve your problem?


Nilkanth Dipak
Jr Varsity III
Forum|alt.badge.img+7
  • Jr Varsity III
  • 307 replies
  • Answer
  • July 28, 2024

Hi @CAMORRISON ,

You need add filters from the Filters screen in Acumatica for the date range you required.

Like for current month you can use predefined filters line @MonthStart and @MonthEnd for current month appointments and for previous you can use @MonthStart-1.

For Current Month
For Previous Month

Hope, it helps!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings