Order Management System. What's new
← Version 1.36.52.2

“Payments by Rep Summary” / “Payments by Rep Details” Reports

Reports List from the Menu:

  • were added the next Reports to the List:
    • Payments by Rep Summary;
    • Payments by Rep Detail;
  • after clicking on the reports -> corresponding forms of Reports are opened.

Report “Payments by Rep Summary”:

  • Rules:
    • data is filtered by date and is grouped by Rep;
    • If the Sales Rep Customers have Parents / Childs Customers -> data is displayed in the hierarchy as on the Customer List;
  • Filters:
    • Date From / To -> required date pickers for separated date;
    • Customer Name -> dropdown List;
    • Store -> dropdown List;
    • Sales Rep -> list for multiple selection:
      • near the each of Sales Rep is displayed checkbox;
      • if the checkbox is checked -> only checked Sales Rep are displayed in teh Datagrid;
      • if nothing was checked -> are displayed all Sales Rep;
    • “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;
      • Sales Rep;
      • Customer;
      • Amount;
    • at the bottom of the Datagrid is displayed Total value:
      • Total = Sum (“Amount”);
  • After double click on the item row -> the “Payments by Rep Details” Report is opened;
  • “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.

Report “Payments by Rep Detail”:

  • Rules:
    • data is sorted by Rep then by order date and then by payment number;
    • If the Rep Customers have Parents / Childs Customers -> they are displayed in the Datagrid;
  • Filters:
    • Date From / To -> required date pickers for separated date;
    • Customer Name -> dropdown List;
    • Store -> dropdown List;
    • Sales Rep -> list for multiple selection:
      • near the each of Sales Rep is displayed checkbox;
      • if the checkbox is checked -> only checked Sales Rep are displayed in teh Datagrid;
      • if nothing was checked -> are displayed all Sales Rep;
    • “Search” button:
      • is always clickable;
      • after clicking on the button -> the Datagrid is filtered based on the selected filters;
  • Datagrid:
    • contains next columns:
      • checkbox;
      • Date -> Date of Payment;
      • Payment Number;
      • Amount -> from Payment;
      • Customer;
      • Sales Rep;
      • Store;
    • at the bottom of the Datagrid is displayed Total value:
      • Total = sum (of Amount column);
  • “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:

  • were added new permissions to Reports tab -> Reports List:
    • Can View Payments by Rep Summary Report:
      • if for user the checkbox is unchecked:
        • “Payments by Rep Summary” Report is hidden from the Report Menu List form;
    • Can View Payments by Rep Detail Report:
      • if for user the checkbox is unchecked:
        • “Payments by Rep Detail” Report is hidden from the Report Menu List form.