Forum Discussion

Barry_OPD's avatar
Barry_OPD
Contributing User
2 years ago
Solved

I need to export inventory balances to CSV. Not an option in File Import/export

I need to export inventory balances to CSV. Not an option in File Import/export

  • Hi Barry_OPD , welcome to the forum,  you could display the item list summary to screen, then send it to a text file and prepare it in Excel, and save as CSV.

7 Replies

Replies have been turned off for this discussion
  • Mike_James's avatar
    Mike_James
    Ultimate Partner

    Hi Barry_OPD , welcome to the forum,  you could display the item list summary to screen, then send it to a text file and prepare it in Excel, and save as CSV.

    • Barry_OPD's avatar
      Barry_OPD
      Contributing User

      Ouch.

      Been trying to print Items List to PDF and then copy into Excel and clean up all the page headers. Also pretty ugly.

       

      Surely doing a stock take you would want a dump of current inventory balances to excel or csv.

       

      Amazed that this isn't a standard export.

      • Mike_James's avatar
        Mike_James
        Ultimate Partner

        Maybe send it straight to Excel? I agree it's not an easy report to work with.