|
 |
 |
 |
 |
 |
|
|
| |
| |
| |
| Tip #4:Compacting your FRX specset database: |
 |
| Frx stores all its report data in a database; external to Solomon. On a periodic basis, say bi monthly, you should compact your spec set database. This task is very simple, but often overlooked by end users. To compact your frx database you choose from the main menu File, then the menu choice : Compact FRX database, then current spec set database. This screen shot describes the location of these menu choices : |
| |
 |
| |
| After successfully compacting the
database, you will get a simple message like: |
| |
 |
| |
| |
| Tip #5: Your report worked previously but now it is giving you bad data. |
| |
| If you have say one column on a report which is giving you bad data, while all other colunmns of the report are properly presenting data, I recommend you review the logic of the problem column in the column definition. If this column definition looks okay, I have seen the problem of the bad data being reported become correct by deleting and re entering the column from the column building block. If this solution works, make sure you save your frx data. |
| |
| |
| Tip #6: Saving your report FRX definitions |
| |
| FRX is a third party software, which is typically used to create all of Solomon financial reports. The logic for the FRX reports is not included with the Ms sql data for Solomon. Therefore it is critical that you back up this data to a safe spot whenever you update or change your financial reports. The location of your data may vary depending on which version of FRX you are using. Therefore these instructions may need to be modified for your particular company; and how FRX was installed. Typically, the FRX programs and your FRX database are stored where ever the Solomon modules files are stored. In a multi user environment, these files are stored typically on the Solomon server in a sub directory below Solomon IV called FX, FV, FD or FP. The multiple subdirectories result from the various versions of FRX, which you may be using. Using only one of these four sub folders has any data or programs in it. This is likely to the also where your frx report definitions are also stored. Check with your VAR if you are not clear how FRX was installed. After locating the desired folder, just make sure this folder and all of its sub folders are backed up. (Typically the data is stored in the sysdata folder). I recommend you keep a copy of these report frx folders on both your server and your main local workstation for your power FRX user. |
| |
| |
| Tip #7: Always turn on Recalc of GL indexes: |
| |
| I have found that the simple trick of always turning on the flag to recalculate FRX gl indexes greatly improves the accuracy of the reports. This flag is found in the catalog are under the field called: report date. Clicking on the black down arrow next to the report date, will bring up this subform: |
| |
 |
| |
| I have found that the simple trick of always turning on the flag to recalculate FRX gl indexes greatly improves the accuracy of the reports. This flag is found in the catalog are under the field called: report date. Clicking on the black down arrow next to the report date, will bring up this subform: |
| |
| I hope these tips are useful. You have a great tool with FRX. Use it. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| ...Back |
...Back to top |
|
|
|
|
|
|
| |
| Copyright © 2007 Systematic Solutions Incorporated. All rights reserved. |
| |
| |
|
