“Daily Sold by Vendor” Report

Reports List from the Menu:

• was added the next Report to the List:
  • “Daily Sold by Vendor” Report;
• after clicking on the report -> the corresponding form of the Report is opened.

Report “Daily Sold by Vendor”:

• Rules:
  • data is filtered by date and is grouped by day and then is grouped by Vendor;
• Filters:
  • Date From / To -> required date pickers for separated date;
  • Item Name -> dropdown List;
  • Description -> textbox;
  • Vendor Name -> dropdown List;
  • Category -> dropdown List;
  • “Search” button:
    • is always clickable;
    • after clicking on the button -> the Datagrid is filtered based on the selected filters;
• Datagrid:
  • were added next columns:
    • checkboxes;
    • Date;
    • Item Name;
    • MPN;
    • Description;
    • Sold Qty;
    • Return Qty;
    • Qty;
    • Sale Amount;
    • Return Amount;
    • Discount;
    • Total Amount;
    • Vendor;
  • At the bottom are displayed next Total values:
    • Total Sales Amount;
    • Total Return Amount;
    • Total Discount;
    • Total Amount;
• “Export to Excel” button:
  • after clicking on the button the excel is downloaded with data from datagrid;
  • if some lines are checked -> are downloaded only checked lines;
  • if no one line is checked -> are downloaded all lines from datagrid;
• was added column selector.

OMS Web -> Settings -> Permission:

• was added new permission to Reports tab -> Reports List:
  • Can View Daily Sold by Vendor Report:
    • if for user the checkbox is unchecked:
      • “Daily Sold by Vendor” Report is hidden from the Report Menu List form.