1. Home
  2. Blog
  3. Inventory Control in ERP: Item Setup, Costing Methods and Stock Counts

Inventory Control in ERP: Item Setup, Costing Methods and Stock Counts

  • 7 min read
  • Tranquil team

Inventory control in ERP is tested at every month-end close. The trial balance shows one inventory figure, the warehouse report shows another, and the stock count at the branch shows a third. Each difference has a cause that can be traced to a document: a goods receipt priced before the supplier invoice arrived, a transfer sent but never received, a sale delivered from the wrong unit of measure, or a count shortage nobody posted.

The three figures agree when four things are right: how items are set up, which costing method IAS 2 allows, what each stock movement posts to the ledger, and how counts and write-downs are handled. Forecasting and reorder levels have their own guide on demand planning in ERP.

Setting up the item master

Most inventory errors we trace in implementations start in the item master, not in the warehouse. Five settings on each item decide how it behaves for the rest of its life:

  • Item type: stock, service (no quantity kept) or production (manufactured from a bill of materials).
  • Units of measure and conversions, for example bought by the carton of 24 and sold by the piece.
  • Batch or serial tracking, with expiry dates for food, pharmaceuticals and chemicals.
  • The inventory, income and cost of sales accounts the item posts to.
  • The costing method, which is hard to change once transactions exist.

Two mistakes recur. The first is the same product created twice under slightly different names, so stock sits on one code while purchasing orders the other. The second is a wrong conversion factor, such as a carton entered as 12 pieces instead of 24, which halves the cost per piece on every sale until someone notices the margin. A short review of new items before they are approved prevents both.

Costing methods under IAS 2: a worked example

IAS 2, as endorsed in Saudi Arabia by SOCPA, measures inventory at the lower of cost and net realisable value (paragraph 9). Items that are not interchangeable, such as vehicles or project-specific equipment, are costed by specific identification (paragraph 23). All other items use FIFO or weighted average cost (paragraph 25). LIFO is not permitted, even where an ERP offers it. Standard cost may be used for convenience if the results approximate cost (paragraph 21).

The figures below are hypothetical. An item has 100 units in stock at SAR 20.00. A goods receipt adds 200 units at SAR 23.00, and the company then sells 150 units.

Step Weighted average FIFO
Stock after receipt 300 units, 6,600.00 100 at 20.00 + 200 at 23.00 = 6,600.00
Unit cost used for the sale 6,600.00 ÷ 300 = 22.00 100 at 20.00, then 50 at 23.00
Cost of sales for 150 units 150 × 22.00 = 3,300.00 2,000.00 + 1,150.00 = 3,150.00
Closing stock, 150 units 3,300.00 150 × 23.00 = 3,450.00

With rising prices, FIFO gives a lower cost of sales and a higher closing stock, here by SAR 150.00. Neither is more correct. What matters is using the same method for items of a similar nature, as paragraph 25 requires, and not switching an item’s method mid-year to improve a margin.

What each stock movement posts to the ledger

In a perpetual system every movement posts at the time it happens. The entries below continue the example, with VAT at 15% on the supplier invoice.

Document Account Debit Credit
Goods receipt (GRN), 200 × 23.00 Inventory 4,600.00
Unbilled purchases 4,600.00
Supplier invoice Unbilled purchases 4,600.00
Input VAT 690.00
Supplier 5,290.00
Delivery to customer, 150 × 22.00 Cost of sales 3,300.00
Inventory 3,300.00

The receipt posts at cost without VAT, and the invoice clears the unbilled account. A balance left on unbilled purchases at month-end is either goods received and not yet invoiced, which is correct, or an invoice matched to the wrong receipt, which is not. Review that account line by line before closing.

Freight, customs duty and insurance on imports belong in the cost of the item, not in expenses. Landed cost spreads them over the receipt lines, usually by value or quantity. If they arrive after the goods have been sold, part of the charge belongs to cost of sales, not to stock.

Stock counts and adjustments

A full count closes the warehouse for a day or more, so most distributors count high-value items in cycles through the year and do a full count at year-end for the auditor. The cycle counting guide explains how to schedule it. Whatever the method, the count sheet should show the item and location but not the system quantity, so the counter records what is on the shelf.

Differences are investigated before they are posted. Many shortages turn out to be a delivery issued from the wrong batch or a transfer received at the other branch. What remains is posted as an adjustment. For 12 units short at SAR 22.00:

Account Debit Credit
Inventory adjustment (expense) 264.00
Inventory 264.00

IAS 2 requires losses of inventory to be recognized as an expense in the period the loss occurs (paragraph 34), so a shortage found in March is not spread over the year. The common error is to correct the quantity with a manual journal on the inventory account, which changes the ledger but not the item’s stock. Our article on inventory shrinkage covers the causes and how to calculate the rate.

Slow-moving and expired stock

Lower of cost and net realisable value means stock is written down when it can no longer be sold for what it cost, less the costs to sell it. Expired batches, damaged goods, discontinued models and items held far beyond their usual sales all qualify. An aging report by receipt date is the usual starting point, followed by a conversation with sales about what can actually be sold and at what price.

The write-down is an expense in the period, against a provision or directly against inventory, and it is reviewed again at each reporting date. Expiry tracking by batch helps here, because the system can show what expires in the next three months while there is still time to sell it.

Inventory control in ERP with Tranquil

In Tranquil an item is a stock, service or production item, with its own inventory, income and expense accounts, a costing method (Average, FIFO or LIFO; for IFRS reporting choose Average or FIFO), batch or serial tracking with expiry validation, and several units of measure, each with its own cost, sales price and minimum price. Each item also carries a reorder quantity and a minimum quantity, and Auto Purchase Order raises orders for items below their minimum in one step.

Warehouses can be split into locators (bins). Stock moves through Stock Transfer Request, Stock Transfer and Stock Transfer Receive, so goods sent are visible until the other store confirms them. Stock Adjustment posts to the inventory adjustment account, and Stock Taking Management works from an uploaded count sheet. Landed cost is spread by price, quantity or equally, approved sales orders move stock to reserved, and Quality Check can be applied to receipts and deliveries.

Under Reports, the Inventory tab has 21 reports, including stock valuation, aging, batch, warehouse and maintain level. The module is described on the Tranquil inventory management page.

Frequently asked questions

Which inventory costing method is allowed in Saudi Arabia?

Under IAS 2 as endorsed by SOCPA, interchangeable items use FIFO or weighted average cost, and items that are not interchangeable use specific identification. LIFO is not permitted. Use the same formula for all items of a similar nature and use.

Can I change an item’s costing method after go-live?

It is possible but rarely worth it. IAS 8 allows a voluntary change of accounting policy only if it gives reliable and more relevant information (paragraph 14), and in many ERPs it means closing the old item and opening a new one with a revalued opening stock. Choose the method carefully before the first receipt.

Why does the inventory account not match the stock valuation report?

Usually because something posted to the inventory account without moving stock, such as a manual journal, or because a receipt is waiting for its invoice. Compare the two at item level, then review manual entries on the inventory account and the unbilled purchases balance.

How often should we count stock?

At least once a year in full, for the financial statements. High-value and fast-moving items are best counted in cycles during the year, for example monthly, so differences are found while the documents are still fresh.

See what this article covers in Tranquil

In the demo we show what this article covers on Tranquil’s own screens and answer your team’s questions.

Dammam +966 13 848 8080, +966 13 817 7724, Riyadh +966 11 213 1330
[email protected]
Sunday to Thursday, 8 am to 5 pm.