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

Description:
We have noticed the following for some time now:

i. When we are invoicing an item and make changes to the price of the item it does not convert to the local currency.

ii. The same thing happens when we make changes to the price of an item in an order record downloaded from YBP.

The conversion works normally when the original order record goes into the system.

Resolution:
Looking at the abc50 z82 (corresponding to the GUI Acq - Admin - Currency display), I see this:

abc50@ALEPH20> select Z82_DATE, z82_ratio from z82 where Z82_CURRENCY_NAME = 'GBP';
**** Hit return to continue ****

Z82_DATE Z82_RATIO
---------- ------------
0
20110708 000010600000

That is, a single date/ratio for each currency.


What I'm *used* to seeing is a series of dates/ratios for a currency, such as:

Z82_DATE Z82_RATIO
---------- ------------
20001123 000004120000
20001124 000004107000
20001127 000004105000
20001128 000004100000
20001129 000004104000
20001130 000004093000
20001201 000004100000
20001204 000004103000
20001205 000004092000

Do you use p_acq_20 to load/update your currency records? p_acq_20 preserves the old currency records so the system has a history of dates/ratios it can look at.

Or do you, perhaps, simply update the ratio in the GUI Acq - Admin - Currency? If so, you lose the history.

I suggest that you start using p_acq_20 to update your currencies.

• Article last edited: 10/8/2013