Tuesday, July 2, 2019

Create a Transaction Search with Foreign Currency Balance and Base Currency Balance

1. Navigate to Transactions > Management > Saved Searches > New.
2. Click Transactions.
3. In the Criteria tab > Standard subtab > Filter column; add the following:
a. Account = (example)HSBC Mastercard bank account
b. Posting = True
c. Date = 1/1/1900 to 1/31/2014
d. Type = is not Currency Revaluation

4. In the Results tab: add the following: (You may also opt to remove some that you do not need; I will indicate the ones that are important.)

a. Date

b. Period

c. Type

d. Number

e. Name

f. Account

g. Memo

h. Amount - (This is important.)

i. Exchange Rate

j. Amount (Foreign Currency) - (This is important.)

k. Date Created

5.. Rename search Title.
6. Click Save & Run.

No comments:

Post a Comment