Tweaks for Inventory Reports

The “Inventory Cost Management” Report List form:

• Rule:
  • in the Datagrid are displayed inventory adjustments with qty = 0 and negative qty;
• Datagrid:
  • “Date” column:
    • was added after the checkboxes;
    • also, was added to the:
      • column selector
      • Excel file;
    • is displayed the date of inv adjustment;
  • “Stock Qty” column:
    • was added after the “Used by Source #” column;
    • also, was added to the:
      • column selector
      • Excel file;
    • is displayed the qty in stock that was before the adjustment:
      • Stock qty = (in stock + available qty) before the adjustment;
  • “Adjust Qty” column:
    • was added after the “Stock Qty” column;
    • also, was added to the:
      • column selector
      • Excel file;
    • is displayed the “New qty” from the adjustment.

The “Inventory Valuation Detail” Report List form:

• Filters panel -> Bug was fixed:
  • “Store” drop-down:
    • if the “Store” drop-down is filled -> the Search is worked.

The “Inventory Valuation Summary” Report List form:

• Datagrid:
  • “Avg Sales Price” column:
    • the logic was changed;
    • the avg cost for the item is calculated like the Running balance;
    • if the user increased the stock the last avg is always recalculated;
    • if the user decreases the stock, the last avg COGS will not change (froze);
    • for example:
      • Item Apple  cost = 1       qty = 1      Avg Sales Price = $1.00;
      • stock was increased by  qty = 10    Cost = $ 1.27;
      • Avg Sales Price  will be recalculated and be:
        • Avg Sales Price = ((1 * $1.00) + (10 * 1.27)) / 11 = 1.25;
      • the stock was decreased by qty = 5;    
      • Avg Sales Price will not be recalculated and be:
        • Avg Sales Price = 1.25;
      • stock was increased by  qty = 15   Cost = $ 2.00:
        • Avg Sales Price = ((0 * $1.00) + (6 * 1.27) + (15 * 2.00)) / 21 = 1.79142; 
      • zero qty -> because the item was sold from stock.