SAGE 300 - GL - Financial Reporter Design Horizontal

SUGGESTED

Hi Support

We have an FR reporter that is written by segments code in vertical format per outlet.

We want to achieve the same format in horizontal format. Is there a way to achieve this.

CURRENT FORMAT - Department listed in vertical format

REQUESTED FORMAT - HORIZONTAL FORMAT

when we place at right side same data that is in first department gets repeated. Even used the Name Manager to mark the perimeter.

Any assistance or advise on this matter will be greatly appreciated. 

Thanks 

Parents
  • 0
    SUGGESTED

    There may be other tools that can do this, but FR is not the way.  FR works on one row at a time, using information in the first four columns as the framework for the whole row.  So the accounts in Column A have to apply to all sections; if you have accounts in another column, they may be printed but they will not be used in calculations.  Similarly, your criteria in Column B will apply to the whole row.  You can set criteria in each column to get good departmental financials, but in your case, it looks like your departments are too dissimilar to make this work.

Reply
  • 0
    SUGGESTED

    There may be other tools that can do this, but FR is not the way.  FR works on one row at a time, using information in the first four columns as the framework for the whole row.  So the accounts in Column A have to apply to all sections; if you have accounts in another column, they may be printed but they will not be used in calculations.  Similarly, your criteria in Column B will apply to the whole row.  You can set criteria in each column to get good departmental financials, but in your case, it looks like your departments are too dissimilar to make this work.

Children
No Data