Docstoc

Stores Supervisor Manual

Document Sample
Stores Supervisor Manual Powered By Docstoc
					    Oracle Financials
    Stores Supervisor Manual

           Version Four




http://www.manchester.ac.uk/finance
          20 August 2007
                                                     Table of Contents

1          INTRODUCTION ................................................................................................ 1
2          STORES OVERVIEW .......................................................................................... 2
3          MISCELLANEOUS TRANSACTIONS .................................................................... 4
           3.1     COUNTER ISSUE – NON PROJECT ...........................................................................................6
           3.2     COUNTER ISSUE – PROJECT ...................................................................................................8
           3.3     INTERNAL REQUISITION .......................................................................................................10
           3.4     MISCELLANEOUS RECEIPT ....................................................................................................10
           3.5     RETURN TO STOCK – NON PROJECT .....................................................................................12
           3.6     RETURN TO STOCK – PROJECT .............................................................................................12
           3.7     STOCK ADJUSTMENT UP ......................................................................................................12
           3.8     STOCK ADJUSTMENT DOWN ...............................................................................................13
4          TRANSACTION SUMMARIES ........................................................................... 14
5          MATERIAL TRANSACTIONS ............................................................................ 16
6          ON-HAND QUANTITY (MATERIAL WORKBENCH) ........................................... 19
7          ITEM COSTS .................................................................................................... 21
8          CREATE A NEW ITEM ...................................................................................... 23
           8.1     THE MASTER ITEM WINDOW ...............................................................................................23
           8.2     APPLYING A TEMPLATE .........................................................................................................26
           8.3     INSERT THE CORRECT CATEGORY CODE ................................................................................28
           8.4     ITEM MIN-MAX PLANNING ...................................................................................................30
           8.5     LIST PRICE & VAT CODE .....................................................................................................32
           8.6     ASSIGN ITEM TO YOUR ORGANISATION .................................................................................33
9          REPLENISHMENT OF STOCK ........................................................................... 37
           9.1     SETTING UP A SOURCING RULE ............................................................................................38
           9.2     ASSIGN SOURCING RULE......................................................................................................40
           9.3     UNIT OF MEASURE CONVERSIONS ........................................................................................43
           9.4     APPROVED SUPPLIER LIST ....................................................................................................44
           9.5     MIN-MAX PLANNING ............................................................................................................46
10         MAINTAINING ITEM DETAILS ........................................................................ 49
           10.1 AMENDING ITEMS AT MASTER LEVEL ....................................................................................49
           10.2 AMENDING ITEMS AT ORGANIZATION LEVEL .........................................................................51
11         THREE WAYS TO UPDATE THE PRICE OF AN ITEM ......................................... 54
12         MAKE AN ITEM INACTIVE ............................................................................... 57
13         APPENDIX A – KEYBOARD SHORTCUTS ......................................................... 59
14         APPENDIX B - TOOLBAR ................................................................................. 63
15         APPENDIX C – LIST OF CATEGORY CODES ..................................................... 64
16         APPENDIX D – DOCUMENT RETENTION POLICY ............................................ 66
17         APPENDIX E – RUNNING A DISCOVERER REPORT ......................................... 67
18         APPENDIX F – APPLYING THE TEMPLATE ...................................................... 72




Course: IT01s
1     Introduction


This manual explains how the Stores module works in the Oracle Financials system.

It is written for anyone that works in Stores.

If you have any support queries, please log an ARS support call

This can be found at: http://helpdesk.man.ac.uk/cgi-bin/incidentreporting.cgi
Or via the links on the Finance System home page
http://www.campus.manchester.ac.uk/finance/Sys/OracleSystem/SysUnityIS.shtml




                 DISCLAIMER:
                The Oracle Financials system is still under development as this manual is
                 being written. Some details of the system may change in future;
                 updated versions of the manual will be made available on the Finance
                 web site as changes are made.




Course: IT01s                                                                          Page: 1
Section: Introduction
2    Stores Overview

What is the Stores module?

The Stores module went live on 1st June 2006 as part of Oracle Financials

Stores is how the University of Manchester provide an internal shopping service

The purpose of Stores is to provide a convenient and immediate supply at an economic
cost

Oracle Inventory system aims to facilitate the management of this process




Course: IT01s                                                                     Page: 2
Section: Stores Overview
Oracle Financials Screen Layout

                                Menu bar and tool bar




Look here for Oracle messages
                                            This is the Navigator window
                                            You can open different menu
                                            options from here




Course: IT01s                                                              Page: 3
Section: Stores Overview
3     Miscellaneous Transactions

A Miscellaneous Transaction is movement of stock in and out of the store. These are
also called counter issues. There are several types of transactions



                                      This is an over the counter issue that will be charged to
Counter Issue – Non Project           an activity code
                                      Example Activity Code: AA12345


                                      This is an over the counter issue that will be charged to
Counter Issue – Project               a project
                                      Example Project Code: R123456 Task: A07


                                      This option is used when the order started as an i-proc
Internal Requisition
                                      requisition


                                      This option is to perform a miscellaneous receipt of
Miscellaneous Receipt
                                      stock


                                      An item has been returned and an activity code needs
Return to Stock – Non Project
                                      crediting


                                      An item has been returned and a project needs
Return to Stock – Project
                                      crediting


Stock Adjustment DOWN                 Manual adjustments of stock


Stock Adjustment UP                   Manual adjustments of stock




                   NOTE: Items issued or returned against project accounts must be
                        entered via the project method




Course: IT01s                                                                            Page: 4
Section: Miscellaneous Transactions
Navigate to: Transactions: XXUOM Miscellaneous Transaction




                                             Click Type to open the
                                             Transaction Types Window




Let’s look at these transactions in more detail




Course: IT01s                                                           Page: 5
Section: Miscellaneous Transactions
3.1        Counter Issue – Non Project

This is an over the counter issue that will be charged to a GL activity code

Navigate to: Transactions: XXUOM Miscellaneous Transaction

      1. This will open the Miscellaneous Transaction window




      2. Date:                        The date is completed for you

      3. Type:                        Counter Issue – Non Project

      4. Source:                      Leave blank

      5. Account:                     Enter a GL activity code here if you are issuing many items
                                      with same code. Otherwise leave blank and you can add
                                      the GL activity code later

      6. Serial-Triggered:            Leave blank


      7. Click Transaction Lines




Course: IT01s                                                                               Page: 6
Section: Miscellaneous Transactions
             8. This opens the Counter Issue Window




