Forum Discussions (3,719)

Discussions Replies Latest Activity

Multiple columns in parameter

I have written a new report using sales rep code as a parameter. Is there a way for me to show an additional column in the parameter so ins…

Started by Rudolph in Alchemex Report Writing

1 Aug 31, 2009
Reply by Fred

Conditional Sum formula

I have raw data with Net Movements for period 1, 2, 3, etc in seperate columns. Now I want to write a formula to sum these columns based on…

Started by Riekie Roux in Excel On Steroids - Excel Issues

2 Aug 30, 2009
Reply by Alexander Toufexis

SQL Error by BIC

Hi guys, how are you? I'm getting erroneous SQL when running a report with BIC (build 6.7.5). While im trying to apply a filter, is does…

Started by Alexander Toufexis in Sage Evolution Intelligence Reporting

2 Aug 29, 2009
Reply by Alexander Toufexis

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name'CSAPP

Hi Am using Alchemex ACCPAC 5.4 with Microsoft SQL 2000. i receive message[An error occurred attempting to verify the system version from t…

Started by Faustino Pinon in General

2 Aug 27, 2009
Reply by Faustino Pinon

Sales per month

Is there an easy way to draw sales information for the past 12 months. I have a year and period indicator in my data.

Started by Riekie Roux in Alchemex Report Writing

1 Aug 26, 2009
Reply by Fred

Dynamically insert rows

I have a Pivot table with a list of Item number and sales statistics. I now need to use this information in a report. Is there a formula or…

Started by Riekie Roux in Excel On Steroids - Excel Issues

2 Aug 26, 2009
Reply by Riekie Roux

Using Dynamic worksheet name in Macro

I create a Pivot table (Office 2003) that shows sales per area. The Area is in the PAGE area of the PT. I then create a very simple Macro t…

Started by Terence Hinrichsen in Excel On Steroids - Excel Issues

4 Aug 25, 2009
Reply by Terence Hinrichsen

SALES Master - With Invoice address line 1 & 2

I am trying to get the address information in the sales master 3.2.1 report. I have found the information in the _bvInvNumARFull view but I…

Started by Grant Swithinbank in Sage Evolution Intelligence Reporting

2 Aug 24, 2009
Reply by Grant Swithinbank

MYOB ODBC Version 9 upgrade

All users of MYOB that have upgraded to MYOB Accounting V18.5, MYOB Accounting Plus V18.5, MYOB Premier V12.5 or MYOB Enterprise V6.5 need…

Started by Brynn Furmidge in Alchemex for MYOB

1 Aug 23, 2009
Reply by Gavin Miles

Security Manager

Hi guys... Let me introduce myself. My name is Alain, I'm the IT administrator for Grandmark International here in Johannesburg, South Afr…

Started by Grandmark in General

1 Aug 21, 2009
Reply by Fred

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service