“Commission” Report modification

“Commision” Report was updated:

• Buckets:
  • were deleted Buckets on the top;
  • Billed Commision / Unbilled Comission:
    • new buckets were added;
    • checkboxes are deleted from the filter panel;
    • Billed Commisions -> are dispalyed users with Invoice / Customer Credits with created Bill;
    • Unbilled Commisions -> are dispalyed users with Invoice / Customer Credits without created Bill;
• Filter Panel:
  • was updated Date picker in filter panel:
    • to the datepicker were added:
      • Today;
      • This week;
      • This Month;
      • This Quater;
      • This Year;
      • Last Week;
      • Last Month;
      • Last Quater;
      • Last year;
    • if user clicks one time on the day in the calendaer -> the value is set up into the “To” field instead of “From”;
• Right section was deleted;
• Datagrid:
  • Rules:
    • by default is displayed list of users with fully paid Invoices and Customer Credits;
  • Columns:
    • Sales Rep:
      • nothing changed;
    • Order #:
      • are displayed Invoice numbers and Customer Credits instead of Sale orders;
    • Order Date;
    • Customer;
    • Order Total;
    • Commision %;
    • Penalty %;
    • Commision:
      • is required;
      • is displayed the commision value calculated based on percent;
      • for Invoice positive value;
      • for Credits negative value;
    • Open Balance:
      • is displayed the Invoice Open Balance;
    • Payment Date:
      • is displayed the max from payment date or date of appliement;
    • Days to Pay:
      • difference between Payment day and Invoice Day;
    • COGS:
      • is taken from Invoice list;
    • Gross Margin:
      • is taken from Invoice list Net Total;
    • Margin %:
      • is taken from Invoice list Net %;
• Create Bill button:
  • if nothing is checked or checked only Billed orders -> the button is disable;
  • if user doesn’t have linked Sales Rep -> the tooltip is displayed: “Sales Rep is not configured. It will be skipped on bill creation”;
  • after clicking on the button:
    •  for each user is opened separate Bill;
  • in Opened Bill:
    • Vendor:
      • is taken from the Sales Rep;
    • COA:
      • is taken from the Sales Rep;
    • Amount
      • from the Commission field:
        • user can change amout;
      • for Invoice positive value;
      • for Credits negative value;
    • Customer
      • from linked Invoice/Credit;
    • once Bill has been saved it’s linked to Invoice/Customer credit and Invoice/Customer credit is moved to Billed Commission bucket (on Report from) even if user make Amount in Bill greater or less than Commission.