Reports fo Vendors

Reports List from the Menu:

• were added next Reports to the List:
  • A/P Aging Summary;
  • Vendor Balance Summary;
  • Vendor Balance Detail;
• after clicking on the report -> the corresponding form of Report is opened.

Report “A/R Aging Summary”:

• Rules:
  • data is filtered by date and is grouped by Vendor;
  • the report contains a list of vendors with unpaid bills since the time the bill was issued along with their duration;
  • in the report are calculated past due bills for a specific period:
    • bills 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;
• Filters:
  • Date Range;
  • “Vendor” drop-down;
  • “Open Balance only” checkbox;
  • “Include PO” checkbox;
  • “Search” button;
• Datagrid:
  • checkboxes;
  • Vendor Name;
  • Open Balance -> Current balance owing;
  • 1 – 30 Days -> A/P aged balances between 1 – 30 days;
  • 31 – 50 Days -> A/P aged balances between 31 – 50 days;
  • 51 – 60 Days -> A/P aged balances between 51 – 60 days;
  • 61 – 80 Days -> A/P aged balances between 61 – 80 days;
  • 81 – 90 Days ->A/P aged balances between 81 – 90 days;
  • > 90 Days -> A/P 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);
• Totals:
  • totals are calculated for each column;
• After double clicking on the Vendor row -> is opened “Vendor Balance Detail” Report filtered by Date and Vendor;
• “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 “Vendor Balance Summary”:

• Rules:
  • data is filtered by date and is grouped by Vendor;
  • is displayed the List of all Vendors in the System;
• Filters:
  • Date Range;
  • “Vendor” drop-down;
  • “Open Balance only” checkbox;
  • “Exclude In Review” checkbox;
  • “Search” button;
• Datagrid:
  • checkboxes;
  • Vendor Name;
  • Open Balance:
    • is taken from Vendor Center -> Open tab;
• Total -> is displayed under datagrid:
  • Total = sum(Open Balance);
• after double-clicking on the vendor row -> the “Vendor Balance Detail” 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 -> all lines from datagrid are downloaded;
• was added column selector.

Report “Vendor Balance Detail”:

• Rules:
  • the List of Vendor Balances based on the Vendor Transactions is displayed;
  • data is sorted by Vendor and then by order date;
• Filters:
  • Date From / To -> required date pickers for separated date;
  • Vendor -> dropdown List;
  • “Order Type” dropdown List;
  • “Open Balance only”  checkbox:
    • is checked by default;
    • if the checkbox is checked -> in the Datagrid are hidden Customers with Open Balance = 0;
  • “Include Purchase Order” checkbox;
  • “Search” button;
• Datagrid:
  • contains next columns:
    • checkboxes;
    • Vendor;
    • Order Type;
    • Order Date;
    • Due Date;
    • Order Number;
    • Order Total;
    • Open Balance;
    • Aging;
• At the bottom are displayed next Totals:
  • Total Amount -> the sum of Order Total Amounts;
  • Total Open Balance -> the sum of Open Balances;
• “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 A/P Aging Summary Report:
    • if for user the checkbox is unchecked:
      • “A/P Aging Summary” Report is hidden from the Report Menu List form;
  • Can View Vendor Balance Summary Report:
    • if for user the checkbox is unchecked:
      • “Vendor Balance Summary” Report is hidden from the Report Menu List form;
  • Can View Vendor Balance Detail Report:
    • if for user the checkbox is unchecked:
      • “Vendor Balance Detail” Report is hidden from the Report Menu List form.