Inventory and costing in Oracle Fusion

The last two stations watched cost leave inventory at delivery. This station explains where the number that left came from.

It is the station that separates an accountant from a consultant. Somebody who knows how the number is computed can explain the margin. Somebody who does not reads a report and believes it.

The three costing layers

The structural difference between this product and everything below it on this site starts here.

Layer	What it does
Inventory organisation	Where the goods physically stand — warehouse, location, quantity
Cost organisation	Who owns the valuation decision, possibly across several inventory organisations
Cost book	The rules the stock is valued by, and there may be more than one for the same stock

That last line is the capability bought at this tier and unavailable below it.

One book values at moving average for statutory reporting, and a second values the same items at standard cost for management. The movement is recorded once and valued twice. A group closing statutory books in one country while managing performance on a single standard across several needs exactly this, and it cannot be assembled in a system that carries one valuation.

Cost methods, and when each is right

Method	When it fits	Its price
Moving average	Trading and distribution, moving prices	Hides why the cost changed
First in, first out	Shelf life, batches, traceability	Heavy under high transaction volume
Standard cost	Manufacturing, or performance control	Needs variances analysed monthly, or it becomes fiction

The choice sits on the item rather than on the company. It is entirely correct for raw materials to be at standard and goods bought for resale to be at average, in the same company.

The rule most projects get wrong: standard cost is not “the advanced method”. It is a method that assumes somebody analyses variances every month. Choose it without that person and you have created a variance account that swells unread, and a comfortable stable cost with no relationship to reality.

Receipt accounting — the bridge that explains two balances

Between receiving goods and accounting for their cost sits a separate layer whose job is to carry the difference.

The receipt creates an accrual; the invoice clears it; and the difference between them — in price or in quantity — lands in a clearing account.

That account is the first thing an auditor opens in these systems. Its balance reads as follows.

• Large and old: goods received whose invoice never arrived, or invoices processed outside the purchase order.
• Negative: billing exceeding receipts — a sign of an unrecorded receipt, rather than an over-billing.
• Volatile with no pattern: price variances that are not analysed, and usually no blanket agreements, as in station four.

Landed cost — the difference between real profit and paper profit

An importer buys an item at 100 and pays freight, insurance, duty and handling worth 18. If the 18 goes to an expense account, the item costs 100, and the reported margin is eighteen percent higher than the real one.

The product provides landed cost, which absorbs those elements onto the items by value, weight or volume, so the item costs 118 and pricing decisions rest on a correct number.

That single error is the commonest reason a trading company is profitable on paper and short of cash — and the gap appears in no report until the cost is computed correctly.

Where this product sits against its alternatives on inventory and costing depth is in the Oracle Fusion Cloud ERP guide.

This station’s exercise

In a spreadsheet rather than in the system.

1. Buy the same item three times at three prices and sell some of it. Compute cost and profit at moving average, then at FIFO. The gap is what you are choosing when you choose a method.
2. Add freight and duty of 18% apportioned by value, and recompute the margin.
3. Write the accrual scenario: a receipt at 100 and an invoice at 105. What stays in the clearing account, and why?
4. Value the same stock in two books: average and standard. Write down why the numbers differ and who uses each.

What you actually do in this station

• Do the exercise by hand. Compute it in a spreadsheet once and you understand it in any system.
• Read the cost management chapter of the documentation in order, not by search.
• Pull the accrual clearing balance in any environment you can reach, and ask about the oldest item in it.
• Write the right method and the reason, in one line, for every item category in a company you know.
• Revisit the inventory cycle for the general principle before the product detail.

The three commonest mistakes

One: one cost method for the whole company. Chosen once and forgotten, so raw materials and finished goods are valued on a logic that suits neither.

Two: ignoring landed cost. A reported margin tens of points above the real one in an importing business.

Three: standard cost with no variance analysis. A variance account growing with no reader, and a comfortable fixed cost that describes nothing.

The acceptance test for this station

1. Distinguish inventory organisation, cost organisation and cost book.
2. Say when each cost method is chosen, and state the condition attached to standard cost.
3. Read the accrual clearing balance in all three states: large, negative, volatile.
4. Show the landed cost calculation and its effect on margin.
5. Explain why the same item’s margin may differ between two entities in the same group.

What comes next

You know where the numbers come from. The next station explains who writes them into the general ledger, and it is the single most important idea in the product: subledger accounting and the close.