5.

Inventory

5. Inventory
5.1 Month-End Guidance
5.2 Inventory Value Report
5.3 Material Account Distribution Detail report

Appendices

G Inventory Value Report

H Material Distribution Detail Report
5. Inventory

5.1 Month End Guidance

These procedures only apply to departments using the UFS Inventory module. It will
be important for the departments with stores to ensure an accurate record of stock is
maintained and that stock is allocated accurately within the department.

Receipt Issue Review Reconcile

Receive the Issue Review stock Reconcile
goods in to individual levels Inventory and
stores items out of GL modules
stores

Month-End Guidance – Inventory

Ø Complete all inventory issues and receipts made during the month (ongoing
process during the month).
Ø Undertake monthly stock-take or cycle count if appropriate
Ø Run Value of Inventory report to review stock items and see overall stock
position
Ø Run Material Distribution Retail Report showing issues of stock items with the
department.

5.2 Inventory Value Report Monthly

Why this report is useful
This report details the stock value at the end of the period and should be reconciled to
the general ledger inventory codes (the T range of transaction codes). It gives a
breakdown of the stock item by item detailing item code, description, unit cost,
quantity (which should agree to the stock take) and the total valuation.

How to run this report

Note the organisation is already chosen and all that is required is to accept the defaults
(see overleaf).

Action Points from this report

Reconcile this report to the general ledger using the material account distribution
detail report.
 Accept all
of the
default
parameters

5.3 Material Account Distribution Detail Report

Why this report is useful
As well as giving the stock value at the end of the period this report details all the
receipts, issues and adjustments into the inventory value account.

How to run this report

It is possible to run this report for each cost centre and thus give a concise report for
all stock movements.

&
NB: It is possible, when using this
report other than at year end, to
narrow down this report for an
individual cost centre, alias or your
T*** stock account.
Action Points from this report
Use this report to reconcile the inventory value report to the general ledger making
adjustments for invoice price variances.

See Appendix H for an example of this report

 Appendix G: Inventory Value Report

PK_Pathology Report Date: 06-JUN-2005 16:22

Sort by Item AFINVCST Page: 1
Cost Type: Average Detailed (GBP)
Category Set: Inventory

Headings wrap
around onto two rows
Item
Item Description Status UOM Quantity Unit Cost Extended Value
--------------- ------------------ ---------- --- ------------ -------------- ----------------
AJ0009 OVERHEAD PROJECTION SHEETS A4 PER SHEET PACK/100 Active Ea 17.00 19.99 339.89

Subinventory Asset Description Rev Quantity Extended Value

------------ ----- -------------------------------------------------- --- ------------ ----------------
--------------------------------------------------
------------------------
ASSET_PK Yes Primary Sub Inventory 17.00 339.89

AKA0015 PHOTOGRAPHIC FILM POLAROID 667 Active Ea 35.00 12.00 420.00 Extended
Value could
Subinventory Asset Description Rev Quantity Extended Value be subject to
------------ ----- -------------------------------------------------- --- ------------ ----------------
--------------------------------------------------
rounding
------------------------
ASSET_PK Yes Primary Sub Inventory 35.00 420.00

Item Code Quantity Average Unit Cost

Available calculated by the
system.
Appendix H: Material Distribution Detail Report
PK_Pathology Report Date: 06-JUN-2002 16:22
Sorted by Account Material Account Distribution Detail(CAPSA) Page:
314
GBP

Account: U.PK.PKAB.ADAA.TAAA.0000

Txn Date Item Description Reference Source Quantity UOM Unit Cost Txn Value
--------- -------- -------------- -------- -------------- ------------ --- ------------- ---------------
12-JAN-01 UDE0011 GLOVES SILK PAIR PA15111 1:VIROLOGY -2.00 Ea 5.75 (11.50)
12-JAN-01 UDE0011 GLOVES SILK PAIR PA15101/PF46022 2:ZOOLOGY -1.00 Ea 5.75 (5.75)
12-JAN-01 UDEG0024 GLOVES - LATEX ANSELL PACK/100 pa15007 1:PROF C HUGHE -4.00 Ea 2.80 (11.20)
15-JAN-01 HEA0002 PAPER TOWELS CENTRE FOLD SPD135 44896 10.00 Ea 1.71 17.10
15-JAN-01 HAD0007 HAND CREAM E45 PA15179 1:MICROBIOLOGY -1.00 Ea 3.90 (3.90)
15-JAN-01 HAD0009 HAND CREAM VASELINE PA15179 1:MICROBIOLOGY -1.00 Ea 1.15 (1.15)

Item Code
PO Number or Transaction
Alias used. Value = Unit
Cost x
Transaction
Quantity
Date
& NB: When viewing the Stock Account Transaction Code (TAAA as
shown in this example) a positive figure represents good received and a
negative figure represents goods issued. However, when viewing an Income
or Expenditure account code, a positive figure will represent the goods
issued from stock and a negative figure will represent goods returned to
stock.