Sage ERP MAS Intelligence - Powered by Alchemex (48)

Discussions Replies Latest Activity
Dana Halpin

Filter on columns in report designer?

I'm editing an existing condolidated report. When in report designer, can you put a filter on the columns? For example for one column we on…

Started by Dana Halpin

1 yesterday
Reply by Dana Halpin
Debbi Silberberg

Adding Text to a Row

I have custom groupings.  Id like to add text for Revenues, Operating Expenses, etc.  How can I do that? Thank you.

Started by Debbi Silberberg

0 yesterday
Debbi Silberberg

Create and Link does not save account mapping

I've created custom account groups using the video posted here.  Worked great except that when I create and link my template, it's not savi…

Started by Debbi Silberberg

2 yesterday
Reply by Debbi Silberberg
Doug Walker

Help creating a SQL Join

I need to create a SQL join for IM_TransactionHistory to the AR_InvoiceHistoryHeader table. Because the AR Invoice number in the IM_Transac…

Started by Doug Walker

2 yesterday
Reply by Doug Walker
Dana Halpin

SMI Consolidating companies w/different fiscal years

Can SMI handle consolidating companies with different fiscal years? When using the cannned container, it consolidates period 1 for one comp…

Started by Dana Halpin

2 on Monday
Reply by Dana Halpin
Allan Brown

Pivot table from sheet 1 and sheet 3

I am a new user Mas Intelligence.  How do i create a pivot using sheet 1 and sheet 3 from a union report.   Allan

Started by Allan Brown

2 on Saturday
Reply by Dave Smith
Robert LeGrand

System.OutOfMemoryException

Getting the following : Exception of type 'System.OutOfMemoryException' was thrown. Number = -2147024882 Driver Error = Unknown SQL State…

Started by Robert LeGrand

3 Feb 16
Reply by Robert LeGrand
Diana M Laughner

Combining Accounts in SMI financials

Can anyone give me a quick run down on how to combine accounts on an SMI financial statement using Mas90/200? Ex. Accounts 101-00-00 and 10…

Started by Diana M Laughner

11 Feb 14
Reply by Debbi Silberberg
Clark Walliser

SMI How to add a new expression to the layout page

  I followed the instructions in another post to create a new expression for PY2ActitivityPer01 for 2 years  back. Now I want to add it to…

Started by Clark Walliser

4 Feb 2
Reply by Clark Walliser
Ralph

What could cause a pivot table Column Label filter to not be maintained?

I've created an SMI report with a pivot table in the spreadsheet, and set a field called YEAR to be a Column Label in the pivot table.  The…

Started by Ralph

1 Feb 2
Reply by Les

RSS

Follow Alchemex on twitter

Like Alchemex on facebook

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service