Inventory Physical Count - Keystone

Purpose:

This function enables the user to enter physical count information by location.

Usage:

Now prepends the lot number with the first character of the lot status.

Untested lots are no longer allowed to be entered into the physical inventory record.

Quantities for rejected lots now posted to qntty-rjctd rather than qntty-on-hnd.

Compute Adjustments now takes lot's status into account.

Make Uncounted Entries now takes lot's status into account.

Step 0: (Optional)

Many users run a custom report that lists the inventory items at the location being counted. This report is used for the physical counting process, and then is used as the input document in step 1.3a. Contact your Data-Basics support representative for additional information.

Step 1: Initial Generation Of the Physical Count Batch

User brings up a blank Physical Count Batch in the Physical Count Viewer.

The following information must be entered: Location Id and Count Date (which serves as the effective date of the transaction) .

When you click the Add Record button, the System generates a Physical Count Batch based on the data entered by the user. A Batch Id is automatically assigned to the new batch.

Step 2: (Optional)

If you did not print a custom report to use as the input for recording the physical count, click the Print Report button, and flag the “Include Missing Items” box. A report listing all items the system thinks are at this location will appear.

The reported will be sorted by Count Location and Item Id.

Step 3: Entering Of Count Information

The user brings up the desired batch in the Physical Count Viewer.

The user enters the quantity counted and optionally the counter’s Id for each Inventory Item counted.

To enter adjusting entries for items that did not appear on the shelf, click the Uncounted Entry button.

The user presses the Change (Delta) button to save the updated batch.

Step 4: Computing Adjustments

The user brings up the desired batch in the Physical Count Viewer.

The user presses the Compute Adjustments Button

The system compares the entered counts to the on-hand quantities computed from the Inventory History file. The batch’s Count Date (which must be filled in) is used as the cutoff for the Effective Date field in the Inventory History file. This results in the on-hand quantities being computed as of the specific date.

The appropriate adjusting quantities are computed and added to the batch lines.

The user presses the Change (Delta) button to save the updated batch.

Step 5: Reviewing The Results

The user brings up the desired batch in the Physical Count Viewer.

The user presses the Print Report Button

A report summarizing the batch is printed.

Step 6: Posting The Adjustments

The user brings up the desired batch in the Physical Count Viewer.

The user presses the Post Adjustments Button.

Adjusting entries are made into the Inventory History file, which make the on-hand quantities match the counted quantities.

NOTE: No adjusting GL entries are made.

Warning: Prior to posting, Recompute Adjustments should be run if any historical information may have been changed.