Dynamics Community Forum Thread Details

Fixed Asset abbreviations when importing

Hello Richard,

Based on what you noted, Are you creating a script to generate the output for use in the asset import\export tool? If so, please see the below

Go to Tools>Utilities>Fixed Assets>Asset Import\Export
Click Help>About this window
Click the option "Guidlines for importing asset information".
At the bottom of the page you will see "Field mappings for importing asset information" click this

This page will have the full spec sheet for importing assets. as well as link to field values.

Asset Book window	Depreciation Methods	Straight-line Original Life	SLO
		Straight-line Remaining Life	SLR
		125% DB	125DB
		150% DB	150DB
		175% DB	175DB
		200% DB	200DB
		Sum of the Year’s Digits	SOY
		Remaining Life	RL
		Amortization	AM
		ACRS Personal	AP
		ACRS Real	AR
		ACRS Real MSL	ARMSL
		ACRS LIH	ALIH
		ACRS Foreign Real	AF
		None	NONE
		Declining Balance	DB
Asset Book window (continued)	Averaging Convention	Half Year	HY
		Modified Half Year	MHY
		Mid-Month (1st)	MM1st
		Mid-Month (15th)	MM15
		Mid-Quarter	MQ
		Next Month	NM
		Next Period	NP
		Full Month	FM
		Full Period	FP
		Next Year	NY
		Full Year	FY
		Full Year All Year	FYALL
		None	NONE
	Switchover	No Switch	NS
	Switchover	Switch to Straight-Line	SL

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL