Personalization, Customization and Productivity Tools

[cpaulnorthcott]

I am using version 4.40 

I am creating some special financial crystal reports from MAS 90 using the SOTAMAS driver. I am having difficulty finding the correct tables and the fields with the financial records that I require.  Can anybody point me to the tables I need for creating an income statement? I need the following records; Revenue, COGS and Expenses.

I want to develop flash reports for specific management, concentrating on certain accounts and triggering a notification upon a change.  I also want to combine several of these metrics on one report.  We also have other software systems that capture HR information of which I would like to use together with the MAS 90 information. Overall I would just like to maximize the versatility and information in MAS 90 and our other systems.

I also have SQL developer that I would like to create a SOTAMAS connection and have not been able to do this yet so any assistance here would be greatly appreciated.

Thanks in advance,

Paul

[DFeller]

The File Layouts are right under the Resources area.

You should be doing this in FRx or MAS Intelligence once it is released.

Dawn

[cpaulnorthcott]

Hi Dawn,

Thanks for your reply.

I think I've just found the correct tables on page 11 of 'Getting Started with FRx 6.7 for Sage MAS90 and MAS 200 ERP 4.x' shows a table that lists the MAS 90 and MAS200 transaction attributes. 

I've heard of MAS Intelligence being Excel based of which I am more familiar with Excel. But why not use Crystal Reports?

Paul

[TomTarget]

FRX  or Excel (with F9 or MAS Intelligence) are simply designed specifically for use for Financial statement reporting so will be easier to use for the given purpose.

Not to say you couldn't use crystal,  will simply be a lot more work.

[rmikolainis]

---

cpaulnorthcott wrote:
 

I've heard of MAS Intelligence being Excel based of which I am more familiar with Excel. But why not use Crystal Reports?  

---

Most accountants are proficient in excel, hence its easier for them to make custom financials.

Also, the report will be in Excel right off the bat, which accountants love, sometimes when exporting from Crystal to Excel, the formatting gets goofy and the columns get jumbled up.