Sort data by Date in Collection

Sort data by Date in Collection

Hello,

I am fetching data from multiple forms and i am trying to sort the data by date wise.But i am unable to get success in that. 
Following Eg. is the way i want
Invoice No.      Invoice Date      Purchase Qty      Sale Qty
      15                  17/10/2020              20
      15                  18/10/2020                                      15
      16                  19/10/2020              15
      16                  20/10/2020                                      10

What i received as data is as follows:
Invoice No.      Invoice Date      Purchase Qty      Sale Qty
      15                  17/10/2020              20
      16                  19/10/2020              15
      15                  18/10/2020                                      15
      16                  20/10/2020                                     10

Code:
  2. inventoryItem = Collection();
  3. for each  rec_Inventory in Inventory[Product_Code == input.Item] sort by Added_Time desc
  4. {
  5. inventoryNewRow = Item_Report.Item_Details();
  6. for each  item in inventoryNewRow
  7. {
  8. for each  rec_Purchase in Purchase_Invoice[Invoice_Date >= input.From_Date && Invoice_Date <= input.To_Date] sort by Added_Time desc
  9. {
  10. for each  rec_Purchase_Sub in rec_Purchase.Product_Details
  11. {
  12. if(rec_Purchase_Sub.Item == input.Item && rec_Purchase_Sub.Bin == rec_Inventory.Bin && rec_Purchase_Sub.Sub_Bin == rec_Inventory.Sub_Bin && rec_Purchase_Sub.Warehouse_Location.Warehouse_Location == rec_Inventory.Warehouse_Location)
  13. {
  14. purchaseNewRow = Item_Report.Item_Details();
  15. for each  item_Purchase in purchaseNewRow
  16. {
  17. item_Purchase.Client_Name=rec_Purchase.Vendor.M_s;
  18. item_Purchase.Invoice_No=rec_Purchase.Invoice_No;
  19. item_Purchase.Invoice_Date=rec_Purchase.Invoice_Date.toString();
  20. item_Purchase.Purchase_Quantity=rec_Purchase_Sub.Quantity.toString();
  21. }
  22. inventoryItem.insert(purchaseNewRow);
  23. }
  24. }
  25. for each  rec_Sale in Sales_Invoice[Invoice_Date >= input.From_Date && Invoice_Date <= input.To_Date && Product_Details.Item == input.Item] sort by Added_Time desc
  26. {
  27. for each  rec_Sale_Sub in rec_Sale.Product_Details
  28. {
  29. info rec_Sale_Sub;
  30. if(rec_Sale_Sub.Bin == rec_Inventory.Bin && rec_Sale_Sub.Sub_Bin == rec_Inventory.Sub_Bin && rec_Sale_Sub.Warehouse_Location == rec_Inventory.Warehouse_Location)
  31. {
  32. salesNewRow = Item_Report.Item_Details();
  33. for each  item_Sales in salesNewRow
  34. {
  35. item_Sales.Client_Name=rec_Sale.M_s.M_s;
  36. item_Sales.Invoice_No=rec_Sale.Invoice_No;
  37. item_Sales.Invoice_Date=rec_Sale.Invoice_Date.toString();
  38. item_Sales.Sale_Quantity=rec_Sale_Sub.Quantity.toString();
  39. }
  40. inventoryItem.insert(salesNewRow);
  41. }
  42. }
  43. }
  44. }
  45. item.Bin=rec_Inventory.Bin.Bin;
  46. item.Sub_Bin=rec_Inventory.Sub_Bin.Sub_Bin;
  47. item.Warehouse_Location=rec_Inventory.Warehouse_Location;
  48. item.Inward_Quantity=rec_Inventory.Inward_Quantity.toString();
  49. item.Outward_Quantity=rec_Inventory.Outward_Quantity.toString();
  50. item.Balance_Quantity=rec_Inventory.Balance_Quantity.toString();
  51. }
  52. inventoryItem.insert(inventoryNewRow);
  53. }
  54. input.Item_Details.insert(inventoryItem);
I am trying to fetch the data and store it inside the Subform Since i want that data to be in excel sheet together. If there is any alternative do suggest me, i am open to suggestions.