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