FXA - Asset Transactions (Report)
Overview
The Fixed Assets 'Asset Transactions' report program generates a detailed report providing asset financial transactions as at a nominated period. It produces a line for every transaction that has occurred to the assets during the 'Year/Period' selected.
For each asset, it displays:
'Opening Net Book Value'.
All Transactions.
'Closing Net Book Value'.
This report/export has extensive options that can be selected at run-time. These selections can be saved as your own report 'Configuration' profiles. Another user (and vice versa) can't access a report 'Configuration' that you create. This is because each 'Configuration' is dependent on the individual user's security permissions that determine the fields that can be included.
To use a previously saved report configuration, select it from the 'Use a Previously Saved Configuration' picklist and click 'Next'.
The 'Use a previously saved configuration' picklist will only be available if a saved configuration exists.
To create a new configuration, click the 'Next' button without selecting an option from the 'Use a Previously Saved Configuration' picklist.
Enter your runtime options for the program.
To save the runtime options that you have entered as a re-usable report configuration, enter a meaningful description into the 'Save this Configuration as' field on the 'Process' or 'Print' tab.
You can delete a report configuration by selecting it from the picklist, clicking the 'Next' button, and then clicking the 'Delete' option.
You can modify an existing configuration by selecting it, making the necessary changes to the run-time options, then clicking 'GO' on the 'Process' or 'Print' tab. You need to ensure the 'Save this Configuration as' field is populated with the report configuration name. This field is populated automatically when an existing configuration is selected.
General Tab
Enter 'Search Criteria' into the 'General' tab to filter the data produced in the report.
Fields that require detailed explanation | |
|---|---|
Period Category GL Location Physical Location Transaction Type | It is possible to select multiple options in these drop-down lists by using the 'Ctrl' key and clicking in combination. |
Trans Amount Depn Amount Net Book Value | These fields will allow the report to be generated for assets where the amount entered here is the same on the asset record. It also has a 'Money Range Picker' that allows for a range to be entered. |
Entered Date | This field allows a date range to be entered. The subsequent report will display only assets for which the transaction was entered during the range nominated. |
Print Tab
Sort By
The default is for the report to sort by 'Asset Code'.
Alternatively, you can elect to sort by 'Asset Description', 'Category', 'GL Location', 'Physical Location', 'Category/GL Location' or 'GL Location/Category'.
Formatting Options
Choose the 'destination' of the report. This can be to Adobe® PDF viewer, Microsoft Excel®, Microsoft Word® or a screen with hyperlinks.
The 'Screen with Hyperlinks' format is best if you need to 'drill-down' to further information.
Use the checkboxes to indicate your preference for displaying 'Alternate Row Colours' and 'Table Borders'. These options can enhance the readability of the report but are not available if the listing destination is Excel®.