Sage 100

 View Only

  • 1.  Ok, so still not having much luck getting this CR

    Posted 04-07-2011 15:02
    Ok, so still not having much luck getting this CR to work and now all exports to Excel come across as ""Group"" which doesn't allow the user the sort any of the data. Really need to get this resolved. Just trying to take the IM5/IM1 data to Excel so they can manually manipulate it since we can't seem to get it to work in CR. Help.


  • 2.  RE: Ok, so still not having much luck getting this CR

    Posted 04-07-2011 15:07
    Can you export to CSV then import into Excel?


  • 3.  RE: Ok, so still not having much luck getting this CR

    Posted 04-07-2011 15:09
    Haven't tried that...will give it a go and let you know.


  • 4.  RE: Ok, so still not having much luck getting this CR

    Posted 04-07-2011 15:17
    I've had a lot of problems with Excel specific file formats -- seems there are so many different versions that it can sometimes be problematic.


  • 5.  RE: Ok, so still not having much luck getting this CR

    Posted 04-07-2011 17:37
    Can't you just do an ODBC read of the data directly from Excel? You should be able to pick the fields you want from both IM5 and IM1. Excel will do the join for you.


Related Content