OPplus Ext. Fixed Assets

This chapter describes how to set up and to use the OPplus Ext. Fixed Assets module. In the application, you can open this module in the navigation area via the Fixed Assets group.

OPplus Fixed Assets Setup

In the OPplus Fixed Assets Setup window, you can use create the setup data by selecting the “Create Setup Data OPplus” button.

You must fill in the fields of the OPplus Fixed Assets Setup window for each company you manage with Microsoft Dynamics™ NAV. This section describes the tabs and fields of the OPplus Fixed Assets Setup window.

To open the OPplus Fixed Assetes Setup window from the navigation pane, click OPplus → Fixed Assets → Setup → OPplus Fixed Assets Setup.

FA Setup

General tab

General Tab

Acquisitions tab

Acquisitions Tab

Retirements tab

Retirements Tab

FA Template

To open the FA template card, go to the FA template list.

Open FA Template

On the FA Template Card, you can define FA templates which allow to speed up the process of creating new assets. In the template, you can predefine various standard fields of the asset, the asset depreciation books and specify the “Inventory Management“ field on the OPplus tab.

You can open the FA templates in the following ways:

  • Via the FA Gen. Journal

Create FA from Template

  • Via the FA Journal

Create FA from Template

  • Directly from a purchase invoice or purchase order

Create FA from Template

  • Via the FA Card

Create FA from Template

In the “Create FA from Template“ window, select a FA template code. Then, define the starting date of regular depreciation and enter the FA name in the “FA Description“ field. In the “No.“ field, you can either use a number series which is automatically generated by the system or specify the FA number manually by previously activating the “With Fixed No.“ field.

After having specified the fields, it is required to click the “Create FA“ button to automatically create the FA. If the “Show FA Card“ check box is activated, the system will open the FA card:

Create FA from Template

FA After Creation from Template

If the FA was created from a FA template, the “Inserted by FA Template“ field will contain a check mark. This setting can be used if you want to check the assets subsequently. After having checked the assets for correctness, you can deactivate this field.

FA Card

The FA Card contains the following new fields and functions:

FA Card

Pmt. Discount on Acquisition Costs

If the “Pmt. Discount on Acquisition Costs“ field is activated in the OPplus Fixed Assets Setup, the acquisition value of the fixed asset will be reduced by deducting the payment discount during purchase invoice payment.

If the purchase invoice contains two or more fixed assets, the payment discount amount will be automatically distributed accordingly. The same applies if the purchase invoice contains both fixed assets and items.

If the application of the purchasing invoice is reversed e. g. in order to apply another invoice instead, the respective posting in the Fixed Asssets area will also be corrected by reversing the correction of acquisition costs (and possibly of depreciation).

Warning

The depreciation posting which is automatically performed by the system on the date of payment remains unchanged when selecting the “Unapply“ function.

If you have performed a depreciation posting between the time of invoice payment and asset acquisition, the depreciation posting will be also corrected accordingly.

For this type of transactions, it is useful to set up a separate product posting group for assets. There are two setup ways in the Gen. Posting Setup:

  • Setup of pmt. discount accounts with balance sheet accounts for asset aquisitions:

General Posting Setup

Payment posting with pmt. discount:

Posting Payment Discount

View of asset entries and general ledger entries:

Entries after Posting

  • Setup of pmt. discount accounts with dedicated pmt. discount accounts for asset postings:

General Posting Setup

Payment posting with pmt. discount:

Posting Payment Discount

View of asset entries and general ledger entries:

Entries after Posting

Round Book Value if Period. Depreciation

If the “Round Book Value if Period. Depreciation“ field contains a check mark in the OPplus Fixed Assets Setup, the depreciation amount will be created in such a way that a rounded book value always remains in case of periodic depreciation and depreciation postings which are generated if the “Depreciation until FA Date“ field is activated.

This will be considered accordingly during the first depreciation posting:

First Deprecation Posting

Depreciation until FA Date and Retroactive Depreciation Adj. for Acquisitions

If the “Depreciation until FA Date“ contains a check mark in the OPplus Fixed Assets Setup, the corresponding field in the journal line or in the purchase document will be activated for additional acquistion postings. This means that a depreciation posting will be performed on the date of asset acquisition:

Depreciation until FA Date

Created Entries

The “Depreciation until FA Date“ will only be activated for further acquisition postings if a depreciation posting has already been made. If no depreciation posting has been performed yet, this field is not required since the next depreciation run will write off the entire acquisition costs as of the starting date of regular depreciation.

