ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> MRP Question
http://www.istechforum.com/YaBB.pl?num=1187636688

Message started by bvesall on 08/20/07 at 12:04:47

Title: MRP Question
Post by bvesall on 08/20/07 at 12:04:47

Hello all,

Is there a way to copy and paste the MRP data from MR-H into Excel in a manner that won't combine all data in one row? I'd like to be able to sort by different methods other than item number, preferably description. Can anyone shed some light on this?

Title: Re: MRP Question
Post by GasGiant on 08/20/07 at 12:39:33

Print the report to disk as a text file, then import it as a data file into Excel (Data > Import External Data > Import Data). That will allow you to set the columns where you want them prior to importing.

Title: Re: MRP Question
Post by Dawn on 08/21/07 at 05:53:25

In Excel higlight the column (either by individual cells or the whole column) and go the DATA drop down at the top and use the TEXT TO COLUMN. You can sort that way. I find it easier than exporting for small amounts of data.

Title: Re: MRP Question
Post by bvesall on 08/28/07 at 14:07:12

Hello everyone,

I appreciate all your help. I am able to import the text into Excel. I was copying and pasting, forgetting the simple import step. Now I just wish I could get more characters in the description field. Maybe that can be in the next version of EVO!

Thanks a bunch!