Forum Discussions (1,193)

Discussions Replies Latest Activity
Jing Han

Is there an easy way to hide rows with zero value across in SMI Designer Reports ?

Dear all,   I am working on an Income Statement, which has multiple accounts with zero balance for all periods on multiple tabs.  Is there…

Started by Jing Han in General

0 3 hours ago
BIC Solutions Ltd

Setting SMTP Server In Sage Pastel Payroll BIC

Hi All, I am using Sage Pastel Payroll BIC and i am having the following issue on emailing report. I am getting the following error messag…

Started by BIC Solutions Ltd in Pastel Payroll BIC

0 4 hours ago
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 in Sage ERP MAS Intelligence - Powered by Alchemex

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 in Sage ERP MAS Intelligence - Powered by Alchemex

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 in Sage ERP MAS Intelligence - Powered by Alchemex

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 in Sage ERP MAS Intelligence - Powered by Alchemex

2 yesterday
Reply by Doug Walker
Derek Sevel

BATCH MODE (2)

Hi   Is there a way to start batch mode (2) without right clicking it. I want it to run as a scheduled task ex microsoft scheduler   Thanks…

Started by Derek Sevel in Sage ERP Accpac Intelligence - Powered by Alchemex

0 yesterday
Mokgadi Letsoalo

BI Core-[Run Report} Error

Hi   I get the Error below when trying to run a report in the report manager  

Started by Mokgadi Letsoalo in Alchemex Report Writing

0 on Monday
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 in Sage ERP MAS Intelligence - Powered by Alchemex

2 on Monday
Reply by Dana Halpin
Joanne McCoy

SQL Join using 2 fields

Hi I am trying to join a [StockandWarehouse] table to a [StockTrans] table.  I need to join on the stock number as well as the warehouse co…

Started by Joanne McCoy in General

2 on Sunday
Reply by Joanne McCoy

RSS

Follow Alchemex on twitter

Like Alchemex on facebook

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service