Error Detection on Stock Controls

Why stock is tedious task to maintain? Because there is no system.
a) product price changes due to inflation, do not know which stock is old and new.
b) product costing changes due to promotion such as buy 1 free 1
c) same product put everywhere within warehouse and shop.

01. Detection on Stock Quantity < 0, Stock Quantity = 0
     * Go to Reports > Sales Order Status Report > Zero Available Stock

02. Detection on Stock Quantity > Limit
     * Go to Reports > Inventory Reports > Physical Worksheet
     * Post to Ms. Excel, sort by Quantity

   

03. Detection on Cost > Selling Price, Cost <= 0, Selling Price <= 0, Markup > Limit, Margin > Limit.
     * Go to Reports > Sales Reports > Profit Margin > By Product
      * From here, Gross Profit must tally with Accounts Gross Profit Margin.

   

04. Detection on old stocks or mistake entry such as double code for same product?
      * Go to Reports > Inventory Reports > Stock Aging Report

    

05. Detection on stock value on how money being invested on
      a) old products,
      b) not popular products
      c) damage products
      d) popular products
      * Go to Reports > Inventory Reports > Stock Aging Report
      * This value when put into Accounts, it must tally with Gross Profit Margin.

     
 

06. To Proof Selling below Cost, Stock over order, To track Cost Price and Selling Price.
       * Go to Transactions > Historical Records > List Historical Price

    
 

07. To Proof Top Selling Product Achieve Profit Margin, tally with Accounts.
       * Go to Reports > Sales Reports > Top 50 Products
       * by Sales Quantity and Sales Value

      

08. A smart program should be written as below with a single touch or button for detection.