TABLE OF CONTENTS

Inventory Count Unmatched


The Inventory Count Unmatched utility assists users in reviewing inventory items that were counted during the inventory count but do not appear on the count sheet lines. This utility provides a comprehensive list of items, allowing users to:

  1. Examine items that were recorded but not found on the count sheet.
  2. Choose whether to process these items as miscellaneous receipts, providing a reason code to justify the adjustment.
  3. Execute miscellaneous receipts in bulk for efficiency, ensuring that inventory records are accurate and up-to-date.

The fields in the listing are: 


FIELDDESCRIPTION

Trans. Num

A unique identifier for each discrepancy recorded.

Count Date

The date on which the item was counted. Helps in auditing and tracking inventory adjustments over time.

Item

The identifier of the item that was scanned.

Description

A brief description of the item to assist with quick recognition. 

Lot Number

The lot number that was counted

Location

The location where the item was actually counted.

UOMUnit of Measure
Qty CountedThe quantity of the item that was counted during the inventory session.
CounterIdentifier of the personnel who performed the counting.
WarehouseThe warehouse where the item was actually counted.
Status

The review status of the unmatched entry. Options include:

  • Add: To be added to inventory via Misc Receipt.
  • Reject: The item should not be added to inventory.
  • Empty: Pending review (initial status).

Note: If the review status is "Processed," the status dropdown will be disabled and blank.


Reason Code

Linked to the 'Misc. Receipt Reason Code'. This field is:

  • Enabled and required if "Add" is selected.
  • Disabled and blank if the status is not set to "Add".


The default value is determined by the Transaction Parameter settings. Users can select a different Misc Reason Code, provided it exists in the Reason Code master file, applicable to Misc Receipt transaction types.


RemarksAn editable field for additional notes, limited to 100 characters.
Action

A clickable icon that allows supervisors to view detailed location and lot-specific information for the item. This assists in verification and auditing.


Note: The system will route to the Item Lot Location List form if the item is lot-tracked, or the Item Location List form if non-lot tracked, and auto-filter the list by Item, Lot, Location, and Warehouse.


  1. Review the list of items and update the Status of each item as needed.
  2. If you decide to perform a miscellaneous receipt, enter the appropriate Reason Code to justify the adjustment.
  3. Enter any additional notes or explanations in the Remarks field if necessary.
  4. Click on the Action icon to view detailed information about the item’s location or lot. This helps in verifying and understanding the discrepancies.
  5. Select the checkboxes for the records you wish to save, then click on the Save button to apply the changes.
  6. Click Export to Excel button to export the result into Excel format.
  7. Click Export to CSV button to export the result into CSV format.
  8. Select the checkboxes for records with the status set to Add and click on the Process button to perform miscellaneous receipt transactions in bulk.
  9. Check the results of the process in the Material Transactions form under the History tab in the Web application. 

Lot Expiry Date Update


The Lot Expiry Date Update utility allows users to update the expiry date of lots in bulk using the Reference Number or other relevant fields. This ensures efficient management of expiry dates post-transaction e.g. PO receipt, enabling users to perform mobile transaction first and update expiry dates later. 

 


The fields in the listing are:

FIELDDESCRIPTION
CheckboxDefault checked. Select/deselect lots for expiry date update.
ItemDisplays the item code.
DescriptionDisplays the item description.
Lot NumberDisplays the lot number. Click to open the "View Lot" form.
Expiry DateDisplays the current expiry date of the lot.
Manufacturing DateDisplays the manufacturing date of the lot.
Lot SourceDisplays the source of the lot (e.g., PO Receipt, Job Receipt).
Reference NumberDisplays the reference number (e.g., PO Number, JO Number).
Reference LineDisplays additional reference details (e.g., PO Line, JO Suffix).
First Received DateDisplays the date when the lot was first received.
Vendor LotDisplays the vendor's lot number (if applicable).
  1. User inputs the new Expiry Date for the lot.
  2. User may filter result by:
    1. Item- Filter field to specify the item for which the expiry date needs updating.    
    2. Lot Number- Filter field to specify a range of lot numbers for expiry date updates.    
    3. Lot Source - Dropdown to select the source of the lot (e.g., PO Receipt, Misc. Receipt).    
    4. Reference Number, Line/Suffix - Filter field for selecting reference number and line/suffix (e.g. PO Number and Line, JO Number and Suffix)
    5. First Received Date - Filter field to specify the date when the lot was first received.
  3. Select Preview radio button to review the Lot expiry date in the list before applying the changes based on the selected new Expiry Date.
  4. Click the Process button to filter result.
  5. Check or uncheck the checkboxes as needed; only records with checked checkboxes will be processed.
  6. Once you have reviewed and confirmed the records in the list, select the Commit mode and click the Process button to proceed with the expiry date changes.