Our Executive Reports tool is designed for facility management to get a high level look at the operations. It is web-based and only requires a browser to access via the internet. This article will focus on one new report just added called “GL Drill Down”. For more information on Executive Reports contact the CPS Sales office at 800-793-1872.
Since the Executive Reports tool is “online”, it lends itself well to the ability to hyperlink and “drill down” into the details of summary data. One of the features of CPS' software all along was its ability to sell various unrelated items at the point of sale and the database would roll up that information to the General Ledger (GL) level for sending over to accounting. The “GL Drill Down” report lets you dissect the data from the other direction. Let’s assume that accounting has a question on the General Ledger account for Merchandise.
You will find the report in the “Executive Reports – Facility Analysis – GL Drill Down” link.
With this report, I can run a General Ledger report in the browser. The Filter allows you to select all or a subset of your General Ledger accounts by GL Code/Account or GL Description. You can also filter by Dates and Store Codes. For the purpose of this example, I selected "ALL" GL Accounts for the entire year in my demo database and then clicked “Show Report”.
The result is a standard General Ledger report for the given filter. Note the circled GL Account Number above. The GL Accounts are underlined indicating a hyperlink. When I click on 107, a new report is displayed that will show you all of the Merchandise (GL Account 107) sold for the given filter.
Now I can see that during the year, I sold products from various Sale Categories that are all assigned to GL Account 107. Notice each Sale Category Number has a hyperlink. For Golf Gloves you can see I circled Category number 18 above. If I want to see the details of Golf Gloves sold, I can click on 18.
Now I have all Golf Gloves (sale category in CPS) that were sold during the year. Each line item lists the Sale Number in which the Glove was sold. If I want to know more about the glove sold in the circled sale number, I can click on sale number 2421612070001 and see the actual Sales Transaction.
Now I can see who this was sold to, who sold it, what other products were sold at the same time, any discounts, etc, all from a browser (I do not have to print massive reports) and all in real-time.
Note this “GL Drill Down” report is available in the January 2017 Executive Reports and beyond, so you may need an update to get this report. The update is FREE if you have the Executive Reports module.
For details on how to add the Executive Reports to your facility, contact Mike Stanovich at our CPS Sales Office 800-793-1872 or contact us via email at Sales@ClubProphetSystems.com.