General Invoice "Local Amount" changes after invoice has been paid

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
Our Acquisitions Department noticed something about Currency Conversion in the General Invoice. After an Invoice has been paid, the currency rate was changed. She changed the currency rate but noticed the dollar amount in a previously paid General Invoice with this currency changed refelecting the change in the new currency rate. The budget line didn't change, so she's not too concerned. She had never noticed this before. She wants to know if this isnormal or is this a change since Version 16? I didn't find anything in the documentation, knowledge base or support incidents.

Resolution:
The individual line items (z601s) contain the Local sum as a data element (z601_local_sum).

The general invoice (z77) does not actually contain the Local sum as a data element. The (total) "Local Amount" which displays on the General Invoice screen is calculated by taking the "Total Amount" and multiplying it by the current z82 ratio for this currency (--except when the z77_i_currency_ratio is populated; see below).

The z601 line items, in contrast, *are* "frozen" at the time the payment occurs.

It's our feeling that the "Local Amount" on the general invoice should also be frozen. This issue is open with Development.

Note: The z77 General Invoice screen contains an "Explicit Ratio" (z77_i_currency_ratio), which takes precedence over the z82 ratio in calculating the "Local Amount". You *could* populate this field at the time the invoice is paid, preserving that ratio and forcing it to be used in any future displays. (But we feel that the *system* should do this.)

(See KB 8192-5191 in regard to how the Explicit Ratio should be entered in.)
This issue is still open and was escalated to Development for further investigation <2008-10-12 01:00:00>.

• Article last edited: 10/8/2013