Fixed Assets Management in SAP B1

Road Map

     Fixed Assets Add-on

     Fixed Assets Module in 9.0 with enhanced functionality

     Enhanced in 9.1

          Cancel Depreciation Runs

          Carry Cost Accounting Information from Marketing Documents:

          An option to create journal entries for asset transfers at any time has been added


Abbreviations Used

     FA- Fixed Assets

     JE-Journal Entry

     NBV-Net Book Value of Fixed Asset

Fixed Assets > Configuration

     Modules > Administration > Setup > Financials > Fixed Assets

1 Account Determination
2 Depreciation Types
3 Depreciation Areas
4 Asset Classes
5 Attribute Groups

Fixed Assets Module

Modules > Financials > Fixed Assets

1 Asset Master Data
2 Capitalization 1) Capitalization thru AP Invoice, 2) Direct Capitalization
3 Capitalization Credit Memo 1) Capitalization thru AP Credit Memo, 2) Direct Capitalization Credit Memo
4 Retirement 1. Retirement> Sales thru AR Invoice, 2) Direct Retirement(Retirement> Scrap)
5 Transfer 1) Asset Class Transfer(Correction Purpose), Asset Transfer(to Transfer Component Item/ Part to main Machinery)
6 Manual Depreciation 1)Planned, Unplanned, Special Depreciation & Appreciation
7 Depreciation Run 1)Month End Activity
8 Asset Revaluation 1) Year End Activity (Land & Building, Good Will Revaluation)
9 Fiscal Year Change 1) Year End Activity

Account Determination for Fixed Assets

Sl No Field Name Best Drawer / Group to Map Debit Credit
1 Asset Balance Sheet A/c Assets > Fixed Assets 1. Capitalization
2. Asset Revaluation> Increase in Value
1. Capitalization Credit Memo
2. Retirement (Capitalization Value+Write Up Value)
3. Depreciation Run / Manual Depreciation (If Depreciation Area> Posting of Depreciation is Direct Posting)
4. Asset Revaluation > Decrease in Value
2 Acquisition Clearing Account Expenditure > Indirect Expenses 1. AP Invoice of Fixed Asset Item 1. Capitalization
3 Revaluation Reserve Equity > Revaluation > Reserve 1. Retirement (Increased value through Asset revaluation) 1. Asset Revaluation> Increase in Value
4 Revaluation Reserve Clearing Revenue > Indirect Revenue(Other Operating Income)
1. Retirement (Increased value through Asset revaluation)
5 Ordinary Depreciation Expenditure > Indirect Expenses 1. Depreciation Run
2. Manual Depreciation > Ordinary Depreciation

6 Accumulated Ordinary Depr. Assets > Fixed Assets 1. Retirement (If Depreciation Area> Posting of Depreciation is Indirect Posting) 1. Depreciation Run / Manual Depreciation
(If Depreciation Area> Posting of Depreciation is Indirect Posting)
7 Unplanned Depreciation Expenditure > Indirect Expenses 1. Manual Depreciation > Unplanned Depreciation
2. Asset Revaluation > Decrease in Value

8 Accumulated Unplanned Depr. Assets > Fixed Assets 1. Retirement 1. Manual Depreciation > Unplanned Depreciation
2. Asset Revaluation > Decrease in Value
(If Depreciation Area> Posting of Depreciation is Indirect Posting)
9 Special Depreciation Expenditure > Indirect Expenses 1. Manual Depreciation > Special Depreciation
10 Accumulated Special Depr. Assets > Fixed Assets 1. Retirement 1. Manual Depreciation > Special Depreciation
(If Depreciation Area> Posting of Depreciation is Indirect Posting)
11 Revenue from Asset Sales (Net) Revenue > Indirect Revenue(Other Operating Income) 1. Retirement (Value:NBV as on Sales Date + Profit Value during retirement) 1. Retirement (Loss Value during retirement)
12 Retirement with Expense (Net) Expenditure > Indirect Expenses 1. Retirement (Loss Value during retirement)(If FA Sales value is Less than NBV of FA)
13 Retirement with Revenue (Net) Revenue > Indirect Revenue(Other Operating Income)
1. Retirement: If FA Sales value is greater than NBV of FA
14 NBV Retirement Expense (Gross) Assets > Fixed Assets > Assets Under Construction

