This Web site is owned by Plus Computer Solutions Ltd. Plus Computer Solutions Ltd. is independent from Sage and Intacct and is not authorized to make any statement, representation or warranties or grant any license or permission on behalf of Sage or Intacct regarding any product, service or Web site content. Certain materials made available on or through this Web site are owned by Sage or Intacct and cannot be used without the prior written permission of those entities. HubSpot Test
Google
Software » Services

Accpac Accounting Software | Accpac Training

Sage Accpac Intelligence - Beyond Report Manager, Part 4

Subscribe to our blog giving us consent to send email updates

Your email:

Search blog

Get in Touch

Phone: 604-544-PLUS (7587)
Toll-free: 1866-714-PLUS
Email: info@plus.ca

Subscribe to our E-Newsletter

Follow Us

Insights & Information regarding enterprise resource planning software from a leading industry expert.

Current Articles | RSS Feed RSS Feed

Sage Accpac Intelligence - Beyond Report Manager, Part 4

  
  
  
  
  
  

In the previous articles of SAI series we learnt step-by-step creation of Consolidated Payables report and configuring it.

Now you’re ready to run it – click the green ‘play’ menu button. You’ll be prompted to enter Fiscal Period and Fiscal Year, since we left values blank. After entering the desired fiscal range twice – one time for each sub-report, we can witness a kind of ‘Excel mambo-jumbo magic’ with jumping numbers and blinking screens, the result of which will be an Excel workbook with two tabs:  Sheet1 –Raw data, Sheet2 – Reports parameters, used by SAI. After spending just a few minutes editing the raw data sheet, we can create a Template that will be used every time you run this report from Report Manager, it might look something like that:

Sage Accpac Intelligence

We can even create a Pivot Table from this raw data, using the powerful Excel tools, which will slice and dice that data the way you want, here’s just one example:

Sage Accpac Intelligenceleon3

Note: Editing SAI reports utilizing the power of Excel won’t be covered here, look for future articles from this series.

When you’re satisfied with the layout, save and link the workbook as a Template (**.XLT) to the SAI report. Next time you run it, the workbook will be arranged in that template’s fashion. You can even create Excel Macro that will be called into action to edit the report as a part of automation process.

That example of data consolidation is not the perfect sample of business logic, but hey – who said you can’t create better and much more sophisticated reports following these simple steps.

In conclusion, I would definitely recommend not giving up on that great addition to the current version of Sage ERP Accpac.

Read more of our blogs here or contact us for more info

Article Author: Leon Colton

Call: 604-420-1099

Email: info@plus.ca

 

Comments

Currently, there are no comments. Be the first to post one!
Post Comment
Name
 *
Email
 *
Website (optional)
Comment
 *

Allowed tags: <a> link, <b> bold, <i> italics