Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    DigiTool

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. DigiTool
    3. Knowledge Articles
    4. ARC ‘Local Sum’ not always reflecting Aleph ‘Local Amount’

    ARC ‘Local Sum’ not always reflecting Aleph ‘Local Amount’

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

    Problem Symptoms:
    ?€˜Local Sum?€™ amount in the ARC, Acquisitions package, is not always reflecting the ?€˜Local Amount?€™ -- on the General Invoice screen in the Acquisitions module -- in Aleph.

    Cause:
    The ARC ?€˜local sum?€™ amounts are coming from Aleph Z601_LOCAL_SUM in the Z601 table. When the invoice is initially created the Z601 is generated; however, the baseline Aleph service acq-29 (Cheque updating program) was not being used to update the Z77 (invoice table) when the check payment information was received from the ERP (Enterprise Resource Planning) system. Instead, an SQL update to table Z77 (General Invoice) to insert the check number generated from the ERP was being performed. This failed to activate the trigger to update the Z601 (Budget Transaction), meaning that exchange rate fluctuations that will result in different Local Amounts in Aleph were not being carried over to ARC via Z601. Small exchange rate differences between the time of the invoice generation and payment were not being picked up.

    Resolution:
    Use the acq-29 service (instead of SQL) to perform the check updates.

    Additional Information

    See also Article 000021957 ("Discrepancies between invoices in Aleph and payments in Finance system")


    • Article last edited: 1/8/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Apostrophes in Digitool Repository Replications
      • ARC 4.0 : Circ-Logger: Minimum date invalid in configuration file
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      DigiTool
    2. Tags
      1. contype:kba
      2. Prod:DigiTool
    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