Order Management System. What's new
← Version 1.37.21.0

“Export Excel” button for Customer Credits

Customer Credit List from:

  • “Export” multibutton:
    • was added to the buttons panel at the top of List form;
    • was added for all buckets;
    • was added near the column picker;
    • contains:
      • “Export to with Items” button;
    • is always clickable;
    • after clicking on the button:
      • the OMS message is displayed:
        • Text: “How to build a report?”
        • radiobuttons:
          • Active Bucket -> it mean opened at the moment bucket -> is selected by default;
          • All Buckets;
        • buttons: 
          • Download:
            • after clicking on the button -> the excel based on the corresponding radio-button is printed;
          • Cancel:
            • after clicking on the button -> the pop-up is closed and nothing isn’t printed;
      • if no one line item in the Datagrid wasn’t selected -> the Excel file with all line items from the Datagrid is downloaded;
      • if line item in the Datagrid was selected -> the Excel file with the selected line item from the Datagrid is downloaded;
      • the columns are copied to excel based on the column selector;
      • Excel file contains next columns:
        • Credit #;
        • Customer;
        • Status;
        • Return Date;
        • Total;
        • Brand;
        • Category;
  • “Export to Excel with Items” button:
    • the logic is the same as “Export” button;
    • Excel file contains next columns:
      • Credit #;
      • Customer;
      • Status;
      • Return Date;
      • Item name;
      • Item Description;
      • Item Original Qty;
      • Item Return Qty;
      • Item Location;
      • Item Price;
      • Item Amount;
      • Total;
      • Brand;
      • Category.