Here is the Item
Description and
Quantity Available




             9. Item:                          e.g. L:JVPSL

             10. Subinventory:                 Click inside the field and the subinventory will automatically
                                               populate

             11. UOM:                          Unit of Measure defaults in

             12. Quantity:                     enter the amount being issued

             13. Selling Price:                This is the price you are charging the customer
                                               This is the unit price plus any mark-up and VAT

             14. Account:                      Click on the 3 dots and enter the GL activity code the item
                                               is being charged to. The IE code will be in the Item
                                               Description e.g. [4090]. The source of funds is 00 for
                                               activity codes.

             15. Reference:                    Optional field to add an internal reference number

             16. Click in the next line if you wish to issue a second non-project item

             17. Click the Save icon

             18. Press the close button ‘x’ when you are finished




         Course: IT01s                                                                                 Page: 7
         Section: Miscellaneous Transactions
3.2        Counter Issue – Project

      This is a counter issue that will be charged to a project

      Navigate to: Transactions: XXUOM Miscellaneous Transaction




      1. The date will default in

      2. Change the Type to ‘Counter issue – project’

      3. The Source field will change to ‘Projects’

      4. Notice the Account field is greyed out

      5. Click Transaction Lines




Course: IT01s                                                      Page: 8
Section: Miscellaneous Transactions
    6. This will open the Counter Issue window

    7. Item:                          e.g. P:CHEM044

    8. Subinventory:                  Click the 3 dots inside the field and the subinventory will
                                      automatically populate

    9. UOM:                           Unit of Measure defaults in

    10. Quantity:                     enter the amount being issued

    11. Selling Price:                the total amount being charged to the customer




    12. Source Project                      e.g. R100002. Ensure you enter the correct project
                                            code to avoid mis-postings

    13. Source Task                         e.g. A07

    14. Expenditure Type                    e.g. 4090. This can be found in the Item Description

    15. Expenditure Org                     Click inside the field and ‘University of Manchester’
                                            will default in

    16. Click in the next line if you wish to issue another item to a project

    17. Click the Save icon

    18. Press the close button ‘x’ when you are finished

Course: IT01s                                                                                Page: 9
Section: Miscellaneous Transactions
3.3        Internal Requisition

This option is only for Stores that process i-proc internal requisitions
Instructions for this option are available in the Internal Trade Stores manual


3.4     Miscellaneous Receipt

Miscellaneous Receipts are generally only used when a store first goes live as a result of
your stock-take figures.
You may need to a miscellaneous receipt if goods are in your store that you have not
receipted via the normal methods. Please log an ARS call if you are unsure whether a
miscellaneous receipt is the correct transaction to do.

Navigate to: Transactions: XXUOM Miscellaneous Transaction

      1. This opens the Miscellaneous Transaction window




      2. Select Type ‘Miscellaneous Receipt’

      3. Click on Transaction Lines




Course: IT01s                                                                       Page: 10
Section: Miscellaneous Transactions
    4. This will open the ‘Miscellaneous receipt’ window




    5. Item:                          e.g. L:JVPSL

    6. Subinventory:                  Click on the 3 dots inside the field and the subinventory
                                      will automatically populate

    7. UOM:                           Unit of Measure defaults in

    8. Quantity:                      Enter the quantity

    9. Account:                       The GL account code for the relevant Stores account is
                                      set in the background and doesn’t need to be entered

    10. Unit Cost:                    The unit cost is the gross cost without any mark-up.
                                      E.g. Net price is 10.00, gross with VAT is 11.75. Selling
                                      price with 3% Mark-up is 12.10. The figure you would
                                      enter in the Unit Cost field is 11.75 – the gross cost

    11. Reason:                       Optional field to add a reason for miscellaneous receipt

    12. Reference:                    Optional field to add an internal reference number

    13. Click in the next line if you do a miscellaneous receipt

    14. Click the Save icon

    15. Press the ‘x’ when you are finished




Course: IT01s                                                                              Page: 11
Section: Miscellaneous Transactions
3.5     Return to Stock – Non Project
Navigate to: Transactions: XXUOM Miscellaneous Transaction
An item has been returned and a GL activity code needs crediting
The screen is the same as a ‘counter issue – non project’ screen


3.6 Return to Stock – Project
Navigate to: Transactions: XXUOM Miscellaneous Transaction
An item has been returned and a project needs crediting
The screen is the same as a ‘counter issue – project’ screen


3.7     Stock Adjustment UP

This option is for manual adjustments of stock

Navigate to: Transactions: XXUOM Miscellaneous Transaction

      1. This opens the Miscellaneous Transaction window

      2. Select Type ‘Stock Adjustment UP’

      3. The ‘source’ field will pre-populate with ‘Stock Adjustment’




      4. Click on Transaction Lines

      5. This opens the Stock Adjustment UP window as shown on the next page




Course: IT01s                                                                  Page: 12
Section: Miscellaneous Transactions
    6. Item:                          e.g. L:JVPSL

    7. Subinventory:                  Click inside the field and the subinventory will automatically
                                      pre-populate

    8. UOM:                           Unit of Measure defaults in

    9. Quantity:                      Enter the quantity

    10. Account:                      The GL account code for the relevant Stores account is set
                                      in the background and doesn’t need to be entered

    11. Reason:                       Optional field to add a reason for stock adjustment

    12. Reference:                    Optional field to add an internal reference number

    13. Unit Cost:                    This should be left blank

    14. Click the Save icon

    15. Click in the next line if you wish to issue a second non-project item

    16. Press the ‘x’ when you are finished


3.8 Stock Adjustment DOWN
Navigate to: Transactions: XXUOM Miscellaneous Transaction
This option is for manual adjustments of stock
This is the same process as the previous section


Course: IT01s                                                                                Page: 13
Section: Miscellaneous Transactions
4    Transaction Summaries

‘Transaction Summaries’ is a look-up and inquiry screen.
You can find the transaction details for an item.



Navigate to: Transactions: Transaction Summaries


    1. This will open the Summarize Transactions window

    2. Change the date fields (the default is transactions from today)

    3. Complete the Item field
       This example is looking for item C:00003

    4. Click Summarize




Course: IT01s                                                            Page: 14
Section: Transaction Summaries
    5. This will open the Transaction Summaries window




    6. This lists the transactions that have taken place over the specified time period

    7. Click Transaction Details to open the Material Transactions window for this item
       – This is described in more detail in the next section.




Course: IT01s                                                                      Page: 15
Section: Transaction Summaries
5     Material Transactions

Material Transactions is like Transaction Summary
It is a reporting mechanism that allows you to look at more than one item
(Transaction summary is for one item only)



Navigate to: Transactions: Material Transactions

     1. This opens the Find Material Transactions window




     2. The transaction dates will default to today’s date

     3. Change the date fields as required

     4. Complete other fields as required

     5. Click Find




Course: IT01s                                                               Page: 16
Section: Material Transactions
     6. This opens the Material Transactions window




     7. Use the horizontal scroll bar to view different fields

     8. Click Distributions to drill down on an item to view where charges or credits have
        been posted in GL.

     9. Remember Projects will not be shown in the Distributions window. Projects use
        the WH00059 clearing account before it is charged to the project. To view which
        project has been charged, click on the ‘Transaction ID’ tab and scroll across.




