“Export” multi-button on the Bill List form

Bills List from:

• “Export” multibutton:
  • was added to the buttons panel at the top of List form;
  • was added for all buckets, except Consignment;
  • was added next to the “Add PO Items” multi-button;
  • contains:
    • “Export to Excel” button;
    • “Export to with Items” button;
• “Export to Excel” button:
  • was added to the buttons panel at the top of List form;
  • was added for all buckets, except Consignment;
  • was added next to the “Add PO Items” multi-button; 
  • is always clickable; 
  • after clicking on the button:
    • 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:
      • Proforma/All/In Review/Paid:
        1. Vendor;
        2. Reference Number;
        3. Memo;
        4. Bill#;
        5. Bill Date;
        6. Due Date;
        7. Payment Term;
        8. Amount;
        9. Status;
        10. Brand;
        11. Category;
        12. PO #;
        13. Store;
      • Open Bills:
        1. Bill #;
        2. Reference #;
        3. Store;
        4. Memo;
        5. Bill Date;
        6. Due Date;
        7. Payment term;
        8. Vendor;
        9. Amount;
        10. Payment;
        11. Open Balance;
        12. Status;
        13. Brand;
        14. Category;
        15. PO #;
• “Export to with Items” button:
  • is always clickable;
  • after clicking on the button:
    • 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;
    • Excel file contains next columns:
      • Proforma/All/In Review/Paid:
        1. Vendor;
        2. Reference Number;
        3. Memo;
        4. Bill#;
        5. Bill Date;
        6. Due Date;
        7. Payment Term;
        8. Item Name;
        9. Item Description;
        10.  Item QTY;
        11.  Item Cost;
        12. Item Amount;
        13. Amount;
        14. Payment;
        15. Open Balance;
        16. Status;
        17. Brand;
        18. Category;
        19. PO #; 
        20. Store;
      • Open Bills:
        1. Bill #;
        2. Reference #;
        3. Store;
        4. Memo;
        5. Bill Date;
        6. Due Date;
        7. Payment term;
        8. Vendor;
        9. Item Name;
        10. Item Description;
        11.  Item QTY;
        12. Item Cost;
        13. Item Amount;
        14. Amount;
        15. Payment;
        16. Open Balance;
        17. Status;
        18. Brand;
        19. Category;
        20. PO #.