“Collection” Report

Reports List from the Menu:

• was added the new Report to the List:
  • Collection Report;
• after clicking on the report -> corresponding form of Report is opened.

“Collection” Report List form:

• Rules:
  • is displayed the List of Customer Balance based on the Customer Transactions;
  • if the Customers have Parents / Childs Customers -> Customers are displayed in the hierarchy as in the Customer List;
  • data is sorted by Customer then by order date;
• Filters:
  • Date From / To -> required date pickers for separated date;
  • Customer -> dropdown List;
  • Sales Rep -> dropdown List;
  • “Open Balance only” checkbox:
    • is checked by default;
    • if the checkbox is checked -> in the Datagrid are displayed only Customers with Open Balance not equal 0;
  • “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;
    • Customer Name;
    • Sales Rep;
    • Phone;
    • Order Type;
    • Order Date;
    • Order Number; 
    • Order Total;
    • Customer Balance:
      • Customer Balance = Order Total – Payment;
    • Aging;
  • At the bottom are displayed next totals:
    • Total Amount;
    • Total Open Balance;
• “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 Collection Report:
    • if for user the checkbox is unchecked:
      • “Collection” Report is hidden from the Report Menu List form.