Defining Journal Report Scripts

You create journal reports to check the status of journals and review journal adjustments. You can create a journal report to display information for a specific journal, or list of journals. For example, you can select to display only journals with a specific status, balance type, entity, or account. You can also select the columns that display on the report and change their sort order.

You can set entity and account filters for journal reports in the report definition. The syntax for Entity filtering is EntityFilter=ParentName.ChildName (for example, UnitedStates.Maryland). The syntax for Account filtering is AccountFilter=MemberName (for example, Sales).

This example shows a sample Journal report definition:

  ReportType=Journal

  ReportDescription=Tax Journals

  POV=S#Actual.Y#2014.P#January.V#<Entity Curr Adjs>

  DisplayColumn_0=Account,Ascending,NoRepeat,Yes,Label

  DisplayColumn_1=ICP,,NoRepeat,No,Label

  DisplayColumn_2=Products,,NoRepeat,No,Label

  DisplayColumn_3=Markets,,NoRepeat,No,Label

  StatusFilter=Working,Submitted,Rejected,Approved,Posted

  TypeFilter=Regular

  BalanceTypeFilter=Balanced,Unbalanced

  EntityFilter=UnitedStates.Maryland

  AccountFilter=Sales