Importing fixed assets transactions into AX 2009

Anas Al-Khalili

unread,

Feb 7, 2009, 3:58:01 AM2/7/09

to

Dear all,

I'm importing fixed assets transactions into AX 2009 SP1 from AX Excel
templates but Microsoft changed fixed asset tables structure comparing with
version AX 4.0.

I used to prepare the assets transactions templates to the following tables:

AssetTrans, AssetTransMerge, AssetBook, AssetBookMerge.

Microsoft changed "AssetTransMerge" from table to view.

Which tables I should select to import the assets transactions (acquisition
and depreciation) to get the correct asset transactions and balance in AX
2009?

Regards,

Hans.

RogerL

unread,

Feb 9, 2009, 3:59:01 AM2/9/09

to

Hi Hans

I would recommend that you post the transactions via the Fixed Asset journals.

Regards

IS

unread,

Jun 12, 2009, 1:23:01 AM6/12/09

to

For asset details :

AssetTable
Assetbook
AssetDepBook

For the transactions :

LedgerJournalTable
LedgerJournalTrans
LedgerJournalTrans_Asset

You would have to do it twice, one for Acquisition and one for Depreciation

IS

barathkumar

unread,

Dec 3, 2009, 9:01:56 AM12/3/09

to

Hi

I have a doubt here, when i am trying to import Acquisition transactions through the respective tables
1. Ledger journal table
2. Ledger journal trans
3. Ledger journal trans_asset

I am unable to find any link between the second and third table , so if i import with all the tables i am not getting the line details in the journal lines

Its getting updated in the tables but in the front end i am unable to see those details

Have any one come across this peculiar problem , if so please help me

Its very urgent

Regards
Barath

IS wrote:

RE: Importing fixed assets transactions into AX 2009
12-Jun-09

For asset details :

AssetTable
Assetbook
AssetDepBook

For the transactions :

LedgerJournalTable
LedgerJournalTrans
LedgerJournalTrans_Asset

You would have to do it twice, one for Acquisition and one for Depreciation

IS

"Anas Al-Khalili" wrote:

Previous Posts In This Thread:

On Saturday, February 07, 2009 3:58 AM
AnasAlKhalil wrote:

Importing fixed assets transactions into AX 2009
Dear all,

I'm importing fixed assets transactions into AX 2009 SP1 from AX Excel
templates but Microsoft changed fixed asset tables structure comparing with
version AX 4.0.

I used to prepare the assets transactions templates to the following tables:

AssetTrans, AssetTransMerge, AssetBook, AssetBookMerge.

Microsoft changed "AssetTransMerge" from table to view.

Which tables I should select to import the assets transactions (acquisition
and depreciation) to get the correct asset transactions and balance in AX
2009?

Regards,

Hans.

On Monday, February 09, 2009 3:59 AM
Roger wrote:

Hi HansI would recommend that you post the transactions via the Fixed Asset
Hi Hans

I would recommend that you post the transactions via the Fixed Asset journals.

Regards

"Anas Al-Khalili" wrote:

On Friday, June 12, 2009 1:23 AM
IS wrote:

RE: Importing fixed assets transactions into AX 2009
For asset details :

AssetTable
Assetbook
AssetDepBook

For the transactions :

LedgerJournalTable
LedgerJournalTrans
LedgerJournalTrans_Asset

You would have to do it twice, one for Acquisition and one for Depreciation

IS

"Anas Al-Khalili" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe.com MSInfo C# Webservice
http://www.eggheadcafe.com/tutorials/aspnet/cdc3dff8-eea5-47ac-91ea-fe2af1b58995/eggheadcafecom-msinfo-c.aspx

Paine@discussions.microsoft.com Nate Paine

unread,

Jan 14, 2010, 2:58:01 PM1/14/10

to

I wrote up some notes on how I imported partially depreciated fixed assets in
AX4.0. I didn't use the Asset___Merge tables, so it may work for 2009 as
well.

http://natepaine.blogspot.com/2010/01/how-to-load-fixed-assets.html

Nate

"barath kumar" wrote:

> .
>