Order Management System. What's new
← Version 1.37.15.0

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

Reports List from the Menu:

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

Report “Payments by Vendor Summary”:

  • Rules:
    • data is filtered by date and is grouped by Vendor;
  • Filters:
    • Date From / To -> required date pickers for separated date;
    • Vendor Name -> dropdown List;
    • Store -> 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;
      • Vendor;
      • Total Payments;
    • at the bottom of the Datagrid is displayed Total value:
      • Total = Sum (“Total Payments”);
    • After double clicking on the line item -> the “Payments by Vendor 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 Vendor Detail”:

  • Rules:
    • data is sorted by Vendor then by order date and then by payment number;
  • Filters:
    • Date From / To -> required date pickers for separated date;
    • Payment # -> textbox;
    • Vendor Name -> dropdown List;
    • Store -> dropdown List;
    • “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;
      • Vendor;
      • Store;
    • at the bottom of the Datagrid is displayed Total value:
      • Total = sum (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 Vendor Summary Report:
      • if for user the checkbox is unchecked:
        • “Payments by Vendor Summary” Report is hidden from the Report Menu List form;
    • Can View Payments by Vendor Detail Report:
      • if for user the checkbox is unchecked:
        • “Payments by Vendor Detail” Report is hidden from the Report Menu List form.