Skip to main content
Dynamics 365 Community / Forums / Finance forum / Importing Remaining Pe...
Finance forum
Answered

Importing Remaining Periods on Fixed Assets with Mid-Month 15th of Month Depreciation Convention

editSubscribe (0) ShareShare
ReportReport
Posted on by 139
Hello All - 
 
I have migrated legacy assets and now want to update the remaining periods on those assets. After attempting to Publish the data back to D365 I receive error messages stating that remaining periods can't be an integer when the depreciation convention is mid month, 15th of month. That makes sense but what's odd is that not all of the lines on the spreadsheet are causing this error - please refer to the screen shot below. Those lines not highlighted in red published successfully even though the assets have the mid month, 15th of month depreciation convention. 
 
Anyone else experience this?
 
Thanks in advance for any advice.
 
 
Attachments
  • Verified answer
    Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,130 Super User on at
    Importing Remaining Periods on Fixed Assets with Mid-Month 15th of Month Depreciation Convention
    Thanks for your reply, Barry. Is your question answered? In that case, can you mark an answer to have the status of your question changes to 'Answered'?
  • Verified answer
    BarryR Profile Picture
    BarryR 139 on at
    Importing Remaining Periods on Fixed Assets with Mid-Month 15th of Month Depreciation Convention
    Andre - when I post the initial acquisition journal for the migrated assets the placed in service and acquisition dates = the transaction date on the journal. In my journal that date was 11/30/2023. After posting the acquisition and accumulated depreciation journals I modify the acquisition dates to match the original purchase dates of each asset.
     
    Also, when I modify the remaining periods by adding a value of .5 to each of those assets that errored out I am able to successfully publish without any further errors.
     
    Thanks.
  • Verified answer
    Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,130 Super User on at
    Importing Remaining Periods on Fixed Assets with Mid-Month 15th of Month Depreciation Convention
    Hi Barry,
     
    Are you also importing the acquisition date and date when the asset was placed in service? If so, is there any difference in the day of the month? I never dealt with the mid-month in my implementations and for that reason, I never experienced this error myself. 
    Are you able to publish the line if you follow the instructions and put e.g. 75.5 and then manually adjust it in the application? Or do you then also get the same error?
  • BarryR Profile Picture
    BarryR 139 on at
    Importing Remaining Periods on Fixed Assets with Mid-Month 15th of Month Depreciation Convention
    Depreciation profile is the same for all assets ==> Straight Line. 
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 13,138 Super User on at
    Importing Remaining Periods on Fixed Assets with Mid-Month 15th of Month Depreciation Convention
    Depends on the depreciation profile. What is the difference on the depreciation profile?

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,130 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,689 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans