FAGLFLEXA and FAGLFLEXT Amount in Transaction currency are Incorrect
Has any one faced any issue using the FAGLFLEXT table for preparing a report for amounts in transaction currency?
Recently I was investigating that a BI report based on a standard extractor from FAGLFLEXT was reporting incorrect transaction figures. What I observed was, issue is not with the BI but the FAGLFLEXT table.
Then I researched further and got below links explaining the behavior in which FAGLFLEXA and FAGLFLEXT are updated.
Though the article is good but it left me wondering how are people dealing with the value in transaction currency based on new gl totals table FAGLFLEXT.
As these values are not correct and does not represent correct picture in case of exceptions mentioned in above link.
Another wiered aspect is the forex gain loss entries which are posted during clearing of different/cross currency document doesn't update the value in transaction currency correctly as well in FAGLFLEXA or T table.
Any help on how someone has dealt with it would be a great help.