Dear Expert,
Transaction code FAGL_FC_VAL calculates foring exchange gain / loss for both Outstanding Invoice and Advances for same PO. It should calculate forex difference for net out standing amount only.
For e.g
1. PO is created for USD 100 ( 50 INR / USD)
2. Advance paid against same PO USD 10 ( 55 INR/ USD)
3. Cleared adavance paid Tcode F-54
4. MIRO booked USD 100 (USD 52 INR/ USD)
5. Net outstanding amount is USD 90 (USD 100 - 10)
6. Month end rate is 60 INR/ USD
7. System should calculate foreign exchange difference as [90 * 8 ( 60 - 52) ] = 720 INR
In current scenario system is calculating foreign rate difference as below.
1. Advance paid USD 10 * 5 (60 - 55 ) = 50
2. O/S Invocie USD 100 * 8 (60-52 ) = (800)
Net Foreign exchange loss : (750) INR
Please advise for same.
Regards,
SK