Skip to main content
Solved

How can I filter most recent Sales Order in a Generic Inquiry

  • 25 September 2023
  • 9 replies
  • 79 views

I have a generic inquiry to show all sales orders lines, but now I want to modify this to retrieve only most recent sales order’s SO Lines. How can I do that?

9 replies

Manikanta Dhulipudi
Rank
Userlevel 7
Badge +12

Hi @charitha82 

You can filter the GI with a date filter to get the sales order lines as needed.

Thanks

Acumatica Functional Consultant /vrsn2709@gmail.com /
C
Rank
Userlevel 4
Badge +1

@manikantad18  Thanks for the response, However, Actually I am feeding that GI data into a Pivot table. So I can not do that manually by using such kind of filter.  Is there any way to add a condition in the GI to get SO lines from most recent SO? 

dcomerford
Rank
Userlevel 7
Badge +14

You can specify this in the conditions

So if you wanted the last 7 days you could put in the value @Today - 7 which is simple. You can also get more complicated using DateAdd/Date Diff etc.

 

Dermot Comerford
C
Rank
Userlevel 4
Badge +1

@dcomerford I don’t want to consider a date range, I just wanted to retrieve last SO only(The most recent SO in the system)

Naveen Boga
Rank
Userlevel 7
Badge +19

@charithalakshan49  In the SORT ORDER tab, please select the SOOrder.CreatedDateTime and Select the Descending, so that GI will be shown the latest orders first.

Naveen B
C
Rank
Userlevel 4
Badge +1

@Naveen Boga Hi, yes I can do like that but it shows other SO as well. But I want to get only the latest one. just one SO.

Naveen Boga
Rank
Userlevel 7
Badge +19

In the Generic Inquiry, we have the SELECT TOP field, you can select 1 there and check.  @charithalakshan49 

 

 

Naveen B
C
Rank
Userlevel 4
Badge +1

@Naveen Boga Thank you. It worked!

Naveen Boga
Rank
Userlevel 7
Badge +19

Great @charithalakshan49  Thanks for sharing the update.

Naveen B

Reply


Terms & ConditionsCookie settings