Skip to Content

SAP launched Fixed Asset add-on as the part of solution in 9.0 for all location.

Below are the steps to import the Fixed Asset master data successfully.

First of all Enable the Fixed Asset functionality as given in below screen.

Go to Administration > System initialization > Company Details  > Basic Initialization Tab > and Tick on Enable Fixed Asset Check Box.

Now define the Masters and FA set up information.

First Define the  account determination as shown in below Screen.

If you will not determine the Accounts for any group then system will generate errors when you will start to import the Master Data.

After configure the account determination, Define Depreciation Type as per your requirement as below

Now define the Asset Classes as below and link the account determination group with depreciation area as below

Now Make Asset group and Depreciation Group at Fixed Asset Master Data as below.

Depreciation Group:

Now Define your template in excel with columns as below

Item code Item Name Asset Class dep Group Asset Group Dep Type Dep Area Usefull Life
FA00001 Voltas Split 2.0 Tons AIR CONDITIONER A C A C SLM4.75 Main Books 252
FA00002 Voltas Split 2.0 Tons AIR CONDITIONER A C A C SLM4.75 Main Books 252
FA00003 Voltas Split 2.0 Tons AIR CONDITIONER A C A C SLM4.75 Main Books 252
FA00004 Voltas Split 2.0 Tons AIR CONDITIONER A C A C SLM4.75 Main Books 252
FA00005 Voltas Split 2.0 Tons AIR CONDITIONER A C A C SLM4.75 Main Books 252
FA00006 Voltas Split 2.0 Tons AIR CONDITIONER A C A C SLM4.75 Main Books 252

(Note::  I have removed columns Capitalization Date and depreciation start date from above txt file. These columns were generating the issues at the time of capitalization and run depreciation Time. ) ℹ

[Note :: SAP has been provided DTW format to import the fixed asset master data with PL07 onwards ๐Ÿ™‚ .check link

Fixed Assets by DTW]

Save the above template as .txt file.(Please remove the header line before saving) .

Now go to Data Import/Export menu as below and choose the column in sequence as you mentioned in .txt file and Import.

Note :::: If you are importing FA Master DATA for more then one Fiscal Year then first defined all fiscal year in System and execute all fiscal year one by one from lower to top through below screen.

Note :: There can be some issue due to Transaction notification. If you do face as such issue than please comment all transaction notification related to ITEM MASTER.

Fixed Assets Import in v9

Please check below also specialy Mr. Jose reply..

Fixed Assets Imports Issues

{

You can Import fixed assets that have to be capitalized for current Financial year as NEW:

Meaning:

a) The start depreciation date is empty

b) The APC, Accumulated depreciation are empty

c) Capitalization date is empty

Once you have imported the asset as ‘new’, you can use application or DTW to enter the capitalizations

This is a logical consequence of system definition documented in the Help File: when you import an asset in any given year the values that you enter must be the values that the asset has on the first day of the fiscal year selected for the import:

BASIC RULES FOR IMPORT FIXED ASSET FROM EXCEL 9.0 (some documented and some based in my experience)

a)Capitalization date, if entered must be <= first day of fiscal year selected for import

b)Depreciation start date, if entered must be <=first day of fiscal year selected for import

c)Remaining useful life = Total number of months of total useful life -Number of calendar months counting from the calendar month of Depreciation start date until the last month of fiscal year prior to the year selected for import

d) If Remaining Useful life is 0, then  APC – Accumulated Depreciation – Salvage Value =0

e) Having Salvage Value is only compatible with Depreciation type that has marked a % of salvage value <>0

f) If Asset Class selected has several areas active, all areas must have value in the import

g) Depreciation areas ‘ derived’ must have exactly same values than the area that is derived from, except accumulated depreciation and depreciation type, that can be different,

h) Values must be defined always for ‘main’ Depreciation Area

I) Keep the same date format order and separator used in company database general settings for  date type values. Only change the alphanumeric to numeric, example ‘July’ , is 07

