Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Change to invoice line item or order price not converted to local currency

    • 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
    //doorbell.io feedback widged