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.
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?
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.
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!
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.