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

(0) Share

Report

Posted on by BarryR

266

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.

I have the same question (0)

All responses (5)

Answers (3)

Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Depends on the depreciation profile. What is the difference on the depreciation profile?

Was this reply helpful? Yes No
BarryR 266 on at

Like (0)

Report

Depreciation profile is the same for all assets ==> Straight Line.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,966 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

BarryR 266 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,966 Super User 2025 Season 2 on at

Like (0)

Report

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'?

Was this reply helpful? Yes No