Forex Difference in case of customer partial payment receipt
we have scenarios where we receive part payment in case of foreign cutomer.
Now when we receive part payment in case of foreign currency invoice we use Residual payment TAB.
In this case system is calculating the forex difference on the full amount not on the partial amount. As per the requirement the system should pass Forex diff amount to the extent of partial received amount to show the correct Realised gain effect.
Example: The invoice amount us 1000 USD @ 45/dollar
Received part payment 500 USD @ 40/dollar
I am using T code F-28(Residual payment)
The USD effect is shown below
Dr. Bank a/c 500 20000
Dr. Customer a/c 500 20000
Cr. Customer a/c 1000 45000
Dr Exchange Diff a/c 0.00 5000
In the above entry the system is passing exchange diff as Rs. 5000 but it should be Rs 2500.
In the above example If I am receiving the full amount within a particular fiscal year then there is no problem, as the net effect of the forex difference will be correct within a year.
Problem arise when i receive the part payment this year and rest of the payment in the next year. Because my realised loss is over stated by Rs 2500 in the above case.
Is there any possible way to show the exchange diff is 2500 not 5000?
Please help anyone.....
Edited by: Paul01 on Apr 9, 2009 9:24 AM