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

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