Physical Inventory: Counting with Other Worksheets

This job aid describes the process for taking a physical inventory using your own count sheet forms (and not count sheets generated by the Eagle system). Refer to other job aids if using Epicor generated 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.

 

 

PIP compared to QPIP

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

Load items

  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, spool the report, do not print it. Then click Options.

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

  4. At Count Sheet Options, select:

  5. M - Show mfg part num (optional)

  6. Q - Show quantity (optional)

  7. X - Exclude detail

  1. Click From / To. Usually, enter a department range so that all items in the area you count are loaded. When you finalize your counts, use the same from and to range.

  2. Click Run to load items into the count file.

 

2

Count items

Using your own count sheet forms, count the items. Record the SKU and in-stock quantity. Including a description is optional, but can help to verify errors after counting.

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. If a count has already been posted for a SKU, the next quantity you enter will replace the original count entered (it does not add the two counts together).

  4. Press Enter or click OK.

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

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 (first time)

  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. F - Finalize counting

  5. X - Exclude detail

  1. Click From / To. Enter the same range you used when loading items (in section 1 above).

  2. Click Miscellaneous. At Print Sequence, select 5.

  3. Click Run to print the report.

 

5

Look for missing inventory

  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 Count Sheet Options, select:

  4. M - Show mfg part num (optional)

  5. O - Only report unposted items

  6. Q - Show quantity (optional)

  7. X - Exclude detail

  1. Click From / To. Enter the same range you used when loading items (in section 1 above).

  2. Click Run to print the report.

  3. Use the Epicor generated count sheets to scan the BEGIN QTY column for items that have a quantity on file.

  4. Research any item that has a quantity on file but was not counted. Make corrections in PIP or QPIP.

6

Finalize the counts (second time)

  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. F - Finalize counting

  5. K - Uposted items assume a zero count

  6. X - Exclude detail

  1. Click From / To. Enter the same range you used when loading items (in section 1 above).

  2. Click Miscellaneous. At Print Sequence, select 5.

  3. Click Run to print the report.

7

Verify the posted counts

Take both finalized RPI reports (from section 4 and section 6 above) and scan the VALUES Variance column. Look for SKUs with a large variance amount. This could indicate an error in counting or in posting the counts. Research any SKUs that might be incorrect.