Sage PFW ERP Intelligence


Sage PFW ERP Intelligence

Location: Worldwide
Members: 47
Latest Activity: Apr 21, 2016

Discussion Forum

Out of Memory error 1 Reply

I am adding a new report and including all fields under columns, except statiscal fields.   I narrow my report to one fiscal year as the parameters.  When I run the report and it starts to rendering…Continue

Tags: errors, Memory, of, Out

Started by Sally Hopper. Last reply by Prabha VIRAH SAMMY Mar 1, 2016.

JobCosting report

Does any job costing reports exists under SAI ?Does any one have a copy of the data dictionary for PFW?Continue

Started by Nicole Despatie Mar 4, 2014.

Drill-down in Designer Report 1 Reply

The drill-down in the Designer report doesn't seem to work as it did in the Management Pack reports.  Often, even when there is a balance in an account, it won't give any data.  Sometimes we can get…Continue

Started by Lori Black. Last reply by Tony Dizon Feb 14, 2013.

Report Templates 2 Replies

Are there any report templates we can import for PFW Intelligence? I have just seen templates for Sage 100, 300, 500 etc..but not PFW.Continue

Started by Chris Irish. Last reply by Chris Irish Feb 13, 2013.

Comment Wall


You need to be a member of Sage PFW ERP Intelligence to add comments!

Comment by Chris Irish on February 14, 2013 at 7:45pm

Is there a SLOB report for PFW Intelligence?

Comment by Lori Black on November 15, 2012 at 5:01pm

I have two questions for anyone who might know about the Report Designer reports in PFW Intelligence.


1)  Can you create a Designer report from scratch, not using one that already exists in the standard reports?  If so, how?

I have tried marking the checkbox after creating a report but before running the report and I have also tried after creating the reprot and after running the report -no luck either way.  I find nothing in any documentation I have that says we can or can't do this.


2) Can a Designer report be used as a report in a Union report?  So far, my attempts have failed.  I want to create a f/s report with the Designer details and add some non-GL data to it that I won't be able to get into source data worksheet 1.





Comment by Kapil Sharma on August 17, 2012 at 8:08pm

Thanks Tony, "Opening Balance" column worked fine :)

Comment by Tony Dizon on August 16, 2012 at 11:33pm

Hi Kapil,  Are you using Financial Reports or Report Designer?  If you're using Report Designer you can add a column called 'Opening Balance'.  This column will always use Last Year's YTD Balance.  Hope that helps. :)

Comment by Kapil Sharma on August 16, 2012 at 10:33pm


How can I get column to always show Dec (Period 12) YTD for prior year no matter which period I am running my report for.



Comment by Tony Dizon on December 13, 2011 at 5:27pm

That worked! Thank you very much for the help! Stephen.

Comment by Stephen Coull on December 13, 2011 at 12:53pm


You can go into the Report Manager > Tools and select either "Tenant Cache Viewer" and delete relevant DSN's or select "Clear All Cached Connection Information".

Hope this helps.

Comment by Tony Dizon on December 12, 2011 at 10:10pm

Hi There,

Question: How do you delete a company under the 'Database Consolidation List' when running Consol Financial Report Designer?

I already deleted the Company in Sage PFW, and manually deleted the DSN in Pervasive, but the company still shows on my list to Consolidate.

Hope to get a response soon.


Tony Dizon - Sage PFW


Members (46)


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service