15 NBV Retirement Revenue (Gross) Assets > Fixed Assets > Assets Under Construction

16 Revenue Account for Retirement Revenue > Indirect Revenue(Other Operating Income)
Retirement> Sales : Sales Value of FA Retirement
17 Revenue Clearing Account Revenue > Indirect Revenue(Other Operating Income) Retirement> Sales : Sales Value of FA Retirement
AR Invoice : Sales Value of FA Retirement

Depreciation Area

Depreciation Area.jpg


Note:
1 Posting of Depreciation:>Indirect posting: At the time of Depreciation (Depreciation Run & Manual Depreciation) Accumulated Depreciation account will be credited and Respective Depreciation account will be debited
2 Posting of Depreciation:>Direct posting: At the time of Depreciation (Depreciation Run & Manual Depreciation) Asset Balance sheet account will be credited and Respective Depreciation account will be debited

Indirect Posting is suggested: Confirm with Accountant / CFO of client


3 Posting of Retirement:>Gross: NBV Retirement Expense (Gross) & NBV Retirement Revenue (Gross) will be debited / credited at the time of retirement
4 Posting of Retirement:>Net : Revenue from Asset Sales (Net), Retirement with Expense (Net) & Retirement with Revenue (Net) will be debited / credited at the time of retirement

“Net” is suggested: Confirm with Accountant / CFO of client

1_AP Invoice oF FA

1_AP Invoice oF FA.jpg

2_JE for AP Invoice of FA

2_JE for AP Invoice of FA.jpg

3_Automatic Capitalization Entry with respect to AP Invoice

3_Automatic Capitalization Entry with respect to AP Invoice.jpg

4_JE of Automatic Capitalization Entry with respect to AP Invoice

4_JE of Automatic Capitalization Entry with respect to AP Invoice.jpg

5_FA Master After adding Capitalization_Overview Tab

5_FA Master After adding Capitalization_Overview Tab.jpg

6_FA Master After adding Capitalization_Values Tab

6_FA Master After adding Capitalization_Values Tab.jpg

7_FA Master After adding Capitalization_Depreciation Tab

7_FA Master After adding Capitalization_Depreciation Tab.jpg

8_Depreciation Run for Month End

8_Depreciation Run for Month End.jpg

9_Journal Entry of Depreciation Run. (Indirect Posting method set in Depreciation area. So Accumulated Depreciation Acct affected)

9_Journal Entry of Depreciation Run. (Indirect Posting method set in Depreciation area. So Accumulated Depreciation Acct affected).jpg

10_Asset Master data After adding Depreciation Run

10_Asset Master data After adding Depreciation Run.jpg

11-Manual Depreciation

11-Manual Depreciation.jpg

12_Journal Entry of Manual Depreciation. (Indirect Posting method set in Depreciation area. So Accumulated Depreciation Acct affected)

12_Journal Entry of Manual Depreciation. (Indirect Posting method set in Depreciation area. So Accumulated Depreciation Acct affected).jpg

13_Asset Master data After adding Asset Manual Depreciation_Overview Tab

13_Asset Master data After adding Asset Manual Depreciation_Overview Tab.jpg

14_Asset Master data After adding Asset Manual Depreciation_Depreciation Tab

14_Asset Master data After adding Asset Manual Depreciation_Depreciation Tab.jpg

15_Asset Revaluation- Decrease in value

15_Asset Revaluation- Decrease in value.jpg

16_JE – Asset Revaluation- Decrease in value

16_JE - Asset Revaluation- Decrease in value.jpg

17_Asset Master data After adding Asset Revaluation- Decrease in value_Overview Tab

17_Asset Master data After adding Asset Revaluation- Decrease in value_Overview Tab.jpg

18_Asset Master data After adding Asset Revaluation- Decrease in value_Values tab

18_Asset Master data After adding Asset Revaluation- Decrease in value_Values tab.jpg

