to the Data
-> Parts Items -> Cross-references
screen, which displays cross-reference relationships between parts. The
part description displays to the right of the ID.Basic Info |
The Basic Info tab displays the results of an inventory snapshot and the recommended action.
When a count is entered for a part/bin, the count and a snapshot of the current total quantity on hand for that part/location are recorded. If there is a difference between the date and time of the snapshot and the date and time the part was counted, the data is analyzed and an adjustment is recommended. If there is a discrepancy between that calculated quantity on hand and the count, the status of the line item is set to DISCREPANCY.
The Count Analysis screen supports location-level access control, so you must belong to a user group with the applicable authorization to make updates on this tab.
Note: A record may not be modified unless its previous status was DISCREPANCY, NEED RECOUNT, or IN PROGRESS. A record that was previously IN PROGRESS may only be processed if its status is changed to NEED RECOUNT.
Tip: To limit the display of information in the grid and maximize performance, use the filter. You can sort on part ID/suffix, inventory location ID, count ID, and count status. Filter on count ID and the count status DISCREPANCY to display all records that need to be resolved.
Tip: When multiple parts have been sent to this screen because of a discrepancy and need to be set as needing a recount, this can be done one by one, or by using bulk editing. The screen must have access to the bulk editing option. Use the following process to edit multiple records at once to set the Count status as NEED RECOUNT. For more information about this process, refer to the Enterprise Portal Administrator Guide, Section 3. Understanding the Enterprise Portal, Enterprise Portal Screen Basics, The Toolbar, Edit, Bulk Record Editing.
Filter for the records that need their Count status changed.
Check the boxes next to the record rows that need changing. The selected rows will be highlighted orange, while the row that is displaying information in the screen is displayed as yellow.
Click Edit.
In the Count status list box, click NEED RECOUNT.
Click Save, the click OK.
The fields in the top section of this tab define the data that displays.
Part ID
Identifier of the part. This field has a zoom
button to the Data
-> Parts Items -> Cross-references
screen, which displays cross-reference relationships between parts. The
part description displays to the right of the ID.
Part suffix
Part suffix associated with the part ID.
Inventory location ID
Identifier of the inventory location. The location name displays to the right of the ID.
Count ID
Identifier of the inventory count.
The fields in the bottom section of the tab display the snapshot details.
Quantities
Count
Number of parts in the specified bin. This field is display only.
Unit of measure
Unit of measure of the part. This field is display only.
Total count (all bins)
Total quantity of all parts in all bins. This field is display only.
Unit of measure
Unit of measure of the part. This field is display only.
Current on hand
Quantity currently on hand in all bins at the specified location. This field is display only.
Unit of measure
Unit of measure of the part. This field is display only.
Transactions since count
Change in inventory quantity since the date and time the count occurred. This field is display only.
Snapshot when count recorded
Quantity on hand at the time that the user entered the count. This field is display only.
Transactions between count and snapshot
Sum of quantity change for transactions that were inserted between the count and the snapshot dates and times. This field is display only.
Expected count
Change in inventory quantity since the date and time of the actual count and the snapshot. This field is display only.
Suggested adjustment
Amount that the inventory needs to be adjusted to make the quantity counted equal to the quantity on hand. Calculated as the total count minus the expected count. May be positive or negative number.
If suggested adjustment is 0, Adjustment field displays NONE
If suggested adjustment is a positive number, Adjustment field displays ADD and Quantity field displays the absolute value of suggested quantity
If suggested adjustment is a negative number, Adjustment field displays SUBTRACT and Quantity field displays the absolute value of suggested quantity
Apply suggestion
If this field has a check, the specified adjustment is performed.
Apply suggestion to all counts listed
Check this field and apply the suggested amount to all records currently loaded in the grid that do not have the Count ID status completed.
Adjustment
Adjustment that should be taken to resolve the discrepancy. Must be NONE unless status is DISCREPANCY. This field has a choice list:
NONE: No action is taken
ADD
SUBTRACT
Quantity
Quantity to be adjusted. May not be a negative number. Must be zero if adjustment type is NONE. Must be greater than zero if adjustment type is either ADD or SUBTRACT. May not be greater than quantity on hand if adjustment type is SUBTRACT. Maximum field length is eight characters.
Current unit price
Unit price of the part. This field is display only. The value that displays depends on the pricing method:
If the pricing method is AVERAGE, the current average price of the part displays.
If the pricing method is FIFO, the oldest lot price of the part displays.
If the pricing method is LIFO, the newest lot price of the part displays.
Adjustment value
The value of the adjustment. This field is display only.
When an adjustment quantity is entered, the adjustment value is calculated as follows:
If the pricing method is AVERAGE and the adjustment type is either ADD or SUBTRACT, the adjustment value equals quantity * current unit price.
If the pricing method is LIFO, the adjustment type is ADD, and lots exist, the adjustment value equals quantity * the newest lot price.
If the pricing method is LIFO or FIFO, the adjustment type is ADD, and no lots exist, the adjustment value equals quantity * current unit price.
If the pricing method is LIFO or FIFO, the adjustment type is SUBTRACT, and no lots exist, the adjustment value equals quantity * current unit price.
If the pricing method is LIFO, the adjustment type is SUBTRACT, and the newest lot has sufficient quantity, the adjustment value equals quantity * newest lot price.
If the pricing method is LIFO, the adjustment type is SUBTRACT, and the newest lot does not have sufficient quantity, the adjustment value equals quantity * average prices of the lots used to fill the quantity.
If the pricing method is FIFO, the adjustment type is ADD, and lots exist, the adjustment value equals quantity * oldest lot price .
If the pricing method is FIFO, the adjustment type is SUBTRACT, and the oldest lot has sufficient quantity, the adjustment value equals quantity * oldest lot price.
If the pricing method is FIFO, the adjustment type is SUBTRACT, and the oldest lot does not have sufficient quantity, the adjustment value equals quantity * average prices of the lots used to fill the quantity.
Bin ID
Identifier of the bin in which the item is stored. This field is display only.
Date and time counted
Date and time (in MM/DD/YYYY HH:MM format) that the items were counted. This field is display only.
Date and time first bin counted
Date and time (in MM/DD/YYYY HH:MM format) that the first bin was counted. This field is display only.
Counted by user ID
Identifier of the user who entered the count. This field is display only.
Date and time recorded
Date and time (in MM/DD/YYYY HH:MM format) that the count was recorded. This field is display only.
Date and time snapshot
Date and time (in MM/DD/YYYY HH:MM format) that the snapshot was recorded. This field is display only.
Count status
Status of the count. You may only select DISCREPANCY, NEED RECOUNT, or NO ADJUSTMENT.
PENDING: Count has not been entered.
IN PROGRESS: Bin count has been entered but other bins for this part are in PENDING or NEED RECOUNT status.
COUNTED: Count was entered and matches the quantity on hand.
DISCREPANCY: Count entered did not match the quantity on hand.
RESOLVED: An adjustment was made to resolve the discrepancy between the count quantity and the quantity on hand.
NEED RECOUNT: Count was entered but it needs to be recounted. The adjustment could not be determined.
NO ADJUSTMENT: There was a discrepancy between the count quantity and the quantity on hand, but the user decided to not perform an adjustment to make the two match.
Once all parts have been counted and resolved, you can set the count status to COMPLETED on the Data -> Parts Activity -> Inventory Counts -> Inventory Count Management screen.