3,494
Hi:
What fields in an Excel spreadsheet do I use to import fixed assets master data and, afterward, YTD accumulated depreciation as of 12/31/2021?
Likewise, for importing the latter, do I import the acquisition cost and then the YTD accumulated depreciation into the FA Journal Line table and do so separately?
Thanks!
John
There is the Depreciation Book record (Company, Financial, Tax) and then there's the FA Depreciation Book records (one for ech asset).
The FA Depr Book has the depreciation method, life, starting and ending depreciation dates. It's table number 5612
Thanks, Kim!
John
Thanks, Kim!
So, really, the only two tables to import into are the Fixed Asset Master (5600) and FA Journal Line (5621). Is that right?
John
So, there are three tables to import using a Configuration Package -- Fixed Asset Master (5600), FA Depreciation Book (5612), and FA Journal Line (5621). Correct?
You said "Then to bring in your acquisition costs..." Are you saying that there are multiple imports into these tables?
How do I turn off the G/L integration?
What you need to understand is that the Fixed Asset Master record is separate from the Fixed Asset Depreciation Book record. This is two separate tables in the database and you probably cannot Edit in Excel for the FA Depreciation Books record. The fixed Asset, just needs a number and name but category, andsubcategory are also helpful during reporting. You'll need FA Posting Group, depreciation, method, staring date, and life for the FA Depreciation book for each asset.
Make sure that you integration to the GL is turned off before you bring in your beginning balances. Then to bring in your acquisition costs into the FA Journal line table, balance to GL and post. Do the same for your accumulated depreciation. Keep in mind the FA posting type and that depreciation amounts are negative.
Don't forget to turn on your GL integration for your Depreciation Book.
#1
André Arnaud de Cal...
294,137
Super User 2025 Season 1
#2
Martin Dráb
232,879
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
