maheshnaik85
Member
Dear all,
I have written a program to calculate closing balance, but I dont know how to keep track of exchange gain amt.
for eg: suppose My base currency is INR .for customer "100" I send the invoice for $100 ( exchage rate 40 Rs = 1 $ ) . It means I have to received Rs 4000/- from the customer.
When I received a check from customer of $100 that time exchange rate was 50 Rs = 1 $ . It means that I received Rs 5000/-.
My program is designed like it will do 4000-5000. and it will show Rs 1000
as a closing balance , but in realilty the transaction is balanced.
This amt Rs 1000/- goes to exchange gain account.But how should I add that amt . Can anyone suggest me a query on gltr_hist to get the record.
I have written a program to calculate closing balance, but I dont know how to keep track of exchange gain amt.
for eg: suppose My base currency is INR .for customer "100" I send the invoice for $100 ( exchage rate 40 Rs = 1 $ ) . It means I have to received Rs 4000/- from the customer.
When I received a check from customer of $100 that time exchange rate was 50 Rs = 1 $ . It means that I received Rs 5000/-.
My program is designed like it will do 4000-5000. and it will show Rs 1000
as a closing balance , but in realilty the transaction is balanced.
This amt Rs 1000/- goes to exchange gain account.But how should I add that amt . Can anyone suggest me a query on gltr_hist to get the record.