Hello,
I'm trying to use the vendor invoice turnover report with some advanced filtering to meet my needs:
let's say I have vendor F189695 with 3 invoices registered in 2024, and one of those has the DOCUMENT DATE = 31/12/2023 while the other 2 are in 2024.
I want to filter the report to match only those with document date between 01/01/2024 and 31/12/2024
So in the advanced filtering under "record to include" I've added a join to Vendor Invoice Journal (that contains the document date)
then in the Range i've added the filter that I needed (01/01/2024 - 31/12/2024)
So in the end I've the following filter:
but the result is showing me the sum of every single invoice for that vendor
so it's ignoring my filter on Document Date and only using the filter for the vendor
Any idea? Is this normal behaviour and the added join is not considered or am i missing something?
