This report lists SKUs in your system that are likely Store Supplies or Coupons and have associated inventory value. These SKUs were likely expensed on your books but are also in your inventory valuation thereby decreasing cost-of-goods-sold and increasing gross profit. As stores build inventory value in store supplies and coupons they run the risk of inflating inventory valuation and taxable gross profits! This report is part of Mango's Level 2 - Dollar Accuracy Boundary Reports.

• Steps to process this report:

  The best practice for removing Store Supply from your inventory is to create a Credit PO to relieve this value.

  1. In Eagle Browser, open Purchasing and Receiving (MPO).
  2. Create a PO with the Order Type of 'C'. This changes the PO to a credit PO.

     • 

  3. Press the Add P.O. button (F4) to begin entering SKUs.
  4. Enter a SKU from the Store Supply report in the Item field and click the Display button.
  5. In the Order Qty field, enter in the current QOH so the net amount when finalized will be zero.
  6. Once all the items have been entered in from the report you can now finalize the PO.

  • A - Store: Eagle store ID.

    B - SKU: Item Number.

    C - Description:

    D - Location: Primary Location.

    E - QOH: Current as of the 1st of the month.

    F - Avg Cost: Average Cost.

    G - Ext. Avg Cost: QOH multiplied by average cost.

    H - Coupon: if it displays a signature of a coupon. Cost and Retail $0.01

    I - Already Taxed: been taxed by the warehouse.

  

• Steps to process this report:

  The best practice for removing Store Supply from your inventory is to create a Return PO to relieve this value.

  1. Select the Purchasing Order Menu.
  2. Click the Plus in the upper-right. 
  3. Create a PO with the Order Type of 'Return.' 

     • 

  4. Press Save.
  5. Click the Shopping Cart Icon to Add items.
  6. In the search box, type a SKU from your report and press Enter.
  7. Click the Check ☑ next to the SKU that was searched.
  8. In the Return Qty field, enter in the current QOH so the net amount when finalized will be zero.
  9. Click Add To Order in the bottom right.
  10. Once all the items have been entered in from the report you can now finalize the PO.

  • A - Store: Propello store ID.

    B - SKU: Item Number.

    C - Description:

    D - Location: Primary Location.

    E - QOH: Current as of the 1st of the month.

    F - Avg Cost: Average Cost.

    G - Ext. Avg Cost: QOH multiplied by average cost.

    H - Coupon: if it displays a signature of a coupon. Cost and Retail $0.01

    I - Already Taxed: been taxed by the warehouse.