Physical Inventory: Counting with Epicor Worksheets

This job aid describes the process for taking a physical inventory using count sheets generated by the Epicor Eagle™ system. Refer to other job aids if you are using your own forms for count sheets. Do not use this job aid if you are using an RF gun to take inventory.

Before you begin, read the topics in the Getting Started book in online help. From the Contents tab, open the Inventory book, then open the Physical Inventory and Shrinkage book.

 

 

QPIP compared to PIP

PIP

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.

 

1

Create and print count sheets

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

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

  3. At Load Options, select L Load Items to Count.

  4. At Count Sheet Options, select:

  5. 3 - Show 3 blank columns (optional)

  6. M - Show mfg part num (optional)

  7. Q - Show quantity (optional)

  8. X - Exclude detail

  1. Click From / To. 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.

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

 

2

Count items

Using the count sheets you created in the previous section, count the items. Make an entry for every item on the count sheet, either the on-hand quantity that was counted or a zero if none were found.

3

Post the counts

If using QPIP, do the following:

  1. From the Eagle Browser, click Applications,  then click Inventory menu. Click Physical Inventory Posting (PIP).

  2. From the toolbar, click QPIP.

  3. Type the SKU and type the quantity.

  4. Press Enter or click OK.

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

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, click Applications, then click Inventory menu. Click Physical Inventory Posting (PIP).

  2. Click Display. 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.

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

QPIP

 

PIP

 

4

Finalize the counts

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

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

  3. At Reconcile Options, select:

  4. D - Double spacing (optional)

  5. F - Finalize counting

  6. U - Unposted items assume zero variance

  7. X - Exclude detail

  1. Click From / To. Enter the same range you used when creating and printing the count sheets (in section 1 above).

  2. Click Run.

5

Verify the posted 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.