j) For numeric values: do only use the decimal separator if the value has decimals. For example ‘10,00’ should be entered as 10

k) For numeric values ensure that you use the same decimal separator used in company database general settings ‘,’ or ‘.’

l) Do not use thousands separators, example ‘10.000,43’ should be entered as 10000,43

j) Do use the same number of decimals that are allowed in company database general settings

k) Use Item No in the template as the first column A

}

Note: Check below thread if there is any issue in FA import:::

http://scn.sap.com/thread/s3373105

Check Below Threads for Fixed Asset related queries or issues.

Assistance needed with importing fixed assets with salvage value in SAP 9.0

SAP 9.0 Fixed Assets

Fixed Asset APC displays 0

SAP Business One 9.0 Fixed Assets, change existing depreciation

Asset Class Transfer

Fixed Asset Mode

Calculation Base in Fixed Asset

Fixed Asset with later capitalization date

Documents for Fixed Assets module in SAP B1 9.1 India Localization

Fiscal Year Change Failure

The specified item was not found.     ——-its about multiple depreciation areas

**********you can cancel the “Depreciation run” now in latest PL of SAP B1 V9.0 and V9.1.

Please share your suggestion and feedback too so that the document could be helpful for others.

CHEERS ๐Ÿ™‚ .

Edit..Now the size of pictures has been reduced as suggested by friends.

Please rate the document if you feel helpful this.

Regards

Deepak Tyagi

To report this post you need to login first.

63 Comments

