Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    What do the FullFund scripts do?

    • Product: Voyager
    • Product Version: All
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    Question

    What do the FullFund scripts (FullFundPendingExpenditures3.sql, FullFundPendingCommitments3.sql, FullFundExpenditures.sql, FullFundCommitments3.sql, FullFundDiagnostic.sql) do?

    Answer

    FullFundDiagnostic.sql can be run regularly to help identify any discrepancies in FUND.COMMIT_PENDING, FUND.COMMITMENTS, FUND.EXPEND_PENDING, and FUND.EXPENDITURES.

    Based on the results of the diagnostic any or all of the following would be run to correct the relevant total.

    FullFundPendingCommitments3.sql

    recalculates the pending commitments and updates the fund summary totals (FUND.COMMIT_PENDING)

    FullFundCommitments3.sql

    recalculates the commitments and updates the fund summary totals (FUND.COMMITMENTS)

    FullPendingFundExpenditures3.sql

    recalculates pending expenditures and updates summary totals (FUND.EXPEND_PENDING)

    FullFundExpenditures.sql

    recalculates expenditures and updates summary totals (FUND.EXPENDITURES)

    Additional Information

    See also Fund discrepancies - totals displayed in Acquisitions not accurate

     


    • Article last edited: 08-Oct-2013