Course: IT01s                                                                      Page: 17
Section: Material Transactions
     10. This will open the Material Transaction Distributions window




     11. Remember Projects will not be shown in the Distributions window. Projects use
         the WH00059 clearing account before it is charged to the project. To view which
         project has been charged, close the Distributions window and click on the
         ‘Transaction ID’ tab and scroll across.


     12. Use the ‘x’ to close windows when you have finished with them




Course: IT01s                                                                    Page: 18
Section: Material Transactions
6    On-Hand Quantity (Material Workbench)

This is a physical snap-shot of what availability an item has right now
That includes what you have in stock and what you have on order


Navigate to: On-Hand, Availability: On-Hand Quantity

    1. This opens the Query Material Window




    2. Search by either Subinventory or Item
       This example is looking for item C:00003

    3. Click Find

    4. This opens the Material Workbench window

    5. Click ‘Availability’




Course: IT01s                                                             Page: 19
Section: On-Hand Quantity (Material Workbench)
    6. This opens the Availability window




    7. This lists the quantity that is ‘On Hand’, ‘Available To Reserve’ and ‘Available to
       Transact’

    8. These numbers will always be the same because one master item is only ever
       assigned to one organisation.

    9. Close the window using the ‘x’

    10. Close the Material Workbench using the ‘x’




Course: IT01s                                                                        Page: 20
Section: On-Hand Quantity (Material Workbench)
7    Item Costs

You can look at your Item Costs (Average Costs)


Navigate to: Costs: Items Costs


    1. This opens the Find Item/Cost Type Window

    2. Complete fields as necessary




    3. Click find




Course: IT01s                                      Page: 21
Section: Item Costs
    4. This opens the Item Costs Summary window




    5. Use the scroll bar to see all of the fields




                TIP: You can export this information into Microsoft Excel
                     Click File, Export, Save, select a file location and change the file
                     extension to .xls
                     This allows you to open the file in Microsoft Excel




                TIP: You can also press the Open button to check the Item Cost and
                     Availability




                TIP: These figures show the average cost and do not include your
                     mark-up




Course: IT01s                                                                           Page: 22
Section: Item Costs
8    Create a New Item

This section describes how to set-up a new stock item

Responsibility: Inventory

Navigate to: Items: Master Items


    8.1    The Master Item Window

This opens the Master Item window. Let’s look at the five main fields




1
2

3

4
5




Course: IT01s                                                           Page: 23
Section: Create a New Item
     Field                Field Description
1    Item                 This is the item reference
                          The Item Reference starts with a letter and a colon to indicate which
                          stores it belongs to

                          A: IT Services
                          C: Chemistry
                          M: MIB
                          L: Life Sciences (consider sub-inventories – as this will help when issuing)
                          P: Pharmacy

                          You cannot change the item reference once it is created.
                          You would have to inactivate the item and create a new item.
                          A consequence of this is there would be lots of inactive items and audit
                          trail and analysis would become complex.
2    Description          Enter the description of the item
                          This field will appear on the Purchase Order. Add any supplier information
                          such as a catalogue number here.
                          Include the IE code at the start of the description e.g. [4090].
                          (The Long Description field can be used to add additional notes. This is not
                          used for the Purchase Order but can be used for reports if required)
3    Flexfield            This is called a flexfield. A flexfield opens another window.
                          See the next page for how this flexfield is used
4    Primary              This is the primary unit of measure. For example, ‘Each’
                          The primary unit of measure is the issuing unit of measure, not the
                          purchasing unit of measure
                          It is very important that this field is entered correctly on the first attempt
                          This field cannot be changed once it is saved
5    Conversions          The convert issue units to purchase units. E.g. issue in ‘Each’, purchase in
                          a ‘Box’

                          The default setting is ‘Both’
                          The setting ‘Both’ will look at standard conversions first, before looking at
                          any ‘Item Specific’ conversions
                          Ensure you select ‘Item Specific’ if you are using ‘Item Specific’
                          conversions




                    TIP: If you are using non-standard conversions, ensure you select Item
                         Specific



    Course: IT01s                                                                              Page: 24
    Section: Create a New Item
Let’s look at a completed example

     Field              Field Description
1    Item               The item reference is C:0152
2    Description        The description is Test Tube Small. Include the IE code at the start of
                        the description e.g. [4090]. This will appear on the Purchase Order
3    Flexfield          This flexfield opens the Items window
                        Mark up %: Typical mark-up is 3%. The maximum mark-up is 99%
                        Extract to i-proc: This is for Stores using Internal Trade only
                        Source Supplier: This is for Stores using Internal Trade only. This is
                        where the item is bought from e.g. Astra Zeneca. This will be displayed
                        on the on-line catalogue. It does not drive any information shown on a
                        Purchase Order
                        Press OK
4    Primary            The Primary Unit of Measure is set to Each
5    Conversions        This has been left at the default setting of Both
                        The setting Both will look at standard conversions first, before looking at
                        any Item Specific conversions
                        Ensure you select Item Specific if you are using Item Specific conversions




                 WARNING: Take care to enter the correct Primary Unit of Measure. You
                          cannot change this field once you have saved it. The item
                          cannot be used if incorrect information is entered.




Course: IT01s                                                                            Page: 25
Section: Create a New Item
8.2        Applying a Template

      Now that we’ve set-up the key attributes for the item, we can apply a template

      The template helps by setting up most of the options for the item. The options
      don’t need to be amended and are duplicated across items e.g. Account Code for
      charging Purchase Orders to



      1. From the Tools Menu, select Copy From




Course: IT01s                                                                     Page: 26
Section: Create a New Item
    2. From the Copy From window, select the List of Values from the Template field




    3. Select your template e.g. For Chemistry – UOM: Chemistry Stock Template

    4. Click OK




    5. Click Apply – this saves the information

    6. Click Done

    7. All generic options have now been set

    8. Press the save icon on the top toolbar




Course: IT01s                                                                   Page: 27
Section: Create a New Item
8.3        Insert the correct Category Code

      The correct category code needs to be set. The category code defines the type of
      item being purchased and is used for reporting purposes and analysis and must
      therefore be set-up correctly

              A category code consists of four letters
              An example of a category code is LH.ZZ
              The first two letters are called the Family
              The second two letters are called the Class
              Each Family can have one or more Classes
              In the example LH.ZZ, LH is the Family code for Laboratory Chemicals –
               Organic & Inorganic and ZZ is the class code for Laboratory Chemicals –
               Organic & Inorganic Miscellaneous

      See Appendix C for a list of category codes


      1. From the Tools menu, select Categories




                TIP: Categories option not available from the Tools menu?
                     Remember to press save first!




Course: IT01s                                                                       Page: 28
Section: Create a New Item
    2. This opens the Category Assignment window
       Enter the Category Code if it is known or click on the List of Values button to
       select from a list




    3. This opens the PO Item Category Window
       Click the List of Values

    4. Change the family category code first
    5. Change the class category code




    6. Here you can see the Family code LP is the code for Laboratory Glassware
       The class code ZZ is the code for Laboratory Glassware - Miscellaneous




    7. Press OK

    8. Close the Category Assignment Window

    9. Click the save icon


Course: IT01s                                                                       Page: 29
Section: Create a New Item
8.4        Item Min-Max Planning

      What is Min-Max planning for an item?


              Item Min-Max planning is not a compulsory section but will help with the
               replenishment of stock by the Min-Max report
              Min-max quantities – Quantity of stock to be available within the store
              Order Quantity – Amount of stock to be re-ordered when replenishment is
               needed
              The values in both of these fields relate to the issue unit of measure
              Conversions previously described will convert issue unit to purchase order
               unit




      1. From the Master Item window, select the General tab




a
b


c
d




Fields a, b, c and d are explained on the next page




Course: IT01s                                                                        Page: 30
Section: Create a New Item
                Field                   Field Description


                Min-Max Quantity


       a        Minimum                 The minimum amount on the shelf


       b        Maximum                 The maximum amount allowed on the shelf


                Order Quantity


                                        The minimum amount you want to order
       c        Minimum
                                        Enter the order amount in singles


                                        The maximum amount you want to order
       d        Maximum
                                        Enter the order amount in singles




    2. Complete fields ‘a – d’ as necessary
       In most cases just fields ‘a’ and ‘c’ are used




                TIP: Consider your numbers carefully
                     You wouldn’t want to have a minimum order quantity of 1000, if
                     the maximum min-max quantity was only 100!




Course: IT01s                                                                     Page: 31
Section: Create a New Item
8.5        List Price & VAT code

      The List price and VAT code need to be completed

      The List Price and VAT code are used to populate the Purchase Order

      1. From the Master Item window, click on the Purchasing Tab




      2. Set the correct List Price
         The List Price is the net value of the item e.g. without VAT
         The List Price will pull through to the Purchase Order

      3. The default settings for the tax fields are set in the template

         Taxable:            Yes
         Tax Code:           Standard

         The ‘Taxable’ field does not need to be changed
         The ‘Tax Code’ field only needs to be changed where items are either Zero Rated
         or Exempt

      4. Please see your Accounting Officer or Finance Office if you need help
         determining whether an item is Zero Rated or Exempt

      5. Click the Save icon




Course: IT01s                                                                     Page: 32
Section: Create a New Item
8.6        Assign Item to your organisation

      The item needs to be assigned to your store


      1. From the Tools menu, select Organization Assignment




Course: IT01s                                                  Page: 33
Section: Create a New Item
    2. This will open the Master Item window

    3. The UOM: Item Master will already be ticked by default

    4. Tick your organisation, for example, UOM: Chemistry Store, as shown below
       Take care to select the correct Store – you cannot un-tick wrong selections




    5. Click the save icon




                WARNING: Take care to select the correct Store. You cannot un-tick
                         any wrong selections. You can still select your correct
                         organisation, but the item will also appear in the wrong
                         organisation




Assign Item to Sub-Inventory

    6. Click the ‘Org Attributes’ button – This will open the Organisation Item window




Course: IT01s                                                                     Page: 34
Section: Create a New Item
    7. From the Tools menu, select Item Sub-Inventories




Course: IT01s                                             Page: 35
Section: Create a New Item
    8. Complete the Sub-Inventory field e.g. Main




    9. Press the save icon

    10. Close the windows

    11. Your item is now created!




                To re-cap you have created an item with:

                        the fields on the Main tab completed
                        the correct Template assigned
                        the Category Code
                        Min-Max Planning values
                        List Price & VAT Code
                        and assigned the item to the correct organisation and sub-inventory!



    Now move onto Section 9 – Replenishment of Stock



Course: IT01s                                                                         Page: 36
Section: Create a New Item
9    Replenishment of Stock

Users need to be able to set-up Sourcing Rules and Approved Supplier Rules. This
means the Min-max report will know which supplier to re-order items from and what the
item’s purchasing unit of measure is

Sourcing Rules are set-up in the Purchasing Responsibility

There are four steps involved in the replenishment of stock

1. New sourcing rule is required for a new supplier where autoreplenish is required. It
   sets up the rule that says where to buy from (not organisation specific.) See section
   9.1

2. The new item must then be added to the UOM assignment set (not organisation
   specific.) See section 9.2

3. A conversion must be defined where this is not standard conversion (this will be
   maintained centrally.) See Section 9.3

4. An ASL (Approved Supplier List) must be defined to specify how to manage the
   purchasing of an item from a supplier. See section 9.4


Section 9.5 describes how to run the Min-Max report




Course: IT01s                                                                     Page: 37
Section: Replenishment of Stock
9.1     Setting up a Sourcing Rule


Responsibility:              Purchasing
Navigate to:                 Supply Base: Sourcing Rules


      1. Determine if you need to set-up a new sourcing rule by checking which sourcing
         rules already exist.
         From the Sourcing rule window, click on the torch icon. This will list all sourcing
         rules. Remember a sourcing rule may have been set-up by a different store.

      2. If the sourcing rule already exists – move onto section 9.2.
         Otherwise, carry on from step 3.

      3. Create a name for the sourcing rule – This example is Fisher

      4. Select All Orgs




      5. Press the tab key on your keyboard. This will complete the ‘From Date’ field with
         today’s date



Course: IT01s                                                                         Page: 38
Section: Replenishment of Stock
    6. Change the Type field to ‘Buy From’

    7. Complete ‘Supplier’ field

    8. Set ‘Allocation %’ to 100

    9. Set ‘Rank’ to 1

    10. Click the Save icon

    11. Close the window

    12. This has set-up the sourcing rule for this supplier




                TIP: You can use the ‘Copy From’ button to copy the attributes from an
                     existing Sourcing Rule. You only need to change the ‘Name’ and
                     ‘Supplier’ fields to create your new Sourcing Rule




Course: IT01s                                                                      Page: 39
Section: Replenishment of Stock
9.2     Assign Sourcing Rule

      The new item will always be added to the UOM Assignment Set

      Navigate To: Supply Base: Assign Sourcing Rules



      1. Press F11

      2. Type ‘UOM’ in the Assignment Set Field. Please note it is case sensitive

      3. Press Ctrl + F11

      4. This returns all items assigned to UOM

      5. Click the row above where you want to insert your new item

      6. Click the New icon to create a new record




Course: IT01s                                                                       Page: 40
Section: Replenishment of Stock
    7. This will create a new blank record




Course: IT01s                                Page: 41
Section: Replenishment of Stock
    8. Complete the following fields:

                  Organisation field:   i.e. ECZ

                  Item/Category:        i.e. C00003

                  Type:                 set to sourcing rule

                  Sourcing Rule:        i.e. Fisher


    9. Click the Save icon




    10. The item is now assigned to the UOM assignment set

    11. Close the Sourcing Rule/Bill of Distribution Assignments by pressing the ‘x’




Course: IT01s                                                                          Page: 42
Section: Replenishment of Stock
9.3       Unit of Measure Conversions

Unit of Measure conversions are managed centrally.

This is the conversion between the unit of measure than an item is purchased in and
unit of measure that an item is issued in.

Unit of Measure conversions are not necessary if an item is bought and sold in the same
unit e.g. ‘Each.’

Units of Measure fall into the following classes:

          Time              –    Hours, minutes and seconds
          Mass              –    weight, grams, ounces, lb
          Quantity          –    each, box, carton
          Volume            –    ml, litres
          Measure           –    mm, cm, metres

There are three types of conversions standard, intra-class and inter-class

          Standard –       This is a standard conversion where the actual conversion would
                            never change i.e. 24 hours in 1 day or 1000g in 1kg.

          Intra-Class – This is a conversion within the same class. i.e. one time unit to
                         another time unit

          Inter-Class – This is a conversion across classes. i.e. buy in one class, but issue
                         in another class. i.e. buy 1 big bottle (quantity) but issue in mls
                         (volume)


A conversion must be defined where this is not standard conversion (this will be
maintained centrally)

Check the conversion between the Purchasing Unit and Issuing Unit is set-up. If you are
using standard conversions move onto section 9.4.

Please log requests for new conversions via the ARS system:
http://helpdesk.man.ac.uk/cgi-bin/incidentreporting.cgi




Course: IT01s                                                                           Page: 43
Section: Replenishment of Stock
9.4     Approved Supplier List

The final step is defining an Approved Supplier List.

This allows us to specify the purchasing unit of measure and also confirm that we will
order this item using the ‘autocreate’ function.



      Navigate to: Supply Base: Approved Supplier List

      1. Enter the item

      2. Enter the Supplier

      3. Change the Status field to Approved




      4. Click Attributes




Course: IT01s                                                                     Page: 44
Section: Replenishment of Stock
    5. This opens the Supplier-Items Attributes window




    6. Complete ‘Purchasing UOM’ field e.g. Pack6

    7. Set the ‘Release Method’ field to ‘Release using Autocreate’

    8. Close the Supplier-Items Attributes window using the ‘x’

    9. Press the save icon

    10. Close the Approved Supplier List window using the ‘x’

    11. These steps allow items to be re-ordered in the correct purchasing unit from the
        correct supplier when you run your min-max planning and requisition import.




Course: IT01s                                                                     Page: 45
Section: Replenishment of Stock
9.5         Min-Max Planning

          Min-Max Planning allows you to run reports to check current stock values, check
           which items need re-ordering and re-order items
          Min-Max Planning reports will probably be run as a scheduled report overnight,
           so that results can be reviewed at the start of the day
          This section describes the steps for running a one-off report
          Sourcing rules need to be set-up before you run the min-max planning report
          For set-up details please see the previous section on Sourcing Rules

Responsibility:              Inventory
Navigate to:                 Planning: Min-Max Planning

This opens the Parameters window




Most fields have a default value. Fields to change are:

      1. Items from                Enter the specific Item or range or Items to be defined
      2. Items to                  Note: you need to know the Item Reference

      3. Restock                   Default setting is NO
                                   Change this to yes to prompt the requisition generation

      4.   Include PO supply       Default setting is YES. This will take into account any
                                   outstanding Purchase Orders

      5. Click OK




Course: IT01s                                                                                Page: 46
Section: Replenishment of Stock
     6. This will return to the Min-max Planning window




     7. Click Submit

     8. Click No

To view the report

    1. Click View for the menu options

    2. Click Requests

    3. Click Find

    4. Click View Output

    5. Click next and scroll across to the far right



                NOTE: The Min-Max can be re-run with the ‘Restock’ field set to yes.
                     This will generate the requisitions.
                      This can be a scheduled or manual process.




Course: IT01s                                                                      Page: 47
Section: Replenishment of Stock
What happens after min-max planning?


    1. If you have successfully run the min-max planning report, those items are ready
       to be turned into requisitions.

    2. The requisition import process runs automatically each day at 8am.

    3. Follow How To sheet IT01-03 – How do I handle Min-Max requisition approval in
       the Core Screens? This How To sheet requires PO Requisition Stores (UOM)
       responsibility.

    4. Approved requisitions can then be turned into Purchase Orders using Autocreate.
       This requires PO Purchasing Unit User (UOM) responsibility. This process may be
       carried by a different purchasing office or someone in your store. Please refer to
       your Purchasing training materials.

    5. When the goods are received from the supplier, they are receipted on Oracle
       using PO Goods Receipting User XXX Store (UOM) responsibility, where XXX is
       your school code. Please refer to your Goods Receipting training materials.

    6. When you receipt the goods, Oracle replenishes Inventory with the correct
       quantity in stock.

    7. The whole process starts again and you can do more counter issues!



Other points to consider:

If the Invoice price has changed from the Purchase Order price – you will need to
update the Item price in Inventory.

You will need to update the average cost of the items currently in stock – see section 11
Average Cost Update

You will also need to update the List Price for the item, to ensure the next purchase
order is raised at the correct price – see section 10.1 Amending Items at Master Level




Course: IT01s                                                                       Page: 48
Section: Replenishment of Stock
10 Maintaining Item Details

This section describes maintaining your item details at master level or organisation level.
Please see section 12 if you want to make an item inactive




                NOTE: Remember, once an item has been saved, you cannot change
                       the Item Reference or the Primary Unit of Measure!




10.1 Amending items at Master Level

Navigate to: Items: Master Items

     1. Click on the torch icon to open the Find Master Items window

     2. Complete fields as necessary e.g. enter Item reference in the ‘Item’ field

     3. Click find




Course: IT01s                                                                        Page: 49
Section: Maintaining Item Details
     4. If there is only one item this will return to the Master Item window, allowing you
        to maintain the Item details

     5. If multiple items match your criteria, this will open the Master Item window in
        Folder window. If you want to view all of the tabs for one item, click inside the
        row for that item and click the Attribute Groups button

     6. Edit the Description field if you want to change what appears on the PO




     7. You can edit the ‘Long Description’ on the Main tab

     8. Change the ‘List Price’ on the Purchasing tab. Remember this is the net value
        without any VAT

     9. Click ‘Tools’ and select Categories to change the category code for this item

     10. Once you have completed changes, click the save icon and press ‘x’ to close the
         window

     11. See Section 10.2 if you want to update the Mark-up, Extract to I-Proc, Tax Code
         or Min-Max quantities fields. You can update these at Master Item level to keep
         them ‘in sync’ with the organisation item but you must remember changing these
         fields at master item level will not update the fields at organisation item level.



Course: IT01s                                                                       Page: 50
Section: Maintaining Item Details
    10.2 Amending Items at Organization Level

    Organization Items allows you to search for all items in your organization and amend
    certain fields

    Navigate to: Items: Organization Items

         1. This opens the Organization Items window and the Find Organization Items
            Window




         2. Complete fields as necessary
            This example will search for all descriptions containing the word ‘Test’

         3. Enter the item reference in the ‘Item’ field if you have that

         4. Remember to use the % sign as a wildcard

         5. Click Find




Course: IT01s                                                                          Page: 51
Section: Maintaining Item Details
         6. All the results will then be displayed in the Organization Items window



a

b

c

d




a–        Folder provides a Top level view – The picture above is in ‘folder view’
b–        Attribute Groups - this displays all details for that item
c–        Assign to an organisation
d–        Revisions



                 TIP: The Find Organisation Items window is still open.
                      Simply click anywhere on the Find Organisation Items window to
                      start another search.



         7. Select the item you want to view or amend and click on the ‘Attribute Groups’
            window




Course: IT01s                                                                         Page: 52
Section: Maintaining Item Details
         8. From the Organisation Item window you can change the following fields

                       The ‘mark-up’ and ‘Extract to i-proc’ fields in the item flexfield

                       The ‘Min-Max’ values on the ‘General’ tab

                       The ‘Tax Code’ on the ‘Purchasing’ tab. Change this with caution – is
                        the item now in the wrong sub-inventory if you are about to change
                        the tax code? You may need to make the item inactive and set-up a
                        new item if the tax code has changed




         9. Click Save and close the window when finished

         10. You can change the above fields at ‘master level’ if you want to keep the
             master and organisation fields ‘in sync’.

         11. Remember changes to the List Price, Description or category code must be
             done at master item level.




Course: IT01s                                                                           Page: 53
Section: Maintaining Item Details
11 Three ways to update the price of an item

There are three ways to update the price of an item – the list price, the unit cost
(average cost) and the selling price.



    Update the List Price

The list price is the net value without any VAT for an item
The list price goes through to the Purchase Order
Change the list price for an item in the Item Master screen – see section 10.1



    Update the Unit Cost (Average Cost)

The unit cost is the gross cost with VAT but without any mark-up.
E.g. Net price is 10.00, gross with VAT is 11.75. Selling price with 3% Mark-up is 12.10.
The Unit Cost in this example is 11.75

This can be updated by Average Cost Update (see next page)

You need to perform an average cost update if the invoice price has changed from the
purchase order price.




    Update the Selling Price

The Selling price is the Unit Cost plus any mark-up
The selling price is updated by changing the mark-up on an item e.g. from 3% to 5%
Change the mark-up for an item at Organisation level – see section 10.2




Course: IT01s                                                                         Page: 54
Section: Three ways to update the price of an item
Average Cost Update

The Unit Cost (Average Cost) of an item can be updated. You need to perform an
average cost update if the invoice price has changed from the purchase order price.

Navigate to: Costs: Average Cost Update

     1. This will open the Update Average Cost window




     2. Click on Type and select Average Cost Update

     3. Enter an account in the Adjustment Account (click on … to select from a list.)
        The relevant Stock Trading Account should be where any adjustment costs
        should be credited/charged to e.g. ST00002, ST00003, ST00055 etc.

     4. Complete the ‘Item’ field with the stock item reference

     5. The ‘Cost Group’ should default in when you press the tab key on your keyboard

     6. Enter new value in the New Average Cost field
        This is the gross cost without any mark-up. E.g. New net price is 10.00, new
        gross with VAT is 11.75. New selling price with 3% Mark-up is 12.10. The figure
        you would enter in the Average Cost field is 11.75 – the gross value

     7. The updated cost will be applied to all the existing stock remaining in the system

     8. Press the Save icon and use the ‘x’ to close the window

     9. Average Cost Update takes a few minutes to update. You will not be able to
        perform counter issues at the new price straight away.


Course: IT01s                                                                       Page: 55
Section: Three ways to update the price of an item
                 TIP: You can enter the actual amount that you want the new unit price
                      to become (or you can specify a % change or value change if you
                      wanted to change the price by a specific % or amount by using
                      the other fields)




                 NOTE: The details at the foot of the form will show what the number
                      in stock, the current average cost, total on-hand value of
                       existing stock, and what the changes will mean in terms of net
                       change that will be charged to the adjustment account
                       specified at the top of the form.

                             The ‘Cost Elements’ button is not used




Course: IT01s                                                                      Page: 56
Section: Three ways to update the price of an item
12 Make an Item Inactive

This section covers the steps to make an item inactive

    1. Determine if you are making the Master Item inactive or Organization Item
       inactive

    2. Navigate to: Items: Master Items OR Navigate to: Items: Organization Items

    3. Query back the item details. Use the torch or query mode (F11 and Ctrl+F11)

    4. Change item status to inactive




Course: IT01s                                                                      Page: 57
Section: Make an Item Inactive
    5. Click on the General tab

    6. Set all Min-Max values to zero

    7. If you use Internal Trade change ‘Extract to i-Proc’ to ‘No’

    8. Click the save icon

    9. If you have made a master item inactive – make sure you make the Organisation
       item inactive also.




                TIP: If you have assigned an item to the wrong organisation, you can
                     make that item inactive for that organisation only by selecting
                     Navigate to: Items: Organization Items and following the above
                     steps



                NOTE: You can make an item active by changing its status back. This
                     does not update immediately, so you will not be able to
                      perform transactions against the item straight away




               NOTE: Stores using Internal Trade also need to reset the ‘Extract To i-
                      Proc’ field to No




Course: IT01s                                                                       Page: 58
Section:
13 Appendix A – Keyboard shortcuts

%                                          wildcard used in searching

%%                                         takes you straight to the results of your search

                   Description                                    Shortcut Key
