Search results for query: *

In the Row layout of a report I'm trying to not only select certain GL accounts but narrow down the selection even more in certain rows using these transaction attributes. From Row format => link to GL => row modifier => I then enter in type = "T" and select a category I want to select on. The...

I'm trying to use Transaction Attributes in FRx rows but I'm not having any luck. These attributes will allow me to select specific data based on fields like posting comment, source journal, register no, etc. In the FRx documentation it says "if your accounting system supports attributes..."...

You're just trying to use SQL and list all the tables in your MAS 90's ProvideX database. Here's one way: http://www.tek-tips.com/viewthread.cfm?qid=1115307 (Excel will give the same thing) The v3.x and v4.x ProvideX ODBC manuals may list something else about this, but I looked and couldn't...

Thanks Blorf. GL8? is that "G/L Budget & History File" in v3.61 of MAS90? We're using v4.05 and according to the file layout that may be "GL_BudgetAndHistoryWrk" for us. Either way I haven't had much luck with any of the Budget tables listed.

I must be missing something. When I write reports in FRx -- and I've done a total of 3 now -- it happily lists our MAS90 GL accounts and their current amounts and even YTD amounts if needed. But when I use MS Access I basically get very little, even though I can see all the MAS90 tables when...

This is why I always suggest that anyone writing reports take the Data Files class". -- Thanks. I checked and I'm looking into that right now. "And I would suggest using SQL Specific Pass Through Queries in Access". -- Thanks again. I would rather use SQL Server and Stored Prcoedures + Crystal...

Right now I'm using both Access and FRx. Access didn't care at all for the ODBC (v3.33) that came with the CD, but likes the V4.0 that's available on the Sage/ProvideX Web site. It looks like I'll use FRx for now and keep messin' and looking around using Access so I can later hopefully break...

I see that FRx has a lot of built-in functions to make things easier but what can it do that Crystal or Access can't ?

Sounds like he's having the same problem I am. I also need to write reports out of MAS90 using its General Ledger data, but I'm not sure if I'm better off using FRx or Crystal or MS Access. I've used Crystal and MS Access with other databases but I'm new to FRx (and MAS90) and I'm not really...