Transaction Saved Search that will extract posting transactions associated to Accounts that uses the Average General Rate Type
Set the following Criteria on the Search:
Account: General Rate Type = is Average
Subsidiary = Child Subsidiary
Period = Preferred Month
Posting = True
Set the following fields as under Results tab:
Consolidated Exchange Rate = None
Show Totals = True
Columns subtab:
Document Number
Date (important)
Amount | Function = Absolute Value (important)
Export the result.
Amounts will be shown in the child subsidiary’s base currency