web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Fixed Asset Legacy entry into NAV

(0) ShareShare
ReportReport
Posted on by 50

Hello, 

I just finished setting up the FA cards in NAV. How does one input the legacy assets at gross book value and run accumulated depreciation for prior years? Based on my experience, NAV only allows me to post depreciation only if I enter an asset in the current month. i.e Sept 1, 2021. All help or explanation is greatly appreciated. Thank you!

Best,

Not giving up on my project...

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at
    RE: Fixed Asset Legacy entry into NAV

    Kami,

    You would use the RapidStart Services and Configuration Package. I am guessing your General Ledger has the correct Fixed Asset balances and you are loading the Fixed Asset sub-ledger so you can use FA and perform monthly depreciation entries into the GL. To load the Acquisition, based on what I just notated, you would use the configuration package to Table 5621 FA Journal Line. You will need to populate:

    FA Journal Template = Enter Template name ASSETS

    FA Journal Batch = Enter your Default Batch

    Line No. = increment by 10000

    FA Posting Date

    Document Date

    Document Type = Invoice or Blank

    Document No. = Enter the next number in Series

    FA No. = Fixed Asset No.

    FA Posting Type = Acquisition Cost

    Amount = Original Acquisition Amount

    NOTE: The Depreciation Book YOU MUST TURN OFF G/L Integration when doing this.

    Enter all the records into your configuration package spreadsheet and then Import back into NAV. You will then Apply the Package. All the entries will now appear in the Fixed Asset Journal. You can now Post the Journal.

    Keeping the Integration off, you can run Depreciation thru the last closed Accounting Period you manually recorded depreciation thru. NAV will run and calculate the depreciation to the Fixed Asset Journal. You can now post the entry. You can now reconcile G/L Fixed Assets Balances to NAV Fixed Asset sub-ledger. Any difference can be resolved either in the GL or Fixed Asset FA Journal (i.e. Depreciation).

    Hope this helps.

    Thanks,

    Steve

  • Kami09 Profile Picture
    50 on at
    RE: Fixed Asset Legacy entry into NAV

    Thank you Steve, this is fantastic!

    I do see how to get to RapidStart Services and I see Configuration Packages under "Lists". I am not sure where to go once I open Configuration Packages. Can you please show me where I need to click on next? Based on what you said, I need to create a template. Not sure if I need to do this in Excel or in the Configuration package. I really appreciate your time and response Steve!

    Best,

    Kami

  • Kami09 Profile Picture
    50 on at
    RE: Fixed Asset Legacy entry into NAV

    Basically, I do not have 5621 in my object IDs. Do I need to create this? Thank you Steve!

    Best,

    Kami

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Fixed Asset Legacy entry into NAV

    Hello,

    You should see the Object 5621 as this is a standard table:

    pastedimage1630621514202v1.png

    The No. of Fields Included should be:

    pastedimage1630621543773v2.png

    You can Export the Table from here and then Import after populated from the same click:

    pastedimage1630621578646v3.png

    After you Import click Functions/Apply Data:

    pastedimage1630621602474v4.png

    Thanks,

    Steve

  • Kami09 Profile Picture
    50 on at
    RE: Fixed Asset Legacy entry into NAV

    Default02_5F00_09_5F00_2021_5F00_19_5F00_10_5F00_07.xlsx

    Wow, Steve this is amazing, thank you! 

    When I am importing my template back into NAV, within the Excel file (attached) where do I write the FA Journal Template name and FA Journal batch?

    Also, I am keeping two separate depreciation books, one for the newly acquired assets which will get posted to G/L and another for my legacy asset which will only remain in the FA subledger. When I am importing my template, do I need to include the depreciation book?

    Again, thank you so much Steve for this invaluable feedback. It means the world to me. Thank you!

    Best,

    Kami

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Fixed Asset Legacy entry into NAV

    Kami,

    Template and Batch are entered in Column A and B, respectfully.  As for the Depreciation Book, that is setup on the Asset card so no need to add it here. It defaults from Asset Card when you enter an Asset No.

    Thanks,

    Steve

  • Kami09 Profile Picture
    50 on at
    RE: Fixed Asset Legacy entry into NAV

    0456.Default02_5F00_09_5F00_2021_5F00_19_5F00_10_5F00_07.xlsx

    Hi Steve,

    I am able to import the table and apply the data just fine. I do not get any error messages. But once I get to the FA Journals all my lines are blank except for the "Aquisition Cost". I have attached my sample file. I am not sure what I am doing wrong. 

    Best,

    Kami

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Fixed Asset Legacy entry into NAV

    Kami,

    Change the Posting Date to = the FA Posting Date. Use the attached and try uploading,

    Steve

    Default03_5F00_09_5F00_2021_5F00_14_5F00_49_5F00_16.xlsx

  • Kami09 Profile Picture
    50 on at
    RE: Fixed Asset Legacy entry into NAV

    Hi Steve,

    Thank you for modifying the spreadsheet. I still get no data except for "Acquisition Date".

    Best,

    Kami

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Fixed Asset Legacy entry into NAV

    Kami,

    When you click Apply Date did the message state all your records inserted or do you have Errors?

    pastedimage1630700037135v1.png

    Mine will not import because the FA No. I do not have so the 26 errors would be correct.

    Does your entry look like this below. I fixed 1 Asset to match one of mine so to show you it will insert. Please check the Errors and fix them.

    pastedimage1630700148988v2.png

    Thanks,

    Steve

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,232

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,863

#3
Sumit Singh Profile Picture

Sumit Singh 2,819

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans