Banner Finance Stores Inventory Training Workbook Release 8.4 – December 2009 Updated 4/31/2012
_______________________________________________________________________________________________

Ellucian

4 Country View Road
Malvern, Pennsylvania 19355
United States of America
(800) 522 - 4827

Customer Support Center website

http://connect.ellucian.com

Distribution Services e-mail address

distserv@ ellucian.com

Other services

In preparing and providing this publication, Ellucian is not rendering legal, accounting, or other similar professional services. Ellucian makes no claims that an institution's use of this publication or the software for which it is provided will insure compliance with applicable federal or state laws, rules, or regulations. Each organization should seek legal, accounting and other similar professional services from competent providers of the organization's own choosing.

Trademark

Banner®, Colleague®, PowerCAMPUS®, Luminis® and Datatel® are trademarks of Ellucian or its affiliates and are registered in the U.S. and other countries. Ellucian, Advance, Recruiter, and Open Digital Campus are trademarks of Ellucian or its affiliates. Other names may be trademarks of their respective owners.

Revision History Log

Publication Date	Summary
4/30/2008	New version that supports 8.0 software.
5//2008 3/26/2009	Minor formatting changes. Minor formatting changes
6/30/2009	Added a lesson on displaying new person fields for internationalization.
2/01/2010	Updated for Banner 8.4
4/31/2012	Updated to the Ellucian template.

Notice of rights

© 2012 Ellucian. All rights reserved.

Contains confidential and proprietary information of Ellucian and its subsidiaries. Use of these materials is limited to Ellucian licensees, and is subject to the terms and conditions of one or more written license agreements between Ellucian and the licensee in question.

Table of Contents

Introduction	4

Process Introduction	6

Set Up	7

Forms Used in Setting Up Stores Inventory	8

Displaying New Person Fields for Internationalization	10

Establishing an Inventory Fund	13

Establishing Stores Inventory Account Codes	15

Establishing External Rate Codes	19

Establishing ABC Tolerance Percentages	23

Establishing Equivalency Codes	26

Establishing Stores Inventory System Control Defaults	28

Establishing Ship-to Codes for Primary Locations	30

Establishing Stock Commodity Codes	35

Establishing Stores Inventory Records	38

Stocking the Warehouse	42

Stocking the Warehouse Using the Quick Method	44

Self Check	48

Answer Key for Self Check	50

Day-to-Day Operations	52

Process Introduction	53

Purchasing Stock Items for the Warehouse	54

Transferring Stock Items	66

Requisitioning Stock Items	69

Canceling Stock Item Requisitions	73

Issuing/Returning Stock Items	75

Using the Inventory Listing Report	85

Making Adjustments to Inventory	88

Making Adjustments to Cost	104

Stores Inventory Inquiry Forms	112

Stores Inventory Processes and Reports	114

Self Check	117

Answer Key for Self Check	119

Appendix	121

Forms Job Aid	122

Terminology	124

Introduction

Course goal

The goal of this workbook is to provide an overview of the Banner Finance Stores Inventory module.

Course objectives

In this course you will learn how to

identify the forms used to set up stores inventory

identify the various methods that can be used to stock inventory warehouses

determine which method may best suit the need of your institution

identify the various forms that can be used to stock the warehouse

stock the warehouse after conversion using the Quick Method

stock the warehouse

make adjustments to inventory

requisition and issue stock items

identify the forms used to query stores inventory items within the Stores Inventory module

identify the reports and processes used to update and/or track and report on stores inventory items within the Stores Inventory module.

Intended audience

Finance Office Administrators and Staff who track and maintain the inventory within an enterprise.

Prerequisites

To complete this course, you should have

completed the Education Practices computer-based training (CBT) tutorial Banner 8 Fundamentals, or have equivalent experience navigating in the Banner system

completed the Banner Finance: Chart of Accounts training workbook

completed the Banner Finance: Purchasing training workbook

administrative rights to create the rules and set the validation codes in Banner.

Process Introduction

About the Process

The Finance Office can

establish inventory for initial stock

create requisitions for stock

issue items

order and replace inventory.

Flow diagram

This diagram highlights the processes used in stores inventory.

What happens

The stages of the process are described in this table.

Stage	Description
1	Stockroom clerk establishes stores inventory for initial stock.
2	Requestor creates a requisition for stock.
3	Inventory clerk issues items on request to end-user.
4	Stockroom clerk orders and replaces inventory.

Set Up

Introduction

The purpose of this section is to outline the set-up process and detail the procedures to set-up your Banner system to handle Stores Inventory at your institution.

Objectives

In this section you will learn how to

identify the forms used to set up stores inventory

identify the various methods that can be used to stock inventory warehouses

determine which method may best suit the need of your institution

identify the various forms that can be used to stock the warehouse

stock the warehouse after conversion using the Quick Method.

Forms Used in Setting Up Stores Inventory

Forms Needed

The forms and table validation views used to setup the Stores Inventory module are listed on the following page. You will also need to decide if you want to display the new person fields for internationalization.

Note: These forms should be set up in the order listed.

Name	Description	Purpose
FTMFUND	Fund Code Maintenance Form	Define inventory funds. A sample of a fund to build would be Inventory fund.
FTMACCT	Account Code Maintenance Form	Define inventory accounts, valuation clearing accounts, interfund transfer accounts. Samples of accounts to build for this training are Stores account (Asset), Stores transfer in (Asset), Stores transfer out (Asset), Valuation acct (Asset), and Inventory Income acct (Revenue).
FTMEXRT	External Rate Maintenance Form	Verify and maintain a list of external Rate codes to support both the Cost Accounting module and the Stores Inventory module.
FTMEQUL	Equivalency Maintenance Form	Define an equivalent unit of measure and the corresponding number of equivalent units to provide a cross-reference between the requisition unit of measure, the purchase order unit of measure, and the receiving unit of measure.
FTMSDAT	System Data Maintenance Form	Define ABC classifications with an allowable tolerance for reconciliation purposes.
FSASYSC	Inventory System Control Maintenance Form	Define inventory control parameters at the system level.
FTMSHIP	Ship to Address Maintenance Form	Establish department routings for deliveries. If establishing a Profit Center, click the Inventory Information option in the Options menu. Enter the location type, inventory fund, inventory account, organization, and program codes, and select the Profit Center check box.

Name	Description	Purpose
FTMCOMM	Commodity Maintenance Form	Create and maintain commodity codes and default expense account relationships.
FTRINVM	Stores Inventory Maintenance Form	Define and display basic information about a commodity defined as a stock item. This form can be completed for each commodity through the FTMCOMM by clicking the View Stores Inventory option in the Options menu.

Displaying New Person Fields for Internationalization

Introduction

A major initiative of SunGard Higher Education is to make Banner more adaptable for use in different countries and with different languages. This ongoing effort is called internationalization (often abbreviated I18N).

As part of this initiative, Banner Finance 8.0 delivered several new fields in the database. These fields, however, were not visible on the user interface. With Banner Finance 8.3, these new fields can be displayed on forms and reports. This enhancement provides worldwide clients with a more robust, accurate, and efficient method of storing personal data.

New person fields

The following person fields are now available on several Banner Finance Forms and reports:

Field	Length	Description
Last Name Prefix	60 characters	Prefix that precedes a last name (for example, “Von” in the last name “Von Hintz”)
House Number	10 characters	Unique number assigned to each building on a street or in an area and used as part of the postal address in some countries (no validation)
Street Line 4	75 characters	Additional street address (no validation)
Telephone Country Code	4 characters	Code that designates the region and country of the telephone number (no validation)

Masked fields

Some users do not need these new fields on Banner forms. For this reason, Banner Finance 8.3 is being delivered with masking rules turned on for these new fields. This means the fields are not displayed on forms when you first upgrade to Banner Finance 8.3. If you want to display the new fields, you can do one of the following:

Run the gssmask.sql script, delivered with Banner General 8.2, to unmask the new fields. Refer to the Banner General 8.2 Release Guide for more details.

Use the Data Display Mask Rules Form (GORDMSK) to unmask the fields. You can unmask specific fields on specific forms. Refer to the Banner General Data Security Handbook for more details.

Masking rules apply only to name fields when they are displayed independently (that is, not concatenated). If fields are concatenated, the masking rules do not apply. It is assumed that the fields where data would normally be entered would be masked, preventing data entry. As a result, no values would be available for display on forms when the fields are concatenated.

Changed forms

Several forms can display the new person fields. Some forms display all new person fields; other forms display some of the new person fields. In general, the new person fields are displayed on forms as follows:

Last Name Prefix is displayed before the Last Name field.

House Number is displayed before the Street Line 1 field.

Street Line 4 is displayed after the Street Line 3 field. (If a form does not include Street Line 3, then Street Line 4 is not included on the form.)

Telephone Country Code is displayed before the Telephone Area Code field.

The following forms support the new person fields:

Buyer Code Maintenance Form (FTMBUYR)

Entity Name/ID Search (FTIIDEN)

Finance Person Search (FOIIDEN)

Location Code Maintenance (FTMLOCN)

Ship To Address Maintenance (FTMSHIP)

Ship To Validation Form (FTVSHIP)

Stores Requisition Form (FSAREQN)

Establishing an Inventory Fund

Purpose

Before setting up Stores Inventory system controls you must designate or establish the fund code where inventory will be recorded into, within, and out of Stores Inventory. An existing Fund may be used, or you may establish a Fund specifically for this purpose. The Fund Code Maintenance Form (FTMFUND) is used to establish the fund code.

Banner form

Steps

Follow these steps to complete the process.

Note: Only one participant (or instructor) needs to create this record.

Access the Fund Code Maintenance Form (FTMFUND).

Note: Remember, FTMFUND is a Maintenance Form, which means that, if you want to review existing information, you must first enter a query.

Perform an Enter Query function (F7).

Enter 3110 in the Fund field.

Perform an Execute Query function (F8).

Note: If no information is retrieved, then proceed to create this fund code. If information is retrieved, then you may choose to use this code in the following exercise, or to re-title this existing fund code, or to create a new fund code.

Perform a Cancel Query function to create a Central Stores fund code.

Enter B (or the Chart of Accounts for your institution) in the Chart of Accounts field.

Enter 3110 (or a unique fund code for your own chart) in the Fund field.

Record the fund code you created, if different: _____________.

Enter Central Stores in the Title field.

Enter 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts) in the Effective Date field.

Leave the Data Entry field checked to signify that this fund will be used for data entry.

Enter 31 (or the fund type code for your institution’s auxiliary enterprise funds) in the Fund Type field.

Review the record.

Click the Save icon.

Click the Exit icon.

Establishing Stores Inventory Account Codes

Required accounts

Before setting up Stores Inventory system controls on you must designate or establish various inventory account records using the Account Code Maintenance Form (FTMACCT).

Inventory account. This is the account where inventory will be recorded in the General Ledger. It must have an internal account type of ‘10’ for assets (or the equivalent account type for your institution.).

Valuation Clearing account. This clearing account is used to record the difference between the estimated cost entered on the PO and the actual Invoice cost. The Unit Cost of a stock item displayed on the Stores Inventory Maintenance form (FTRINVM) is updated by the amount of the change in cost between the PO and Invoice as a by-product of this clearing account process. The internal account type must be a ‘10’ or a ‘20’ (or the equivalent for your institution.).

Optional accounts

In addition to the required accounts, you have the option to define or establish the following accounts:

Inventory Transfers In and Transfers Out accounts. These accounts are invoked on the Inventory Transfers form (FSATRAN), whenever inventory items are transferred from one location to another. They must have an internal account type of ‘10’ for assets (or the equivalent for your institution.)

Stockroom Income account. Optional. This account is used to record the administrative overhead charges, “profit” margins, or discounts on Stores Issues associated with the External Rate codes on the External Rate Maintenance Form (FTMEXRT).
This account may be a revenue or expense account. It must have a valid operating ledger account type (internal account type codes must equal ‘50’, ‘60’, ‘70’, or ‘80’).

Banner form

Steps

Follow these steps to establish Stores Inventory Account codes using the Account Code Maintenance Form (FTMACCT).

Note: Only one participant (or instructor) needs to create these records.

Access the Account Code Maintenance Form (FTMACCT).

Note: Remember, FTMACCT is a Maintenance Form, which means that, if you want to review existing information, you must first enter a query.

Perform an Enter Query function (F7).

Enter 1400 in the Account field.

Perform an Execute Query function (F8).

Note: If no information is retrieved, then proceed to create this account code. If information is retrieved, then you may choose to use this code in the following exercise, or to re-title this existing account code, or to create a new account code.

Perform a Cancel Query function to create an Inventory account code.

Enter B (or the Chart of Accounts for your institution) in the Chart of Accounts field.

Enter 1400 (or a unique account code for your own chart) in the Account field.

Record the account code you created, if different: _____________.

Enter Inventory in the Account Title field.

Enter 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts) in the Effective Date field.

Change the value in the Data Entry field to NO to signify that this account will be used for reporting purposes only.

Leave the Predecessor Account field blank.

Enter 14 in the Account Type field (or the account type code for your institution that designates inventories-type accounts).

Review the record, then click the Save icon.

Click the Rollback icon.

Perform an Enter Query function (F7).

Enter 1430 in the Account field.

Perform an Execute Query function (F8).

Note: If no information is retrieved, then proceed to create this account code. If information is retrieved, then you may choose to use this code in the following exercise, or to re-title this existing account code, or to create a new account code.

Perform a Cancel Query function to create a Central Stores account code.

Enter B (or the Chart of Accounts for your institution) in the Chart of Accounts field.

Enter 1430 (or a unique account code for the Central Stores account for your own chart) in the Account field.

Record the account code you created, if different: _____________.

Enter Central Stores in the Account Title field.

Enter 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts) in the Effective Date field.

Leave the Data Entry field set to YES to signify that this account will be used for data entry purposes.

Enter 1400 (or the account code for your institution that designates the Inventory account) in the Predecessor Account field.

Enter 14 in the Account Type field (or the account type code for your institution that designates Inventories-type accounts).

Review the record, then click the Save icon.

Click the Rollback icon.

Repeat steps 14-26 to create the other four Stores Inventory accounts listed in Table 1. Review and save each record.

Table 1

Use the information listed here to complete the steps above. Enter B in the Chart of Accounts field and 01-JUL-2000 in the Start Date field for all.

Account	Account	Account Title	Data Entry	Account Type	Predecessor Account
Inventory	1400	Inventory	NO	14
Central Stores	1430	Central Stores	YES	14	1400
Transfers In	1440	Inventory Transfers In	YES	14	1400
Transfers Out	1450	Inventory Transfers Out	YES	14	1400
Valuation Clearing	1460	Central Stores	YES	14	1400
Stockroom Income	5910	Stockroom Revenue	YES	59

Establishing External Rate Codes

Introduction

Use the External Rates Maintenance Form (FTMEXRT) to define external rate codes.

Many institutions will charge different rates to internal and external customers. For example, you might add a $1/unit surcharge to a commodity for reselling purposes, or you may give a 5 percent discount to in-house purchases. External rate codes are used to specify administrative overhead charges, profit margins, or discounts on Stores Issue documents. Once you enter a commodity code on the Stores Issue/Return Form (FSAISSU), the system calculates unit cost for that commodity. External rate codes may be entered on FSAISSU to override this unit cost if the warehouse is defined as a profit center.

External rate codes may be input on the Stores Inventory Maintenance Form (FTRINVM) to act as a default into FSAISSU for a specific stock item. The warehouse (primary location) that the item is issued out of must be defined as a Profit Center on of the Ship To Address Form (FTMSHIP) in order to use this functionality.

External Rate is a three character user-defined code.

Short Description is a ten character user-defined description.

Full Description is a 35 character user-defined description

Adj. % and Adj. $ is the surcharge or discount expressed in either percent (which will be applied to internal rate) or dollars (which will be added to the internal rate). One or the other must be entered.

Banner form

Steps

Follow these steps to establish External Rate codes using the External Rate Maintenance Form (FTMEXRT). External Rate codes are used to specify surcharges or discounts on inventory items issued from Profit Center warehouse facilities.

Note: Only one participant (or instructor) needs to create these records or it will be necessary to ensure that each code is unique.

Access the External Rate Maintenance Form (FTMEXRT).

Note: Although FTMACCT is a Maintenance Form, it does not display in query mode when first accessed. You may use the vertical scrollbar or down-arrow key to review existing information.

Perform an Enter Query function (F7).

Enter $5 in the External Rate field.

Perform an Execute Query function (F8).

Note: If no information is retrieved, then proceed to create this external rate code. If information is retrieved, then you may choose to use this external code in the following exercise, or to re-title this existing code, or to create a new external rate code.

Perform a Cancel Query function to create an External Rate Code.

Enter $5 in the External Rate field.

Enter %5fee in the Short Description field.

Enter $5.00 Surcharge in the Long Description field.

Leave the Adjusted Percent field blank.

Enter 5.00 in the Adjusted Dollars field.

Enter 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts) in the Effective Date field.

Note: If you are copying forward an existing code, the date entered in this field must be the current or a future date.

Review the record.

Click the Save icon.

Perform an Enter Query function (F7).

Enter -10 in the External Rate field.

Perform an Execute Query function (F8).

Note: If no information is retrieved, then proceed to create this external rate code. If information is retrieved, then you may choose to use this external code in the following exercise, or to re-title this existing code, or to create a new external rate code.

Perform a Cancel Query function to create an External Rate Code.

Enter -10 in the External Rate field.

Enter Discount10 in the Short Description field.

Enter 10% Discount in the Long Description field.

Enter -10 the Adjusted Percent field.

Leave the Adjusted Dollars field blank.

Review the record.

Click the Save icon.

Click the Exit icon.

Establishing ABC Tolerance Percentages

Introduction

ABC classification is an industry-defined classification associated with inventory that is used to classify items within inventory valuation.

For example, typically an ‘A’ classification not only represents 20 percent of the inventory items within a site, but also represents 80 percent of the entire value of the inventory within this same site.

Note: These representations are strictly user-defined.

When you classify items based on their relative value, you can support various kinds of inventory analysis.

If you use this classification system when setting up your stock inventory items on the Inventory Maintenance Form (FTRINVM), the system reflects it in the Physical Inventory report sort features.

Reconciling physical inventory

ABC classification is also used in Banner for reconciling physical inventory.

A percentage of tolerance for physical inventory processing is assigned to each ABC classification code on the System Data Maintenance Form (FTMSDAT). These control records are delivered as follows:

Class ‘A’ allows up to 10% variance with no adjustment

Class ‘B’ allows up to 5% variance with no adjustment

Class ‘C’ allows no variance between the book count and the physical count without making the adjustment from book to actual.

Note: These delivered tolerance percentages may be changed to meet the specifications of your institution.

If you classify your stock inventory items with an ABC Class value of ‘A’, B’ or ‘C’ when setting up inventory records on FTRINVM, the system uses these system-defined tolerance percentages to automatically mark as reconciled any items that are counted and found to be within this tolerance percent of the system count. This happens when the Physical Inventory Reconciliation batch process (FSRPHYR) is run during physical inventory.

Assigning ABC classification tolerance percentages is optional; however, the Physical Inventory Reconciliation batch process (FSRPHYR) will not be able to automatically reconcile an item unless the stock inventory item has been classified with an ABC Class value on the FTRINVM record.

Banner form

Steps

Follow these steps to review the three ABC Classification Tolerance Percentage control records that are delivered with Banner using the System Data Maintenance Form (FTMSDAT).

Note: You can change the tolerance percentage assigned to a given ABC Class code to meet the specifications of your institution by copying forward the control record, changing the value entered in the Data field, and entering a current or future effective date.

Access the System Data Maintenance Form (FTMSDAT).

Note: Remember, FTMSDAT is a Maintenance Form, which means that, if you want to review existing information, you must first enter a query.

Perform an Enter Query function (F7).

Enter FTVINVM in the Entity or Usage Code field.

Perform an Execute Query function (F8).

The form displays the ABC Class Tolerance Percentage control records.

The Optional Code Number 1 field displays the ABC class code.

The Data field displays the tolerance percentage that is assigned to the ABC Class code.

Use the vertical scroll bar or the down-arrow key to scroll through and review the additional ABC control records.

When you have reviewed all of the ABC Class control records, click the Exit icon.

Establishing Equivalency Codes

Introduction

The Equivalency codes are used to cross reference what is ordered on a PO to stock an item and what a customer (Department) will request from stock on the Stores Requisition Form. For example: the stockroom might order 100 YD of tubing for use in the Science Department. But when that department request tubing for a class they might request by feet. In Banner you would need an equivalency code to note that the Unit of measure codes have this relation. For the code INC (inches) the equivalency Unit of Measure would be FT (feet) with an equivalency number of units of 12 (12 inches in a foot). You could also put in a code of FT (feet) with and equivalency Unit of Measure YD (yards) with an equivalency number of units of 3 (3 feet in a yard). For every code, you may define an equivalent unit of measure and the corresponding number of equivalent units. Access this form from the Procurement Maintenance Menu (*FINPOTAB).

Banner form

Steps

Follow these steps to establish Equivalency codes in the Equivalency Maintenance Form (FTMEQUL).

Note: Only one participant (or instructor) needs to create this record.

Access the Equivalency Maintenance Form (FTMEQUL).

Enter the Unit of Measure code you want to equate. Use the search button to view the list.

Enter the Equivalent Unit of Measure to correspond with this equivalency. Use the search button to view the list.

Enter the number of units that code in column 1 that equate to the Unit of Measure in column 2. (example: code is INC=inches in column (1), 12 in the equal units in column (3), and FT=feet is the Unit of Measure in column (3) that has 12 inches in it.

Review the record, then click the Save icon.

Click the Exit icon.

Establishing Stores Inventory System Control Defaults

Introduction

The Inventory System Control Maintenance Form (FSASYSC) is used to define system-wide inventory control parameters that are not specific to any particular Chart of Accounts. The system uses the fund and account parameters that you define on this form in relevant accounting transactions.

When the system uses the values in the Inventory Fund and Inventory Acct fields for posting Stores Inventory transactions, it first looks for these values on the commodity record. If these values have not been defined at either the commodity or the location (Ship To) level, the system uses the codes that you enter here on FSASYSC.

Banner form

Steps

Follow these steps to establish defaults at the system level for Stores Inventory transactions using the Inventory System Control Maintenance Form (FSASYSC).

Note: Only one participant (or instructor) needs to create this record.

Access the Inventory System Control Maintenance Form (FSASYSC).

Perform an Insert Record function (F6).

Perform a Duplicate Record function (F4).

Enter the current date in the Effective Date field.

Note: You may enter a future date in this field if you do not want your changes to be effective immediately.

Enter 3110 or the code that identifies the fund for the system use to record inventory into, within, and out of Stores Inventory in the Inventory Fund field.

Enter 1440 or the account code for system use when inventory items are transferred into one location from another in the Inventory Transfers In Account field.

Enter 1450 or the account code for system use when inventory items are transferred out of one location to another in the Inventory Transfers Out Account field.

Note: The same account code may be used for both Transfers In and Transfers Out.

Enter 1400 or the code that represents where inventory will be recorded in the General Ledger in the Inventory Account field.

Enter 1460 or the account code that identifies the account for the system to credit against when goods are received against a purchase order in the Valuation Clearing Account field.

Enter 5910 or the account code for the system to use for credit to record the administrative overhead charges, profit margins, or discounts on Stores Issues associated with the External Rate codes on FTMEXRT in the Stockroom Income Account field.

Leave the Physical Inventory All indicator box unchecked.

Note: The Physical Inventory All check box indicates whether the Physical Inventory process is occurring for all defined stock items. Be aware that when you select this check box, it turns the Inventory Status indicator to I in the Stock Location tables!

Review the record, then click the Save icon.

Click the Exit icon.

Establishing Ship-to Codes for Primary Locations

Introduction

The Ship To Address Maintenance form (FTMSHIP) is used to create Primary Location (Ship To) codes and to establish departmental routing criteria for Stores Issues delivery locations.

Ship To location codes are used on the Stores Inventory Maintenance form (FTRINVM) to identify the stock item’s Primary Location (warehouse or stockroom). Primary location can also be used in conjunction with sub location to identify the location of the stock item within the warehouse facility.

The Location Type field on the Inventory Information window is used to differentiate Warehouse and Dock facilities. The inventory-related fields on this window can be used to default accounting information into Stores Issues documents at the location level. These fields are optional; however, they should be completed if you expect to track accounting information by inventory warehouse.

The Warehouse Organization and Program codes are used in combination with the Stockroom Income Account on FSASYSC and the External Rate codes on FTMEXRT to record surcharges and discounts on Stores Issues. The Profit Center Indicator must be selected and the Warehouse Organization and the Warehouse Program fields must be populated to use this feature for any Primary Location.

Banner form

Steps

Follow these steps to establish Ship-to codes for a dock facility, a warehouse facility, and a departmental delivery address, using the Ship To Address Maintenance Form (FTMSHIP).

Note: If more than one participant creates these records it will be necessary to ensure that each code is unique.

Access the Ship To Address Maintenance form (FTMSHIP).

Enter a unique Ship-to code in the Ship To Code field to represent the warehouse facility/loading dock where stock items are received.

Record the Ship-to code you created: _____________.

Click the Next Block icon.

Note: If no information is retrieved, then proceed to create this Ship-to location code. If information is retrieved, click the Rollback icon and enter a different code.

Enter the street address of the dock location in the Address Line 1 field.

Note: You may use the additional lines to include detailed information required for delivery, for example, dock, warehouse, etc.

Enter the name of the city of the dock location in the City field.

Enter the State/Province Code representing the state or province of the dock location in the State/Province field.

Enter the ZIP or postal code of the delivery location in the ZIP/Postal Code field.

Enter 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts) in the Effective Date field.

Select Inventory Information from the Options menu.

Enter D in the Location Type field to indicate that this location is a Dock facility.

Note: You must assigned a facility a ‘D’ (Dock) location type to utilize the Dock to Stock Exceptions Report (FSRSTEX).

Review the record, then click the Save icon.

Click the Rollback icon.

Enter a unique Ship-to code to represent a warehouse facility where stock items are maintained in the Ship To Code field.

Click the Next Block icon.

Note: If no information is retrieved, then proceed to create this Ship-to location code. If information is retrieved, click the Rollback icon and enter a different code.

Using the steps outlined on the previous page, enter address and effective date information for this warehouse location.

Select Inventory Information from the Options menu.

Enter W in the Location Type field to indicate that this location is a Warehouse facility.

Enter 3110 or the code for the fund from which the purchase of specific inventory items maintained within this location is paid in the Inventory Fund field. (Overrides FSASYSC.)

Enter 1410 or the code for the account from which funds for the purchase of inventory items at this location will be drawn in the Inventory Account field.

Enter 126011 or the code for the organization responsible for the purchase of the specific inventory items maintained within this location in the Warehouse Organization field.

Enter 90 or the code for the program to which the inventory item will be applied in the Warehouse Program field.

Select the Profit Center indicator check box.

Review the record, then click the Save icon.

Click the Rollback icon.

Enter a unique Ship-to code to represent a departmental delivery location for Issued goods in the Ship To Code field.

Click the Next Block icon.

Note: If no information is retrieved, then proceed to create this Ship-to location code. If information is retrieved, click the Rollback icon and enter a different code.

Enter the street address of the delivery location in the Address Line 1 field.

Note: You may use the additional lines to include detailed information required for delivery, for example, department, building name or number, floor, etc.

Enter the name of the city of the delivery location in the City field.

Enter the State/Province Code representing the state or province of the delivery location in the State/Province field.

Enter the ZIP or postal code of the delivery location in the ZIP/PC field.

Enter the name or title of the primary contact for stores deliveries at this location in the Contact field.

Enter the phone number of the primary contact at this location in the Phone Number and Extension fields.

Enter 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts) in the Effective Date field.

Review the record, then click the Save icon.

Click the Exit icon.

Establishing Stock Commodity Codes

Introduction

A two-record structure is used to create stock items in Banner. You first establish inventory items as valid commodities on Commodity Maintenance Form (FTMCOMM) and mark them as stock commodities using the Stock Item indicator, and then establish stores inventory values for the stock items on the Stores Inventory Maintenance form (FTRINVM).

Note: You cannot use Stores Inventory if you do not intend to use commodity codes.

Use the Commodity Maintenance Form (FTMCOMM) to establish a representative selection of commodities and identify them as stock items for use in performing the steps in this workbook.

Note: Before establishing stock items at your institution, you will need to determine a coding scheme. In Banner, commodity codes can be either user-defined, or the NIGP (National Institute of Governmental Purchasing) code may be used.

Banner form

Steps

Follow these steps to establish a stock Commodity code using the Commodity Maintenance Form (FTMCOMM).

Note: If more than one participant creates these records it will be necessary to ensure that each code is unique.

Access the Commodity Maintenance Form (FTMCOMM).

Enter 3110000000 or a unique code of your own devising in the Commodity Code field.

Note: You may also enter Next in this field to have the system assign a new commodity number after the new code has been added.

Click the Next Block icon.

Enter a description of the commodity in the Commodity Description Field, e.g. Tablets, Ruled, 8.5x11.

Enter EA in the Unit of Measure Code field.

Enter 3100000000 or the predecessor code for this commodity item in the Predecessor Commodity field.

Note: This field is optional. Also be aware that stock and non-stock items may be mixed within a hierarchy.

Leave the Tax Group field blank.

Note: This field is optional. If you enter a tax group, use the Override Taxes check box to indicate whether to override this tax group when you process a procurement document.

Check the Stock Item to identify the commodity as a stock item for processing in the Stores Inventory module.

Enter 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts) in the Start Date field.

Enter B in the Chart of Accounts field.

Enter 7210 in the Accounts field, or double-click on the field and select a valid account number from the list. (This must be an expenditure account.)

Note: The Accounts field is used to define default expense accounting, not for the store, but for departments purchasing from the store.

Review the record, then click the Save icon.

Click the Exit icon.

Establishing Stores Inventory Records

Introduction

The Stores Inventory Maintenance form (FTRINVM) is used to definition and display basic data about a commodity defined as a stock item. The Commodity Code must exist, be effective, and be defined as a stock item on the Commodity Maintenance Form (FTMCOMM), and the Issued Unit of Measure must exist and be in effect to create this record.

This form maintains and displays the default primary location (warehouse) where the stock item is most likely to be stored, as well as the default Chart of Accounts, Inventory Fund, and Inventory Account. Entering the primary location (required) and sub location (optional) physically creates a stock record with a quantity of zero. The system stores the count quantity on the Inventory Stock Locations record (FTVSTKL).

You also use this form to define the safety stock quantity, reorder point quantity, and minimum replenishment quantity, and to define the ABC classification for this inventory item.

Safety Stock Quantity is the amount of stock, which is required to cover purchasing lead time for the inventory item.

Reorder Point Quantity is available stock minus safety stock, the quantity amount you wish to reach to trigger the system to notify you to reorder this commodity.

Minimum Reorder Quantity is the minimum quantity to order when a reorder point has been reached.

Maintaining quantity

You also use this form to define the safety stock quantity, reorder point quantity, and minimum replenishment quantity, and to define the ABC classification for this inventory item.

Safety Stock Quantity is the amount of stock, which is required to cover purchasing lead time for the inventory item.

Reorder Point Quantity is available stock minus safety stock, the quantity amount you wish to reach to trigger the system to notify you to reorder this commodity.

Minimum Reorder Quantity is the minimum quantity to order when a reorder point has been reached.

Minimum reorder quantity is informational only. The Safety Stock and Reorder Point quantity fields are used by the system to determine when to reorder stock, based on the number of items on hand in the warehouse, the number of items on order, and the number of items being held in reservation.

A low stock warning record is created out of the issue process if the total of on hand quantity from all locations for the issued item plus the on order quantity, minus the reserved quantity, minus the safety stock quantity from FTVINVM, is less than or equal to the reorder point quantity from FTVINVM. These low stock records may be viewed on the Stores Inventory Low Stock List Form (FSAPREQ).

Note: Reordering is not an automated process. The items listed on FSAPREQ only serve as a guide to what inventory items you need to reorder.

The Quantities fields on this form are display-only.

Unit Cost represents the current unit cost value for the stock item, based on the invoice price if the goods have been invoiced, or the purchase order price if the goods have not been invoiced.

The Onhand quantity is the total amount of the stock item available for issue in all inventory locations. This quantity is updated when receiving is performed on an Inventory PO, when a previously received PO is canceled, when items are issued, or when previously issued items are returned.

The on-hand quantity may also be updated through the physical inventory process or using the FSASTKQ form.

On Order displays the quantity of outstanding purchase orders for this stock commodity.

Reserved displays the quantity of the stock item reserved by departmental requestors but not yet issued. The reserved quantity does not diminish the on-hand quantity.

Not Invoiced is the quantity that has been received in to the system through the procurement system (FPARCVD) but has not yet been invoiced. When the invoice is completed and approved, this quantity is reduced by the invoiced quantity.

Banner form

Steps

Follow these steps to establish inventory values for a commodity that has been defined as a stock item.

Note: If more than one participant creates this record it will be necessary to ensure that each code is unique.

Access the Stores Inventory Maintenance form (FTRINVM).

Enter 3110000000 or the unique stock commodity code that you established on FTMCOMM in the Commodity field.

Click the Next Block icon.

The current date defaults into the Effective Dates field. Change the date to 01-JUL-2000 (or another past date such as the start date for your Chart of Accounts).

Enter B in the Chart of Accounts field, or enter the COA code for your chart of accounts.

Enter 3110, or enter the inventory fund for this inventory item In the Inventory Fund field.

Enter the account where inventory will be recorded in the General Ledger for this inventory item in the Inventory Account field. (Overrides the Inventory Account code entered at the location and system level).

Enter WARE1 or the valid Ship-to code representing the default primary location (warehouse) where this stock item is most likely to be stored in the Primary Location field.

Enter the External Rate code associated with this inventory item, if applicable in the External Rate field.

Enter EA, or the Unit of Measure used when issuing this inventory item in the Issued U/M field.

Enter 50, or the amount of stock, which is required to cover purchasing lead time for the inventory item in the Safety Stock Quantity field.

Enter 75, or the quantity when available stock minus safety stock is reached, triggers a reordering in the Reorder Point Quantity field.

Enter 200, or the minimum quantity to order when a reorder point has been reached in the Minimum Reorder Quantity field.

Enter RACK 1, or another user defined location code secondary to the primary location for this stock item in the Sub-Location field. (Can be defined in a format of rack/shelf/bin.)

Note: If the Sub-Location field is left blank, postings to Banner may be incorrect.

Enter B or the classification code associated with this inventory item in the ABC Classification field.

Review the record, then click the Save icon.

Click the Exit icon.

Stocking the Warehouse

Introduction

There are three methods which may be used to get stock into the inventory warehouse:

Quick Method

Normal Method

Physical Inventory Method

Quick method

The Quick method allows you to quickly define stock quantity by primary or sub location using the Stores Quick Quantity Entry Form (FSASTKQ), and then establish the total value amount by entering the stock commodity unit cost on the Stores Quick Cost Entry Form (FSASTKC).

Note: No accounting transactions are created when the Quick Method is used. To complete the cycle, you must create journal voucher entries to represent the stock value in the inventory fund and account.

This method is intended for use by institutions converting from a legacy Inventory system to the Banner Finance: Stores Inventory system.

Normal method

The Normal method of getting stock into the warehouse is a detailed and thorough method, which allows you to purchase inventory from outside vendors using the Purchasing and Procurement modules. The following forms and reports are used, in the order listed, to stock the warehouse using this method:

Requisition Form (FPAREQN) – (Optional.) Used by the stores clerk to submit a request for the initial purchase of stock commodity items.

Purchase Order Form (FPAPURR) – Used to purchase stock commodity items from outside vendors. To order inventory from an outside vendor on either FPAREQN or FPAPURR, the commodity must be a stock item, and the accounting in the form must be towards a General Ledger account.

Receiving Goods Form (FPARCVD) – Used to enter receipt information from a packing slip or receiving document for stock items that have been delivered to the institution. You can only receive goods against an Approved purchase order. An Invoice cannot be entered for a stock commodity until a Receiving document has been entered against the Purchase Order.

Dock to Stock Exceptions Report (FSRSTEX) – (Optional.) Lists all items for a specific primary location that have been received by the central receiving process, but have not yet been put away. To use this report, the stock location that you received the stock into must be identified as a location type of Dock.

Stores Put List Report (FSRPUTL) – (Optional.) Used by warehouse personnel to determine where to put the incoming stock. Lists all items from a packing list with the default location, and all stock locations that may contain the commodity.

Stores Stock Transfer Form (FSATRAN) – (Optional.) Used to introduce stock into the Stores system and to record movement of stock between locations after the warehouse receives the stock by standard receiving. Can be used to establish a new location.

Invoice/Credit Memo Form (FAAINVE) – Used to pay for received stock item goods. A Purchase Order and Receiving document must exist before an Invoice can be processed for a stock commodity.
Note: This method will be discussed in detail in the Day-to-day Operations section of this workbook.

Physical inventory method

You can add stock into a stock location when the on-hand stock quantity is zero using the Physical Inventory method by entering a quantity adjustment on the Adjustment to Quantity/Inventory Reconciliation Form (FSAADJQ), and then defining the cost of the item on the Stores Adjustment to Unit Cost Form (FSAADJC).

The advantage of using the Physical Inventory method is that it produces a posting document to support each inventory item.

This method might be used at an organization that performs fund and account transactions at the commodity level.

Note: This method will be discussed in detail in the Day-to-day Operations section of this workbook.

Stocking the Warehouse Using the Quick Method

Introduction

The Stores Quick Quantity Entry Form (FSASTKQ) was created to facilitate quick entry of stock quantities for institutions that may already have their own stores inventory system in place and are in the process of converting their system to the Banner Finance: Stores Inventory System.

Note: No accounting transactions are created when this form is used.

The only enterable field is the Stock Quantity field. The only records displayed are those that have a status value of null in all locations for a stock item, which indicates that no type of physical inventory is being performed on these items.

FSASTKQ also has a delete capability, which may only be used to remove records with quantities of zero. This capability enables an institution to clear out old or obsolete inventory locations. To delete an obsolete location, highlight the record and click the Remove Record icon.

Warning: Due to this form’s capability to quickly alter or remove records without affecting the ledgers, it should be used with extreme caution. High security should be enforced to restrict access to authorized users.

Steps

Follow these steps to establish stock quantity information by primary/sub location using the Stores Quick Quantity Entry Form (FSASTKQ).

Note: Only one participant (or instructor) needs to create these records or it will be necessary to ensure that each code is unique.

Access the Stores Quick Quantity Entry Form (FSASTKQ).

Select the record for your default primary location.

Enter the quantity of stock in your default primary location in the Stock Quantity field.

Select another record to be updated, and enter the quantity of stock for that location. Continue as needed until all records have been updated.

Click the Save icon.

Click the Exit icon.

Purpose

The Stores Quick Cost Entry Form (FSASTKC) was created to facilitate quick entry of a total value amount for stock commodities (by entering unit cost) for institutions that may already have their own stores inventory system in place and are in the process of converting their system to the Banner Finance: Stores Inventory System.

Note: No accounting transactions are created when this form is used.

The only enterable field is the Unit Price field. The only records displayed are those that have a status value of null in all locations for a stock item, which indicates that no type of physical inventory is being performed on these items.

The form calculates the Total Value Amount of the stock commodity as the Unit Price multiplied by the Stock Quantity.

If the Stock Quantity is zero, the Total Value Amount will be zero. Changing the Unit Price of a zero Stock Quantity results in no change. In this case, first use the Stores Quick Quantity Entry Form (FSASTKQ) to change the quantity to a non-zero value, and then use FSASTKC to store the cost.

Steps

Follow these steps to establish stock quantity information by primary location using the Stores Quick Quantity Entry Form (FSASTKQ).

Note: Only one participant (or instructor) needs to create these records or it will be necessary to ensure that each code is unique.

Access the Stores Quick Cost Entry Form (FSASTKC).

Select the stock commodity record you wish to update.

Enter the unit cost of the selected stock commodity item in the Unit Price field.

Select another record to be updated, and enter the unit cost for that stock commodity. Continue as needed until all records have been updated.

Click the Save icon.

Click the Exit icon.

Self Check

Directions

Use the information you have learned in this section to complete this self check activity.

Question 1

Which Banner form is used to create the Valuation Clearing account?

Question 2

A two-record structure is used to create stock items in Banner. Which two forms are used for this purpose?

Question 3

How is the External Rate code used in the Stores Inventory module?

Question 4

What form do you use to define the inventory control parameters at the system level?

Question 5

Which method for stocking the warehouse is used when an institution is converting from an existing Inventory system to the Banner Finance: Stores Inventory system?

Question 6

How is the Regular method used to stock the warehouse?

Question 7

What condition must apply before you can delete a record on the FSASTKQ Stores Quick Quantity Form?

Question 8

One of the quick entry forms must be used with caution. Which one and why?

Answer Key for Self Check

Question 1

Which Banner form is used to create the Valuation Clearing account?

Account Code Maintenance Form (FTMACCT)

Question 2

A two-record structure is used to create stock items in Banner. Which two forms are used for this purpose?

Commodity Maintenance Form (FTMACCT) and the Stores Inventory Maintenance Form (FTRINVM)

Question 3

How is the External Rate code used in the Stores Inventory module?

External Rate codes are used to specify surcharges or discounts on inventory items issued from Profit Center warehouse facilities.

Question 4

What form do you use to define the inventory control parameters at the system level?

Inventory System Control Maintenance Form (FSASYSC)

Question 5

Which method for stocking the warehouse is used when an institution is converting from an existing Inventory system to the Banner Finance: Stores Inventory system?

Quick method

Question 6

How is the Regular method used to stock the warehouse?

The Regular method uses Procurement and Purchasing forms and processes to purchase stock inventory items from outside vendors.

Question 7

What condition must apply before you can delete a record on the FSASTKQ Stores Quick Quantity Form?

The quantity amount must be zero.

Question 8

One of the quick entry forms must be used with caution. Which one and why?

Stores Quick Quantity Cost Form (FSASTKC), because it can alter and remove records without affecting the ledgers.

Day-to-Day Operations

Introduction

The purpose of this section is to explain the day-to-day operational procedures to handle Stores Inventory at your institution.

Objectives

In this section you will learn how to

stock the warehouse

make adjustments to inventory

requisition and issue stock items

identify the forms used to query stores inventory items within the Stores Inventory module

identify the reports and processes used to update and/or track and report on stores inventory items within the Stores Inventory module.

Process Introduction

About the process

The Finance Office can

establish stores inventory for initial stock

create requisitions for stock

issue items

order and replace inventory.

Flow diagram

This diagram highlights the processes used in stores inventory.

What happens

The stages of the process are described in this table.

Stage	Description
1	Stockroom clerk establishes inventory for initial stock.
2	Requestor creates a requisition for stock.
3	Inventory clerk issues items on request to end-user.
4	Stockroom clerk orders and replaces inventory.

Purchasing Stock Items for the Warehouse

Introduction

In order to purchase inventory from outside vendors to stock the warehouse, the following forms are used, in the order given, using the Purchasing and Procurement module.

Purchase Order Form (FPAPURR) - Use this form to create and issue purchase orders.

Receiving Goods Form (FPARCVD) - Use this form to enter or view receipt information from a packing slip or receiving document.

Invoice/Credit Memo Form (FAAINVE) - This form provides the basis for all Accounts Payable processing activities.

Stores Stock Transfer Form (FSATRAN) - Use this form to record movement of stock between locations after the warehouse receives the stock by stores receiving.

Purchase Order form

Use the Purchase Order Form (FPAPURR) to create and issue purchase orders when purchasing stock items for the inventory warehouse.

To order inventory from an outside vendor on either FPAREQN or FPAPURR, the commodity must be a stock item, and the accounting in the form must be towards a General Ledger account.

The form recognizes that the item is a stock item based on the Stock indicator on the Commodity Code record. The accounting defaults the Inventory Fund and Account first from the FTRINVM inventory defaults, then from FTMSHIP inventory defaults, then from the FSASYSC inventory defaults. If document level accounting is in effect, then the first commodity is searched for a fund and account.

At completion, the FTRINVM On Order quantity for this inventory item is updated with the ordered quantity. If in defer edit mode, the On Order quantity is not updated until FGRTRNI is run. Or, if the document is awaiting final approval, On Order quantity is not updated until FORAPPL is run.

Purchase orders will normally be sent to the posting process. However, when using FPAPURR to order stock commodities, no posting to the ledger will occur so long as a General Ledger account is used. When the goods have been received the posting will occur at the completion of the receiving transaction.

Banner form

Purchase Order Form (FPAPURR)

Steps

Follow these steps to create a purchase order to order a stock item from an outside vendor.

Access the Purchase Order Form (FPAPURR)

Enter NEXT in the Purchase Order field to create a system generated number.

Perform a Next Block function.

Change the Order Date if today’s date is not appropriate.

Change the Transaction Date if today’s date is not appropriate

Enter a delivery date in the Delivery Date field.

Note: The delivery date must be the same as or later than the order date.

Select a buyer in the Buyers Code field.

Check the Deferred Editing and NSF Checking fields if appropriate.

Requestor/ Delivery Information tab

Select the Requestor/Delivery Information tab.

Note: If set up, FOMPROF will default the Requestor and Ship to information.

Enter the requestor in the Requestor field; if appropriate.

Enter a chart of account in the COA field, if appropriate.

Enter an organization in the Organization field, if appropriate.

Enter a shipping address in the Ship To field, if appropriate.

Note: When you select a shipping address the Address, Phone, Contact, and Attention fields will be filled in.

Enter a name in the Attention To field.

Vendor Information tab

Select the Vendor Information tab.

Select a vendor in the Vendor field.

Note: Once a vendor is selected, the remaining fields will be filled in for you, if the Procurement Default Address exists for the vendor. If you need to create a vendor or add address information for the vendor, use the Vendor Maintenance Form (FTMVEND).

Enter a Discount code in the Discount field. View and select from the available records in the Discount Terms List (FTVDISC).

Enter an FOB code in the FOB Code field. View and select from the available records in the FOB Code List (FTVFOBS).

Enter a tax group if tax processing is on in the Tax Group field. View and choose from the available records on the Tax Group Table (FTVTGRP).

Note: Tax groups entered in the purchase order override the settings on the System Control Form (FOASYSC) and the Vendor Maintenance Form (FTMVEND).

Enter a Purchase Order Classification code in the Class Code field. View and choose from the available records on the Purchase Order Classification List (FTVPCLS).

Enter a Purchase Order Shipping Carrier code in the Carrier field. View and choose from the available records in the Carrier List (FTVCARR).

Select a Currency code in the Currency field if the order is in a foreign currency.

Note: If your institution does not maintain accounts in foreign currency, and has specified on the Currency Maintenance Form (GUACURR) that a disbursing agent exchanges the funds and makes the actual foreign currency payment, Banner checks the Disbursing Agent box.

Commodity/ Accounting tab

Select the Commodity/Accounting tab.

Enter a commodity in the Commodity field.

For this exercise select a commodity that is already set up as stock item. Commodities that are stock items have a Y in the Stock field.

Note: The U/M field will be filled in after the commodity is selected.

Tab to the Quantity field and enter 10 for the quantity to be requested.

Tab to the Unit Price field and enter $50 for the unit price of this commodity.

Tab to the Discount field.

Result: Notice the extended price has been filled in by Banner.

Perform a Next Block function.

Result: The FOAPAL string should have been defaulted in based on the commodity you selected. If not follow steps 29 & 30 to enter the proper FOAPAL

Click the Search icon for Funds and select fund 3110.

Click the Search Icon for Accounts and then select 1430.

Note: The account number is what tells Banner that this purchase is for Stores Inventory. The account code has an account type that indicates it is an inventory account.

Enter the amount to be charged to this accounting distribution in the USD extended field. Enter in the amount shown in the Remaining Commodity Account field.

Select the Balancing/Accounting tab.

Review the Header, Commodity, and Accounting amounts.

If these amounts are in balance, click the Complete button

Note: The auto help line should read “Inventory Purchase Order: PXXXXXXX has been completed and approved.”

Click the Exit icon.

Access the Stores Inventory Maintenance Form (FTRINVM).

Enter the commodity code for one of the items ordered in the Commodity field.

Perform a Next Block function.

Note that the On Order quantity for this item has increased by the amount ordered.

Note: If in defer edit mode, the On Order quantity is not updated until FGRTRNI is run. Or, if the document is awaiting final approval, On Order quantity is not updated until FORAPPL is run.

Click the Exit icon.

Receiving Goods Form (FPARCVD)

Use the Receiving Goods Form (FPARCVD) to receive items purchased for the inventory warehouse/store. The commodity received must be a stock item, and the accounting in the form must be towards a General Ledger account. Both Primary Location and the Sub Location are required.

Receiving transactions can only be performed against approved purchase orders. You may receive one or more packing slips within the same document, provided the same vendor is used for the entire document.

If physical inventory or cost adjustments are in progress, the system does not allow you to receive any of the stock items that are currently being adjusted.

When goods are received, the system debits the Inventory fund and account by the amount entered on the PO, and credits the Valuation Clearing account using the existing purchase order price to obtain the extended cost.

If the receiving/matching process is being utilized, the actual posting of the difference performed during posting after the FABMATC process has been run, otherwise it is recorded during posting after the invoice has been completed and approved.

Banner form

Steps

Follow these steps to create a receiver document to record the receipt of a stock item from an outside vendor.

Access the Receiving Goods Form (FPARCVD).

Enter Next in the Receiver Document Code field to allow the system to generate number or click the Search icon to select an incomplete receiving document.

Perform a Next Block function.

Double-click in the Receiving Method field to select a receiving method.

Select a carrier in the Carrier field. (optional).

Tab to the Date Received field, if necessary. Override the date displayed in the Date Received field, if appropriate.

Perform a Next Block function.

Enter the packing slip number in the Packing Slip field.

Note: If the packing slip encompasses the receipt of more than one purchase order, click the Search icon to select the packing slip number entered with a different purchase order number.

Tab to the Bill of Lading field and enter the bill of lading number (optional).

Perform a Next Block function.

Tab to the Receive Items radio button and verify that it is selected.

Select the Receive All Purchase Order Items the Options menu.

Note: The Receive All Purchase Order Items option is not available if there are already receiving documents against the selected purchase order. In this case, select the Select Purchase Order Items option and select the remaining items to be received on FPCRCVP.

Perform a Next Block function.

Note: The commodity information defaults from the purchase order.

For each commodity, did you receive all the goods?

If yes, leave the Final Received? checkbox checked.

If no, uncheck the Final Received? checkbox.

Note: As a side note to the Accounts Payable department - for creating the payment document, additional receiving documents can still be created.

Enter the quantity received for this item on the packing slip in the Current Received field.

Enter the amount of any rejected items at delivery time in the Current Rejected field.

Enter the current Received and Current Rejected defaults from the purchase order in the U/M field.

Enter WARE1 in the Primary Location field.

Note: Both Primary Location and the Sub-Location are required fields if the item received is a stock item and the ordering account is a General Ledger account.

Select a sub-location in the Sub-Location field.

Select Access Completion from the Options menu to go to the Completion window.

Click Complete to complete the receiving document.

Result: Once you complete the document, the Receiver Document number will be displayed on the Auto-Hint Help line and the cursor will rollback to allow you to enter another receiver.

Click the Exit icon.

Access the Stores Inventory Maintenance Form (FTRINVM).

Enter the commodity code for one of the items received in the Commodity field.

Perform a Next Block function.

Note that the on order quantity for this item has decreased and the not invoiced quantity has increased by the amount received.

Click the Exit icon.

Invoice/Credit Memo Form (FAAINVE)

Use the Invoice/Credit Memo Form (FAAINVE) to pay for received stock item goods. A Purchase Order and Receiving document must exist before an Invoice can be processed for a stock commodity.

If the invoice unit cost is different from the purchase order unit cost, the system processes the transaction as follows:

Calculates any difference between the net purchase order amount and the net invoiced amount. The accounting entry is:

Dr: Valuation Clearing Account for the net invoice amount

Cr: Accounts Payable for the net invoice amount

Debits or Credits the Inventory Fund and Account for the difference between the net purchase order price and the net invoice amount.

Banner form

Steps

Follow these steps to create an invoice document to pay for a stock item purchased from an outside vendor.

Access the Inventory/Credit Memo Form (FAAINVE).

Assign an invoice number in the Document field or tab to the Multiple field to have Banner generate an invoice number.

Select Regular in the Invoice Type field.

Enter the purchase order number in the Purchase Order field to roll a previously completed, approved, and posted purchase order into the invoice.

Enter Y (Yes) in the Invoice All field if you want to select all the commodities.

Invoice/Credit Memo Header window

Perform a Next Block function to navigate to the Invoice/Credit Memo Header window.

Note: All of the header information is populated from a purchase order for a Regular invoice.

Enter the Payment Due date in the Payment Due field (required field).

Enter a valid Bank code (required field).

Perform a Next Block function.

Note: The Commodity information is populated from the originating purchase order.

The Final Payment Indicator must be set to F for each commodity in or to close (liquidate) that line item of the Purchase Order.

Enter an amount in the Additional field to allow for surplus charges on the invoice if needed.

Note: Shipping costs must be processed as an Additional Amount so that they will be included in the unit cost calculations.

Options – Accounting Information

Select Accounting Information from the Options menu to navigate to the Invoice Accounting Distribution Information window.

Select Balancing/Completion from the Options menu once all vendor invoice and accounting information has been entered to complete the document. This window displays summary information.

Click the Complete button if all the appropriate levels balanced.

Access the Stores Inventory Maintenance Form (FTRINVM).

Enter the Commodity Code for one of the items invoiced in the Commodity field.

Perform a Next Block function.

Note that the Not Invoiced quantity for this item has decreased by the amount invoiced.

Click the Exit icon.

Transferring Stock Items

Introduction

The Stores Stock Transfers Form (FSATRAN) is used to transfer stock to other locations and create new stock locations (after the warehouse receives the stock). Use this form to introduce stock received by the standard receiving process into the Stores Inventory process.

If physical inventory or cost adjustments are being processed for a commodity/location, you may not use transfers for that adjusted commodity/location.

When you complete this document, the system adds the transfer quantity to the on-hand quantity of the new location and subtracts from the on-hand quantity of the old location.

After you complete this document, you may not make any changes to it. However, you may use this document as a query for completed transfers. If this form is used to query a transfer, a warning message may appear to inform you that the transfer is completed and changes are not allowed.

You may not process a cancellation on this form. If you must make an adjustment, you need to enter another transfer.

Types of stock transfers

There are two different types of stock transfers:

Stock transfer within one stockroom: You can move stock within the same primary location from one sub location (e.g., rack, shelf, or bin) to another sub location. The net effect increases the stock on-hand quantity in the new location and decreases the quantity in the previous location.

Stock transfer between stockrooms: You can move stock from one warehouse sub location to another warehouse sub location. In this case, you may have an accounting entry as well. If you designate different inventory accounts based upon Primary Location code, then this transfer generates a credit to the old Primary Location code and a debit to the new one.

Banner form

Steps

Follow these steps to transfer stock items between inventory Primary Locations.

Access the Stores Stock Transfers Form (FSATRAN).

Enter NEXT in the Transfer field to have the system generate a transfer number in the system, or click the Search icon to access a list of Stores Transfers List Validation Form (FSITRAN) to select an incomplete transfer.

Tab to the Transaction Date field.

Note: The system date appears in the Transaction Date field, this date can be changed if desired. For this exercise leave the date as of today.

Have all the items that need to be transferred been received?

If yes, leave this field blank.

If no, enter the receiving number in the Receiver Document field or Click the Search icon to select one from the Receiver/Packing Slips Validation Form (FPIPKSL).

Perform a Next Block function.

Note: If all the items were received and a receiver document was not entered then a nothing defaults in when a next block is performed.

If a commodity code needs to be entered, click the Search icon to select the commodity that needs to be transferred

Perform a Next Block function

Note: The current primary and sub locations will appear for the commodity selected and a window will appear showing the amount of items in the current location.

Use the Next Record function to navigate to the primary location that needs to be transferred.

Note: The data in the window will change as each record is selected

Once the right primary and sub-locations are found to transfer, use your mouse and select the primary field that the items will move to in the window to the left.

Enter in the new Primary location or click the search icon to select one in the Primary field.

Enter in the new sub-location in the Sub location field.

Enter in the amount to be transferred in the Transfer Quantity field.

Click the Save icon.

Repeat steps 8-13, if additional transfers are needed to be made on this commodity.

Select Complete the Transfer from the Options menu.

Click the Exit icon

Requisitioning Stock Items

Introduction

Use the Stores Requisition Form (FSAREQN) to create requests (requisitions) for stores stock items. Once this form is completed and approved, the system creates a reservation for the requesting organization (which you enter in the Accounting block on this form) and updates the stock reserved quantity with the requisitioned quantity within Stores.

You cannot use this form to modify or complete any documents created on the Requisition Form (FPAREQN) nor can FPAREQN be used to request Stores Stock items.

You may use the Record Remove function to delete a FSAREQN Stores Requisition document only so long as long as it is in process. Once completed, you may use the Requisition Cancel Form (FPARDEL) to cancel a Stores request, so long as no Issue documents have been entered against it.

You cannot use FPARDEL to cancel individual items on a Stores request; you must cancel the entire requisition.

Banner form

Steps

Follow these steps to create a stores request for issue of stock items from the inventory warehouse/stockroom/store using the Stores Requisition Form (FSAREQN).

Access the Stores Requisition Form (FSAREQN).

Enter NEXT in the Request field to have the system generate one or click the Search icon to select an incomplete one.

Perform a Next Block function.

The transaction date defaults to the current date, but you may enter a different one in the Transaction Date field.

Enter the date the requester wants all items on the requisition to be issued in the Delivery Date field.

Leave the Cancel Date field blank.

Note: A date is displayed only if you are viewing a Requisition number that has already been created and canceled.

The Requestor, Phone, and Extension fields are optional.

Select the delivery location code in the Ship To field.

Perform a Next Block function.

Enter the commodity code of the Stores item being requested in the Commodity field, or click on the search icon to select one.

Result: The description and U/M fields default in.

Enter the requested quantity of the commodity in the Quantity field.

Tab to the Extended Cost field.

Result: The extend cost will be calculated based on the unit price of the commodity and the number of items requested.

Use the Next Record function and repeat steps 10-12 to add additional commodities.

Perform a Next Block function.

Enter your chart if it did not default in Chart of Accounts field.

Fiscal year will default in based on the transaction date.

Enter 1110 in the Fund field.

Enter 11102 in the Organization field.

Enter 7210 in the Account field.

Enter 10 in the Program field.

Tab to the Amount field and enter in the amount to be charged to this accounting distribution.

Note: You may also enter a distribution percentage in the Percent field to divide the charge between multiple account distributions. Use the Next Record function to add additional account distribution records.

Select Review Accounting Information from the Options menu to double check if you are in balance with commodities total.

Click the Exit icon.

Perform a Next Block function.

Click the Complete button to complete this requisition.

Click the Exit icon.

Canceling Stock Item Requisitions

Introduction

You may use the Requisition Cancel Form (FPARDEL) to delete requests (stores requisitions) for stock items so long as no issues have been entered against it. Once this form is completed and approved, the system cancels the reservation for the requesting organization and decreases the FTRINVM reserved quantity within Stores for all items requested.

Before you can cancel a requisition, you must complete, approve, and post that requisition. Otherwise, you will receive an error message when you try to proceed with this form.

You cannot use FPARDEL to cancel individual items on a Stores request; you must cancel the entire requisition. Access this form from the Request Processing menu (*FINREQST).

Banner form

Steps

Follow these steps to cancel a stock item requisition using the Requisition Cancel Form (FPARDEL).

Access the Requisition Cancel Form (FPARDEL).

Enter the requisition code of the document you want to cancel in the Request Code field.

Perform a Next Block function.

Note: The system displays the summarized data for this requisition.

Select the Cancel Date tab.

Verify the date in the Cancel Date field. The system date defaults in. You can enter any date within an open fiscal year period.

Enter the code that represents the reason for this purchase order being canceled in the Reason Code field, or double click in the field to select one from a list.

Select Process Cancellation from the Options menu to complete the cancellation of this requisition.

Click the Exit icon.

Issuing/Returning Stock Items

Introduction

Use the Stores Issue/Return Form (FSAISSU) to enter issues or returns of stock items. You may use this form to create issues from existing requisitions or enter issues directly.

If the issue is created from an existing request, information is copied from the request directly into the issue.

If the issue is entered directly, the appropriate data must be entered on this form.

Once you enter a commodity code, the system calculates unit cost for that commodity. You may use an external rate code to override this unit cost if the warehouse is defined as a profit center. The external rate may default from the Commodity Code table or may be applied on this form.

The Stores Issue/Return Form also enables you to issue items from one or multiple locations. If you issue an item from more than one location, these locations must all be profit centers or must all not be profit centers, as long as you define them uniformly.

You can complete the document from any point on the form. If a rate or quantity changes, the form will automatically calculate the accounting impact.

This form can also be used to enter return documents. The Return check box indicates whether the document is an issue (unchecked) or a return (checked). A single document may not contain both issues and returns.

The on-hand quantity of the issued stores commodity is adjusted once the document is completed. You do not use the approvals process for stores issue/return documents.

If physical inventory or cost adjustments are occurring, no issues or returns for the item being adjusted can occur.

Banner form

Steps – Procedure 1

Follow these steps to issue stock items directly (without referencing a stores requisition document) using the Stores Issues/Return Form (FSAISSU).

Access the Stores Issues/Return Form (FSAISSU).

Enter NEXT in the Issue field to have the system generate an issue code, or click on the Search icon to select an issue document that is incomplete.

Leave the Request Number field blank.

Perform a Next Block function.

Verify the date in the Issue Date field. The system date defaults in. It may be changed but for this exercise leave the date as is.

Verify the date in the Transaction Date field. The system date defaults in. It may be changed but for this exercise leave the date as is.

Leave the Return check box unchecked (blank).

Select the NSF On/Off checkbox to have Banner check for non-sufficient funds.

Tab to the Requestor field and enter the name or title of the person requesting the stock items.

Tab to the Ship To field and enter the departmental requestor’s Ship-to code (the delivery address for the issued item.)

If you want to attach text to this issue document, select Document Text from the Options menu to open the General Text Entry Form (FOATEXT) and enter the text there.

Note: Once you save your entry and return to FSAISSU, the Document Text check box is checked.

Select the NSF On/Off check box to have Banner check for non-sufficient funds.

Perform a Next Block function

Enter the commodity code for the first stock item to be issued in the Commodity field or click the search icon and select it from the list, and then tab out of the field.

Note: The commodity description, unit of measure and unit cost default.

Enter a rate code in the External Rate field, if applicable, to apply a surcharge or discount to the issued unit price cost of the commodity.

Note: The External Cost will default. To use this feature, the inventory location must be defined as a profit center.

Perform a Next Block function.

Note: All locations for the selected commodity will be queried in this block. All sub locations, if any, will be queried for the selected commodity. Use the Next Record Function to scroll through all available locations.

Enter the desired issue quantity in the Issue or Return Quantity field.

Note: This amount cannot be greater than the on-hand quantity for the location. The Item Cost field will automatically be calculated.

Perform a Next Block function.

Select your chart if it did not default in the Chart of Accounts field.

Fiscal year will default in based on the transaction date.

Enter 1110 in the Fund field.

Enter 11102 in the Organization field.

Enter 7210 in the Account field.

Enter 10 in the Program field.

Tab to the Percent field. Enter 100 if you intend to charge the issued items to one account.

Notes: If you intend to divide the charge for the issued item between multiple accounts, change the percentage accordingly. You may also divide the charge between multiple accounting distributions by clearing the Percent field and entering the amount to be charge to this account distribution in the Amount field.

Use the Next Record function to add additional account distribution records.

Perform a Next Block function.

Click the Complete button.

Note: If this document is the first issue or return completed in your Banner session, the Stores Inventory Distribution Initialization Form (FOADEST) will automatically open. This form is used to designate the printer that will print out your issue/return documents if your system is configured to automatically run the FSRISST Issue Ticket Report in sleep/wake mode.

Enter a printer in the Issues field if using sleep/wake to generate issue tickets. Otherwise, leave this field blank.

Click the Exit icon.

Banner form

Steps - Procedure 2

Follow these steps to issue stock items against a stores request (referencing a stores requisition document) using the Stores Issues/Return Form (FSAISSU).

Access the Stores Issues/Return Form (FSAISSU).

Enter NEXT in the Issue field to have the system generate an Issue code, or click on the Search icon to select an Issue document that is incomplete.

Enter one of the stores requisition numbers you just created in the Request Number field or click on the Search icon to select it from a list.

Check the Issue All Items check box if you intend to issue all items on the request to generate Issue Commodity Detail records automatically for all items on the selected request.

Note: You cannot select this check box if items have been previously issued against the selected stores request.

Perform a Next Block function

Verify the date in the Issue Date field.

Note: The system date defaults in. It may be changed but for this exercise leave the date as is.

Verify the date in the Transaction Date field. The system date defaults in. It may be changed but for this exercise leave the date as is.

Leave the Return checkbox blank.

The Document Text checkbox is selected if text exists for this requisition. If there is text, select Document Text from the Options menu to view it.

Select the NSF On/Off checkbox to have Banner check for non-sufficient funds.

The value in the Ship To field defaults from the selected stores requisition. It cannot be updated.

Click the Select Items checkbox to select specific items from the specified request.

Note: When you check this box, you automatically access the Issue Requisition Selection Form (FSCISSR), where you will select individual items from the requisition. You cannot select this check box if you previously selected the Issue All Items checkbox.

Click the ADD checkbox on FSCISSR for those commodities you wish to issue.

Click the Save icon.

Click the Exit icon.

Note: The selected commodities are now loaded in the Commodity Information block of FSAISSU.

Enter a rate code in the External Rate field, if applicable, to apply a surcharge or discount to the issued unit price cost of the commodity.

Note: The External Cost will default. To use this feature, the inventory location must be defined as a profit center.

Perform a Next Block function.

Note: All locations for the selected commodity will be queried in this block. All sub locations, if any, will be queried for the selected commodity. Use the Next Record function to scroll through all available locations.

Enter the desired issue quantity in the Issue/Return Quantity field.

Note: This amount cannot be greater than the on-hand quantity for the location. The Item Cost field will automatically be calculated.

Perform a Next Block function.

Note: The account distribution data defaults into the Accounting Information block from the selected stores requisition. Double check it for accuracy.

Perform a Next Block function.

Click the Complete button.

Note: If this document is the first issue or return completed in your Banner session, the Stores Inventory Distribution Initialization Form (FOADEST) will automatically open.

This form is used to designate the printer that will print out your issue/return documents if your system is configured to automatically run the FSRISST Issue Ticket Report in sleep/wake mode.

Enter a printer in the Issues field if using sleep/wake to generate issue tickets. Otherwise, leave this field blank.

Click the Exit icon.

Steps 3

Follow these steps to record the return of issued stock items.

Access the Stores Issues/Return Form (FSAISSU).

Note: An Issue document must be completed and posted before a Return can be entered against it.

Enter NEXT in the Issue field to have the system generate an Issue code, or enter a user-defined code.

Note: You cannot view Stores Return information on FOIDOCH by querying the either the Stores Issue document that the return was entered against, or the Stores Requisition referenced by the Stores Issue. To view a Stores Return on FOIDOCH, you must query the code assigned to the Stores Return document. For this reason, many institutions choose to use a user-defined code when entering Stores Returns.

Leave the Request Number field blank.

Perform a Next Block function

Verify the date in the Issue Date field. The system date defaults in. It may be changed but for this exercise leave the date as is.

Verify the date in the Transaction Date field. The system date defaults in. It may be changed but for this exercise leave the date as is.

Click the Return checkbox to indicate that this document records the Return of issued stock items.

Tab to the Requestor field and enter the name or title of the person returning the issued stock items.

Tab to the Ship To field and enter the departmental requestor’s Ship-to code (the delivery address that the issued item is being returned from.)

If you want to attach text to this Return document, select Document Text from the Options menu to open the General Text Entry Form (FOATEXT) and enter the text there.

Note: Once you save your entry and return to FSAISSU, the Document Text checkbox is checked.

Perform a Next Block function

Type the code belonging to the Stores Issue document the item being returned was issued on in the Returned Issue field.

Note: For the purpose of this exercise, use the Issue document you created in the previous exercise.

Tab to the Commodity field. Enter the commodity code for the first stock item being returned.

Note: If you try to enter a commodity code on a Return that wasn’t on the original Issue, Banner displays the warning “Commodity not issued by document.”

Perform a Next Block function.

Enter the quantity of this stock commodity being returned in the Issue or Return Quantity field, and then tab out of the field.

Note: The Item Cost and Commodity Total are automatically calculated. The returned quantity must be less than or equal to currently issued quantity, e.g., the original issue quantity less previously returned quantity.

Perform a Previous Block function to access the Commodity Information block if more than one stock item from the Returned Issue document is being returned.

Perform a Next Record function to obtain a blank record.

Repeat steps 12-15 until Returned Issue, Commodity, and Return Quantity info is established for all items being returned.

The Accounting Information data defaults from the original Stores Issue document. It cannot be changed.

Perform a Next Block function.

Click the Complete button.

Note: If this document is the first issue or return completed in your Banner session, the Stores Inventory Distribution Initialization Form (FOADEST) will automatically open.

This form is used to designate the printer that will print out your issue/return documents if your system is configured to automatically run the FSRISST Issue Ticket Report in sleep/wake mode.

Enter a printer in the Issues field if using sleep/wake to generate issue tickets. Otherwise, leave this field blank.

Click the Exit icon.

Using the Inventory Listing Report

Introduction

Use the Inventory Listing Report (FSRINVL) any time you want to obtain a snap shot of the Banner system on-hand count for stock commodities.

Depending on your site policies, FSRINVL can be used during physical inventory by warehouse staff taking the physical count, or used by administrative staff for comparing on-hand count quantities with the “blind” count quantities taken by the warehouse staff using the Physical Inventory Worksheet (FSRPIWS).

If used during physical inventory, be sure to start the inventory adjustment process on FSASYSA before running this report. This will prevent any receipts, invoices, transfers, or issues from being processed that would change the on-hand count captured in the FSRINVL report output.

This report creates a listing of stock items, their on-hand quantities, their current value, and their locations. Depending on the parameter values entered, the report may print:

all commodities for all locations sorted by commodity/location (default value)

one commodity across all locations

one commodity in a subset of locations

all commodities for one location.

Banner form

Steps

Follow these steps to run the Inventory Listing Report (FSRINVL) leaving all parameters set to their default values in order to produce a list of all commodities for all inventory locations sorted by commodity/location.

Access the Inventory Listing Report (FSRINVL).

Enter a valid printer name, or enter DATABASE in the Printer field to view the saved report output on GJAREVO.

Enter these parameter values.

Parameter	Description
Parameter 01: Commodity Code	(Optional) – May be entered multiple times. If a commodity code is entered, FSRINVL reports on only this commodity across all locations (depending upon other parameter values entered.) If a high level commodity is entered, FSRINVL reports on all commodities within this hierarchical structure. If left with the wildcard (%) default, all commodities are reported.
Parameter 02: Primary Location	(Optional) If a value for this parameter is entered, FSRINVL reports on commodities existing only in this location. If left with the wildcard (%) default, all locations are reported.
Parameter 03: Sub Location	(Optional) – Requires a Primary Location parameter. If entered, all commodities within these locations are reported. If left as-is, all sublocations are reported (depending upon other parameter values entered.)
Parameter 04: Sort Commodity by Description	(Optional) If Y (Yes) is entered, the report is sorted by commodity description. The default is N (No), sort by commodity code.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Click the Exit icon.

Making Adjustments to Inventory

Introduction

Use the Inventory Adjustment System Control Form (FSASYSA) to initiate and to end adjustments to either the on-hand quantity or unit cost of a Stores Inventory stock item. Use it also to flag inventory location/items for physical count.

Before you make an adjustment to either quantity or unit cost, you must restrict the stores item so that issue, transfer, and receipt documents are not created until you complete and post the adjustment. FSASYSA is used to restrict stores items for this purpose.

To initiate an adjustment process on this form, first enter a primary location, commodity code, or both to specify the inventory item(s) to be adjusted, and then indicate the type of adjustment process you wish to perform by selecting either the Cost or Quantity adjustment option radio button.

Once you commit your selection, the form begins the adjustment process and updates an internal adjustment status indicator maintained on the stock item’s FTVSTKL record to either

I – Inventory Quantity Adjustment in Progress

T – Cost Adjustments in Progress

Once the adjustment process is initiated, no receipts, invoices, transfers, or issues may be processed for the selected location/commodity until the adjustment process is ended.

Banner

Steps

Follow these steps to initiate an inventory quantity adjustment using the Inventory Adjustment System Control Form (FSASYSA). Adjustments to cost will be covered in another exercise.

Access the Inventory Adjustment System Control Form (FSASYSA).

Enter the primary location code in the Primary Location field, or double click in the field to select it from a list.

Enter the code of the commodity for which adjustments are being performed in the Commodity Code field.

Note: The description of the commodity code displays automatically in the Description field.

Click Quantity to begin adjustments to inventory.

Click the Save icon to commit this adjustment to your Stores Inventory records

Result: The adjustment history for this commodity displays. If necessary, you may scroll through these records.

Click the Exit icon.

Note: Running the Physical Inventory Worksheet (FSRPIWS) job will list all the commodities that are currently being adjusted for quantity.

Purpose

The Physical Inventory Worksheet (FSRPIWS) creates a listing of all items that have been flagged for physical inventory count by specific location. The purpose of the report is to facilitate the recording of count quantities.

This report sorts by location and commodity. A secondary sort option allows you to sort by commodity and location.

Be sure to start the inventory quantity adjustment process on FSASYSA before running this report.

Banner form

Steps

Follow these steps to run the Physical Inventory Worksheet report (FSRPIWS) leaving all parameters set to their default values in order to produce a list of all commodities in all inventory locations that are currently flagged for inventory count.

Access the Physical Inventory Worksheet report (FSRPIWS).

Enter the desired printer name in the Printer field.

Note: Enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Parameter	Description
Parameter 01: Primary Location	(Optional) If a value for this parameter is entered, FSRPIWS reports on commodities existing only in this location. If left with the wildcard (%) default, all locations are reported.
Parameter 02: Sub Location	(Optional) – Requires a Primary Location parameter. If entered, all commodities within these locations are reported. If left as-is, all sublocations are reported (depending upon other parameter values entered.)
Parameter 03: Commodity Code	(Optional) – May be entered multiple times. If a commodity code is entered, FSRPIWS reports on only this commodity across all locations (depending upon other parameter values entered.) If a high level commodity is entered, FSRPIWS reports on all commodities within this hierarchical structure. If left with the wildcard (%) default, all commodities are reported.
Parameter 04: Sort Commodity by Description	(Optional) If Y (Yes) is entered, the report is sorted by commodity and location. The default is N (No), sort by location and commodity.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Select Review Output on the Options menu to review the report.

Click the Exit icon.

Click the Exit icon.

Purpose

The Stores Physical Inventory Count Recording Form (FSAPHYC) is used to record the physical inventory count obtained by warehouse personnel for each commodity flagged for inventory count at the specified location(s).

The Recording block displays only those commodities that have been flagged for count by entering a quantity adjustment on FSASYSA. The Count Quantity field in the Recording Information block is the only data enterable field on this form.

The system stores the count quantity on the Inventory Stock Locations record (FTVSTKL).

You may want to access the Stores Inventory Commodity Location Form (FSISTKL) before you access FSAPHYC to verify which sub locations have been flagged for a physical inventory count. Alternatively, you may consult the FSRPIWS Physical Inventory Work Sheet.

Banner form

Steps

Follow these steps to complete the process.

Access the Stores Physical Inventory Count Recording Form (FSAPHYC).

Enter the primary location code in the Primary Location field, or click the Search icon to select a code from a list

Note: If you only enter the Primary Location, the system retrieves all commodities in all sub locations in that location. If you enter the Primary Location and Sub Location, the system retrieves all sub locations starting with the one specified.

Enter a Sub Location in the Sub Location field to further refine the query. This may be entered in conjunction with the % sign to find all entries that match the entered data.

Enter a commodity code in the Commodity Code field to limit your query to that specific commodity. Leave blank to display all commodities in the selected location.

Perform a Next Block function

Note: Only those locations that await a physical inventory count display in the Recording Information fields. All of the Recording Information fields are display only, except for the Count Quantity field.

Enter the desired inventory quantity for each location/commodity in the Count Quantity field.

Click the Save icon to commit this inventory count to your Stores Inventory records.

Click the Exit icon.

Note: At this point, you can run the Physical Inventory Process (FSRPHYR). Items within tolerance are marked reconciled.

Then run the Physical Inventory Discrepancy Report (FSRPIDR), which lists all items whose system inventory count does not match the physical inventory count.

Purpose

The Physical Inventory Process (FSRPHYR) automatically marks as reconciled all those items whose system inventory count does not vary from the physical inventory count by an amount greater than the system defined tolerance for that stock commodity.

Before running this process, you must assign all or some stock commodities an ABC classification on the Stores Inventory Maintenance Form (FTRINVM).

The process can be run in A (Audit) or U (Update) mode.

Run the process in Audit mode to view the records that are marked for automatically reconciliation without making changes to the database.

Run the report in Update mode to have the process update the database and automatically reconcile those inventory records that can be reconciled.

Print this report after the process has run to obtain a list all reconciled items. The report output resembles the Physical Inventory Discrepancy Report (FSRPIDR).

Banner form

Steps

Follow these steps to run the Physical Inventory Process (FSRPHYR) in Audit mode to view all items within tolerance marked for automatic reconciliation without making changes to the database.

Access the Physical Inventory Process (FSRPHYR).

Enter the desired printer name in the Printer field.

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Parameter	Description
Parameter 01: Primary Location	(Optional) If a value for this parameter is entered, FSRPHYR marks as reconciled only those commodities existing in this location that are within tolerance limits for the commodity ABC classification. If left with the wildcard (%) default, all locations are reconciled that are within tolerance limits for the commodity ABC classification.
Parameter 02: Sub Location	(Optional) – Requires a Primary Location parameter. If entered, all commodities within these locations that are within tolerance limits for the commodity ABC classification are marked as reconciled. If left as-is, all sublocations are reconciled that are within tolerance limits for the commodity ABC classification (depending upon other parameter values entered.)
Parameter 03: Report Mode	(Required) – A = Audit, U = Update The process can be run in audit mode by entering A (Audit). This allows you to view the records that are marked for automatically updated without making changes to the database. Enter U (Update) to have the process update the database and automatically reconcile those inventory records that can be reconciled.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Result: The Auto hint line displays the job submission number for the report log and list file.

Select Review Output on the Options menu to review the report.

Click the Exit icon.

Purpose

The Physical Inventory Discrepancy Report (FSRPIDR) lists all items whose system inventory count does not match the physical inventory count. If an item was reconciled, values do not appear in the Count Quantity column.

Redefine the location parameters based on your site policies. The system automatically performs a wildcard search using the sublocation, if entered. If only the primary location (warehouse) is entered, all discrepancies within that warehouse are reported. If a primary location and sublocation are entered, all locations matching the primary location and sublocation (rack/shelf/bin) are returned.

All values with the exception of the Commodity Description and Over/Under values are retrieved from the Stock Locations Table (FTVSTKL). The commodity description is retrieved from the Commodity Verification Table (FTVCOMM). The Over/Under column is calculated as (Count Quantity minus System Quantity).

Additional features

You may control the printing of the discrepancy report by an ABC tolerance. To take advantage of this feature, you must assign some or all stock commodities an ABC classification on the Stores Inventory Maintenance Form (FTRINVM).

The List Reconciled parameter enables you to display only R (Reconciled) items, U (Unreconciled) items, or list A (All) locations regardless of whether items have been reconciled or not. In all cases, an asterisk appears in the Not Reconciled column identifying those items that have not been reconciled.

To request a report for a hierarchy of commodities, enter the high level commodity within the group.

This report sorts by location and commodity. Enter a value in the Sort by Commodity parameter to change the sort order of the listing to commodity and location.

Banner form

Steps

Follow these steps to run the Physical Inventory Discrepancy Report (FSRPIDR) with the parameters set to obtain a list of all unreconciled items.

Access the Physical Inventory Discrepancy Report (FSRPIDR).

Enter the desired printer name in the Printer field.

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Parameter	Description
Parameter 01: Primary Location	(Optional) If a value for this parameter is entered, all discrepancies within that warehouse are reported. If a primary location and sublocation are entered, all locations matching the primary location and sublocation (rack/shelf/bin) are returned. If left blank, all locations with quantity discrepancies are reported.
Parameter 02: Sub Location	(Optional) – Requires a Primary Location parameter. If entered, all commodities with quantity discrepancies within these locations are reported. If left blank, all sublocations with quantity discrepancies are reported (depending upon other parameter values entered.)
Parameter 03: ABC Classification	(Optional) If entered, prints only those stock items that exceed the tolerance defined using the FTMSDAT form for the ABC classification entered. Only those commodities with this classification are checked for tolerance. If left blank, all discrepancies are reported no matter what the tolerance.
Parameter 04: Status Selection	(Required) This parameter controls the listing of reconciled and unreconciled items. U (Unreconciled) lists only unreconciled locations. R (Reconciled) lists only reconciled locations. A (All) lists both reconciled and unreconciled items. Use this parameter along with the above parameters to control the printing selections.
Parameter 05: Commodity	(Optional) May be entered multiple times. If entered, reports on locations with quantity discrepancies only for this commodity. If left blank, all commodities are reported along with the above parameter values. A high level commodity may be entered which reports on all commodities within this hierarchical structure.
Parameter 06: Sort Commodity by Description	(Optional) If Y (Yes) is entered, the report is sorted by description and location. The default is N (No), sort by location and commodity.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Result: The Auto hint line displays the job submission number for the report log and list file.

Select Review Output on the Options menu to review the report.

Click the Exit icon.

Purpose

The Adjustment To Quantity/Inventory Reconciliation Form (FSAADJQ) is used to reconcile discrepancies in the Physical Inventory process.

The data that appears on this form specifies only those items in your inventory that maintain a discrepancy between the recorded on-hand count (System Quantity) and the physical count (Count Quantity).

Banner form

The Adjustment To Quantity/Inventory Reconciliation Form (FSAADJQ)

When you check the Select Items checkbox on the Adjustment To Quantity/Inventory Reconciliation Form (FSAADJQ), the system displays another window where you can select which items you wish to add.

Steps

Follow these steps to run the Physical Inventory Worksheet report (FSRPIWS) leaving all parameters set to their default values in order to produce a list of all commodities in all inventory locations that are currently flagged for inventory count.

Access the Adjustment To Quantity/Inventory Reconciliation Form (FSAADJQ).

Enter NEXT to have the system assign a reconciliation number or click on the Search icon to select one that is incomplete in the Reconciliation Number field.

Verify the date in the Transaction Date field.

Note: The system date defaults in; either enter a transaction date or use the system date.

Click the Select Items checkbox to access the Inventory Reconciliation Location Selection Form (FSCSTKL) in order to view those locations awaiting reconciliation and select some (or all) of those locations for reconciliation.

Click the Add checkbox to select those items to be adjusted.

Click the Exit icon.

Note: The items selected default in the Adjustment Detail Information fields.

Verify the quantity in the Adjusted Quantity field.

Perform a Next Block function to access the Balancing/Completion window.

Click the Complete icon to post this reconciliation and save this adjustment document to your Stores Inventory records.

Run the Posting process (FGRACTG) once you complete this document.

Notes: The posting program processes each entry that you make in the Adjustment Detail Information and creates the proper accounting records for the discrepancies in the quantities to the General Ledger.

When you post this document, the system updates the recorded on-hand System Quantity field with the adjusted quantity, and clears the Count Quantity field in the Stock Locations table (FTVSTKL).

Purpose

Use the Inventory Adjustment System Control Form (FSASYSA) to end the on-hand quantity adjustment of a Stores Inventory stock item.

Banner form

Steps

Follow these steps to use the Inventory Adjustment System Control Form to end the on-hand quantity adjustment performed in the previous exercise.

Access the Inventory Adjustment System Control Form (FSASYSA).

Enter the primary location code for the adjustment(s) just made in the Primary Location field.

Enter the code of the commodity for which adjustments was just made in the Commodity Code field.

Note: The description of the commodity code displays automatically in the Description field.

Select End to end adjustments in progress in the Adjustment Action field.

Click the Save icon.

Click the Exit icon.

Flow diagram

Making Adjustments to Cost

Purpose

Use the Inventory Adjustment System Control Form (FSASYSA) to initiate a unit cost adjustment of a Stores Inventory stock item.

Before you can adjust a unit cost, you must restrict the stores item so that issue, transfer, and receipt documents are not created until you complete and post the adjustment. FSASYSA is used to restrict stores items for this purpose.

Enter the commodity codes that you wish to adjust on FSASYSA and choose Cost from the Adjustment Action radio group to update the status to T (Cost Adjustments In Process).

At this point, issue, transfer, receipt, and physical quantity adjustment documents cannot be created or completed for the commodity code specified.

When adjusting a stock commodity’s unit cost, you must make cost adjusts to all of the Primary Locations in which the commodity is stored.

Banner form

Steps

Follow these steps to initiate an inventory unit cost adjustment using the Inventory Adjustment System Control Form (FSASYSA).

Access the Inventory Adjustment System Control Form (FSASYSA).

Enter the primary location code in the Primary Location field, or double click in the field to select it from a list.

Enter the code of the commodity for which adjustments are being performed in the Commodity Code field or click the Search icon to display a list of valid codes, if needed.

Note: The description of the commodity code displays automatically in the Description field.

Click the Cost radio button to update the status to T (Cost Adjustments in Progress) to begin adjustments to inventory.

Click the Save icon to commit this adjustment to your Stores Inventory records.

Perform a Next Block function.

Note: The adjustment history for this commodity displays. If necessary, you may scroll through these records.

Perform a Rollback function.

Repeat steps 2-7, until all locations for this commodity have been started on the cost adjustment process.

Click the Exit icon.

Purpose

Use the Stores Adjustment to Unit Cost Form (FSAADJC) to make adjustments to the unit cost of a stores item.

You may not view or modify quantity type adjustment documents from this form. You also cannot make adjustments to a cost adjustment document after it has been completed.

Once a valid commodity code is entered in the Unit Cost Adjustment Block, the commodity code cannot be changed. The item must be deleted if the commodity code is incorrect.

Once the cursor passes the commodity description field, total value amount is defaulted from the FTVCOMM table. Total on-hand quantity is defaulted by summarizing all FTVSTKL ftvstkl_stock_qty records for the commodity code entered. A unit cost is calculated by dividing total value amount by total on-hand quantity.

After an adjusted unit cost is entered, the adjustment amount is calculated as follows:

calculated unit cost

- adjusted unit cost

net adjustment to unit cost

x sum ftvstkl_stock_qty

adjustment amount

The adjustment amount represents the entry being made to the general ledger when posting is executed. A document adjustment amount for the entire document is displayed in the Unit Cost Adjustment Block.

When a FSRADJD record is inserted, the commodity’s adjustment status is updated to a C (Cost Entered) status. By doing this, no other document can update the cost for this commodity code. If the record is deleted, the status is updated back to T (Cost Adjustment in Progress) status to allow other documents to update the commodity code.

Once you complete this form, the form becomes query-only, and you may not make any further changes to the adjustment document.

Banner form

Steps

Follow these steps to adjust the unit cost of an inventory item using the Stores Adjustment to Unit Cost Form (FSAADJC).

Access the Stores Adjustment to Unit Cost Form (FSAADJC).

Enter NEXT in the Adjustment Document Number field to have the system generate a number.

Verify the date in the Transaction Date field. The system date defaults in, either enter a transaction date or use the system date.

Perform a Next Block function.

Enter the commodity number you started the adjustment on the previous form in the Commodity field.

Note: The associated commodity description displays and the values for the Total Value Amount, On-hand Quantity, and Unit Cost fields all default from existing records or previous adjustment records.

Enter the unit cost amount desired for the commodity in the Adjusted Unit Cost field.

Tab to the Adjustment Amount field to show the change.

Click the Save icon.

Perform a Next Block function.

Click the Complete button to post this reconciliation and save this adjustment document to your Stores Inventory records.

Run the Posting process (FGRACTG) once you complete this document.

Note: The posting program processes each entry that you make in the Adjustment Detail Information and creates the proper accounting records for the discrepancies in the quantities to the General Ledger.

Purpose

Use the Inventory Adjustment System Control Form (FSASYSA) to end the unit cost adjustment of a stores inventory stock item.

Banner form

Steps

Follow these steps to complete the process.

Access the Inventory Adjustment System Control Form (FSASYSA).

Enter the primary location code for the adjustment(s) just made in the Primary Location field.

Enter the code of the commodity for which adjustments was just made in the Commodity Code field.

Note: The description of the commodity code displays automatically in the Description field.

Click the End radio button to end adjustments in progress in the Adjustment Action field.

Click the Save icon.

Perform a Rollback function.

Repeat steps 2-6, until all locations for this commodity have been ended on the cost adjustment process.

Click the Exit icon.

Flow diagram

Stores Inventory Inquiry Forms

Name	Description	Purpose
FPIREQN	Requisition Inquiry Form	A companion query form for the Requisition Form (FPAREQN), this form is also used to view Stores Requisition documents created on FSAREQN.
FSAPREQ	Stores Inventory Low Stock List	This form is used to view and maintain a list of all stock that the system finds to be at the user defined point of reorder. You may delete these stock items or leave them in the system as a reminder that you must reorder them. Neither deleting nor ordering is an automatic process. The items listed on this form only serve as a guide to what inventory items you need to reorder. To remove an item from the Low Stock List, position the cursor on the item and select Remove Record. Note: This record is system-generated. If a record already exists in this table for stock to be ordered, then the issue process does not generate another reorder table record until you delete this one.
FSAREQN	Stores Requisition Form	This form is used to view completed Stores Requisition documents as well as to enter new Stores Requests. Note: Only the first two commodity record lines on a completed stores request can be viewed on FSAREQN. To view all of the commodity records entered on a completed stores requisition document, use the Requisition Inquiry Form (FPIREQN).
FSIOSRO	Open Stores Request Form	Use this form to query open stores requisitions by organization, commodity, or both. A list of all open requisitions for the organization displays, including the commodity information attached to each requisition. Note: This list includes incomplete and unapproved stores requests along with complete/approved requests.
FSIISSU	Issue/Return List Validation Form	Use this form to select stores issues or returns. The form lists all issue documents within the system that are completed, not completed, and returns.

Name	Description	Purpose
FSITRAN	Stores Transfers List Validation Form	Use this form to select stores transfers. The form displays a list of all Stores Transfer documents that have been entered on the Stores Stock Transfer Form (FSATRAN).
FSIADJL	Stores Adjustment Document List Form	Use this form to select physical inventory reconciliation documents. The form displays all adjustment documents that are currently entered in the system. The adjustment documents may be one of two kinds, quantity, or cost.
FOIDOCH	Document History Form	Use this form to view the processing history of purchasing and payment documents. FOIDOCH also identifies and provides the status of all documents in the processing path for the document selected in the key block. Using this form, you can determine in a glance what documents have been completed in the process of purchasing stock items and in the course of issuing stock items to fulfill stores requests.
FSISTKL	Stores Commodity Location List Form	Use this form to select Stores commodity locations. Also use this form to determine the inventory adjustment status of any given commodity. Inventory adjustment status values are: (I)nventory adjustments in progress, (Q)uantity being counted, items (Reconciled), (A)djusted quantity in progress and (C)ost adjustments in progress.
FSIISSQ	Stores Issue/Return Query Form	A companion query form for the Stores Issue/Return Form (FSAISSU). Use this form to query information about the issues or returns created on FSAISSU
FTVCOMM	Commodity Validation Form	This form displays a list of all Commodity codes entered in the system and their associated descriptions. Use this form to select a Commodity code to process or verify relevant information attached to the commodity.
FTVINVM	Stores Inventory Validation Form	View Commodity codes defined as stock items and verify that they have been assigned to the Stores Inventory System. You can also use it to verify effective dates and termination dates for a commodity’s active period.
FTVSHIP	Ship to Validation Form	Use this form to select or verify shipping locations for Stores Inventory requisition deliveries.

Stores Inventory Processes and Reports

Name	Description	Purpose
FSRDTLG	Stores Daily Transaction Listing Report	This report provides you with all activity that changed overall balances of stock in the Stores Inventory System for a defined date range. The system lists all receipts of stock first. Issues list afterward with the “issued to” department or organization.
FSRINVL	Inventory Listing Report	This report contains on-hand commodity quantities by location. Depending upon the parameter values, the report may print all commodities for all locations sorted by commodity and location, one commodity across all locations, one commodity in a subset of location, or all commodities for one location.
FSRISST	Issue Ticket Report	When stock is issued from the stockroom, generate this report to accompany the goods. This report is also used to print return issue documents. Generally, you print this report after the issue/return has been created and completed online.
FSRLWSR	Stores Low Stock Report	This report lists all stock items whose on-hand quantity plus on order quantities has fallen below the predefined reorder point quantity or have fallen below a range defined as a percentage of the reorder point quantity.
FSROPNR	Open Stores Requisitions Report	Generate this report to display the status of requests for stock items, goods, and services that are not fully satisfied. Open requests display as of a specific date and are sorted by requisition number. The system displays all open requisitions unless you use the optional parameters to selectively define the report listing.

Name	Description	Purpose
FSRPHYR	Physical Inventory Process Report	This report automatically marks all those items whose system inventory count does not vary from the physical inventory count by an amount greater than the system defined tolerance for that commodity as reconciled. Before you run this process, assign all stock commodities an ABC classification on the Stores Inventory Maintenance Form (FTMINVM). You may assign a site-specific tolerance percentage to the ABC classifications using the System Data Maintenance Form (FTMSDAT).
FSRPICK	Pick List Report	This list contains all open stores requests by a user-defined commodity, location, or commodity/location combination. Use this report after you create a stores request, and print this report just before the issue. This report enables warehouse personnel to pick items to satisfy a request.
FSRPIDR	Physical Inventory Discrepancy Report	This report lists all items whose system inventory count does not match the physical inventory count. The system automatically performs a wildcard search using the sub-location, if entered. If only the primary location (warehouse) is entered, all discrepancies within that warehouse are reported. If you enter a primary location and sub-location, all locations that match the primary location and sub-location (rack/shelf/bin) are returned.
FSRPIWS	Physical Inventory Worksheet	This list contains all items by specific location(s). The purpose of the report is to facilitate the recording of count quantities. All locations print that have not yet been counted or reconciled based upon the values you enter.

Name	Description	Purpose
FSRPUTL	Put List Report	This list contains all items from a packing list and their default location in order for warehouse personnel to determine where to put the incoming stores. You may sort this report by receiver document number, packing list, or by commodity code. The system lists all stock locations that may contain the commodity.
FSRSTEX	Dock to Stock Exceptions Report	This report lists all items for a specific primary ship to location that have been received by the central receiving process but have not yet been introduced into the Stores Inventory System. The receiving information that prints is accepted quantity, remaining dock quantity, receipt date, receiver document number and packing slip number, purchase order number, and the order amount. The system scans the central receiving document for all stock commodities that have not been transferred over to the Stores warehouses.
FSRSUPC	Supply Catalog Report	This report gives a list of all stock commodities that are currently active sorted by commodity code. Each commodity is checked to be sure that it is still active and has not been terminated.

Self Check

Directions

Use the information you have learned in this workbook to complete this self check activity.

Question 1

What kind of purchase orders can receiver transactions be performed against?

Question 2

Can you invoice stock items for which there is no purchase order?

Question 3

What form is used to cancel a completed, approved Stores Requisition document?

Question 4

What two kinds of inventory adjustments can you make?

Question 5

What two Stores Inventory reports can be used to obtain a list of all reconciled stores inventory items?

Question 6

What form is best used for viewing commodity line detail on a completed Stores Requisition document?

Question 7

Are the low stock warning records listed on the Stores Inventory Low Stock List (FSAPREQ) automatically updated once a listed item’s on-hand quantity increases?

Question 8

What report is used for recording count quantities during a “blind” physical inventory count?

Question 9

What form can be used to view a completed Stores Return document?

Question 10

What report can be used to get a list of all Issue documents completed during a specified date range?

Answer Key for Self Check

Question 1

What kind of purchase orders can receiver transactions be performed against?

Approved purchase orders

Question 2

Can you invoice stock items for which there is no purchase order?

No

Question 3

What form is used to cancel a completed, approved Stores Requisition document?

Requisition Cancel Form (FPARDEL)

Question 4

What two kinds of inventory adjustments can you make?

Quantity and cost

Question 5

What two Stores Inventory reports can be used to obtain a list of all reconciled stores inventory items?

Physical Inventory Process (FSRPHYR) and the Physical Inventory Discrepancy Report (FSRPIDR)

Question 6

What form is best used for viewing commodity line detail on a completed Stores Requisition document?

Requisition Inquiry Form (FPAREQN)

Question 7

Are the low stock warning records listed on the Stores Inventory Low Stock List (FSAPREQ) automatically updated once a listed item’s on-hand quantity increases?

No. Low stock warning records only serve as a guide to what inventory items you need to reorder. You must delete these stock items manually to remove them from the form.

Question 8

What report is used for recording count quantities during a “blind” physical inventory count?

Physical Inventory Worksheet (FSRPIWS)

Question 9

What form can be used to view a completed Stores Return document?

Stores Issue/Return Query Form (FSIISSQ)

Question 10

What report can be used to get a list of all Issue documents completed during a specified date range?

Stores Daily Transaction Listing Report (FSRDTLG)

Appendix

Forms Job Aid

Form	Full Name	Use this Form to...
FAAINVE	Invoice/Credit Memo Form	enables you to create invoice documents.
FPAPURR	Purchase Order Form	enter information to create or modify purchase orders.
FPARCVD	Receiving Goods Form	enter or view receipt information from a packing slip or receiving document.
FPARDEL	Requisition Cancel Form	cancel a requisition document.
FSAADJQ	Adjustment to Quantity/Inventory Reconciliation Form	reconcile discrepancies in the physical inventory process.
FSAISSU	Stores Issues/Return Form	enter issues or returns of stock items.
FSAPHYC	Stores Physical Inventory Count Recording Form	record the physical inventory count for each commodity, location, and sublocation.
FSAREQN	Stores Requisition Form	issue requests for stores stock items.
FSASYSA	Inventory Adjustment System Control Form	control adjustments to either quantity or unit cost of a Stores Inventory item by location or stock item.
FSASYSC	Inventory System Control Maintenance Form	define inventory control parameters at the system level.
FSATRAN	Stores Stock Transfer Form	record movement of stock between locations after the warehouse receives the stock by stores receiving.
FSRPHYR	Physical Inventory Process	automatically marks all those items whose system inventory count does not vary from the physical inventory count by an amount greater than the system defined tolerance for that commodity as reconciled.
FSRPIDR	Physical Inventory Discrepancy Report	list all items whose system inventory count does not match the physical inventory count.
FSRPIWS	Physical Inventory Worksheet	list all items by specific location(s).
FTMACCT	Account Code Maintenance Form	establish an object of expenditure accounts.
FTMCOMM	Commodity Maintenance Form	create and maintain commodity codes and default account relationships.
FTMEQUL	Equivalency Maintenance Form	access a cross-reference between the requisition unit of measure, the purchase order unit of measure, and the receiving unit of measure.
FTMEXRT	External Rate Maintenance Form	verify and maintain a list of external rate codes to support both the Cost Accounting module and the Stores Inventory module.
FTMFUND	Fund Code Maintenance Form	establish fund codes for a specific chart of accounts.
FTMSDAT	System Data Maintenance Form	maintain information integral to the processing or maintenance of various transactions and/or reports within Finance.
FTMSHIP	Ship to Address Maintenance Form	establish departmental or central routings for deliveries.
FTRINVM	Stores Inventory Maintenance Form	define and display basic information about a commodity defined as a stock item.

Terminology

ABC tolerance percentage

An industry-defined classification associated with inventory that is used to classify items. It is used in Banner for reconciling physical inventory.

Surcharge

An additional amount charged to all customers or just specific customer types.

Requisition

A request to purchase goods or services.

Valuation clearing account

An account used to record the difference between the estimated cost entered on a purchase order and the actual invoice cost.