Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Discrepancies between invoices in Aleph and payments in Finance system

    Discrepancies between invoices in Aleph and payments in Finance system

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    Discrepancies between invoices in Aleph and the actual payments seen in the University Finance system Agresso ABW. These discrepancies seem to have to do with exchange rates for non-local-currency invoices and where the figure for the ?€œPayment?€? column in the acq-16 report (Budget Summary) comes from {the Invoice Local Amount or the budget transaction table (Z601)}.

    Cause:
    The main cause of the large discrepancy is not the exchange rate but an error in the local SQL/PERL script which was exporting the data from Aleph. The problem concerned the VAT components of any credits: when credits were posted to QL/ABW, the total amount of the credit was (correctly) posted as a negative sum. However, any VAT component of this credit was (incorrectly) posted as a positive sum.

    Resolution:
    Create a reconciliation report between the two systems, based on the z601_local_sum which remains static and is the figure which populates the Payment figures in the acq_16 report.


    • Article last edited: 1/8/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Discarded items being searchable in OPAC
      • Discrepancy between GUI and WebOPAC requests for a patron
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved