inventory valuation and fixed assets l.
Skip this Video
Loading SlideShow in 5 Seconds..
Inventory Valuation and Fixed Assets PowerPoint Presentation
Download Presentation
Inventory Valuation and Fixed Assets

Loading in 2 Seconds...

play fullscreen
1 / 42

Inventory Valuation and Fixed Assets - PowerPoint PPT Presentation

  • Uploaded on

Inventory Valuation and Fixed Assets. Lawson User Association AGM. Helen Davis Solution Design Fixed Assets. Register Asset. Record Asset . Define Depreciation. Activate Asset. Register Asset. Record Asset . Define Depreciation. Activate Asset.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Inventory Valuation and Fixed Assets

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
inventory valuation and fixed assets

Inventory Valuation and Fixed Assets

Lawson User Association AGM

Helen Davis

Solution Design


Register Asset

Record Asset

Define Depreciation




Register Asset

Record Asset

Define Depreciation




- xxxxxxxx -

- xxxxxxxx -

- xxxxxxxx -

General ledger

Register Asset

Purchase Receipt

Accounts payable




1. From entry of supplier

invoices or journal entries

2. Manual entry

in assets book

Asset book

3. Activation of

assets in progress

Project accounting


Register Asset

Record Asset

Define Depreciation




Straight line

Asset book




Tax Book

User defined

Depreciation types

Depreciation types

Depreciation types

Define Depreciation

  • External
  • Internal
impairment of assets ias36
Impairment of Assets – IAS36
  • What

the value of a tangible fixed asset in the balance sheet (carrying amount) cannot exceed its estimated economic worth (recoverable amount).

  • When

If there is any indication on the balance sheet date that a tangible fixed asset has diminished in value, the company should analyze whether the fixed asset must be impaired. Otherwise, the analysis must be done as a part of the company’s year-end routines.

Companies must impair their fixed assets even when the recoverable amount is only temporarily lower than the carrying amount.

impairment of assets ias3614
Impairment of Assets – IAS36
  • What

IAS 36 applies to all fixed assets in the following categories:

    • Land
    • Buildings
    • Machinery and equipment
    • Investment property carried at cost
    • Intangible assets
    • Goodwill
    • Investments in subsidiaries, associates and joint ventures
    • Assets carried at revalued amounts under IAS 16 and 38.
  • Consequently, IAS 36 does not apply to:
    • Inventories (see IAS 2)
    • Fixed assets arising from construction contracts (see IAS 11)
    • Deferred tax assets (see IAS 12)
    • Assets arising from employee benefits (see IAS 19)
    • Financial assets (see IAS 39).
impairment of assets ias3615
Impairment of Assets – IAS36
  • How

1. Identify the Recoverable Amount

    • Fair value less selling costs (net selling price); or
    • Present Value of future cash flows
    • Calculations done outside of M3

2. Update Recoverable Amounts in M3

    • Update manually in FAS003; or
    • Use Annual Run Open to calculate replacement cost based on cost of capital method held in M3.

3. Run a report identifying assets where carrying value > recoverable amount


If the extraordinary depn value is entered, the replacement value will be calculated as the remaining value less extraordinary depreciation.

If you enter a replacement value, the extra depreciation amount is calculated automatically as the residual value less the replacement value.


The field indicates how depreciation will continue when an extraordinary depreciation has been made.


1 = Depreciations continue in the same way as before. This means that the fixed asset will be fully depreciated faster than it would have been without extraordinary depreciation.

2 = The depreciation will continue as long as planned, but with a lower amount each year. The extraordinary depreciation is stored in a specific value type.

inventory valuation23
Inventory Valuation
  • What:
    • Lower of Cost and NRV
  • Why:
    • AASB 102
    • IAS 2
    • GAAP
  • When:
    • Anyone preparing General

Purpose Financial reports

(other than agricultural producers &

Commodity traders)

  • How in M3:
inventory revaluation cas180
Inventory Revaluation – CAS180
  • Use CAS180 to create an inventory valuation “round”
  • Creating:
    • Valuation proposal showing FIFO, average, actual and recommended inventory amounts
    • Print of sales value, adjusted sales value, replacement cost and recommended actual value
    • Variance Print categorised by facilities, product groups, accounting rules etc
    • Accounting proposal with proposed adjustments to inventory

Use CAS025 to define settings for different inventory groups by:

- Division

- Facility

- Item Group

- Item Number


The field indicates which method to be used for calculating the acquisition cost of the inventory.


1 = FIFO

2 = LIFO

3 = Average.


Price list indicates the price list with manually entered inventory values for items.

You can choose to automatically update the inventory value of the item in the price list if you enter an inventory value manually in CAS196/E - Inventory Valuation. Enter Manually


The Obsolete field indicates the percent of the inventory value considered as obsolete during inventory valuation.


If you choose to use the Net Sales Method

The search path indicates the sequence in which the net sales value is searched.


1 = From the price list

2 = From the item's basic data

3 = From preferred acquisition cost method.


Value 21 means that the price is first searched for in the item file. If there is no value there, the search continues in the specified price list.


If you choose to use the Net Sales Method

The Percent Share Inventory Value field indicates the percent of the price from the price list or item file used when calculating inventory value.


If you choose to use the Replacement method

  • The field indicates how the replacement cost is defined, with or without applying a purchase costing model.
  • Alternatives
  • 0 = No replacement cost.
  • 1 = Purchase price from the agreement file
  • 2 = Purchase price from the item/supplier file
  • 3 = Purchase price from the item master file.
  • 4 = Average cost.
  • 5 = Price on the latest invoice in the purchasing statistics
  • = The lowest alternative of 4 and 5.
  • = Replacement cost is to be set equal to a specific costing type and subtotal

Every inventory item has the FIFO, LIFO, Net Sales and Replacement Sales value calculated for it.


Depreciation is calculated by forecasting future demand based on historical usage split into “buckets”.

Depreciation for each bucket is calculated as follows:

(Quantity per bucket) x (Unit price) x (Percentage per bucket)