Question: error in purchase report excel sheet

error in purchase report excel sheet

I just download the purchase report of a supplier in excel sheet.But, there is a little problem. First purchase row in getting into last and last purchase is getting into the first on sheet.

ZA

Zubair Ansari

Asked
I just download the purchase report of a supplier in excel sheet.But, there is a little problem.
First purchase row in getting into last and last purchase is getting into the first on sheet.
here is the video what actually i'm facing.
https://streamable.com/ebwnfb
  • ZA

    Zubair Ansari

    Answered
    ?
    answer please
  • MS

    Mian Saleem

    Answered
    Hello,

    The export will be same as on the list purchases page. You can sort the purchases by clicking the column header.

    *The question response time is 1 - 2 days so please be patient while expecting reply from us.*

    Thank you
  • ZA

    Zubair Ansari

    Answered
    Sir I did tried by sorting but still its not getting changed in if we export into excel sheet. (it is only effecting on the web page if we do sorting)
  • MS

    Mian Saleem

    Answered
    Are you saying the excel order is not same as on the list purchase? Please take screenshots of both before export and then excel.
  • ZA

    Zubair Ansari

    Answered
    sure, Screenshots are attached
  • MS

    Mian Saleem

    Answered
    Hello,

    I am sorry as I was checking list purchases. The reports are exported with default order. For purchases report it's `date desc` If you need to change it you can modify the `getPurchasesReport` method of `app/controllers/admin/Reports.php`

    > Please be informed that we don't offer support for modification or modified versions. You are allowed to do it at your own risk as per license.

    Thank you
  • ZA

    Zubair Ansari

    Answered
    thank you so much, It works.
  • Login to Reply