Store Supplies and Coupons

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.

      • Store_Supplies_CreditPO_Example.png

    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.
      • The SKU has QOH other than zero.
      • The SKU matches Mango's internal store supply listing (common warehouse store supply SKUs).
      • The SKU has STORE as a location code (best practice).
      • The SKU has a coupon signature: Location of CRED, or a retail of 0.01 and a cost of 0.01.

    • It is important to understand the difference between Store Supply and Store Use. Store Supply is not inventory, rather they're items that we do not sell (or very rarely) sell to our customers. Examples include shelving, peg hooks, or vests. Alternatively, Store Use items are regular inventory that we sell to our customers but also use in our stores from time to time. These are items like knives, packaging tape, or toilet paper and are rung out at the register through your store’s house account.

    • EXT AVG. COST - The extended value of the SKU by multiplying its QOH times its Average Cost.

      COUPON - If a SKU exhibits a Coupon signature then a 'Y' may be listed in this column. For these SKUs, you may consider setting the Keep Stock Info option to N.

      ALREADY TAXED - This column will indicate if the SKU is in a class of SKUs for which sales tax has already been collected via your Ace statement.

  • 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.' 

      • Propello_Return_PO.png

    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.
      • The SKU has QOH other than zero.
      • The SKU matches Mango's internal store supply listing (common warehouse store supply SKUs).
      • The SKU has STORE as a location code (best practice).
      • The SKU has a coupon signature: Location of CRED, or a retail of 0.01 and a cost of 0.01.

    • It is important to understand the difference between Store Supply and Store Use. Store Supply is not inventory, rather they're items that we do not sell (or very rarely) sell to our customers. Examples include shelving, peg hooks, or vests. Alternatively, Store Use items are regular inventory that we sell to our customers but also use in our stores from time to time. These are items like knives, packaging tape, or toilet paper and are rung out at the register through your store’s house account.

    • EXT AVG. COST - The extended value of the SKU by multiplying its QOH times its Average Cost.

      COUPON - If a SKU exhibits a Coupon signature then a 'Y' may be listed in this column. For these SKUs, you may consider turning off Track Inventory.

      ALREADY TAXED - This column will indicate if the SKU is in a class of SKUs for which sales tax has already been collected via your Ace statement.