Skip to Main Content
Ideas Portal
Status Planned
Categories Reports
Created by Richard Williams
Created on Jun 15, 2022

Incorrect Sorting for CSV reports

Hi,


When exporting the “Required Payments” report and “Gross To Net” report as a CSV file, the employee name are exported along with their titles (Mr, Mrs, etc.).


So when we try to sort the CSV file employee it sorts them based on title which is incorrect.


We would suggest that you export the employee name without title for CSV exports (maybe you can add title as an additional column).



  • Attach files
  • lucy killick
    Reply
    |
    Jun 22, 2022

    The payment file isn't in the correct format, please provide a payment file in the following format.


    26-MAY-22," ","20189341","00","086001","employee","Account","00","sortcode","HWT","amount","N"