Level 0 - PIP Overview

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.

Recommended PIP Columns

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.

• 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)

Adding colors to your grid

To add colors to your view, right-click on the header you want to add a color to, click Set Alerts On ..., pick a color Alert, select a condition and a value, and finally click Set Color Alert. Some examples are provided based on the screenshot below.

• Loc 3 - set Green alert, Is Not Blank
• Repl Cost Variance - 2 alerts - set Yellow alert, Is Not Between -20 and 20. Set Red Alert, Is Not Between -50 and 50
• Mango Count Type - set Yellow alert, Contains XX
• Store Closeout - set Yellow alert, Contains Y

Save the view for future use

To Save this view with the columns, alerts, etc., click File in the upper-left header, click Save View, click​ Physical Inventory Posting and Save, and finally click Yes to replace existing

​