Job Aid: How To Physically Count Inventory Using Epicor Worksheets

 

Use this job aid procedure to manually count your inventory using Epicor-generated worksheets. You should review Physical Inventory and Shrinkage in this online help Getting Started material before performing a manual count.

Note: If you are using and RF gun to count inventory, use the XYZ job aid instead.

Overview:  PIP versus QPIP

There are advantages to QPIP when you have a smaller inventory count to perform:

Physical Inventory Posting (PIP)

Quick Physical Inventory Posting (QPIP)

  • Post up to three counts and locations per SKU for a single shrinkage type.

  • Post one difference amount per SKU for a single shrinkage type.

  • Add or change location codes for SKU records.

  • Change shrinkage types for SKU records.

  • Display and view SKU information.

  • Use Add to post counts or Change for previously loaded counts.

  • Erase a posting from the count file with Delete.

  • Post only to the default shrinkage type.

  • Post only to SKUs that have locations codes (or an empty location value specified if loaded with RPI report).

  • Change the QTY field (for a count previously posted in PIP or QPIP).

  • Use Enter to post counts.

Part 1: Create and Print Count Sheets

To create and print count sheets:

  1. From the Eagle Browser Applications > Reports menu, select Inventory Reports and then Physical Inventory (RPI).

  2. Enter your print options on the Print Setup page, then select Options.

  1. At the Load Options prompt, select L Load Items to Count.

  2. At the Count Sheet Options prompt, select one of the following:

  1. Click From / To.

Note: Usually, enter a department range so that all items in the area you count are loaded and printed. When you finalize your counts, use the same from and to range.

  1. Click Run to load items into the count file and to print the count sheets.

Part 2: Count the Items

Using the count sheets you created in the previous section, count the items.

Be sure to enter a count for every item on the count sheet: either the on-hand quantity that was counted or a zero if none were found.

Part 3: Post the Counts

If using QPIP, do the following:

  1. From the Eagle Browser Applications > Inventory menu, select Physical Inventory Posting (PIP).

  2. From the toolbar, select QPIP.

  1. Type the SKU and enter the quantity.

  2. Press Enter or click OK.

  3. Repeat steps 3 and 4 for all items on the count sheet.

Note: To save time, do not post a SKU if the count is the same as the beginning quantity. You can use the system to automatically post a zero variance when you finalize the count.

If using PIP, do the following:

  1. From the Eagle Browser Applications > Inventory menu, select Physical Inventory Posting (PIP).

  2. Click Display.

Note: For each SKU, type the quantity counted and location code. Use the mouse to click the field you want to update or use the arrow and enter keys to move to the field.

  1. After all counts have been entered, click Change.

Part 4: Finalize the Counts

  1. From the Eagle Browser Applications > Reports menu, select Inventory Reports and then Physical Inventory (RPI).

  2. Enter your print options on the Print Setup page, then select Options.

  1. At the Reconcile Options prompt, select:

  2. D - Double spacing (optional)

  3. F - Finalize counting

  4. U - Unposted items assume zero variance

  5. X - Exclude detail

  1. Click From / To.

Note: Enter the same range you used when creating and printing the count sheets (in section 1 above).

  1. Click Run.

Part 5: Verify the Counts

The finalized RPI report from the previous section should match, line for line, with the count sheets.

You can fold the final sheets so that the posted count can be laid beside the hand written count and quickly compared to verify the correct count was posted.