Block Menu                                         Ctrl + B
Clear Block                                        F7
Clear Field                                        F5
Clear Form                                         F8
Clear Record                                       F6
Commit                                             Ctrl + S
Count Query                                        F12
Delete Record                                      Ctrl + Up
Display Error                                      Shift + Ctrl + E
Down                                               Down
Duplicate Field                                    Shift + F5
Duplicate Record                                   Shift + F6
Edit                                               Ctrl + E
Enter Query                                        F11
Execute Query                                      Ctrl + F11
Exit                                               F4
Function 0                                         Shift + Ctrl + F10
Function 1                                         Shift + Ctrl + F1
Function 2                                         Shift + Ctrl + F2
Function 3                                         Shift + Ctrl + F3
Function 4                                         Shift + Ctrl + F4
Function 5                                         Shift + Ctrl + F5
Function 6                                         Shift + Ctrl + F6
Function 7                                         Shift + Ctrl + F7
Function 8                                         Shift + Ctrl + F8
Function 9                                         Shift + Ctrl + F9
Help                                               Ctrl + H
Insert Record                                      Ctrl + Down
List of Values                                     Ctrl + L
List Tab Pages                                     F2
Next Block                                         Shift + Page Down
Next Field                                         Tab
Next Primary Key                                   Shift + F7
Next Record                                        Down
Next Set of Records                                Shift + F8
Previous Block                                     Shift + Page Up
Previous Field                                     Shift + Tab
Previous Record                                    Up
Print                                              Ctrl + P


Course: IT01s                                                                            Page: 59
Section: Appendix A – Keyboard shortcuts
Return                                     Return
Scroll Down                                Page Down
Scroll Up                                  Page Up
Show Keys                                  Ctrl + K
Up                                         Up
Update Record                              Ctrl + U




Menus:

File Menu
                    Command                                Description
                      New                  Creates a new record in the active form
                                           Opens the detail screen for the current
                        Open
                                           selection
                                           Saves any pending changes in the active
                         Save
                                           form
                                           Saves any pending changes in the active
                Save and Proceed
                                           form and advances to the next record
                                           Updates the process workflow in the
                      Next Step            navigator by advancing to the next step in
                                           the process
                                           Exports information in your current form to
                        Export
                                           a browser
                                           Creates an icon in the Documents tab of
                Place on Navigator         the Navigator which can be used to recall
                                           the active form and its current record
                                           Allows you to log on to Oracle Applications
           Log on as a Different User
                                           again as a different user
                                           Allows you to change the responsibility in
              Switch Responsibility
                                           effect for your current log on
                                           Prints your current window. An application
                         Print             may override this action to instead allow
                                           printing of one or more specific reports
                   Close Form              Closes all windows of the current form
             Exit Oracle Applications      Quits Oracle Applications




Course: IT01s                                                                  Page: 60
Section: Appendix A – Keyboard shortcuts
Edit Menu

                    Command                                 Description
                                           Undoes any typing done in a field before
                    Undo Typing            the field is exited and returns the field to
                                           the most recent value
                         Cut               Cut
                        Copy               Copy
                        Paste              Paste
                                           Copies all values from the prior record to
            Duplicate Record Above
                                           the current record
                                           Copies all the values of the current field
              Duplicate Field Above
                                           from the prior row
                                           Erases the current record from the current
                    Clear Record
                                           field
                     Clear Block           Erases all records from the current block
                                           Erases any pending changes from the
                     Clear Form
                                           current form
                                           Deletes the current record from the
                        Delete
                                           database
                                           Selects all records (for blocks with multi-
                      Select All
                                           select)
                                           Deselects all selected records except for
                    Deselect All           the current record (for blocks with multi-
                                           select)
                                           Displays the Editor window for the current
                      Edit Field
                                           field
                                           Displays the Change Password dialogue
        Preferences Change Password
                                           box
               Preferences Profiles        Displays the Profiles window


View Menu

                    Command                                 Description
Show Navigator                             Displays the Navigator window
Zoom                                       Invokes custom defined zooms
Find…                                      Displays the Find window to retrieve
                                           records
Find All                                   Retrieves all records
Query by Example Enter                     Invokes ‘Enter Query’ mode to enter
                                           search criteria for a query-by-example
Query by Example Run                       Executes the query-by-example
Query by Example Cancel                    Cancels the query-by-example by exiting
                                           from ‘Enter Query’ mode
Query by Example Show Last Criteria        Recovers the search criteria used in the
                                           previous query-by-example

Course: IT01s                                                                    Page: 61
Section: Appendix A – Keyboard shortcuts
Query by Example Count Matching Records         Counts the number of records that would
                                                be retrieved if you ran the current query-
                                                by-example
Record First                                    Moves the cursor to the first record
Record Last                                     Moves the cursor to the last record
Translations                                    Displays the translations window
Attachments                                     Displays the attachments window
Summary/Detail                                  Switch between the summary and detail
                                                views of a combination block



Tools Menu
May contain up to 15 product-specific entries


Window Menu

                    Command                                       Description
                                                Displays any open windows in a ‘cascaded’
                       Cascade
                                                or stair-stepped fashion
                                                Displays any open windows in a
                 Tile Horizontally              horizontally ‘tiled’ (non-overlapping)
                                                fashion
                                                Displays any open windows in a vertically
                   Tile Vertically
                                                ‘tiled’ (non-overlapping) fashion
                                                Displays a list of open windows titles in the
           1 (Title of Open Window)
                                                order in which they are stacked


Help Menu

                   Command                                      Description
                   Window Help                  Displays help for the current window
                                                Displays a window that lists all available
           Oracle Applications Library
                                                Oracle Applications Help text
                                                Displays the current mapping of specific
                  Keyboard Help
                                                functions and menu options
                                                There are multiple Diagnostics menus used
                     Diagnostics
                                                for the coding and debugging
                                                Displays information about who created
                  Record History
                                                and updated the current record
                                                Displays information about the current
           About Oracle Applications
                                                window and application




Course: IT01s                                                                         Page: 62
Section: Appendix A – Keyboard shortcuts
14 Appendix B - Toolbar

                                        New

                                        Find

                                  Show Navigator

                                        Save

                                     Next Step

                                Switch Responsibility

                                        Print

                                    Close Form

                                        Cut


                                       Copy

                                       Paste

                                    Clear Record

                                       Delete

                                     Edit Field

                                       Zoom

                                    Translations

                                    Attachments

                                   Folder Options

                                   Window Help




Course: IT01s                                           Page: 63
Section: Appendix B - Toolbar
15 Appendix C – List of Category Codes

   Code Starts with the letter…                         Group contains items of category…

                    A                                       Audio Visual and Multimedia

                    B                                         Library and Publications

                    C                                     Catering Supplies and Services

                    D                          Medical, Surgical and Nursing Supplies and Services

                     E                           Agricultural / Fisheries / Forestry / Horticultural /
                                                       Oceanographic Supplies and Services

                     F                                  Furniture, Furnishings and Textiles

                    H                          Cleaning Materials and Equipment, Janitorial Supplies

                    K                                    Computers Supplies and Services

                     L                                   Laboratory Supplies and Services

                    M                                  Workshop and Maintenance Supplies
                                                               (Lab and Estates)
                     P                                              Printing

                    Q                          Postal, Telecommunications and Mail Room Services

                    R                                   Professional and Bought-in Services

                     S                                     Stationery and Office Supplies

                    T                                          Travel and Transport
                                                        (incl Vehicle Hire and Subsistence)

                    U                                           Safety and Security

                    V                                Vehicles (Purchase, lease, Contract Hire)

                    W                                          Estates and Buildings

                     X                                              Miscellaneous




