IC70.1 - Select IDs
Use the Select ID form to define select IDs for physical inventory cycle
counts.
Select IDs identify item groups and item selection parameters. You can define
multiple select IDs for different purposes such as complete physicals,
selected item cycle counts, or bin group counts.
The first step of setting up a select ID is creating it using the Select ID
form. The form indicates whether the select ID is for all locations or for a
report group. You can include items with zero stock-on-hand quantities and
items with no unit cost. You can assign additional selection parameters to the
select ID by entering data into the forms for class and bin selection, logic
selection, and/or item selection.
Perform the following to do a physical inventory count using the Inventory
Control application.
Create select IDs. When you are ready to count items, you enter the select ID
in IC170 (Freeze Selected Items) to generate a freeze file. A freeze file is a
snapshot of current stock quantities for the selected items. After you create
a freeze file, you can run IC270 to print count sheets and/or tags for
recording purposes.
Enter actual item counts in IC72.1 (Counts by Page), IC73.1 (Count Detail), or
IC74.1 (Random Counts). By default, select IDs require you to enter actual
item counts. However, you can override this default when the select ID is set
up in IC70.1 (Select IDs) so that freeze quantities are considered valid
unless otherwise specified. Regardless of how you enter item counts, you must
select the Add form action to verify them.
Item counts are updated to inventory when you run IC175 (Update Variances) in
update mode. Prior to update, you can run IC175 in nonupdate mode to print the
Variance Report Next, you explain count variances by reason code in any count
entry form (IC72, IC73, or IC74). After update, you can only explain variances
in IC76.1 (Variance Reasons).
Physical inventory processing steps are outlined below. Refer to the Inventory
Control User Guide for detailed instructions.
1) Create select ID(s) in IC70 (Select IDs)
2) Optionally, print select ID criteria in IC271 (Select ID Listing).
3) Freeze selected items in IC170.
4) Optionally, print count sheets and/or tags in IC270.
5) Physically count items.
6) Enter item counts by page (IC72), in detail (IC73), or randomly (IC74). **
7) Run IC175 (Update Variances) in Nonupdate mode to print a variance report.
8) Optionally, explain variances with any count entry form.
9) Repeat steps #4 through #8 until are satisfied.
10) Run IC175 (Update Variances) in update mode.
11) Optionally, explain variances in IC76 (Variance Reasons). ***
12) Delete freeze records in IC179 (if delete option not selected in update).
** You can interface inventory counts processed by an outside source using
IC574 (Physical Inventory Interface).
*** You must delete freeze records before you can use the select ID again for
another physical inventory count. When you delete records depends on when you
explain variances. If you explain variances prior to update, you can delete
records in IC175 (Update Variances). If you explain variances after update,
you must delete records in IC179 (Delete Freeze Records).
Updated Files
CKPOINT - This file is used in the event of a program or system failure
to enable a batch update program to continue from where it left
off.
ICSELECT - Primary file maintained by program.
Referenced Files
BINGROUP - Used to validate bin group.
ICCOMPANY - Used to validate the existence of company number and display
the company name.
ICFREEZE - Used to verify the existence of freeze records before deleting
a select ID.
ICLOCATION - Used to validate the location and display the name.
ICRPTGRP - Used to validate report group entered as a parameter.
ITEMLOC - Used as a primary file to sequence by item within location.
ITEMMAST - Used to retrieve the item description information.
MAJORCL - Used to validate major sales class.
MINORCL - Used to validate minor sales class.
|
