Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

floplag (MIS)
26 Apr 10 19:50
Forgive me but im quite new to MAS90.  
I am the network administrator tasked with helping an end user export to excel or an excel compatible format.  
Here is our issue...on trying to export the data we reach the "export file options" screen, and all options other than "Ascii text file - Report format" are not clickable and unavailable.
Any hints as to why?
Thank You
BigLouie (TechnicalUser)
27 Apr 10 8:54
Based on what little info you have posted it is my guess that you are trying to export the results of a report on the reports menu. Also you are doing this on a module that is not on the business framework. Note that these reports are the result of programming and as such do not have the features of a report written in Crystal. So you cannot export to Excel. Just not possible.

It would help a lot more if you describe exactly what module you are in and what data you are trying to export.
floplag (MIS)
27 Apr 10 11:28
I'm sorry but as i said im not actually the end user, just the IT guy tasked with helping them figure our thier issue.  ill try to fill in some blanks.

They are trying to import a vendor listing from an old company in MAS90 into Dynamics Great Plains to be specific.  

In printing the report, it has a screen with numerous formats for the exported data to be formatted in, beginning with the standard ASCII and also listing delimited, Excel, Lotus, dbase as options, yet we cannot choose any of them, only the ASCII, which is formatted nice for reading but basically unuseable for import to Excel or ultimately GP.

We have an excel template we were given but im not married to that if there are better alternatives.

Bottom line i need to try to export data from MAS90 into a format usable in excel or for import into GP.  That;s my root issue.
BigLouie (TechnicalUser)
28 Apr 10 9:07
Thanks for the detail because now I can give you a better answer. PULL the data with Excel. MAS is ODBC compliant so you can just open an Excel spread sheet and do a Get External Data.  The data is in AP1 this is the Vendor Master File.  You can also use MS Access and pull the tables into there. You will need to know a MAS user log in information.
floplag (MIS)
28 Apr 10 18:50
Louie
Thanks, but if i may ask could you be a bit more specific in pointing to that data?

when you say AP1 are you referring to a folder or a file ?

i do not have a folder in the MAS90 shared folder location by that name so im hoping you are referring to file.  Then again we have numerous folders in the share so i would then be wondering which folder?

sorry for being such an amatuer but this is a new app for me.
pizzabox (IS/IT--Management)
3 May 10 14:49
Any answer to this.  I'm having same problem.
BigLouie (TechnicalUser)
5 May 10 9:00
Pizzabox, exactly what problem are you having?
ChrisLC (TechnicalUser)
2 Jun 10 9:50
To pull MAS data via Excel:  In Excel (ver 2007), Data > From Other Sources > From Microsoft Query, in the Choose Data Source screen choose SOTAMAS90.  From there MAS should prompt you for a company code and MAS login info.  After that, you will see all the data tables.  Vendor Master will be either table AP1 or AP_Vendor depending on the version.

You can dump any MAS table data into Excel via this method as long as you have MAS login permissions.  By the way, your GP reseller should be familiar with this process.  Data extraction is very similar for most ERP packages.  

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close