cancel
Showing results for 
Search instead for 
Did you mean: 

Need to remove fixed asset upload

Former Member
0 Kudos

All,

We uploaded approximately 500 assets.  The Asset Manager retired some of the assets then realized the depreciation was not correct on the upload.  We cancelled the retirement and tried to undo the upload, but get the error "postings for the assets have already been created".  What can we do to remove the Assets so that we can correct the depreciation and re-upload the file?

Regards,

Fred

Accepted Solutions (1)

Accepted Solutions (1)

Joselito
Advisor
Advisor
0 Kudos

Hi

This is normal system definition, you cannot undo import if transactions are posted for the assets

Retirement (wite off) doesn't mean that an asset has been cancelled, but that the Net book value has been lost as an expense. It behaves the same way in Business One for items, you can not remove the item if transactions were posted, even if the balance in quantity and inventory value has become 0.00

If you do the retirement you have to do it having as posting date the first day of the fiscal year selected for the import,

If you wnat that the posting created by the retirement not influencing balances of GL accounts, you would have to reverse/cancel the posting created by that retirement

Then you will have to repeat the last depreciation run and check if depreciation has been readjusted

so whatever depreciation was posted from the assets retired is readjusted

I cannot provide any workaround,

Please do test first in back up and compare balances of GL accounts involved with a back up before you tried to import for the first time

Is good advice to import the assets in batches so you have more margin , this query would help, in that case at least find if there is any batch of import that you could remove because the assets were not used in transactions or depreciation run

 

 

select

T0.U_IMpID,T0.U_AsstNum from

[@BA_MDIM2] T0

 

where

T0.U_AsstNum NOT IN (select T1.U_Account from [@BA_ODOC3] T1

)

 

and

T0.U_AsstNum NOT IN (select T2.U_AsstNum from [@BA_ODRN3] T2

)

Jose Antonio Castillo

Answers (0)