Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Trusted Contributor
mas90guru
Posts: 230
Registered: 10-28-2008

Sage MAS 90 and 200 Data Dictionaries Online (4.1+)

[ Edited ]

We receive lots of questions from clients wanting to use Visual Integrator or Crystal Reports. While the programs themselves are easy enough to use (for the most part) - users are sometimes stumped about which data files should be used in their report (usually fewer data files are better).

 

Then when they figure out the data files, there are questions about what fields are available within those files. Here's a handy tip ....

 

The Sage MAS 90 and 200 data dictionaries are all available online - and the best part is you don't have to remember a user name and password to access them. They're all available online via your web browser.

 

Sage MAS 90 and 200 data dictionaries

 

For those of you upgrading, you'll want to look at the cross reference which shows the old file name (pre-4.x) with a link to the new file name. Very cool.

 

Sage MAS 90 data file cross reference

 

Links:

 

Sage MAS 90 and 200 Version 4.3 Data File Layouts

 

Sage MAS 90 and 200 Version 4.2 Data File Layouts

 

Sage MAS 90 and 200 Version 4.1 Data File Layouts

 

(Earlier versions require a login to Sage Software Online and a visit to the TRSG - Technical Reference and Support Guide section)

 

 

Message Edited by mas90guru on 11-03-2008 05:44 AM
View Wayne Schulz's profile on LinkedIn
Wayne Schulz - http://www.s-consult.com - Glastonbury CT
v: 860-516-8990
e: wayne@s-consult.com

Regular Contributor
RobWaite
Posts: 133
Registered: 11-02-2008
0

Re: Sage MAS 90 and 200 Data Dictionaries Online (4.1+)

Wayne,

Thanks for posting this. This will be very handy.

Robert

Regular Contributor
Armadillo
Posts: 77
Registered: 12-31-2008
0

Re: Sage MAS 90 and 200 Data Dictionaries Online (4.1+)

When will the TRSG be updated (online) with v4.40 Info?

MAS Environment: MAS 200 v4.40
Moderator
khmackall
Posts: 201
Registered: 10-16-2008
0

Re: Sage MAS 90 and 200 Data Dictionaries Online (4.1+)

That's a great resource but just so everyone knows, this information is built into the Sage ERP MAS 90 and MAS 200 Products. 

 

When you launch MAS 90 or MAS 200, click on the Resources link under Tasks on the Sage MAS 90 Desktop.  Scroll to the bottom of the resources page and click on the File Layouts and Program Information link.  This will open a window where you can view File Layouts and look at various Program and Table Information for MAS 90 and MAS 200.

 

This information is updated with each release major release of MAS 90 and MAS 200.

 


Thanks,

Kent

Regular Contributor
Armadillo
Posts: 77
Registered: 12-31-2008
0

Re: Sage MAS 90 and 200 Data Dictionaries Online (4.1+)

Thanks for your response!!  We usually run a minimal view so I didn't recall seeing that information in the Tasks section.

 

MAS Environment: MAS 200 v4.40