|
| |
| Of course, all true detail reports must reference GLREC. However, financial reports which only look at summary data reference SUMREC instead and thereby recognize a dramatic speed improvement as the amount of data to be reviewed is much smaller. Certain transactions, like exchange rate changes which operate on balance information, also use SUMREC in order to recognize speed improvements. |
Unfortunately, some of our customers, particularly those who had large numbers of
foreign currency accounts or who changed exchange rates frequently, did not experience
the full amount of the speed improvements that would have been expected. Upon detailed
investigation, we found that the system was storing unnecessary records in SUMREC related
to exchange rate changes. |
As some of you may have noticed when reviewing GL detail information, each time
you change exchange rates, each of your foreign currency accounts gets two transactions posted
to it. The first is a reversal of the account balance at the old exchange rate and the
second is a reposting of the account balance at the new exchange rate. Of course, in the
native currency of the account, the value of the transaction is zero while in domestic
currency, the value of the transaction is the balance in the account multiplied by the
difference in exchange rates. |
It turns out that while the exchange change information must of course be stored in the
GLREC detail file, the value of the summary posting in SUMREC which is tracked in the
native currency of the account is always zero. Consequently, there is no real reason to
track the information in SUMREC at all. We have therefore removed the SUMREC zero postings
for exchange rate changes from the system. |
We found that this change had a dramatic effect for one of our partners in this project.
The time to run their balance sheet was reduced by 75%. That is, it now takes them a
quarter of the time that it used to, to run their balance sheet. Of course, they did
have over 80 foreign currency accounts and have been changing their exchange rate daily
for four years. Actual speed improvements recognized will vary depending on the number
of foreign currency accounts, the frequency of exchange rate changes and the number of
years of data in your system. |
WARNING |
While the Load Summarized GL option is relatively straightforward to run, it must be
run when there are no other Minotaur programs being run and it can be time consuming.
As it is a bulk data change option, we also recommend that it be run in a controlled
format. |
Following is a recommended process for running the Load Summarized GL option. |
| |
|
|
 |
|
| |
