Home

Reflecting on the last decade at Alchemex, I can truly say it has been one of the most fun I have had – considering I have lived for 4 decades and some. It is difficult to have fun on your own – for me anyway – so this is testament to the most amazing and [...]

{ 0 comments }

Question:     When doing a conditional formatting command, I frequently wish I could extract/highlight the rows in which my data appears.  Is there a way to do this? Answer:        Yes, by using the conditional formatting formula function.  Why:            To highlight/extract the rows in which the Product Category item “Bath” appears by formatting the background color [...]

{ 1 comment }

Business Intelligence (BI) has become quite the ‘buzzword’ in the software industry in the last few years, yet many small business owners still view it as the realm of big business only. As we move towards 2020 and information overload becomes commonplace, however, SMBs are now starting to realize that BI can benefit them too. [...]

{ 1 comment }

As we move into the new Sage regime and with our first Softline conference behind us, it is interesting to see some encouraging patterns emerging. It was a very proud moment to stand in front of the Softline leaders from all the South African operating companies (Pastel, Accpac, VIP, Netcash) and share the Alchemex story [...]

{ 0 comments }

As a young Business Intelligence Company in South Africa, we have come to the realization that the Youth of South Africa are the future leaders of tomorrow. In current times of economic decline where job creation is rare and job opportunities are scarce it is vital that we come to the understanding that an investment [...]

{ 0 comments }

Using keyboard shortcuts can allow you to save a lot of time when working with repetitive tasks. Using keyboard shortcuts in Microsoft Excel helps you increase your efficiency and productivity to use Microsoft Excel like a Power User. In this Excel Tip and Trick we take a look at how we can use Excel Shortcuts [...]

{ 0 comments }

Did you know you can view the raw data of a report before it’s passed through to Excel? This can be very useful if you need to quickly check to see if you are getting the right data from your container or that your filters and/or parameters are working correctly without waiting for the data [...]

{ 0 comments }

It is handy to be able to hide reports that do not need to be run separately, but only as sub reports of a union report.  This will give your object window in the Report Manager a neater look. To hide a report: Select the report in the Object window of the Report Manager, under [...]

{ 0 comments }

Sage PFW ERP Intelligence is an excellent product with which to replace FRx. It is however, a different product to FRx which means that inevitably there are many ways in which it can and will be perceived as “superior” or “inferior” to FRx. The purpose of this blog post is to share with you the [...]

{ 0 comments }

I think by now everyone at Alchemex knows the strong philosophy we have regarding the need to work as a team to achieve success and, as we continue our integration into the world wide Sage family, I believe even more strongly than ever that we have an enormous opportunity to show the power of team [...]

{ 1 comment }