Notifications
Announcements
No record found.
I am creating a SQL script to create the macros to import fixed asset GENERAL and BOOK information. Looking at the template for BOOK I see:
SLO -Depreciation Method
FP -Averaging Convention
NS - Switchover
Is there a guide that list all the accepted abbreviations for these three fixed asset properties?
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
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
(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
Switchover
No Switch
NS
Switch to Straight-Line
SL
Perfect, thank you very much. I never noticed that.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
