This topic explains:
Custom Views, ready-to-use:
Items Never Loaned Out
Items never loaned out: this view displays the list of items from your library that were never loaned out.
Number of Loans By Year_Month
Your library has loan transactions processed over several years. You would like to see the number of circulations by month together with the year (example "2018 / 01").
Explanation: the SQL query extracts month number from the loan date (January will be 1), to have results in order the month number is converted to 01.
Library Replace Cost Of Not Returned Items
What is the cost of the not returned library items? How to list the not returned library items together with the replace cost?
Copyright © 2018 · All Rights Reserved · PrimaSoft PC