Course: IT01s                                                                                      Page: 64
Section: Appendix C – List of Category Codes
Breakdown of Laboratory Supplies and Services Category Codes


                 LC         Small Apparatus and Equipment (Non Medical)
                 LE         Lab Blood Products
                 LF         Lab Bonded Alcohol
                 LG         Lab Capital Equipment (Non Medical)
                 LH         Lab Chemicals
                 LJ         Lab Clothing
                 LK         Lab Consumables incl. disposables
                 LL         Lab Diagnostic Services
                 LM         Lab Equipment Maintenance and Repair
                 LN         Lab Gases Purchase and Rentals
                 LP         Lab Glassware
                 LQ         Pharmaceuticals - Non Vetinary
                 LR         Pharmaceuticals - Vetinary
                 LS         Lab Plastic ware
                 LU         Refrigerants
                 LV         Scintillation Fluids
                 LW         Isotopes and Radiochemicals
                 LX         Tissue Culture
                 LY         Lab Waste Disposal
                 LZ         Miscellaneous




Course: IT01s                                                             Page: 65
Section: Appendix C – List of Category Codes
16 Appendix D – Document Retention Policy

This document is intended to guide users as to what paper documents they need to
store, where they should be stored, and for how long.

Procure to Pay

Type of             Where kept?              How long?                  Any further comments
document
Requisitions        Not required to be       6 years plus current          Electronic requisitions are stored
                    kept, unless full        year, or if a grant or         on the Oracle system – no paper
                    details are NOT          contract in accordance         required.
                    entered onto the         with the terms and            If a requisition starts life in paper
                    system                   conditions of that grant       format, if all details, including
                                             or contract                    who requested the items, are
                                                                            entered onto a requisition or an
                                                                            order in Oracle, it does not need
                                                                            to be stored, as the electronic
                                                                            record will be complete.
                                                                           If the original document is paper
                                                                            format, and all the information is
                                                                            not held on the system, the paper
                                                                            copies must be retained
Orders              Not required – if        6 years plus current          Orders which start life as
                    electronic               year, or if a grant or         electronic requisitions will be
                    approval. If             contract in accordance         stored electronically on the
                    manually signed,         with the terms and             system with all supporting
                    copies need to be        conditions of that grant       information, so local storage is
                    retained.                or contract                    not required.
                                                                           If the order was approved
                                                                            manually by signature, the paper
                                                                            copy needs to be retained as
                                                                            evidence of approval.
Delivery notes      Local storage in         3 years
                    schools/
                    departments
Purchase            Local storage in         6 years plus current       This is a key document for audit/VAT
invoices            schools/                 year, or if a grant or     reasons that departments must be
                    departments              contract in accordance     able to produce as and when
                                             with the terms and         required.
                                             conditions of that grant
                                             or contract
Purchase            Local storage in         6 years plus current       This is a key document for audit/VAT
credit notes        schools/                 year, or if a grant or     reasons that departments must be
                    departments              contract in accordance     able to produce as and when
                                             with the terms and         required.
                                             conditions of that grant
                                             or contract




Course: IT01s                                                                                       Page: 66
Section: Appendix D – Document Retention Policy
17 Appendix E – Running a Discoverer Report


       Reports in Oracle are linked to responsibilities. Your responsibility
       determines which reports you can access.

       Navigate to: Discoverer Viewer


    1. To run a report click the Discoverer Viewer option. A list of available reports will
       be shown.




    2. Click on the report name to open the report.




Course: IT01s                                                                         Page: 67
Section: Appendix E – Running a Discoverer Report
    3. Select the worksheet you wish to run.




    4. Click on Run Query.


    5. Enter the Required Parameters.




    6. Click on Apply Parameters to run the query.




Course: IT01s                                        Page: 68
Section: Appendix E – Running a Discoverer Report
    7. The Report Data is Shown.




Course: IT01s                                       Page: 69
Section: Appendix E – Running a Discoverer Report
Printing and Exporting Discoverer Reports


Once a Discoverer report has been run, the output can be printed or exported.


    Printing Discoverer Reports

    1. At the top of the screen, select the Printer Friendly Version.




    2. Use the Print option in the browser to print.




        The report will now have been printed!




Course: IT01s                                                             Page: 70
Section: Appendix E – Running a Discoverer Report
    Exporting Discoverer Reports

    1. At the top of the screen, select Export data.




    2. Select the format of the data to be exported, from the drop down list.
    3. Click Export Date




3. Select Save at the file download.




Selecting Open will open the file in another browser, not the application (e.g. excel) that
is associated with the file type.




Course: IT01s                                                                       Page: 71
Section: Appendix E – Running a Discoverer Report
18 Appendix F – Applying the template

Main tab - without template




Main tab - with template




Course: IT01s                                 Page: 72
Section: Appendix F – Applying the template
Inventory tab - without template




Inventory tab – with template




Course: IT01s                                 Page: 73
Section: Appendix F – Applying the template
Bills of material tab – without template




Bills of material tab – with template




Course: IT01s                                 Page: 74
Section: Appendix F – Applying the template
Costing tab – without template




Costing tab – with template




Course: IT01s                                 Page: 75
Section: Appendix F – Applying the template
Purchasing tab – without template




Purchasing tab – with template




Course: IT01s                                 Page: 76
Section: Appendix F – Applying the template
Receiving tab – without template




Receiving tab – with template




Course: IT01s                                 Page: 77
Section: Appendix F – Applying the template
Physical attributes tab – without template




Physical attributes tab – with template




Course: IT01s                                 Page: 78
Section: Appendix F – Applying the template
General planning tab – without template




General planning tab – with template




Course: IT01s                                 Page: 79
Section: Appendix F – Applying the template
MPS/MRP Planning tab – without template




MPS/MRP Planning tab – with template




Course: IT01s                                 Page: 80
Section: Appendix F – Applying the template
Lead times tab – without template




Lead times tab – with template




Course: IT01s                                 Page: 81
Section: Appendix F – Applying the template
Work in progress tab – without template




Work in progress tab – with template




Course: IT01s                                 Page: 82
Section: Appendix F – Applying the template
Order management tab – without template




Order management tab – with template




Course: IT01s                                 Page: 83
Section: Appendix F – Applying the template
Invoicing tab – without template




Invoicing tab – with template




Course: IT01s                                 Page: 84
Section: Appendix F – Applying the template
Service tab – without template




Service tab – with template




Course: IT01s                                 Page: 85
Section: Appendix F – Applying the template
Web option tab – without template




Web option tab – with template




Course: IT01s                                 Page: 86
Section: Appendix F – Applying the template

				
DOCUMENT INFO