Is there an issue with the fixed assets import?

Hello

Do you have a dummy username and password to connect?

I replicated your test scenario. Imported fixed asset with acq. value 8400. Accumulated depr. 7900 as of 12/2022.

Posted import object transactions.

I can see object balance is correct after import.

Created a depreciation proposal. And depr. amount for Jan 2023 is 100, which is correct.

I think either your depreciation method has wrong set up, or your accumulated depreciation is wrong. If you can share screen shot or share dummy username and password. I can verify and come back to you.

Hope this helps

url:  https://samuel-uat.ifs.cloud/

credentials: SUPPORT

this is read only account for IFS Support only.

I was looking now at asset (456-000824) which I set up with acquisition cost, accumulated depreciation and remaining months of 10.  The issue wit this was that when it ran the depreciation it didn’t start with remaining value but rather the total acquisition value.  The depreciation run was for $3,169.21.  Apparently putting in depreciation for 11/30/2022, I should have entered it with a date of 12/1 so it wouldn’t have depreciated for November again.  Why does it not recognize my accumulated depreciation in the calculation?

I did screen shots of object transactions and depreciation proposal but I can’t get it to paste/send.

Hi there,

So your method is not SL BP but REM BP REPL, is that right?

I actually just caught that, cancelled the depreciation proposal, changed it to REPL BP and re-ran the proposal.  It gives me the same result for period depreciaton.  

The error you described in first post is not matching what you are doing.  You said you have issue with SL BP. But your depreciation method is not SL BP.

I believe your lifetime is not correct in case you have REM BP method. You must write 07y 00m in books tab of fixed asset object.

I originally wanted to upload assets with the original acquisition date but I would then need to create both depreciation calendars and accounting calendars for periods from the beginning of active assets, 1988.  I had thought it would be easier to use an import date and remaining periods over remaining value, in this case, rather than 7 y 00 m, use remaining periods of 0 y 10 m.  Unfortunately, it appears I need to rethink that or find out why it isn’t depreciating correctly.  Do you have suggestions to correct what I am doing?

Are you saying to enter one accounting period for the entire time, 1988 to Dec 2021?  Then I will need depreciation calendar for each month?  

Can you drop your email on private message please I will call you on teams and resolve issue quickly?

I have had success with suggestions from GUMABS regarding setups of schedules before importing assets.  I have one remaining issue with my imports and wondering how to resolve.  In Line Type N, I included accumulated depreciation in field Amount, 2022 in Year and 11 in Period.  This did not full in the Thru field for accumulated depreciation as anticipated.  When I ran the depreciation proposal, it generated a report for depreciation from the acquisition date forward.  What field on the import templates do I need to input the date to create a Thru Date?  I am wondering if this is just a matter of inputting a date of 12/1/2022 in the depreciation start date field.  

Hi Thomas,

Thru date is assigned by the system when you import fixed asset template with line type N and post import transactions. See the sample below.

If you will use attached import file for SL BP method, it will work properly

Regards

It filled it in…. the thing I was missing was transaction type of Depreciation.  

I rolled back the object, it is now in Registered status.  Wanted to delete object but it says it is used in the Wait Table.  Do you know how I can remove it from there?  Would I then be able to delete it?

Hi Thomas

If you post import transactions, then system will create accounting rows which means it is not possible to delete the fixed asset anymore.

This is system design and you cannot change it. 

Regards