Neeraj Bhuwania
Member
Calculation of wrong Gain/loss and improper display of Foreign Exchange rate in Payment Voucher :
I) In Production environment we get very distorted results as it neither calculates Foreign exchange gain nor payment amount of bank accurately.
As in following case Actual Gain should be Rs.57602/- but as per JDE it is Rs. 20226/-
And Actual amount that should hit the bank account should be Rs.1976070/- but as per JDE it is calculating Rs. 2006598/-
Voucher was booked at respective rate and payment was made @ Rs. 44.14 as follows :-
Voucher Paid as per our calculation Paid as per JDE
USD Rate Rupees Rate Paid amount Gain Rate as Per JDE Gain
3232.03 45.465 146944.2 44.14 142661.8042 4282.43975 44.14 142661.804 4282.44
4300 45.465 195499.5 44.14 189802 5697.5 44.14 189802 5697.5
6127 45.465 278564.1 44.14 270445.78 8118.275 44.14 270445.78 8118.275
1176 45.465 53466.84 44.14 51908.64 1558.2 44.14 51908.64 1558.2
430 45.465 19549.95 44.14 18980.2 569.75 44.14 18980.2 569.75
6463 45.465 293840.3 44.14 285276.82 8563.475 44.14 285276.82 0
6020 45.465 273699.3 44.14 265722.8 7976.5 45.465 273699.3 0
4255 45.465 193453.6 44.14 187815.7 5637.875 45.465 193453.575 0
290 45.465 13184.85 44.14 12800.6 384.25 45.465 13184.85 0
262 45.465 11911.83 44.14 11564.68 347.15 45.465 11911.83 0
631.62 45.465 28716.6 44.14 27879.7068 836.8965 45.465 28716.6033 0
2540.59 45.465 115507.9 44.14 112141.6426 3366.28175 45.465 115507.924 0
3690 45 166050 44.14 162876.6 3173.4 45.465 167765.85 0
1250 45.465 56831.25 44.14 55175 1656.25 45.465 56831.25 0
1950 45.465 88656.75 44.14 86073 2583.75 45.465 88656.75 0
1764 45.465 80200.26 44.14 77862.96 2337.3 45.465 80200.26 0
187 45.465 8501.955 44.14 8254.18 247.775 45.465 8501.955 0
200 45.465 9093 44.14 8828 265 45.465 9093 0
1976070.114 57602.068 2006598.39 20226.16
II) Result of Test case in Development Environment :-
1.Rate is set as follows : from USD to INR
Date Rate
28.03.05 44.00 ( Voucher booking Date)
29.03.05 45.00 ( Voucher booking Date)
30.03.05 44.14 (Payment booking Date)
2.Voucher is booked as follows :-
Number Date USD Amt Rate Amt in Rupees
11 28.03.05 8000 44.00 352000.00
22 29.03.05 9000 45.00 405000.00
3.Payment was made for 17000 USD @ 44.14 gain loss calculated in JDE as follows
For Voucher No. Open Amount Paid Amount Gain/(Loss)
11 352000 353120 (1120)
22 413000 397260 15740
for Voucher no. 11 amount calculated is correct but for Voucher No.22 amount should be as follows
22 405000 397260 7740
and in both the above environment while displaying payment voucher it is picking up 1st vouchers rate of exchange eventhough amount converted is shown correct as per payment rate.
Requested to suggest
I) In Production environment we get very distorted results as it neither calculates Foreign exchange gain nor payment amount of bank accurately.
As in following case Actual Gain should be Rs.57602/- but as per JDE it is Rs. 20226/-
And Actual amount that should hit the bank account should be Rs.1976070/- but as per JDE it is calculating Rs. 2006598/-
Voucher was booked at respective rate and payment was made @ Rs. 44.14 as follows :-
Voucher Paid as per our calculation Paid as per JDE
USD Rate Rupees Rate Paid amount Gain Rate as Per JDE Gain
3232.03 45.465 146944.2 44.14 142661.8042 4282.43975 44.14 142661.804 4282.44
4300 45.465 195499.5 44.14 189802 5697.5 44.14 189802 5697.5
6127 45.465 278564.1 44.14 270445.78 8118.275 44.14 270445.78 8118.275
1176 45.465 53466.84 44.14 51908.64 1558.2 44.14 51908.64 1558.2
430 45.465 19549.95 44.14 18980.2 569.75 44.14 18980.2 569.75
6463 45.465 293840.3 44.14 285276.82 8563.475 44.14 285276.82 0
6020 45.465 273699.3 44.14 265722.8 7976.5 45.465 273699.3 0
4255 45.465 193453.6 44.14 187815.7 5637.875 45.465 193453.575 0
290 45.465 13184.85 44.14 12800.6 384.25 45.465 13184.85 0
262 45.465 11911.83 44.14 11564.68 347.15 45.465 11911.83 0
631.62 45.465 28716.6 44.14 27879.7068 836.8965 45.465 28716.6033 0
2540.59 45.465 115507.9 44.14 112141.6426 3366.28175 45.465 115507.924 0
3690 45 166050 44.14 162876.6 3173.4 45.465 167765.85 0
1250 45.465 56831.25 44.14 55175 1656.25 45.465 56831.25 0
1950 45.465 88656.75 44.14 86073 2583.75 45.465 88656.75 0
1764 45.465 80200.26 44.14 77862.96 2337.3 45.465 80200.26 0
187 45.465 8501.955 44.14 8254.18 247.775 45.465 8501.955 0
200 45.465 9093 44.14 8828 265 45.465 9093 0
1976070.114 57602.068 2006598.39 20226.16
II) Result of Test case in Development Environment :-
1.Rate is set as follows : from USD to INR
Date Rate
28.03.05 44.00 ( Voucher booking Date)
29.03.05 45.00 ( Voucher booking Date)
30.03.05 44.14 (Payment booking Date)
2.Voucher is booked as follows :-
Number Date USD Amt Rate Amt in Rupees
11 28.03.05 8000 44.00 352000.00
22 29.03.05 9000 45.00 405000.00
3.Payment was made for 17000 USD @ 44.14 gain loss calculated in JDE as follows
For Voucher No. Open Amount Paid Amount Gain/(Loss)
11 352000 353120 (1120)
22 413000 397260 15740
for Voucher no. 11 amount calculated is correct but for Voucher No.22 amount should be as follows
22 405000 397260 7740
and in both the above environment while displaying payment voucher it is picking up 1st vouchers rate of exchange eventhough amount converted is shown correct as per payment rate.
Requested to suggest