You must be Logged on to comment or reply to a post.

  1. Jose Antonio Castillo

    That is good start, my congratulations for giving useful explanations

    Just ,there is one part that I would not recomend to use even if it is technically correct.

    Importing for several fiscal years

    If it is current fiscal year, and as well next fiscal year you would have, in next fiscal year, assets for which you cannot report on past fiscal year

    Example , you import for Fiscal year 02, and asset telling that it was acquired in Fiscal year 01. But if you report fixed assets for year 01, you cannot find data for this asset but you have data for other assets.

    Nothing incorrect from technical point of view but a real mess for the accountant when trying to justify the books.

    I would use the import as a start implementation but not as part of regular maintenance of assets, once functionality is implemented.

    Use instead acquisitions

    Jose Antonio

    (0) 
    1. Deepak Tyagi Post author

      Thanks for suggestion Jose.. I did mention this only if you want to maintain the history of Fixed asset else there is no need of this. We can start from current fiscal year….

      (0) 
    1. Deepak Tyagi Post author

      You can remove the FA item only if there is no any transaction you did post in the system.

      If you have posted the transaction against the item then you can not remove the item.

      You can sale/retired/Return etc….First consult with your finance person about the same.

      (0) 
    2. Jose Antonio Castillo

      Hi:

      In 9.0 there is a rule that depends on the status:

      Only asset status ‘NEW’ can be removed

      Asset is only ‘new’ if start depreciation date has not been registered in the asset

      Important: if you have imported the asset as legacy data, the asset cannot be removed because status is not ‘new’, even if there are no transactions entered after the import

      Reason: in accountancy terms, a ‘legacy’ asset is not new.

      (This is a relevenat change on the definition of product in 9.0, versus the add-on old version)

      (0) 
  2. vamsi krishna

    Hi Deepak Bhai

    It was help full Article ,

    But i have query here , suppose i am using SAP B1 8.82 Version , in that i have marked the FA indicator , and maintained the Fixed Assets.

    If i upgrade to 9.0 then , how shall i Transfer the Fixed Asset Items from Item master data to Asset master Data. Because both the tables are OITM and while importing it throws error as item already exixts.

    Can you help out Please Deepak bhai.

    Regards

    Vamsi Krishna

    (0) 
    1. Deepak Tyagi Post author

      Hi Vamsi,

      Truely I did not work on this scenario but as per my assumption it will not be possible.SAP allow the migration of  FA Data if it is defined in Fixed Asset Addon. there could be a work around. First inactive all these item from the Item (FA) Master Data and define new item code in FA Item Master with balances. overall you have to do start Fixed asset module from scratch in 9.0,

      before doing this wait for other experts answer.

      (0) 
    2. Jose Antonio Castillo

      Hi Deepak

      What you said is true,

      When using the fixed assets migration wizard in 9.0, assets that where stored in Add-on tables are transferred to table in Item master data.

      During the migration process, if application finds that there was a record already in table of items with same code than the asset that is to be migrated, then the migration for the assets affected wil fail, the not affected will success.

      There are two possible aproaches:

      to detect cases ,

      Select * from [@BA_OAMD] where U_AsstNum in (select itemcode from OITM)

      The migration wizard, any way, will show you which assets are not migrated

      a) For the assets that failed, use the import from excel that is included in 9.0,

      b) Look for SAP support, that will request database and apply a query fix that what will do is rearrange the historic code of the assets in add-on tables, so thier codes are different, (adding a prefix or sufix at users choice)

      Hope this answers your question.

      Jose Antonio

      (0) 
  3. Jose Antonio Castillo

    Regarding to the import process:

    The functionality is able to handle several areas (of course if you have defined them)

    By default the system comes with 3 pre-defined  areas

    The area code 100 Posting to G/L (main depreciation) , and its child ‘Derived’ area code 300 (to be used only for special depreciations)

    And a third ‘Aditional Area’ 200 (do not create journal entries)

    You can create more Posting to G/L areas (with its derived areas or not), plus more Additional Areas (Do not create journal entries)

    When you import, the only mandatory area is the one that you have defined as ‘main’

    and the values that you enter will be only for that area

    In case that you want as well for the other areas, you will need to create additional areas separated records

    for example if you have an asset X, and you have area 100, 200, and as well 300 defined actives for the asset class linked to asset X, you wil enter 3 records in the excel file

    One for each area

    (0) 
  4. Andrea Baquerizo Villacres

    Hi Deepak

    Thank you for the information you posted, it was really
    helpul.

    Would you be able to clarify the concepts for depreciation
    areas. The types of depreciation areas as: Posting to G/L, Derived Area and Additional Area and you can  only have one type set as  main depreciation .  I couldnt find any document that explains the effect of setting up a depreciation area as MAIN one.

    How would you recommended to set up the depreciation areas for a client that has Business Units. They want to havevisibility whether for example the depreciation for laptop 1 goes to Finance/ HR or ADMIN according to the Business Unit they belong to. 

    Thank you ๐Ÿ™‚

    Kind Regards

    (0) 
    1. Deepak Tyagi Post author

      Hi Andrea

      I am working for India localization, so I can tell you as per the same. there are two depreciation areas (Main books,tax books). in INDIA there are two acts related to depreciation. One is company act and 2nd is Income tax act.We use main books as Company act and Tax books as Income tax act. Depreciation calculation as per main books(Company act) impact the finance (Credit the Asset ledger and debit the related asset depreciation ledger) but in Tax books ,depreciation just calculated ,there is not any financial impact.

      Thanks.

      (0) 
    2. Deepak Tyagi Post author

      SAP Business One supports the following types of depreciation areas:

      • Posting to G/L – The area for posting asset depreciations in the general ledger accounts.
      • Derived Area – The derived area of the main depreciation area. Generally, you use this area when carrying out special depreciations.

        In special depreciation, you can specify the same depreciation type for both the normal and alternative depreciation. This way, the main depreciation area carries out the normal depreciation and the special depreciation while the derived area carries out the normal depreciation only. You can then compare the asset depreciation with and without the special depreciation.

        The derived area is used only for information purposes, and there is no posting in the general ledger.

      • Additional Area – The area in addition to the posting depreciation areas. You can use this area to compare the effects of using different depreciation areas. You can carry out an additional depreciation calculation for a different depreciation area in parallel to the actual calculation. The parallel calculation is for information purposes only, and no posting is carried out in the general ledger.

      check below link

      http://help.sap.com/saphelp_sbo900/helpdata/en/45/fe524a96255f4be10000000a114a6b/content.htm

      (0) 
      1. Andrea Baquerizo Villacres

        Hi Deepak

        Thank you for your quick response.  I still unsure about the best way to set up the assets by business unit, depreciation or asset group set up? there is an option on the asset master data to define both but I cant find a report or a option to pull the asset information by depreciation or asset group. I will continue readind and see what else I can find there

        Regards

        (0) 
        1. Deepak Tyagi Post author

          Hi Andrea

          have you resolved your issue ? if yes than please share the same here so that others could take help from this.

          Thanks

          (0) 
  5. Nick Lakasas

    Hi Deepak,

    Thanks for putting this information up, it is great.

    Can I suggest you resize the pictures smaller?
    It would make your document look nicer and would reduce the length of the page ๐Ÿ™‚

    Kind Regards,

    Nick Lakasas

    (0) 
  6. Charlotte Sicard

    Deepak – I don’t think you need to change a thing.  This is a great reference document.  Appears professionally formatted if you select View as Pdf.   I’ve saved as pdf and it retains professional format.

    (0) 
  7. Lean John

    Hi all,

    I upload capitalization of asset through DTW, but when i tried to do depreciation run, I can’t find those Assets to depreciate. Any idea?

    Regards,

    Lean

    (0) 
    1. Deepak Tyagi Post author

      check basic initialization tab in company details screen. calculate depreciation by is ‘Day’  or month. also check the fixed asset master data window (depreciation start date and end date are same or different?)

      (0) 
      1. Julie Jamieson

        Is it possible to import Distribution Rule and Attribute details for assets? Have everything else working but don’t want to have to use interface to update hundreds of assets!

        (0) 
  8. Andrea Baquerizo Villacres

    Hola

    I need help to implement something at client side. They have assets that they complete the useful life and the value on the books is zero, but after that, they have decide the asset is still operational and they would like to extend the useful life for another two years

    Version 9 PL 9. what is the best way to bring this scenario into SAP

    Muchas Gracias!

    (0) 
      1. Andrea Baquerizo Villacres

        Thank you Julie

        There is some accounting policies at client side that are limiting the options. They will create a new asset for the value and the new useful life and journal for the acquisition

        Regards

        (0) 
    1. Deepak Tyagi Post author

      you can change the useful life column for the same. but there will not be any depreciation or appreciation activity on the same just because of the zero value. please discuss the same with your finance guy for the same before applied  the suggestion.

      (0) 
  9. Rajesh Khater

    Hi Deepak,

    I am not clear about the Capitalization process in SAP. There is a field Capitalization Date in Asset Master, which can be entered manually until you create an AP Invoice or Capitalization document. If you have not entered the date manually, once you create AP Invoice or Capitalization document, the same is updated in Asset Master and not editable.

    Can you clarify the various options for capitalization?

    I have posted a thread here:

    Capitalization Process For Fixed Assets in SAP

    Thanks.

    (0) 
    1. Deepak Tyagi Post author

      Hi

      if you will enter a date in capitalization date field then system will capitalize the asset at specific date mentioned by you else system will capitalize the same at the time of A/P invoice creation date.

      Now I think your question is, you want to create A/P invoice but not want to capitalize the asset at same time or you dont know the exact date of capitalization. for this you can raise an A/P invoice of service type and let be GRPO open until you do not know the exact date. once you are clear about the capitalization date just make A/P invoice from GRPO.

      Hope it will help you.

      (0) 
      1. Rajesh Khater

        Am a bit confused ๐Ÿ™‚

        You are telling me to make AP Invoice of Service Type and keep GRPO open, and later make another AP Invoice based on GRPO when I am clear about the capitalization date. Won’t this create double AP Invoice?

        (0) 
          1. Rajesh Khater

            In that case, GRPO not needed at all. I can just make a Service Type AP Invoice by selecting the mapped Fixed Assets GL account, and make a Capitalization document when required. Only the AP Invoice will not show up in the Fixed Asset Reports … but I guess thats a system limitation, am I right?

            (0) 
            1. Deepak Tyagi Post author

              Actually GRPO for FA item will help you to check the purchased FA item list vendor wise in future. you can generate no. of reports based on GRPO for FA Items. anyway its totally up to u.

              Yes FA module for India localization is very limited. we would have to manage things through workarounds. you will not find the FA location transfer functionality in system…

              (0) 
              1. Rajesh Khater

                Ok. I got this part. Make an AP Invoice (Service Type) for the accounting, make a GRPO for the FA Reports, close the GRPO manually immediately so that it does not remain open. These 3 activities happen on the same Posting Date.

                Later create a Capitalization document when we want to capitalize the asset with a different Posting Date / Value Date.

                So far so good.

                The Capitalization document will debit the Asset Account and credit the Asset Clearing Account.

                Issue is:

                1. Asset account is debited twice (once in AP Invoice of Service Type) and then in Capitalization JE

                2. How will the Asset Clearing A/c get nullified… will it forever remain in the Balance Sheet as an obligation?

                (0) 
                1. Rajesh Khater

                  At the time of AP Invoice (Service Type):

                  Debit   Fixed Asset A/c

                  Credit  Vendor A/c

                  At the time of Capitalization:

                  Debit     Fixed Asset A/c

                  Credit    Asset Capitalization A/c

                  How is Asset Capitalization getting nullified? Moreover Fixed Asset is debited twice?

                  Obviously I am missing something from what you intent to communicate.

                  (0) 
  10. Rajesh Khater

    Hi Deepak,

    Can you give an overview of how to bring Fixed Assets already in use, into the SAP system.

    You need not give the exact DTW template or Import from Excel template. Just the steps, if someone were to enter it manually in SAP.

    Once I understand the steps, using the DTW or Import from Excel will be easier to understand.

    For existing assets, where and how do we record the capitalization date?

    Where do we enter the book value and accumulated depreciation as on SAP go-live date ?

    Is the process different if SAP is already in use for several years but Fixed Assets module being implemented now?

    What is the difference between “Historical APC” and “Acquisition and Production Costs”?

    If you give example of 1 or 2 assets with some values, it will be easier to understand.

    We can assume 2 Depreciation Areas for India localization: one for Companies Act, and one for Income Tax Act.

    In this document, you have explained how to activate the module, create Asset Groups, Depreciation Areas, etc., but you have not explained the Asset master itself in detail, for someone new to the module. Hope you can provide these inputs.

    I have posted a thread here:

    Thanks.

    (0) 
  11. Pรกl Szabados

    Dear Deepak,

    Thank you for your document!

    My customer want to use SAP’s Fixed Assets.

    I want to import assets into SAP Business One 9.1 PL08.
    I made a TXT file for import.

    There are some assets which has been already depreciatied whole amount or partly.

    Asset import template.jpg

    I want to import this for example:

    113/003 SAP váll.irányítási rendszer 113 20051230 LIN14,5 SZVT 20051230 3641625 3641625 0 3641625 72 0
    113/003 SAP váll.irányítási rendszer 113 20051230 LIN14,5 TAO 20051230 3641625 3641625 0 3641625 72 0

    But I got this error message:

    Asset import error.jpg

    After this error the SAP crashes with a runtime error of C++.
    I can’t see, because that windows closes quickly.

    The system:
    WINDOWS 10 64 bit.
    MSSQL 2012 64 bit.11.0.5343

    I got this error when I tried to import on (my customer’s server):
    WINDOWS Server 2012 R2
    MSSQL 2008 R2 – 10.50.2500

    Do you have any idea, what is wrong?

    Thank you for your help,
    Pál Szabados

    (0) 

Leave a Reply