Skip to main content
Solved

Filter line details


Forum|alt.badge.img+1

Hi all,

What do I put in the visible expression to filter line details and only display those with SO numbers? Actually, this line here isn’t suppose to show because I have a filter for complete status only but it still shows? Any help please.

Thanks!

There’s one of which status is Open so it shouldn’t appear too. Why is it not filtering correctly?

 

Best answer by DavidEichner

If you check Released Only, it will also include any AR transactions that don’t have a sales order associated with the AR transaction (perhaps entered as an invoice in SO or AR).  If you want to only show documents that originated from SOOrder, then you need to change the join between ARTran and SOOrder to be an inner join instead of a left join.

 

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

DavidEichner
Captain II
Forum|alt.badge.img+12

Hi @paula012 

Can you upload the rps file so I can look at it in Report Designer?

Best,

David Eichner, CPA


Forum|alt.badge.img+1
  • Semi-Pro II
  • January 18, 2023

Here it is sir @DavidEichner , thank you!


DavidEichner
Captain II
Forum|alt.badge.img+12

This is what I am getting when I run the report:

Looks like your report is referencing some user defined fields that my Acumatica demo data doesn’t have.  However, I don’t see any other issues.  Is there data that I should see that is not being displayed?

Best,

David Eichner, CPA


DavidEichner
Captain II
Forum|alt.badge.img+12

I published it into my instance, ran it with Released Transactions checked and exported to PDF (see attached).  


DavidEichner
Captain II
Forum|alt.badge.img+12

When I checked both Released and Completed, I got a similar result.


DavidEichner
Captain II
Forum|alt.badge.img+12

I made a slight change to the filter.  Here is the report when you select Completed checkbox:

 


DavidEichner
Captain II
Forum|alt.badge.img+12

When you select Completed and Released, the report then provides the following result:

 


DavidEichner
Captain II
Forum|alt.badge.img+12

If you check Released Only, it will also include any AR transactions that don’t have a sales order associated with the AR transaction (perhaps entered as an invoice in SO or AR).  If you want to only show documents that originated from SOOrder, then you need to change the join between ARTran and SOOrder to be an inner join instead of a left join.

 


DavidEichner
Captain II
Forum|alt.badge.img+12

Here’s the report with the updated filter.  Hope this helps.

Best,

David Eichner, CPA


Forum|alt.badge.img+1
  • Semi-Pro II
  • January 19, 2023
DavidEichner wrote:

If you check Released Only, it will also include any AR transactions that don’t have a sales order.

Thank you so much for extending much help sir @DavidEichner! I just want to emphasized I just learned this now. So basically, I need to filter those that are completed transactions (meaning, with shipment and invoice-which can have no SO as you said, or in my case, this OPEN SO of mine happen to have both shipment and invoice so it shows). So it’s alright for me that this one appears then! And thanks a lot for mentioning the need to change join when I want transactions only from SO. I really appreciate the time you took to help me solve this and understand!


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