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

    Discrepancies between invoices in Aleph and payments in Finance system

    • 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)}.

    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.

    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