Go to main content
1/87
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Information
Conventions
1
Overview to Inventory Management
1.1
Features
1.1.1
Stocking Considerations
1.1.2
Item Identification
1.1.3
Location and Lot Considerations
1.1.4
Physical and Logical Warehouses
1.1.5
Item Count and Cost Computation
1.2
System Integration
1.3
System Integration with Distribution/Logistics Systems
1.4
System Integration with Manufacturing Systems
Part I Item Entry
2
Overview to Item Entry
2.1
Objectives
2.2
About Item Entry
2.2.1
Before You Begin
3
Enter Item Master Information
3.1
Entering Item Master Information
3.1.1
Z File Processing
3.1.2
What You Should Know About
3.2
Entering Basic Item Information
3.2.1
What You Should Know About
3.3
Entering Item Text
3.3.1
Before You Begin
3.4
Assigning Item Responsibility
3.5
Entering Item Classification Codes
3.6
Entering Item Unit of Measure Information
3.7
Entering Item Manufacturing Information
3.8
Entering Item Grade and Potency Information
3.8.1
What You Should Know About
3.8.2
Processing Options
3.9
Transferring Item Number Changes to Other Files
4
Enter Branch/Plant Information
4.1
Entering Branch/Plant Information
4.1.1
Z File Processing
4.1.2
What You Should Know About
4.2
Assigning an Item to a Branch/Plant
4.3
Working with Item Locations
4.3.1
What You Should Know About
4.3.2
What You Should Know About
4.4
Entering Item Tax Information
4.5
Locating Item Sources
4.6
Entering Item Reorder Quantities
4.7
Entering Item Branch/Plant Manufacturing Information
4.7.1
What You Should Know About
4.8
Duplicating Item Information for Multiple Branch/Plants
4.8.1
Before You Begin
4.8.2
What You Should Know About
4.8.3
Processing Options
4.9
Updating G/L Class Codes to Inventory Locations
4.9.1
Processing Options
5
Enter Item Cost Information
5.1
Entering Item Cost Information
5.2
Assigning a Cost Level to an Item
5.2.1
What You Should Know About
5.3
Assigning a Cost Method to an Item
5.3.1
What You Should Know About
5.4
Entering Item Costs
5.4.1
What You Should Know About
5.5
Entering Manufacturing Setup Cost Information
5.5.1
Processing Options
6
Enter Sales Price Information
6.1
Entering Sales Price Information
6.1.1
What You Should Know About
6.1.2
What You Should Know About
Part II Inventory Transactions
7
Overview to Inventory Transactions
7.1
Objectives
7.2
About Inventory Transactions
7.2.1
Where Does the System Record Transactions?
7.2.2
Which Accounting Information Does the System Update?
7.2.3
What Types of Accounting Information Can I Review?
7.2.4
Before You Begin
8
Issue Inventory
8.1
Issuing Inventory
8.1.1
What You Should Know About
8.1.2
What You Should Know About
8.1.3
Processing Options
9
Adjust Inventory
9.1
Adjusting Inventory
9.1.1
What You Should Know About
9.1.2
What You Should Know About
9.1.3
Processing Options
10
Transfer Inventory
10.1
Transferring Inventory
10.1.1
What You Should Know About
10.2
Example: Transfer Transaction
10.2.1
What You Should Know About
10.2.2
Processing Options
Part III Item and Quantity Information
11
Overview to Item and Quantity Information
11.1
Objectives
11.2
About Item and Quantity Information
11.2.1
Types of Quantities and Commitments
11.2.2
How the System Commits Inventory
11.2.3
System Calculations for Supply and Demand Quantities
11.2.4
Reconcile Item Balances with the G/L
12
Locate Item Information
12.1
Locating Item Information
12.1.1
Before You Begin
12.2
Defining Search Criteria
12.2.1
What You Should Know About
12.3
Entering Search Text
12.3.1
What You Should Know About
12.3.2
Processing Options
13
Locate Quantity Information
13.1
Locating Quantity Information
13.1.1
Before You Begin
13.2
Locating Summary Quantity Information
13.2.1
What You Should Know About
13.2.2
Processing Options
13.3
Locating Detailed Quantity Information
13.3.1
What You Should Know About
13.3.2
Processing Options
13.4
Locating Quantity Information by Lot
13.4.1
What You Should Know About
13.4.2
Processing Options
13.5
Locating On-Hand Quantity Information
13.5.1
What You Should Know About
14
Review Supply and Demand Information
14.1
Reviewing Supply and Demand Information
14.1.1
Before You Begin
14.1.2
Processing Options
15
Review Performance Information
15.1
Reviewing Inventory Quantities
15.2
Reviewing Sales History
15.3
Reviewing Open Purchase Orders
15.3.1
Processing Options
16
Work with Transaction Records
16.1
Working with Transaction Records
16.1.1
Before You Begin
16.2
Creating Balance Forward Records
16.2.1
What You Should Know About
16.2.2
Processing Options
16.3
Reviewing "As-Of" Balance Forward Records
16.4
Entering Individual Transactions
16.4.1
What You Should Know About
16.4.2
Processing Options
16.5
Reviewing Multiple Transactions and Balances
16.5.1
Processing Options
16.6
Reviewing Transactions on General Ledger Reports
16.6.1
Reviewing the Item Ledger Detail Print Report
16.6.2
Reviewing the Item Ledger by G/L Class Print Report
16.6.3
Processing Options
16.6.4
Reviewing the General Ledger by Object Account Report
16.6.5
Processing Options
16.6.6
Reviewing the Trial Balance by Object Account Report
16.6.7
Processing Options
17
Summarize Inventory
17.1
Summarizing Inventory
17.2
Running Summary/As-Of Generation
17.2.1
Processing Options
17.3
Running the Summary Inquiry
17.3.1
Processing Options
17.4
Running Summary Inquiry Reports
17.4.1
The Item Ledger/Inventory Summary Integrity Report
17.4.2
The As Of Inventory Summary Integrity Report
Part IV Reports
18
Overview to Reports
18.1
Objectives
18.2
About Reports
19
Review Inventory Status Reports
19.1
Reviewing the Stock Status Report
19.1.1
Processing Options
19.2
Reviewing the Item Master Directory Report
19.2.1
Processing Options
19.3
Reviewing the Buyers Guide Report
19.3.1
Processing Options
19.4
Reviewing the Inventory Journal Report
19.4.1
Processing Options
19.5
Reviewing the Price Book Report
20
Review Inventory Analysis Reports
20.1
Reviewing the ABC Analysis Report
20.1.1
Before You Begin
20.1.2
Processing Options
20.2
Reviewing the Cost Analysis Report
20.2.1
Processing Options
20.3
Reviewing the Margin Analysis Report
20.3.1
Processing Options
20.4
Reviewing the Valuation Analysis Report
20.4.1
Processing Options
20.5
Reviewing the Inventory Turn Report
20.5.1
Before You Begin
20.5.2
Grouping Transaction Types
20.5.3
Running the Inventory Turn Report
20.5.4
What You Should Know About
20.5.5
Processing Options
20.6
Reviewing the Supply and Demand Report
20.6.1
Before You Begin
20.6.2
Processing Options
20.7
Printing Stock Tags
20.7.1
Before You Begin
20.7.2
Processing Options
21
Review Inventory Integrity Reports
21.1
Reviewing the Item Ledger/Account Integrity Report
21.1.1
Before You Begin
21.1.2
Processing Options
21.2
Reviewing G/L Transactions without Item Ledger Transactions Report
21.2.1
Before You Begin
21.2.2
Processing Options
21.3
Reviewing the Item Balance Ledger Integrity Report
21.3.1
Processing Options
21.4
Reviewing the General Ledger Class Code Integrity Report
21.5
Reviewing the Summary Availability Zero/Negative Report
21.5.1
Processing Options
22
Review Inventory Audit Reports
22.1
Reviewing Inventory Audit Reports
22.1.1
What You Should Know About
22.2
Reviewing the Item Master Audit Report
22.3
Reviewing the Item Branch Audit Report
Part V Physical Inventories
23
Overview to Physical Inventories
23.1
Objectives
23.2
About Physical Inventories
24
Process a Cycle Count
24.1
Processing a Cycle Count
24.1.1
Before You Begin
24.2
Running the Select Items for Count Program
24.2.1
Processing Options
24.3
Reviewing the Cycle Count Status
24.3.1
What You Should Know About
24.3.2
Processing Options
24.4
Printing Cycle Count Sheets
24.4.1
Before You Begin
24.4.2
What You Should Know About
24.4.3
Processing Options
24.5
Canceling the Cycle Count
24.5.1
What You Should Know About
24.6
Entering the Cycle Count Results
24.6.1
Before you begin
24.6.2
What You Should Know About
24.6.3
Processing Options
24.7
Reviewing the Cycle Count Variances
24.8
Revising the Cycle Count Quantity
24.9
Printing the Variance Report
24.9.1
Processing Options
24.10
Updating the Cycle Count Status
24.10.1
Processing Options
25
Process a Tag Count
25.1
Running the Select Items for Count Program
25.1.1
What You Should Know About
25.2
Printing Inventory Tags
25.2.1
What You Should Know About
25.2.2
Processing Options
25.3
Recording Tag Distribution Information
25.3.1
What You Should Know About
25.4
Recording Tag Receipt Information
25.5
Entering the Tag Count Results
25.5.1
What You Should Know About
25.5.2
Processing Options
25.6
Reviewing the Tag Status
25.6.1
Processing Options
25.7
Reviewing the Tag Count Variances
25.7.1
Processing Options
25.8
Running Tag Count Updates
25.8.1
Data Sequence
25.8.2
Processing Options
25.9
Running a Quantity Count Comparison
Part VI Cost Updates and the Supplemental Database
26
Overview to Cost Updates
26.1
Objective
26.2
About Updating Costs
26.2.1
Before You Begin
27
Update Item Costs
27.1
Updating Item Costs
27.1.1
What You Should Know About
27.2
Updating Costs for an Item across Multiple Branch/Plants
27.2.1
What You Should Know About
27.2.2
Processing Options
27.3
Updating Costs for Multiple Items across Multiple Branch/Plants
27.3.1
Processing Options
27.4
Updating Average Costs for Items
27.4.1
What You Should Know About
27.5
Updating Current Item Costs with Future Costs
27.5.1
Processing Options
28
Overview to Supplemental Database
28.1
Objectives
28.2
About the Supplemental Database
28.2.1
What You Should Know About
29
Define Data Types
29.1
Defining Data Types
29.1.1
Before You Begin
29.1.2
What You Should Know About
Part VII Kits
30
Overview to Kits
30.1
Objective
30.2
About Kits
30.2.1
Kit Components
30.2.1.1
Example: Kit
30.2.1.2
Example: Feature
30.2.2
Kits in Distribution Systems
31
Enter Kit Information
31.1
Entering Item Master Records for Kits
31.1.1
What You Should Know About
31.2
Setting Up Locations for Kits
31.3
Entering Kit Pricing Information
31.3.1
What You Should Know About
32
Enter a Bill of Material
32.1
Entering a Bill of Material
32.1.1
Before You Begin
32.1.2
What You Should Know About
32.1.3
Processing Options
Part VIII System Setup
33
Set Up Constants
33.1
Setting Up Constants
33.1.1
Before You Begin
33.2
Defining Branch/Plant Constants
33.2.1
What You Should Know About
33.3
Defining Item Availability
33.3.1
What You Should Know About
33.4
Defining System Constants
33.5
Defining Batch Control Constants
33.6
Defining the Location Format
33.6.1
What You Should Know About
34
Set Up Warehouse Locations
34.1
Setting Up Warehouse Locations
34.1.1
Before You Begin
35
Set Up Automatic Accounting Instructions
35.1
Setting Up Automatic Accounting Instructions
35.1.1
G/L Class Codes
35.1.2
AAIs for the Inventory Management System
35.1.3
Before You Begin
35.1.4
AAI Error Messages:
35.1.5
What You Should Know About
35.1.6
Processing Options
36
Set Up Messages
36.1
Setting Up Messages
36.1.1
What You Should Know About
36.2
Defining a Message
36.2.1
What You Should Know About
36.3
Defining Print Information for Messages
36.3.1
Defining Documents on Which to Print Messages
36.3.2
What You Should Know About
36.3.3
Defining Document Type Exceptions
36.3.4
Processing Options
37
Set Up Default Location Information
37.1
Setting Up Default Location Information
37.1.1
Before You Begin
37.2
Defining a Default Location and Approval Route Code
37.3
Assigning Default Print Queues
37.3.1
What You Should Know About
38
Set Up Standard Units of Measure
38.1
Setting Up Standard Units of Measure
38.1.1
Example: Conversion Factors for Units of Measure
38.1.2
Before You Begin
38.1.3
What You Should Know About
39
Set Up Item Cross-Reference
39.1
Setting Up Item Cross-References
39.1.1
Before You Begin
39.1.2
What You Should Know About
39.1.3
What You Should Know About
40
Work with Speed Location Maintenance
40.1
Working with Speed Location Maintenance
40.1.1
Elements
40.1.2
Steps
40.1.3
Limits
40.1.4
Examples: Working with Speed Location Maintenance
40.1.5
Before You Begin
40.1.6
What You Should Know About
Part IX Lot Processing
41
Overview to Lot Processing
41.1
Objectives
41.2
About Lot Processing
42
Enter Lot Information
42.1
Entering Lot Information for Items
42.2
Entering Date Information for Lots
42.3
Entering Information for Lots
42.3.1
What You Should Know About
42.3.2
Processing Options
43
Work with Lot Availability
43.1
Viewing Lot Availability
43.1.1
What You Should Know About
43.1.2
Processing Options
43.2
Working with Lot Quantities
43.2.1
What You Should Know About
43.3
Working with Lot Activity Dates
43.3.1
Processing Options
43.4
Working with Lot Statuses
43.4.1
What You Should Know About
44
View Lot Transactions
44.1
Viewing Lot Transactions
44.2
Print Trace and Track Reports
44.3
Reviewing Trace and Track Information
44.3.1
What You Should Know About
44.3.2
Processing Options
44.4
Setting up Trace and Track Inclusion Rules
44.4.1
What You Should Know About
44.5
Defining a Trace and Track Mode
45
Reclassify Lots
45.1
Reclassifying Lots
45.1.1
Example: Types of Reclassifications
45.1.2
What You Should Know About
45.1.3
Before You Begin
45.1.4
What You Should Know About
45.1.5
Processing Options
Part X System Updates
46
Overview to System Updates
46.1
Objectives
46.2
About System Updates
46.2.1
Before You Begin
47
Update Item Search Information
47.1
Updating Item Search Information
47.1.1
Files Used
48
Update Item Information
48.1
Updating Item Master and Branch/Plant Information
48.1.1
Processing Options
48.2
Updating Category Codes and Item Numbers
48.2.1
Processing Options
49
Update Effective Thru Dates
49.1
Updating Effective Thru Dates
49.1.1
Before You Begin
49.1.1.1
Process Flow
49.1.2
Processing Options
50
Revise Location Format
50.1
Revising Location Format
50.1.1
Before You Begin
50.1.2
What You Should Know About
50.2
Setting Up a Model Branch
50.2.1
What You Should Know About
50.3
Updating the Location Formats
50.3.1
What You Should Know About
50.3.2
Processing Options
Part XI Purges and Data Conversions
51
Overview to Purges
51.1
Objectives
51.2
About Purges
51.2.1
Before You Begin
51.2.2
What You Should Know About
52
Purge Data
52.1
Purging Data
52.1.1
Before You Begin
52.1.2
What You Should Know About
52.2
Running the General Purge
52.2.1
Processing Options
52.3
Running the Special Purge
52.3.1
Running the Item Deletion Purge
52.3.2
Running the Item Master Purge
52.3.3
Processing Options
52.3.4
Running the Item Balance Purge
52.3.5
What You Should Know About
52.3.6
Processing Options
53
Overview to Data Conversions
53.1
Objectives
53.2
About Converting Data in Inventory Management
53.2.1
Before You Begin
54
Convert Display Decimals
54.1
Converting Display Decimals
54.1.1
Before You Begin
54.1.2
What You Should Know About
54.2
Reviewing Data Items
54.3
Converting Data Items
54.3.1
Processing Options
55
Convert Cost Levels
55.1
Converting Cost Levels
55.1.1
About Item Cost Level Conversion
55.1.2
Before You Begin
55.1.3
Processing Options
Part XII Processing Options
56
Item Entry Processing Options
56.1
Item Master Revisions (P4101)
56.2
Item Master Revisions - Z File (P4101Z)
56.3
Item / Branch Duplication (P41015)
56.4
Manufacturing Values Entry (P41013)
56.5
Manufacturing Values - Z File (P41013Z)
57
Inventory Transactions Processing Options
57.1
Simple Inventory Issues (P4112)
57.2
Inventory Adjustments (P4114)
57.3
Inventory Transfers (P4113)
58
Item and Quantity Information Processing Options
58.1
Item Search with Word Search (P41200)
58.2
Item Availability (P41202)
58.3
Detailed Availability (P41023)
58.4
Lot Availability (P41280)
58.5
Supply & Demand (P4021)
58.6
Branch/Plant Item Information (P41026)
58.7
Item Branch Information - Z File (P41026Z)
58.8
Buyer's Inquiry (P4115)
58.9
Item Ledger "As-Of" Generation (P41542)
58.10
Item Ledger by G/L Class Code Print (P41541)
58.11
As-Of Maintenance (P41112)
58.12
G/L by Object Account (P09421)
58.13
T/B by Object (P094121)
58.14
Item Ledger - Costs (P4111)
58.15
Item Ledger - Locations (P4111)
58.16
Item Ledger - Lot Status/Grade/Potency (P4111)
58.17
Item Ledger - Running Quantity Balance (P4111)
58.18
As-Of Maintenance (P41112)
58.19
Inventory Summary Inquiry (P41118)
59
Reports Processing Options
59.1
Stock Status - All Warehouses & Items (P41530)
59.2
Stock Status - Specific Warehouse(s) (P41530)
59.3
Item Master Directory - Sales Report Code 1 (P41560)
59.4
Buyers Guide (P4152)
59.5
Inventory Journal - All Branches (P41550)
59.6
ABC Analysis - Sales (P4164)
59.7
Unit Cost Warnings Plus or Minus 5% (P41580)
59.8
Margin less than 50% based on Last In (P41700)
59.9
Summary Availability Report - Zero OH (P41702)
59.10
3-Way Valuation Analysis (P41590)
59.11
Inventory Turn Report (P41116)
59.12
Supply & Demand Report (P4051)
59.13
Stock Tags (P41531)
59.14
Item Ledger/Account Integrity (P41543)
59.15
Item Variance (P41544)
59.16
G/L Trans without Item Ledger Trans (P41571)
59.17
Release Mature Lots (P41083)
60
Physical Inventories Processing Options
60.1
Select Items for Count - All Items (P41411)
60.2
Cycle Count Review (P41240)
60.3
Print Count Sheets - By Item, Branch (P41410)
60.4
Cycle Count Entry - By Item, Branch (P4141)
60.5
Variance Detail Print (P41403P)
60.6
Cycle Count Update (P41413)
60.7
Tag Status Review (P41604)
60.8
Tag Inventory Update (P41610)
60.9
Print Inventory Tags (P41607)
60.10
Tag Inventory Count Entry (P41602)
60.11
Print Tag Inventory Variances (P41608)
61
Cost Updates Processing Options
61.1
Item Cost Revisions (P4105)
61.2
Cost Revisions - Z File (P4105Z)
61.3
Batch Cost Maintenance - Cost Level 1 (P41802)
61.4
Future Cost Update - Cost Level 1 (P41052)
62
Kits Processing Options
62.1
Bill of Material Revisions (P3002)
63
System Setup Processing Options
63.1
AAI Revisions (P40901)
63.2
Print Messages/Item Notes (P4016)
64
Lot Processing - Processing Options
64.1
Lot Master Revisions (P4108)
64.2
Lot Master Revisions - Z File (P4108Z)
64.3
Lot Availability (P41280)
64.4
Speed Lot Update (P41080)
64.5
Lot Tracing and Tracking (P41203)
64.6
Item Reclassifications (P4116)
65
System Updates Processing Options
65.1
Update Item Master Fields (P41804)
65.2
Update Item Branch Fields (P41805)
65.3
Global Category Code Update (P41803)
65.4
Effective Thru Date Update (P4028)
65.5
Location Redefinition (P41822)
66
Purges Processing Options
66.1
Batch File Purge (P00PURGE)
66.2
Purge Item Master File (F4101) (P4101P)
66.3
Purge Item Branch File (F4102) (P4102P)
67
Data Conversions Processing Options
67.1
Data Decimal Conversion (P40CVT)
67.2
Item Cost Level Conversion (P41815)
Part XIII Appendices
A
Appendix A - Functional Servers
A.1
About Functional Servers
A.1.1
Example: Voucher Processing Functional Server
B
Appendix B - Z File Processing
B.1
Import Data Using Z File Processing
B.1.1
Technical Considerations
B.1.2
Processing Options
B.1.3
Data Selection
B.1.4
Data Sequence
Index
Scripting on this page enhances content navigation, but does not change the content in any way.