Forum Discussion

Barry_OPD's avatar
Barry_OPD
Contributing User
3 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 Cover User
    3 years ago

    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
    3 years ago

    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 Cover User
    3 years ago

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

  • Barry_OPD's avatar
    Barry_OPD
    Contributing User
    3 years ago

    So how would you do that? Send it straight to Excel?

    Sorry I am new to AccountRight (and managing a project to upgrade to MYOB Advanced so AccountRight won't be in use much longer) so am trying to find my way through an unfamiliar system

     

  • Barry_OPD's avatar
    Barry_OPD
    Contributing User
    3 years ago

    And thanks so much for your help on this - much appreciated

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    3 years ago

    Hi Barry_OPD , once you have the report on screen, select File, Send to, Excel.

     

    Hope you can display the report?

     

    Good luck with the migration.

  • Barry_OPD's avatar
    Barry_OPD
    Contributing User
    3 years ago

    Thank you thank you

    That is the solution

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.