Saved search to show all the Journals which have the transaction currencies and base currencies are different but the exchange rate wrongly added as one.

Scenario

Client created JEs and they made wrong exchange rate in the transaction. i.e., if the base currencies and transaction currencies are different, the exchange rate will not be 1 But they wrongly added one as the exchange rate. So, they want to know which all are the wrongly posted JEs. Eg. USD to USD will be one but USD to GBP is 0.85 But here USD to GBP is 1.00.

Solution

For this reason, we created a Transaction saved search

1. List > Search > Saved search > New
2. Select Transaction as Search type
3. Under Criteria tab,
   a) Select Type as “Journal”
   b) Select Posting as “True”
   c) Mention Period as “This Fiscal Year To Period”
   d) Select Formula (Numeric) and, in the formula field type formula as “CASE WHEN {currency} = {subsidiary.currency} THEN 1 ELSE 0 END”
   and under Formula (Numeric) field select the value as “equal to” and type 0 in the value field.
   click set
   e) Select System note : Type as Create
   f) Exchange Rate (Line) as 1.00
   
4. Under Results tab,
   • Select Document Number
   • Select Subsidiary (No Hierarchy)
   • Select Period
   • Select Date Created
   • Select Currency
   • Select Exchange Rate
   • Select created by
5. Click Save.