Bug 39959 - Add total amount column to invoice search results
Summary: Add total amount column to invoice search results
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Acquisitions (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-05-21 16:37 UTC by Hannah Dunne-Howrie
Modified: 2025-07-07 13:03 UTC (History)
0 users

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Hannah Dunne-Howrie 2025-05-21 16:37:10 UTC
We want to be able to customize the invoice tables we see here https://wcc-rbkc-staff.koha-ptfs.co.uk/cgi-bin/koha/acqui/invoices.pl like we can for the order tables so we can add in the columns we want or hide columns as needed. 

In particular, we want to be able to add in total columns to this view so when we search for invoices we see the total amounts in the search results to quickly help us work out which invoice is which when we have limited information but know the total amount.
Comment 1 Hannah Dunne-Howrie 2025-07-04 16:52:32 UTC
So, I was recently dealing with a reported problem with invoices (publisher sending through duplicate invoice numbers to new invoices) and it would have really helped if there was a 'total amount' column in invoice search results to be able to see quickly and easily which invoice was which by amount. Instead I had to go into each individual invoice and check the amounts which was LONG. You would make us very happy if we were able to customize this table view to include more columns
Comment 2 Owen Leonard 2025-07-07 12:57:55 UTC
The invoice detail page shows three different totals:

Total (GST X %)
Total ($)
Total + adjustments + shipment cost ($)

Which do you think is the correct one to show?
Comment 3 Hannah Dunne-Howrie 2025-07-07 13:03:11 UTC
That's is a very good question. For us we want 'Total + adjustments + shipment cost ($)' but I'm aware that other libraries might need a different value, so my hope would be that instead there are options to customize the table view in configuration so perhaps all three are enabled but then in configuration libraries can choose which to hide by default from view.