Fixed Assets Opening Balance Import Through DTW in SAP Business One 9.1

[Former Member]

Dear Expert,

     Please let me know , How to upload fixed assets opening balance and it's depreciation calculation method ( If any other setting or option need to be done ) .

Example:

     If i am uploading two year before purchased asset what is the opening balance and depreciation , in Straight Line Depreciation Method .

Thanks & Regards,

Sudhir.J

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please refer document

Thanks & Regards,

Nagarajan

[Former Member]

Hi Sudhir,

You can ask this Question from your Client.

He can give you Accumulated Depreciation, Net Book Value and Historical Cost of Fixed Asset with Depreciation Type.

Use OITM and ITM7 Template to Import Fixed Asset with Depreciation Type without any Transnational Information. With OITM and ITM7 Template you can Upload only Fixed Asset Master Data.

Then Use ACQ1, ACQ2 and OACQ Templates to Import Capitalization Data of Fixed Asset.

Then Run Depreciation for the Assets so that Accumulated Depreciation can be Calculated.

Note:- You Can Import Fixed Asset for the First day of Current Financial Year.

Hope this helps

--

--

Regards::::

Atul Chakraborty

[julie_jamieson2]

It is better to use the Import from Excel option under Administration to complete this.

Make sure you do testing first in a test database