Edwin Male Johannesburg South Africa: Share on Facebook

Share Twitter

Blog Posts
Discussions (75)
Groups (2)
Photos
Photo Albums
Videos

Edwin's Friends

View All

Edwin's Groups

Sage ERP Accpac Intellig…

124 members
Sage ERP MAS Intelligence

124 members

View All

Edwin's Discussions

Consolidating Cost Centres
2 Replies

We have 80 sites so our sales account is made up as 1000/001; 1000/002 until 1000/080Thus I have 80 different ledger accounts for 80 clients my cost of sales will work the sameEg. 2000/001,2000/002…Continue

Started this discussion. Last reply by Edwin Oct 22, 2010.

Creating Of Custom Balance Sheet

How do I create a balance sheet that looks like this: Balance Sheet – 4 columns (let’s say at Jun 30 2010 I would report)-current month (Jun 30 2010)-previous year, same month (June 30 2009)-previous…Continue

Started Oct 19, 2010

Cost With Similar Features Per User
1 Reply

What is the cost to get the same or similar features with SAI per user, is it more than if you use Orchids Info Manager or Explorer?Continue

Started this discussion. Last reply by Craig Juta Oct 24, 2010.

Options For Creating Departmental Income Statements
2 Replies

What options are available for creating departmental income statements at present with Simply Accounting Intelligence. Continue

Started this discussion. Last reply by Carmine Feb 14.

View All

Edwin's Page

Latest Activity

Carmine replied to Edwin's discussion 'Options For Creating Departmental Income Statements'

I am having a really hard time separting income statements for every department. I am doing it for a hotel and I cant seem to get each income statement indivdually as per GL numbers it keeps spitting out gl departments which i dont want as…

Feb 14

Edwin liked Ruth Gray's group 'Sage Peachtree Business Intelligence' Jun 24, 2011

Edwin replied to Charles Sivewright's discussion 'Clearing Filters in a "protected" worksheet'

Hi, Refer to the attached document for a solution to your problem.I had to create a macro that unprotects,removes filters and then protects the worksheet. Thanks Edwin

Jun 23, 2011

Edwin replied to Hagashen Govender's discussion 'Excel assistance'

Hi, You will be required to insert a calculated column(Distance Travelled) that divides the km/diesel issued. Thereafter you can then create a pivot table. I have attached a workbook with a solution to your issue. A guide on how to create a…

Jun 20, 2011

Edwin replied to Leon Colton's discussion 'Totals of Pivot Table'

Hi, A combination of calculated fields and value field settings can help.

May 27, 2011

Edwin replied to Cliff van der Poll's discussion 'Export data Container ( Connector )'

Hi, You can use copy and paste.That is you copy a container and paste it into the desited connection. Thanks

Apr 14, 2011

Edwin replied to Pat Bernard's discussion 'Inserting a signature into Excel 2007'

Hi, You can select your signature within adobe reader, copy and paste in MS Excel.

Apr 1, 2011

Edwin replied to Anthony Whitehouse's discussion 'Restricting access to a specific report'

Hi, Iam of the view that this can be done in pastel partner Click on setup Users/passwords Users Select the respective user Under user group-select personalised Click on the BIC access tab on the right and make the necessary changes I hope…

Mar 23, 2011

Edwin replied to Ross Leahy's discussion 'Sorting and Indexing'

Hi, The solution is by using the countif function.Refer to the attached workbook for the answer.

Mar 10, 2011

Edwin replied to Ramanjaneyulu's discussion 'Could you please help me?'

Hi, I have attached some information on scheduling reports. I hope you will be able to resolve your problem.

Mar 9, 2011

Edwin replied to Shwu Hua Gan's discussion 'Schedule of report, but source data huge.'

Hi, By generating an output file, your problem can be solved. Tick the advanced box and under Generate Output File ;specify the location i.e server path where the excel file can be stored .Do not forgot to include the extension of the…

Feb 25, 2011

Edwin replied to Shwu Hua Gan's discussion 'Export to HTML'

Hi, I have attached a document with detailed steps on how to export an Alchemex Report to HTML. I hope it helps.

Feb 25, 2011

Edwin replied to Jacqueline de Koker's discussion 'ERROR ON BIC REPORT MANAGER WHEN RUNNING REPORT'

You tried to convert a field to a different data type by using SQL.Inorder to solve you problem I will ask you to give us the conversion code .

Feb 24, 2011

Edwin replied to Riekie Roux's discussion 'Count of cells between values'

Hi, Do you mean countif,=countif(range,criteria). Otherwise uploading a file with example data will help in understanding your question.

Feb 16, 2011

Edwin replied to Riekie Roux's discussion 'Count of cells between values'

Hi; There are several functions you can use; =Count (counts the number of cells in a range that contain numbers) =CountA(counts the number of cells in a range that are not empty) =Countblank(count the number of empty cells in a…

Feb 16, 2011

Edwin replied to Michelle Montgomery's discussion 'BI Tools Add-Ins'

Hi, • Click on the office icon • Click on Excel options • Click on Add- ins on the left hand side of the window • Select COM add ins under manage at the bottom of the window • Click on Go • Activate the PLDRILL.Connect…

Feb 15, 2011

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours: Excel On Steroids

How long have you been using the above solution?: For along period

Where did you hear about us?: Alchemex Site

Comment Wall

You need to be a member of The BI Community - Powered by Alchemex to add comments!

Join The BI Community - Powered by Alchemex

No comments yet!

Welcome to
The BI Community - Powered by Alchemex

Sign Up
or Sign In

You can also sign up with:

Follow Alchemex on twitter

Follow @alchemex

Like Alchemex on facebook

This Weeks Top Content

1	Sage MAS Intelligence Report Designer and 13 fiscal periods
2	SQL Join using 2 fields
3	Create and Link does not save account mapping
4	SMI Consolidating companies w/different fiscal years
5	Pivot table from sheet 1 and sheet 3