“A/R Aging Summary” Report

Reports List from the Menu:

• was added the new Report to the List:
  • A/R Aging Summary;
• after clicking on the report -> corresponding form of Report is opened.

Report “A/R Aging Summary”:

• Rules:
  • data is filtered by date and is grouped by Customer;
  • the report contains a list of customers’ with unpaid invoices since the time the sales invoice was issued along with their duration;
  • in the report are calculated past due invoices for specific period:
    • invoices are calculated for which the number of days at the current moment, starting from the due date, did not exceed N days;
    • N day – displays in a column;
  • If the Customers have Parents / Childs Customers -> Customers are displayed in the hierarchy as in the Customer List;
• 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;
    • Open Balance -> Current balance owing;
    • 1 – 30 Days -> A/R aged balances between 1 – 30 days;
    • 31 – 50 Days -> A/R aged balances between 31 – 50 days;
    • 51 – 60 Days -> A/R aged balances between 51 – 60 days;
    • 61 – 80 Days -> A/R aged balances between 61 – 80 days;
    • 81 – 90 Days -> A/R aged balances between 81 – 90 day
    • > 90 Days -> A/R aged balances greater than 90 days;
    • Total -> Total = (1 – 30 Days) + (31 – 50 Days) + (51 – 60 Days) + (61 – 80 Days) + (81 – 90 Days) + ( > 90 Days);
  • After double click on the customer row -> the “Customer Balance Detail” Report is opened;
• Totals at the bottom:
  • totals are calculated for each 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:

• was added new permission to Reports tab -> Reports List:
  • Can View A/R Aging Summary Report:
    • if for user the checkbox is unchecked:
      • “A/R Aging Summary” Report is hidden from the Report Menu List form.