19_Asset Revaluation- Increase in value

19_Asset Revaluation- Increase in value.jpg

20_JE_Asset Revaluation- Increase in value

20_JE_Asset Revaluation- Increase in value.jpg

21_Asset Master data After adding Asset Revaluation- Increase in value_Overview Tab

21_Asset Master data After adding Asset Revaluation- Increase in value_Overview Tab.jpg

22_Asset Master data After adding Asset Revaluation- Increase in value_Values Tab

22_Asset Master data After adding Asset Revaluation- Increase in value_Values Tab.jpg

23_Sales of Fixed Asset with Loss (NBV as on 31.03.2016 8,50,000 ; Sales Value 8,49,000

23_Sales of Fixed Asset with Loss (NBV as on 31.03.2016 8,50,000 ; Sales Value 8,49,000.jpg

24_JE for AR Invoice_ Sale of Fixed Asset with Loss

24_JE for AR Invoice_ Sale of Fixed Asset with Loss.jpg

25_Automatic retirement document – Sales of Fixed Asset with Loss

25_Automatic retirement document - Sales of Fixed Asset with Loss.jpg

26_JE for Retirement Document with Loss

26_JE for Retirement Document with Loss.jpg

27_Sales of Fixed Asset with Profit (NBV as on 31.03.2016 4,05,000 ; Sales Value 4,07,000

27_Sales of Fixed Asset with Profit (NBV as on 31.03.2016 4,05,000 ; Sales Value 4,07,000.jpg

28_JE for AR Invoice of FA with Profit

28_JE for AR Invoice of FA with Profit.jpg

29-Automatic retirement document-Sales of Fixed Asset with Profit

29-Automatic retirement document-Sales of Fixed Asset with Profit.jpg

30_JE_Automatic retirement document-Sales of Fixed Asset with Profit

30_JE_Automatic retirement document-Sales of Fixed Asset with Profit.jpg

31_Asset Retirement _ Scrapping (Direct)

31_Asset Retirement _ Scrapping (Direct).jpg

32_JE_Asset Retirement _ Scrapping (Direct)

32_JE_Asset Retirement _ Scrapping (Direct).jpg

Hope it is useful

Thanks

Unnikrishnan

To report this post you need to login first.

13 Comments

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

  1. Fernando Martins

    Very Good Document Unnikrishnan 🙂

    I am trying to implement this in my company and I am facing a doubt.

    I have a few FA that had already depreciation value (another system) and I want to add them also.

    Example: Truck acquired in 01/07/2013

    I was not able to add the FA item with a date before ??? I only have SAP B1 since 2014 and not allowed to put the initial date and therefore the capitalization date is always 01/01/2015.

    I thought in adding with that date but need to have only the remain depreciation period and need to add the values already depreciated before.

    Can you help me Please?

    Fernando Martins

    (0) 
    1. Michael Barrah

      Fernando,

      I have just gone thru this myself.

      Once you activate Fixed Assets, you will be able to import Fixed Asset data using the “Data Import/Export” -> “Import Fixed Asset Master Data” option in Administration.

      It provides a standard template for the excel spreadsheet and allows you to load assets with original Cap date, orig cost and depn to date etc.

      Very easy to use.

      Fixed Assets.JPG

      (0) 
  2. Satrio Adi Wibowo

    Dear all,

    Please help me for import Fixed Assets Master data from excel. I had trouble import from excel the following error “Cannot import “BB10001″; its active depreciation areas must be the same as those defined in the corresponding asset class”.

    Do you have any idea for fix problem??

    Thanks,

    Best Regards

    FA import.PNG

    error.PNG

    (0) 
  3. Sajith Morais

    Hi Guys,

    Anybody can suggest me how to add OB of Land as a Fixed Asset in SAP business one 9.1? We can use data import feature via MS excel but the Land (asset) won’t be appeared in the FA reports.

    Regards,

    Sajith

    (0) 
  4. Francisco Flores

    I need to get the data from the OFDV table, like the ACQCost field, but the table does not exist or is hidden, does anyone know how to get that data?

    (0) 

Leave a Reply