The “Inventory Cost Management” Report List form

Reports List:

• “Inventory Cost Management” report:
  • the new report was added to “Report -> Inventory”;
  • is displayed if permission “Show Cost” is switched on;
  • report contains:
    • Filter panel:
      • “Date Range” datepicker;
      • “Item Name” drop-down:
        • Search by item name and description;
      • “Added by Source #” textbox:
        • search by orders which added inventories to store:
          • Adjustment;
          • Customer credit;
          • Bill;
          • IR;
          • Invoice;
          • Transfer Order;
      • “Used by Source #” textbox:
        • search by orders which allocated item from store:
          • SO;
          • Invoice;
          • Assembly Order;
          • Transfer Order;
      • “Store” drop-down;
    • Datagrid:
      • all fields read-only except COST;
      • displays the list of inventories linked to Source # in filter panel;
      • contains next columns:
        • checkbox;
        • Date;
        • Item Name;
        • Description;
        • Added by Source #;
        • Used by Source #;
        • COST:
          • is required;
          • is editable;
          • only numbers are allowed;
          • decimal field;
          • by default displays the item cost of inventory which is linked to the Source #;
        • Store;
    • “Apply Cost” button:
      • after clicking on the button -> the message is displayed: “Do you want to change item cost in related orders? Yes / NO”:
        • No:
          • the cost will be changed only in the inventory table and will not be changed in a specific order;
        • Yes:
          • the cost will be changed in the inventory table and in the specific order:
            • Adjustment;
            • Bill;
            • IR;
    • Column Selector;
    • “Export to Excel” button.

Average COGS popover:

• “View Cost” button:
  • was added;
  • after clicking on the button -> the Inventory Cost Management report is opened and filtered by linked Source # / Store / Date range.