F-03 - detailed workings for large volume of transaction

[former_member1263431]

Hi,

I have a GL where there are many transaction in different FX currencies going through the year. At the end of each year the GL is cleared down to nil in document currency by way of summing to nil. And then the local currency is cleared through the F-03 function. So then at year end, the entire account is nil and closed.

I am currently being audited and they have sampled a couple of the F-03 journals that were posted, however I am unable to work out how to recalculate it from start to finish.

Because it is not a simple one to one relationship in this GL, it is over the whole year, I cannot seem to work out how F-03 aggregates and calculates the journals to make.

From looking at the postings, there are multiple postings in say the USD currency, and they are at varying different FX rates that I think are a blended mixed rate of some kind?

In the end, I want to be ale to recalculate any F-03 resultant line item, by using the data from the GL in the year. Can someone please provide me with the intricate details/is there a manual as to how it is calculated?

Thank you,

[sanilbhandari]

Hi ronyap28

I am not sure, if you can get all the details you need. Assuming you are on ECC, you might get details of all the documents cleared with reference to a clearing document through BSAS table. You can than have a look at the documents cleared and analyze the business rationle for the same. If you are an end user, you can get the required info with the help of an IT Colleague. However, there is system report to tell why document(s) were cleared using a specific clearing document, since that is a business decision, when the documents were cleared in the first place

Thanks & Regards

Sanil Bhandari