Scheduling report on Invoice Item Adjustments performed yesterday

[Rolando]

I built a report so show invoice item adjustments for yesterday and scheduled it to send daily.
When I run the report in the UI I get results. I have never gotten results from the scheduled report run from 3/16/17 forward.

[Rolando · Accepted solution]

I would recommend that you change the Invoice Item Adjustment: Adjustment Date filter to reflect the Invoice Item Adjustment: CREATED Date instead.

For example, on 4/4/2017 there were several Invoice Item Adjustments CREATED, however those ADJUSTMENT dates were from 3/31/2017. Therefore, the report would not report those IIA's since it is looking for Adjustment Dates from the previous day- 4/3/2017.

The adjustment date for an IIA is not necesarily always going to be the same day it is created, however the created date will always remain consistent.