Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Get Invoice "Local amount" incorrect when "Explicit Ratio" is non-zero

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

    Description:
    I've got this result for converted data on PROD server and replicated it in Ex Libris' USM50 (il-aleph02 / region 181).

    (1) Open Gui Acq & connect to USM50
    (2) Retrieve order number 51639
    (3) Click on "Invoice" and select "Gen Invoice"
    (4) This is what happening:

    IF "total amount" = 14658.00
    and "currency" = JPY
    and "explicit ratio" = 0
    then system takes JPY ratio 0.94 from the z82 table and calculates "local amount" = 137.79
    The "local amount" *is* correct.

    Now enter 0.008825 in the "explicit ratio" field and click on "Refresh".
    Note: 0.008825 is USD amount converted in CMA gen invoice record.
    As a result: "local amount" is now 1.29 which is incorrect.
    The "local amount" should be:
    "total amount" X "explicit ratio" ==> 14658.00 X 0.008825 = 129.36

    I think there is a decimal error with gen invoice. The local price is off by two decimal points.
    It's showing 1.29 instead of 129.36

    Resolution:
    You need to put the z77 Explicit Ratio in the same form as the z82_currency_ratio.

    Note: The correct currency code for the Japanese yen is "JPY", not "JAY".

    We see this for the z82_currency_ratio (for JPY):

    JPY 20020129 000000749000
    JPY 20040212 000000940000

    while the z77_i_currency_ratio's for "JAY" are like this:

    000000006608
    000000006200
    000000006200
    000000007415
    000000007700
    000000007800
    000000007901
    000000007835
    000000007917
    000000008210

    abc50@ALEPH1> select z77_rec_key from z77 where z77_i_currency_ratio = '000000008825';
    **** Hit return to continue ****

    Z77_REC_KEY
    -----------------------------------
    92 1893


    The ratio of 0.008825 *should* be like this:

    000000882500

    Please try that.

    Jerry


    • Article last edited: 10/8/2013