If the “Retroactive Depreciation Adj. for Acquisition“ field contains a check mark in the OPplus Fixed Assets Setup, the corresponding field in the journal line or in the purchase document will be activated for additional acquistion postings. This means that a retroactive depreciation posting will be performed on the starting date of regular depreciation.

The “Retroactive Depreciation Adj.“ field will only be set if the additional acquisition posting is performed in the same fiscal year of the first acquisition posting. If the additional acquisition posting is made in a new fiscal year, only the “Depreciation until FA Date“ will be activated. If you want the system to perform a retroactive depreciation adjustment, you can activate this field manually.

Activate Copy Process and Autom. Post Copies

If the “Activate Copy Process“ field is activated in the OPplus Fixed Asset Setup, the corresponding field in the journal line or in the purchase document will automatically contain a check mark for asset acquistion postings.

Use Duplication List

Activate the “Autom. Post Copies“ field if you want the system to directly perform postings, which would be provided in the FA Gen. Journal, and not to copy them into respective journals (as it is the case in the standard application):

Fixed Asset Card Book Value

Also in case of subsequent acquisition postings and when activating the “Depreciation until FA Date“ field, the acquisition and depreciation postings will be posted automatically in the corresponding FA depreciation books.

The following prerequisites apply for the above features:

  • “Allow Copies“ field is activated in the depreciation book
  • Respective journals are specified in the FA Gen. Journal Setup

FA Journal Setup

Depr. Until FA Date for Sales

If the “Depr. Until FA Date for Sales“ field is activated in the OPplus Fixed Assets Setup, the “Depr. Until FA Date“ field in the journal line or in the sales document will automatically contain a check mark for asset disposals.

Sales Invoice

With the “Depr. Until FA Date“ field activated, the system will perform a regular depreciation posting on the date of asset disposal:

FA Entries

Difference between Scrapping and Sale

When performing an asset disposal, you can choose between two options: Scrapping or Sale.

If you want to scrap the asset, place a check mark in the “Scrapping“ field in the journal line and leave the “Amount“ field empty (value 0.00):

Scrapping FA Journal

After posting, the FA Card will indicate in the Depreciation Books area that the asset has been “Scrapped“:

FA Card - Scrapped

A scrap posting can only be performed with an amount of zero (0.00). Otherwise, it will be considered as a sale which has the consequence that you have to deactivate the “Scrapping“ field.

In addition, you have the option to post scrapping by using special accounts if your deprecation books are integrated into the General Ledger area.

FA Posting Group Card

In the following OPplus reports, scrapping will be marked as * for asset disposals:

  • Inventory Sheet
  • Assets Analysis with Reposting
  • Asset Disposals
  • Development of Fixed Assets

Example for an Asset Disposals report:

FA Retirements Report

Assets with Quantities

Setup

To specify quantities for your assets, you need to activate the “Inventory Management“ field in the OPplus area of the FA Card. The FA Depreciation Book will show the remaining quantity for the respective depreciation book.

Quantity in FA Card

OPP Fa Card

The “Inventory Management“ field is also available on the FA Template Card:

FA Template Card

Acquisitions with Quantities

To enter acquisitions with quantities, you can use the following windows and forms:

  • FA Journals

FA Journals

  • Purchase Invoices

Purchase Invoice

The result is shown in the FA Depreciation Books as well as in the FA entries:

FA Depreciation Book and FA entries

The quantity is printed in the following reports:

  • Inventory Sheet:

Inventory Sheet Report

  • Assets – History

FA History

Partial Disposal

If you want to perform a partial disposal for an asset, you can use the new OPplus Partial Disposal feature provided on the FA Card.

To activate this feature, you need to specify a Reposting Journal Template and a Reposting Journal Name in the OPplus Fixed Assets Setup:

Reclass. Template and Batch

Select the “Post Partial Disposal“ menu option which is available on the FA Card:

Partial Retirement Action

Post Partial Retirement

In the window which opens you can enter the number of the new asset by using the number series of the system or by entering a fix number manually. A fix number can also be used for a sub-asset.

On the “Reposting“ tab, you can specify the date and the entry type (e. g. reposting acquisition or regular depreciation), indicate if it is a partial disposal for an asset with quantities and enter the disposal quantity.

