Physical Inventory Posting (or PIP) is an Eagle viewer that shows pending physical counts and variances. Counts can be entered into PIP directly (F3) or via your RF gun. A variance is logged if the SKU's quantity-on-hand (Beg. Qty column in  PIP) differs from the quantity counted. The Variance column will adjust the SKU's quantity on hand when the PIP viewer is finalized (RPI), because of this behavior, sales and purchasing activity can continue in your store while variances are pending in PIP. For example, ifa SKU is showing a variance of -3 then 3 will be subtracted from the SKU's current quantity-on-hand at the time RPI is finalized. Finalizing PIP (via RPI) also updates the SKU's Date of Last Physical (Stocking tab Inventory Maintenance) which is used by Mango to track Count Sheet Completion.

PIP Tips: 

• List multiple location columns. Make sure Option ID 1136 is set to 3 or higher. This will make it easier to spot variance on items with multiple locations.
• Enter counts into PIP as soon as possible, a sale or purchase between the time of count and PIP entry will result in a bad count.
• When possible, use an RF gun to eliminate the bad count risk (above).
• Consider forcing ALL variances into PIP (see System Settings for Variance Control, Step 2) 
• Do not edit/correct counts in PIP, rather delete the row in PIP and reenter the count (this refreshes Beg. Qty in case it has changed).
• Add Mango Count Type as a column in PIP. Option ID 2071 needs to be set to YES.

• Inventory counts entered into PIP from Eagle Mobile+ updates the item’s quantity on hand only after the RPI is run. To create an RPI to finalize the inventory counts, follow the steps below.
  

  1. On the Eagle Browser Launch line, type RPI and press Enter.
  2. Set up the screens as indicated below:
     • Print Setup
       In the Print To field, select S – Spool Only
     • Options
       In the Reconcile Options field, select these options:
       F – Finalize Counting
       I – Change Location Codes
       S – Show Detail
       V – Print Variances Only
     • From / To
       No need to specify a range
     • Miscellaneous
       Print Sequence – Option 5 (Location/SKU)
       
     • Fax Setup
       No input is required.
  3. To run the report, click Run (F4).

• To add a column to your view, right-click on any of the header columns, click Select Column to view, pick any of the columns you wish, and finally click apply. Be sure to save the view so you won't need to repeat these steps each time.

  Loc, Loc 2, Loc 3 - can be useful in making sure multiple locations were counted, especially when there is a variance

  Variance - useful to sort on any high QTY variances

  Repl Cost Variance - most important to see the dollar amount of the pending event

  Mango Count Type - if the SKU was reported on your Count Sheets it'll have a corresponding Count Type which is the reason the SKU was reported. (Eagle Level 32.1 and higher. OPT ID 2071 = Y)