Reports of Fixed Assets Register

Type of Depreciation

This checkbox is affected by the setting made in the menu Settings | Program | Administration panel | Settings | Financials | Fixed Assets in section Settings, where you define for what kind of depreciation the report is being created.

Inventory No.

Enter the inventory number for which you want to display data. You can select it from the drop-down menu by clicking on the  (arrow) icon. More inventory numbers can be selected by clicking on the  (magnifier) icon.

If the field is left empty, the report is created for all inventory numbers.

Parent Inv. No.

Field is shown only for the selected report type Fixed Assets Register – Structure.

The data displayed in the report may be limited by the inventory number of the parent fixed asset.

Department

The data displayed in the report can be limited by a specific department. You can select it from the drop-down menu by clicking on the  (arrow) icon. More departments can be selected by clicking on the  (magnifier) icon.

Cost Center

The data displayed in the report can be limited by a specific cost center. You can select it from the drop-down menu by clicking on the  (arrow) icon. More cost centers can be selected by clicking on the  (magnifier) icon.

HINT Using the function   opens Lookup table in which multiple options can be selected within a single field. In this case, different Cost Centers in relation to their Name, Group or Status.

Location

The data displayed in the report can be limited by a specific location. You can select it from the drop-down menu by clicking on the  (arrow) icon. More locations can be selected by clicking on the  (magnifier) icon.

hint Location can be set on the Movement or Utilization tabs. Some reports have the option to set which location should be taken into account (either from the the Movement or Utilization tab): If the Movement tab is selected, it is essential that data on the tab (Date of isssue/Returned, Quantity) is entered correctly. If the Utilization tab is selected, it is essential that data on the tab (Utilization Start/Utilization End, Quantity) is entered correctly.

Assigned to

The data displayed in the report can be limited by a specific person to which fixed assets are assigned to. You can select it from the drop-down menu by clicking on the  (arrow) icon. More persons can be selected by clicking on the  (magnifier) icon.

Caretaker

The data displayed in the report may be limited by specific caretakers of fixed assets.

HINT Caretaker is set on the Utilization tab, which is why, on some reports, this filter is only visible when you select Utilization in the report criteria:

Option is multiselect, so you can choose more than one Caretaker.

Supplier

The data displayed in the report can be limited by a specific supplier.

Name

The data displayed in the report can be limited by the name of subject.

Name 2

The data displayed in the report can be limited by name 2 of subject.

Labels to skip

Available only for reports 106 and 10C (Inventory Labels for Fixed Assets). It enables you to skip first x labels on paper. It is useful especially when there are already some used labels on paper.

Quantity

This section is shown only if you select one of the following report types:

• 221 – Fixed Asset Card
• 222 – Register by inventory numbers
• 223 – Fixed Asset Register
• Inventory Sheets reports
• Inventory Labels reports
• Fixed Assets Register – Details reports

Select from which tab the quantity will be shown on report:

• Movement: Data about quantity and location can be set on the Movement or Utilization tab. On reports/filters where this data is included, the user must select from which tab data will be filtered/displayed on the report. 
• Utilization: Data about quantity and location can be set on the Movement or Utilization tab. On reports/filters where this data is included user must choose from which tab the data will be filtered/displayed on the report. 

Deprec. Categ.

The data displayed in the report can be limited by one or more selected depreciation categories. You can select it from the drop-down menu by clicking on the  (arrow) icon. More categories can be selected by clicking on the  (magnifier) icon.

Tax Depreciation Calculation

The data displayed in the report can be limited by one or more selected tax depreciation category.

warning This option is available only when tax depreciation calculation is enabled in the Settings | Program | Administration panel | Settings | Financials | Fixed Assets.

WARNING When you have separate business and tax depreciation, reports for tax depreciation are also available.

Acquisition Acct.

The criterion used for the report can be the acquisition account from the account setting in the Fixed Assets register (see the chapter Main window) or a specific set of accounts (by using wildcard characters).

Status

The data displayed in the report can be limited by status (by date) of the LAST record in the status item of the fixed asset.

Account

The report criterion may also be the acquisition account from the status item in the fixed asset register or a specific set of accounts (by using wildcard characters).

Entry type

Certain reports can be limited according to the type of entry in the Fixed Assets register (criterion is not available on the reports of the type Fixed assets register - detailed). You can select more than one entry type from the drop-down menu by clicking on the  (magnifier) icon.

Entry Type Date From/To

Report can be viewed depending on the entry type date.

Date of Value

By default, the date of balance is today's date. Reports are therefore created according to the balance of the revaluated purchase and upward revaluated value on the current (today's) date. In such a case, all records, which are of this or date or earlier from the Balance panel are displayed in the report. Only those entries of the fixed asset acquisition and revaluation/depreciation of fixed asset are considered that are of this date or earlier. Only confirmed calculations are displayed in the report!

If you try to display the fixed asset card, then ALL the records from the fixed assets register will be displayed, but limited only to the items to Date of balance. If the fixed asset has been purchased on the selected date of balance and has been depreciated accordingly, then this fixed asset will be included in the report of the fixed asset card. But the data will not be visible in the Items register, because it has not existed on the entered date of balance.

Due to the nature of the calculation, certain reports (Fixed assets register - detailed) that do not have a selected date of balance are not displayed.

Supp.doc.

The data displayed in the report can be limited by the number of suppliers document entered in the Fixed Assets register on the Accounting tab in the Suppliers Invoice field.

Related doc.

The data displayed in the report can be limited by the document based on which the fixed asset has been received (related doc. field from the Balance panel). If fixed assets that are kept in records under multiple different inventory numbers are received based on one supplier invoice, then this function is useful for creating a summary report.

Our doc.

The data displayed in the report can be limited by the number of your document entered in the Fixed Assets register on the Accounting tab in the Internal Document field.

Manuf. No.

The data displayed in the report can be limited by the manufacturer's part number of the fixed asset.

Year of manufacture

The data displayed in the report can be limited by the year of manufacture of the fixed asset.

FA group

The data displayed in the report can be limited by a specific group of fixed assets, which is selected from the drop-down menu.

You can also use the multiselect option by clicking on the  (magnifier) icon, which enable more than one FA Group to be included in the report.

Func. State

The data displayed in the report can be limited by a specific ID of the functional state of the fixed asset.

Purchase From

The data displayed in the report can be limited by the start date of acquisition.

Purchase To

The data displayed in the report can be limited by the end date of acquisition.

Activation From

The data displayed in the report can be limited by the start date of activation.

Activation To

The data displayed in the report can be limited by the end date of activation.

Deactivation From

The data displayed in the report can be limited by the start date of deactivation.

Deactivation To

The data displayed in the report can be limited by the end date of deactivation.

Disposal From

The data displayed in the report can be limited by the start date of disposal.

Disposal To

The data displayed in the report can be limited by the end date of disposal.

Subtype

The data displayed in the report can be limited by the subtype selected in the header of the Fixed Assets form.

License plate

The data displayed in the report can be limited by the no. of license plate if the fixed asset is defined as a compact vehicle or trailer.

Sort by

Records in the report from the Fixed Assets register can be sorted by:

• Accounts
• Depreciation categories
• Inventory numbers
• Department
• Location
• Supplier
• Assigned to
• FA Group

HINT These criteria are not available when trying to display Fixed Assets register structure.

Include Disposed Fixed Assets

Used to show value data for already disposed fixed assets in the reports 221, 222, 223, 22E, 22R, 22S.

Report

Displays a preview of the report.