The Direct SQL Query tool allows direct interrogation via SQL of data within your Administrator defined Data Connections. The query tool allows only SELECT queries and {call} type queries for stored procedure execution (if supported). UPDATE, DELETE and INSERT and
Ever wanted to create inventory running balances and could not do so? Well by using simple Excel sum function you can actually see the running balances as you enter new inventory over time. As the stores controller, knowing the correct
If you want to view parts of several worksheets on one worksheet, try using the Paste Picture Link Option. This will enable you to print multiple areas of a workbook onto one worksheet. Dashboards summarizing parts of the workbook can
By using the MAX function, the maximum value in a range can be calculated. However to find the cell with the highest value in a range three functions(Address, Match & Max) will have to be nested. The steps below explain
This is the Wrap-Up of the III Part Blog Series You will get the most value from this blog if you review Part II first, because I am going to build upon the same report that we built in that
Given that you imported data into excel with the First Name and Surnames in separate cells – The Concatenate function can be used to join the cells and have the First Name first, then the Surname. This will obviously automate
Alright, Now Let’s Begin Writing the Sales Comparison Report We are going to build a report using Peachtree (becoming Sage 50) as our data source, but the steps below could be used to create a similar report from any Sage
Compacting your MetaData occasionally can result in improved system performance. Depending on your usage levels it may be desirable to do this more often. Select File Then select Compact Metadata A window will appear stating that Alchemex Smart Reporting must
What are comparison methods? Comparison methods are used with Filters and Parameters to refine or limit the rows that are returned to a report. Below is a list of Various Comparison Methods with an example: Comparison Method Example Search Objective
I’d Like to, but it’s Complicated….Isn’t it? Ok, so at this point we have all heard about the cool new report writing tool available in many Sage accounting solutions, called Business Intelligence. After all, reporting is the whole reason for