On the “Disposal“ tab, you can indicate if it is a sale or a scrap. If you select “Scrapping“, the other fields can no longer be edited. If you have completed your entries, select the “Repost Asset“ button.

Reclassification FA

Once you have selected the “Repost Asset“ button, a new asset will be created with the specified quantity and the ‘formerly existing‘ asset quantity will be reduced accordingly:

Quantity Reduced FA

In addition, a scrap or sale line will be generated in the FA Gen. Journal which needs to be posted accordingly:

FA Gen. Journal

If you use several FA Depreciation Books, you need to perform the partial disposal also for the remaining depreciation books. For this, you can use the asset which has been already created:

Post with Fix Numbers

If you select the “Repost Asset“ button, reposting will be done for the next FA depreciation book by creating a new line in the FA Journal:

FA Gen. Journal

Please make sure that you perform depreciation before posting the partial disposal in order to get the correct book value on the date of disposal and to ensure that depreciations of the existing asset are performed correctly in the future. If you have missed to perform depreciation, the system will show a respective dialog box:

Post Partial Retirement Question

Asset Posting Reversals

Delete Asset No. if Transaction Reversal

If you select the “Reverse Transaction“ button in the FA Entries window, the system will not only perform a reversal in the General Ledger area (as in the standard application), it will also perform a reversal in the Fixed Assets area (OPplus feature) by creating a reversal entry in your Fixed Assets:

Reverse Transaction

Error Ledger Entries Action

This feature is also available for acquisition postings which have been created by using a journal:

Error Ledger Entries

The feature is not available for sales postings as the system only supports asset reversals. However, this can be done more easily with OPplus than in the standard application.

Reversal of Sale or Acquisition Posting via FA Gen. Journal

By activating the “Fill Tax Parameters if Sale or Acq. Reversal“ and “Complete Person Account if Sale or Acq. Reversal“ fields in the OPplus Fixed Assets Setup, you can simplify the process of reversals.

To reverse a sale posting, place the cursor into the Sales Price line in the FA Entries area:

Reverse Transaction

The correct posting will be shown in the FA Journal. The system will calculate the gross amount and enter a balancing account line (if it is a person account):

FA G/L Journal

Now, you need to specify the document number and reverse the sale posting. Any existing depreciation posting created by the sale will not be reversed (as in the standard application). However, you can reverse it in the convential way, if requested.

You can also reverse a purchase posting by using the “Reverse Entries“ button. Also in this case, the system will enter the gross amount and a balancing account line in the journal:

FA G/L Journal

This type of reversal can also be used for purchase postings which have been created by using a purchase invoice or a journal.

Warning

The system will create a reversal posting on the person account which will remain as open entry. Consequently, you need to apply this reversal posting with the original vendor invoice.

Sales Invoice Reversal via Sales Credit Memo

If the “Set FA Reversal Entry No. in Sales Credit Memo“ field is activated in the OPplus Fixed Assets Setup, you can reverse an asset sale via a sales invoice by creating a credit memo via the “Copy Document“ button.

Copy Sales Document

FA Error Entry No.

If you make use of this feature, the system will perform an asset reversal in the Fixed Assets area.

If a depreciation posting has been performed on the date of disposal (with the “Depreciation until FA Date“ field activated), the above performed sale reversal will not reverse the depreciation posting. It will remain in the system.

FA Reports

Inventory Sheet

The “Inventory Sheet“ report shows all relevant FA information such as asset master data or asset postings:

Inventory Sheet Report

Report Assets – History

In the “Assets – History“ report, you can view all postings per FA within a specific period:

FA History Report

Assets Analysis with Reposting

The Assets Analysis report shows the value development of your fixed assets within the reporting year:

Assets Analysis with Reposting Report

Asset Additions

The “Asset Additions“ report shows all asset additions, incl. the values per asset within a specific period:

Asset Additions Report

Asset Disposals

The “Asset Disposals“ report shows the asset disposals postings within a specified period, incl. the disposal date and the sales price. Scrapped assets are marked with an asterisk (*) in the corresponding column.

Asset Disposals

Development of Fixed Asset

The “Development of Fixed Assets“ reports shows the development of individual assets within a specified period as well as the book value on the specified ending date:

Development of Fixed Asset Report

Asset – Preview

The “Asset - Preview“ report shows the expected development of an asset within the next 5 year, as of the starting date.

Asset – Preview Report

You can also work with different group totals accrual in this report. GroupReport