Missing invoice amount from cost per use report

Description

A user reported a data error on the cost per use report. There is one invoice in the system that seems to be generating a line on the cost per use report, but the cost is not appearing. 

Steps to replicate:

  1. Go to the Index Data test agreement: https://thor.ci.folio.org/erm/agreements/3b6623de-de39-4b43-abbc-998bed892025

  2. Select the cost per use report. You can keep all the default parameters.

  3. Download the csv version of the report.

  4. Go to the invoice 34567: https://thor.ci.folio.org/invoice/view/c1fc5c62-a894-4254-a8ea-edde9b403a6f

  5. Open the invoice line for $6,000.

  6. Compare the invoice line to the report. You will see lines on the report for each title in the BMJ test package that match the fiscal year and subscription dates of that payment. However, the amount is always $0. The $6,000 should be represented on the report.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

3

Checklist

hide

TestRail: Results

Activity

Show:

Kristen WilsonNovember 19, 2021 at 5:17 PM

Confirmed that this is working as expected now.

Adam DickmeissNovember 19, 2021 at 10:50 AM
Edited

OK.. I've made a change so that if common period of subscription period and reporting period is zero, then the title is omitted.

Not to be confused with usage periods .. No matter usage .. no matching titles, the titles will be there (we had issue on that earlier).

On Thor now. No need to analyze again (but for the invoice fix re-analysis is necessary).

Kristen WilsonNovember 18, 2021 at 7:32 PM

Ah, yes that makes sense that the payment falls outside the report period. I think users are finding it confusing that those subscription dates are listed at all. Can we omit them instead of including them with no money or usage listed?

Adam DickmeissNovember 18, 2021 at 6:35 PM
Edited

For the 6000 invoice mod-eusage-reports have the following data:

The subscription date range starts with 2022 .. If I select a period with at least January 2022, then these lines are not zero anymore.

If these dates are right, I don't think there's an issue with mod-eusage-reports on this matter.

Adam DickmeissNovember 18, 2021 at 3:39 PM

Thx will look into that.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Mjolnir

Fix versions

Release

R3 2021 Bug Fix

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 18, 2021 at 2:34 PM
Updated September 21, 2022 at 12:20 PM
Resolved November 19, 2021 at 5:17 PM
TestRail: Cases
TestRail: Runs