Support Alert ....!!!! How to print a Balance Sheet for 2009 when 2008 is an open year using FRx CRM:0027329

How to print a Balance Sheet for 2009 when 2008 is an open year using FRx

To print a Balance Sheet by using FRx for the year 2009 when 2008 is an open year with regard to the Column Layout of your report, follow these steps. The Row Format and the Tree (if applicable) have already been created.

Important The report date should be set to the current date.

 

1.	Create a DESC column.
2.	In the Column Layout, you need a GL Actual Column with the Fiscal Year set to 2008 or BASE-1 (if the user date is XX/XX/2009). The Period Code will be 1 TO 12, and CurrentPer/YTD will be YTD. The Print Control for the column will be NonPrint (NP).
3.	Create another GL Actual Column with the Fiscal Year set to 2009 or BASE (if your user date is XX/XX/2009). The Period Code will be BASE and the CurrentPer/YTD will be YTD. The Print Control for the column will be NonPrint (NP).
4.	Create a CALC column. In the Calc Formula cell, enter the calculation B+C (assuming that your GL Columns are B and C). By using this kind of Column Layout, this report yields information for all of 2008 + the current balance through the end of the period in which the report date falls.

 

 

Faiqa Usman

Support Manager

Maison Consulting & Solutions ||Your ERP/CRM Partner|| Microsoft Gold Certified || MBS President Club 2008 |faiqaq@m-consultants.com|http://www.m-consultants.com

 

Microsoft World Class Affordable ERP

>

Rapid Implementation

>

Fixed Scope Value Delivered

>

Post Installation Support

>