• 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