Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Configuration Package for Depreciation Book (5612) Not uploading No. of Depreciation Years

(1) ShareShare
ReportReport
Posted on by 15

I found a thread from early 2022 that seems to dead end and went unsolved, but I am currently facing similar problem.  I've successfully uploaded my Fixed Asset catalogue using T5600 and have moved on to uploading depreciation book T5612. I am successfully uploading with no errors, but my depreciation years will not populate and calculate the depreciation end date. I have attached a sampling of my file below.  Some other important considerations/troubleshooting I have already tried:

  • I am populating depreciation years only, not both years and months.
  • No depreciation end date is defined. I have narrowed down the columns so I am only using what's absolutely necessary.
  • The field specifies decimal format and the format in BC UI also reads as decimal with two places so I've tried converting field to number format to two decimals.  I've also tried to copy formatting from fresh download of config package to mimic the formatting from the source file as best as I can (Screen cap of my data below. The number format in that screen cap mimics what I get in the source file).
  • Just for fun, I took out the acquisition date field in case it was causing some confusion. It's later in the processing order so it shouldn't interfere but at this point I'll try anything.
  • I am able to enter a number in the UI Years field and depreciation date calculates no problem. I can't do this 1500+ times however.

Screenshot-2023_2D00_05_2D00_19-070847.png

Thanks in advance! Also, for reference I am linking the original post I found with some replies. 

community.dynamics.com/.../configuration-package-will-not-import-depreciation-book-5612

  • mallard Profile Picture
    mallard 15 on at
    RE: Configuration Package for Depreciation Book (5612) Not uploading No. of Depreciation Years

    Thanks for the suggestion. This worked for me when I was testing in my Sandbox environment.  I did, however, execute a successful upload with No. of Depreciating years when I started implementing in our production environment.  The solution for this issue may just be scrap/start over with upload.  I did paste values in the No. of Depreciating Years column which didn't work for me initially but did today.   Thanks for the response Kaspars.

  • Verified answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,993 Super User 2024 Season 2 on at
    RE: Configuration Package for Depreciation Book (5612) Not uploading No. of Depreciation Years

    Not fully sure why You don't succeed on this, but You can use the Ending date in import - just calculate in Excel +10 years from Starting date. 

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,661 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans