Fixed Asset Import

CJBeattie

Hello all

Does anyone have a list of tables that are needed to import into for Fixed Assets?

So far I have: -

AssetTable
AssetBook

I have imported into them, with acquisition values, dates deprecitation last run etc, but cannot get a net book value to calculate on the asset value model form under Inquiry --> Balance.

This is stopping me from being able to run a depreciation, as there is no actual acquisition value recorded, all it seemed to do on the import was populate a free text field.

What I was planning to do was to import the assets, and put through a single depreciation to get its opening position. and have the import tell the system how many periods are remaining etc.

If there is no list of tables, what is the best practice to get the assets in?

Any ideas?

Regards

Craig

Harish

Hi Craig,

This is one question that comes up very often. To update assets to NBV -

* Post acquisition journal manually using fixed assets journal
* Make appropriate changes to assets (entering acquisition, depreciation dates, service life etc)
* Finally running depreciation adjustments manually using FA journal

Hope this helps,

CJBeattie

Thanks very much.

I messed around with this a little after I posted the initial question.

I think I will import into those tables I mentioned, and so long as I have an acquisition value entered on the value model for the asset, I should be able to register the acquisitions using the acqusition proposal from the fixed asset journal, am I right?

On the posting profile for the assets, I am specifying the acquisition ledger account, and offset account to be the same. This way, it will register an acquistion but not effect the ledger balance sheet, as they have already been accounted for.

I should hopefully then be able to update the deprecitation to date.

As part of the import, I am populating the depreciation periods remaining etc, but on the manual depreciation journal, entering a depreciation to date for the asset as the amount to post in that period.

If there is anything drastically wrong with my approach, please let me know.

Thanks Harish

Craig