08-28-2018, 04:55 PM
No there is no way of doing that report in coreBOS. In fact, I think you would have a hard time in any tool, even specialized reporting tools.
The SO report alone is very doable, you should be able to do that one with the normal reporting system
The Invoice report can be done with the SQL report type putting conditions on the SO relation and then making the invoice date bigger or equal to a subquery on the maximum invoice date of all the related SO. At least I think you should be able to do it:
http://www.artfulsoftware.com/infotree/queries.php
I see no way of mixing both reports without programming something.
HTH
The SO report alone is very doable, you should be able to do that one with the normal reporting system
The Invoice report can be done with the SQL report type putting conditions on the SO relation and then making the invoice date bigger or equal to a subquery on the maximum invoice date of all the related SO. At least I think you should be able to do it:
http://www.artfulsoftware.com/infotree/queries.php
I see no way of mixing both reports without programming something.
HTH
Joe
TSolucio
TSolucio