AX 2012 R3 - Fixed Asset Migration with NBV and Depreciation amount

(0) Share

Report

Posted on by Community Member

Looking forward to your advice on migrating just the fixed assets with depreciation and netbook value into fixed asset module, without affecting GL. Because, acquisition and depreciation amount has already been entered into GL manually. I am not sure if DIXF allows us to import assets with NBV and depreciation amount. I appreciate your help.

Thanks,

Rjay

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Rjay,

This can't be done.

If you migrate your transactions into the fixed asset module and post the fixed asset journals, AX will generate vouchers. You can't prevent that except by manually cancelling them or reversing the previously posted GL transactions.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ludwig,

We are not migrating any transactions. We want to migrate only the fixed assets with current NBV and continue the remaining depreciation for remaining periods on the asset.

Thanks,

RJay

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi RJay,

I see. In this case you can post the acquisition value and the depreciation amounts - that result in your NBV - in a fixed asset journal. This will create a posting in GL. To avoid a double counting you would then have to manually reverse this posting in GL by entering a ledger voucher.

Best regards,

Ludwig

Was this reply helpful? Yes No
Chandra Wijaya Seti... 1,145 on at

Like (0)

Report

Another alternative is to post the asset acquisition with offsetting the control account

Let say asset01

Asset group computer

Ledger asset 001 - computer asset

Ledger accumulated 002 - computer Acummulated depreciation

In journal pass two entries

Debit account type asset asset01 trans type acquisition 1000 offset account ledger 001

Second entry

Credit account type asset asset02 trans type depreciation credit 100 offset account 002

If you posted net in ledger would be

Debit 001 1000

Credit 001 1000

Credit 001 100

Debit 001 100

But in asset module you would have nbv 900

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, Chandra. This is great! Do you know if DIXF will allow to import the FA transactions and will work as explained above? By work, i mean the remaining depreciation will continue without any further changes to the asset.

Was this reply helpful? Yes No
Chandra Wijaya Seti... 1,145 on at

Like (0)

Report

DXIF should be able to help you to upload the journal however be mindful on additional table ledgerjournaltrans_asset which you may need to consult with your developer.

After the posting of opening balance above, in value model of asset (assetbook table) you must make sure following value are correct so system can do depreciation proposal correctly for next run:

1. Acquisition date

2. Placed in service date

3. Service life

4. Remaining life

5. Run depreciation date

6. Depreciation (must be ticked).

Please run testing for one or two asset and make sure the next depreciation proposal run before you do for all assets. Hope it helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Chandra,

Loaded fixed assets and also acquisition/depreciation transactions. NBV shows the correct value. Now, when i run the depreciation proposal, proposal runs on the acquisition value instead of the NBV. Also, the whole periods were taken instead of the remaining periods on the asset. What am i missing here?

Was this reply helpful? Yes No