Skip to end of metadata
Go to start of metadata

INTRODUCTION TO INFO AND REPORTING

This Chapter describes the Standard Reporting features in Compiere. The following features are supported: Info, Reporting (Window Report, Document Print, and Custom Reports), Trial Balance, and Financial Reports (Report Line, Report Column).

THE INFO

The Info Windows are windows that provide you with all of the information that is available on a specific element. These windows can be accessed via the View Menu.

LIST REPORTING

List Reporting is initiated by clicking on the Report button on the toolbar or by pressing Alt-P.

This brings up a viewer with an initial layout, which can be tailored to match your requirements.

Note: the following features are available in the Java Client.

The Report offers two features:

  • Drill-down
  • Drill-across

The Drill-down feature is used by clicking on the underlined lines. Double-click on one of them to create a Report for that specific element or item.

The Drill-across features is available 'where used'. You select the data you want to 'Drill to' from the Drill drop down list at the top of the Report window and then double-click on the line you want to use as the source of the drill.

The Report also offers a search facility, which is identical to the window search. Either click on File < Find record, use the Ctrl-F shortcut or click on the Find record button on the toolbar.

The Page Setup button on the Report toolbar is used to set up the orientation of your Report.

The Print button on the Report toolbar is used to set up the printing options for your Report.

The Send Email button int he Report toolbar is used to send the report as a PDF attachment to an Email.

For additional information on sending Emails, refer to the Common Functions and Commands Chapter.

The Archive Documents and Reports button on the Report toolbar is used to Archive this report.

For additional information on Archiving, refer to the Utilities Chapter.

The Export button on the Report toolbar is used to export your data to the following formats: Excel CVS, HTML, XML, Postscript, and PDF.

Customizing Reports

Compiere allows you to customize your Report and adapt it to your needs. You can change the following elements.

  • Display Order
  • Sort Order
  • Format Item
    • Field, Image, Text, Print Format
    • Alignment% Width/Height
    • Calculate Sum - Average - Count
    • Group by (requires Order by sorting)

Print Format

Open the Print Format window to customize your Report by either clicking Print Format from the Main Menu or by clicking on the Customize Report button from the toolbar of the Report in the Java Swing Application.  In the Web UI you can also use the Visual Editor to customize your Print Format.

Note: When you open the Print Format using the menu option you must close and reopen your report to see the changes that were made. If you open the Print Format using the Customize Report button your report will be re-displayed with the changes made when you close the Print Format.

Print Format

You see the Name of the Report, which corresponds to the Table in which the field resides.

The Report View field specifies the view that is used to generate this report.


 
De-select the Form check box to print a columnar List report. Select it to print a Form. Customizing Forms will be discussed in the next section, Customizing Forms. A form has individual elements with layout information (example: invoice, check). A columnar list report has individual columns (example: list of invoices or inventory lines).

The Print Table Format determines Fonts, Colors of the printed Table.

Select the Standard Header/Footer check box to indicate that the standard Header and Footer is used. If you do not want to use the standard header, it must be explicitly defined.

The Print Paper defines Size, Orientation, and Margins of the document.

The Print Font is the Font used for printing. The Print Color is the Color used for printing.

The Copy/Create buttons allows you to copy an existing Print Format or create a new Print Format from a Table.

EAN-13 type barcode

EAN-13 is a linear barcode and is primarily used in supermarkets to identify product at the point of sales. The products contain the EAN (International Article Number) or GTIN (Global Trade Item Number) for identification.

Note: Ensure that the number of digits is 12 or more for the EAN-13 Barcode. The standard EAN/GTIN product code has 13 digits.

The advantages of using the EAN/GTIN code are:

  • It is not necessary to label all articles with the price. The price is stored in the database and can be accessed using the barcode number.
  • Faster usage and increased safety with zero errors.

For more information, refer to the EAN-13 type barcode document.

Display Order

Move to the Display Order tab to change the Display order of the elements on it and adapt it to your needs.


 
To add an element to the Report, click on an item from the list of Excluded Items and move it to the Included Items list by clicking on the Right arrow. Change the sequence of an element by selecting an Item and using the "Up and Down" arrows. To remove an element from the Report, simply select the item to remove and click on the Left arrow. Save your changes. The changes will be immediately effective in your Report.

Sort Order

Move to the Sort Order tab to change the Sort Order and adapt it to your needs.


 
To add an element to the Record Sort No field, click on it in the list of the Excluded Items and move it to the Included Items list by clicking on the Right arrow. Change the Record Sort No of an element by selecting an item and using the "Up and Down" arrows. To remove an element from the right side, simply select it and click on the Left arrow. Save your changes.

You would only insert fields which you need to be sorted, for example the Line No or the Quantity Count.

Format Item

Move to the Format Item tab to see which elements are on your Report.

The items listed correspond to the Sequence list in the Display Order tab.

Select an item to display the Single Record.

The Sequence specifies the order of this Format item.

The Name specifies the name of the field that will print on the report.

The Print Text specifies the label that will print before the field value. The Print Text may also contain any of the following variables:

  • @*Page@ - the current page number
  • @*PageCount@ - the total number of pages
  • @*MulitPageInfo@ - page X of Y. It is only printed if there is more than one page
  • @*CopyInfo@ - if this is a copy of a documents 'Duplicate' is printed
  • @*ReportName@ - the name of the report
  • @*Header@ - full header with user/Tenant/org name and connection
  • @*CurrentDate@ - the print date
  • @*CurrentDateTime@ - the print time

The Format Type tells you what format the element has, for example, Field, Image, Line, Rectangle, Text, Print Format. Depending upon the selection made, different fields will display.

If you select a Format Type of Rectangle, you must select a Shape Type of 3D Rectangle, Normal Rectangle, Oval, or Round. Select the Fill Shapecheck box if you want to have a solid shape. The left top corner of the shape will is defined either an absolute value or relative value, as detailed below. The bottom right corner is calculated using the Maximum Width/Height.

There are different ways to determine where to print an item. If you want to enter the absolute position of a field, de-select the Relative Position check box. You then enter the X Position and Y Position for the field in points (1/72nd of an inch). Select a Field Alignment of Block, Center, Default, Leading (left), or Following (right).

You may also define the print position of an item relative to the prior field that printed. To use this method, select the Relative Position check box. Select the Set NL Positioncheck box if you want this position to be used when printing an item on a new line (similar to a tab stop in a document). Select the Next Line check box if this field will print on the next line (similar to a carriage return). If this is not selected, the item will print on the same line. Select the Next Page check box if this field will print on a new page. Select a Line Alignment of Center, Leading (left), Following (right), or None. Select a Field Alignment of Block, Center, Default, Leading (left), or Following (right). Enter an X Space (horizontal) to indicate in points (1/72nd of an inch) where this item should print in relation to the previous item. Enter a Y Space (vertical) to indicate in points (1/72nd of an inch) where this item should print in relation to the previous item.

Enter the Maximum Width of the item in 1/72 of an inch (point). If the value equals zero (0), there is no height restriction.

Enter the Maximum Height of the item in 1/72 of an inch (point). If the value equals zero (0), there is no height restriction.

If you select a Format Type of Image, you must either select the Image Attached check box and attach the image, or enter the Image URL where the image can be found. If the Image is attached it is stored in the database. If the Image URL is used, the image is retrieved at run time so users must have access to the location indicated. The image can be a GIF, JPEG, or PNG file.

The Area specifies where the field, image, print format or text will print. You may select Header, Footer, or Content.

If you select a Format Type of Print Format, you must select the Column to indicate the field to use for joining the header and detail records and the select the Included Print Format to be used. This allows for the printing of Master / Detail reports.

The Print Label Suffix can be used to print a character or group of characters after the field label.

If you select a Format Type of Text, no additional fields are required.

If you select a Format Type of Field, you must enter the database Column for this field.

The Printed check box indicates if this column will display and print on the Report.

If you select a Format Type of Line, you must select a Line Width. The start point is defined as either an absolute value or relative value, as detailed below. The end point is calculated using the *Maximum Width/Height.*For example, a Width of 0 and a Height of 10 will print a vertical line. A Width of 10 and a Height of 0 will print a horizontal line. A Width of 10 and a Height of 10 will print a diagonal line.

Select the Suppress Null check box to indicate that this column won't be displayed if there are no values in it. If only a single field has no value, the field won't be displayed (and printed).

Select a Barcode Type from one of the 20 specifications available. This will print a barcode representation of the field selected. 

Enter the Maximum Width of the item in 1/72 of an inch (point). If the value equals zero (0), there is no height restriction.

Select the Fixed Width check box to indicate that the Column has a fixed width independent from the content.

Enter the Maximum Height of the item in 1/72 of an inch (point). If the value equals zero (0), there is no height restriction.

Select the One Line Only check box to indicate that only one line is printed. If the column has a width restriction, the text is broken into multiple lines. If One Line is selected, only the first line is printed.

Select a Print Color to indicate which Color is to be used for printing the value in the element.

Select a Print Font to indicate which Font used for printing the value in the element.

Select the Order by check box to indicate that the records are ordered by the value of this column. If a column is used for grouping, it needs to be included in the sort order as well.

The Record Sort No determines in what order the records are displayed.

Use the Group by field to group different elements. Grouping allows you to print sub-totals. If a group changes, the totals are printed. Group by columns need to be included in the sort order.

Select the Calculate Sum check box to indicate that the total sum the data is to be calculated if the field is numeric. If not, the total sum length of the field will be calculated.

If the Calculate Sum check box is selected, the Running Total check box will be displayed. Select this check box to indicate that running totals should be displayed. Enter the Running Total Lines to indicate the number of lines to print on the report before displaying a Running Total.

Select the Calculate Count check box to indicate that the total number of NOT empty elements is to be calculated (maximum is the number of lines).

Select the Calculate Minimum check box to indicate that the minimum value is to be displayed.

Select the Calculate Maximum check box to indicate that the maximum value is to be displayed.

Select the Calculate Mean check box to indicate that the average of the data is to be calculated if the field is numeric. If not, the average length of the field will be calculated.

Select the Calculate Variance check box to indicate that the variance of the data is to be calculated if the field is numeric. The variance is calculated as the average of the square differences of the rows of data and their mean.

Select the Calculate Deviation check box to indicate that the deviation of the data is to be calculated if the field is numeric. The deviation is calculated as the average of the square root of the variance.

Item Translation

Click on the Translation tab to enter a translation for your item/element. If you are printing Translated Documents you will want to translate any Text fields, Print Text and Print Label Suffixes. For more information on Multi Lingual Documents, refer to The Multi's Chapter.

Note: The Translation tab will only be displayed if your Preferences indicate it.

Customizing Forms

Compiere allows you to customize your Forms. Compared to a columnar list report, a Form has individual elements with layout information. An example would be an Invoice or a Check.

Customize Invoice

Select the Form you want to customize and click on the Print button. As an example you would open your Invoices by clicking on Invoice (Vendor) from the Main Menu. Select an invoice to customize.

Use the Data Grid toggle to Switch to the Single Record and click Print. This calls the Invoice and displays how it will actually be printed. Note that in your Preferences the Always Preview Print check box has to be selected. Otherwise the document will print directly.

To customize your Invoice, click on the Customize Report button from the toolbar of the Invoice or simply open the Print Format window from the Main Menu and select Invoice Header. This will open the Print Format window for the Invoice Header.


 
The Name of the Report is now 'Invoice Header', which corresponds to the Table in which the field resides.

The Report View specifies the view that is used to generate this report.

The Form check box is selected now to indicate that it is a Form. De-selecting it specifies that a columnar list report with individual columns is being created (example: list of invoices or inventory lines). See section above, Customizing Reports.

The Print Table Format, which is now the 'Standard Document' determines: Fonts and Colors of the printed Table.

The two fields Header Margin and Footer Margin tell you the distance from the top/bottom of the printable page to the beginning/end of the main content in 1/72 of an inch (point).

Select the Standard Header/Footer check box to indicate that the standard Header and Footer is used. If you do not want to use the standard header, it must be explicitly defined.

The Printer Name defines the printer to be used for this Print Format. It takes precedence over the printer selected on the login screen.

The Print Paper defines Size, Orientation, and Margins of the document.

The Print Font is the Font used for printing. The Print Color is the Color used for printing.

The Copy/Create button allows you to copy an existing Print Format or create a new Print Format from a Table.

Note: If you are not satisfied with the layout of your document and want to start again, you refresh the Print Format Forms (e.g. Invoice formats) from Templates. To do this, you have two options.

The options available to modify the document layout are as follows:

Option A)

  • Open the Print Format window and select a Print Format from the data grid.
  • Delete the Lines(!) of the Form you want to refresh - (you cannot delete the Format itself as it is still referenced.)
  • Click on the Copy/Create button and select the Template.
  • Enter a different name for this Print Format.

Option B)

  • Create a new Print Format - choose any table/name
  • Click on the Copy/Create button and select the Template
  • Enter a different name for this Print Format
  • Go to Print Form and select your new Format
  • You can delete the old Print Format

Display and Sort Order

The Display Order and Sort Order tabs are used in the same way as in the section above, Customizing Reports.

In this case, the only Record you would normally use for sorting would be the Document No.

The element you would need to change in the Format Item tab is the Logo. Open the tab and select the Logo record.

Use the Data Grid toggle to switch to the Single Record for Logo.

The Name now defaults to Logo, the Format Type to Image. To use an attached image select the Image attached check box. (Attached images are not currently supported.) The image to be printed on the document is stored in the database as an attachment to this record. The image can be a GIF, JPEG or PNG file.

Then click on the Attachment button on the toolbar and then on the Load button in the Attachment window, that opens.

Select a GIF, JPEG, or PNG file and click OK.

To use an image which is not stored in the database, de-select the 'Image attached' check box, and provide the URL of the image. Now the image will be retrieved at runtime. The image can be a GIF, JPEG, or PNG file and click OK.

Note: The URL needs to be the path to a file on the web server.

For an explanation on the other fields see the Section above, Customizing Reports.

Item Translation

Click on the Translation tab to enter a translation for your item/element.

Note: The Translation tab will only be displayed if your Preferences indicate it.

Print Form

The forms that are used for different Documents are defined in Print Form. The Initial Tenant Set up defines the forms to use for all Organizations for the Tenant but you can define specific forms to use for each Tenant.

To create, modify or delete Print Forms in Compiere, click on Print Form from the Main Menu. The icon in front of the menu item indicates that it is a window.


 
This window defines all the Print Formats to be used for different document types. In this example all Orders (Sales and PO, regardless of Order Type) will use the Order Header Print Format.

If you want to use a different Format for any of all of the documents for a specific Organization, create a new record or copy this record. Make sure you select a specific Organization and a unique name. Then select the desired Print Formats. Print Forms defined at an Organization level override any Forms defined at a System * level.

Print Format

There may be instances where you required a unique Print Format for a Document Type. For example, you have defined a new Document Type for Orders for Government facilities. It follows all of the processing rules as a Standard Order, uses a specific numbering sequence. To accomplish this you must do the following:

  • Define a new Document Sequence
  • Define a new Document Type
  • Define a new Print Format
  • Select the new Print Format for the Document Type
  • Select the Document Sequence and Document Type

Once you have defined the new Print Format, return to the Document Type Window by clicking on Document Type from the Main Menu. The icon in front of the menu item indicates that it is a window.

In this window you would select the new Print Format and Document Sequence. A Print Format defined here takes precedence over a Print Formats defined in Print Forms.

The decision path is as follows:

  • Print Format defined for Document Type
  • Print Format defined in Print Forms for that specific Organization
  • Print Format defined in Print Forms for the System

Customizing Hints and Tips

The best way to create a new table based Report is to copy an existing Print Format and then make the desired changes.

If you are modifying a Print Format and need to return to the templates to start again you have 2 options.

From the existing Print Format:

  • Select the Print Format
  • Delete the Lines of the Form you want to 'refresh'. You cannot delete the format itself as it is still referenced.
  • Click on the Copy/Create button and select the Template.
  • Rename the Print Format

From a new 'Print Format':

  • Create new Print Format (give it any name)
  • Click on the Copy/Create button and select the Template
  • Rename the Print Format
  • Go to Print Form and select the new Print Format
  • You can now delete the old Print Format as it is no longer referenced.

If you want to define specific Print Formats for an Organization's documents, do not define the Print Format in the Document window. Instead, define the Print Format for each Organization.

Print Format used for Invoices are selected in the following way:

  • Defined for the Business Partner
  • Defined for the Document Type
  • Defined in Print Format for a specific Organization
  • Defined in Print Format for all Organizations *

Print Format used for all other documents are selected in the following way:

  • Defined for the Document Type
  • Defined in Print Format for a specific Organization
  • Defined in Print Format for all Organizations "*"

FINANCIAL REPORTING

Financial Reports are used to generate controlling reports like Balance Sheet and Income Statement.  They are comprised or 2 distinct entities, Report Column Set and Report Line Set.  These two entities are combined to generate a Financial Report.  This definition allows you to combine entities to produce new reports.  For example, if you have defined a Report Line Set that includes your Expense accounts you can use that with a Report Column Set that has Current Period Actual and Current Period Budget to rate expense based on budget or with a Report Column Set that has Current Period Actual and Prior Period Actual and Last Year Actual to compare against historical data.

Report Column Set

The Report Column Set is the window where you define the data that will appear as columns in your report.  Generally this will be amount information like Current Period or Year to Date, but it could be any dimension available for a given Organization.  To open this window, click on Report Column Set from the Main Menu. The icon in front of the menu item indicates that it is a window.

The Report Column Set Tab defines and identifies the columns of a Financial Report.  Click on the New Record button to create a Report Column Set.  Enter a Name and a Description if you like. 

The Copy Columns button allows you to copy columns from an existing Report Column Set. You may choose this option if you are creating a new Report Column Set that is similar to an existing one.  When you select the Copy Columns button you will be prompted to select an existing Report Column Set from which to copy. 

Save your record prior to moving to the Report Column Tab.


 
The Report Column Tab defines the columns for the report.  Enter a Name, which will appear as the column heading in your report and a Description

The Sequence entered will determine the order the columns will display in. 

Select a Posting Type of Actual, Budget or Statistical.

Select an Amount Type, for example Period Balance or Period Debit Only.

Select a Column Type of Relative Period, Calculation or Segment.  When Relative Period is selected, the Relative Period field will display in which you enter a numeric offset from the current or reporting period.  For example, if you want to have a column which displays the previous period balance, enter a -1.  If you want to display the current period enter a 0.  If Calculation is selected, the Calculation, Operand 1, and Operand 2 fields display allowing you to define the type of calculation and the columns to use in the calculation.  If Segment Value is selected then the Type field is displayed allowing you to select the Segment to use and also the specific value.  You would use this option if your report was to display Business Partners as columns and Products as lines, for example.

Select the Is Printed check box if you want this column to print on your report.  This allows you to suppress the printing of columns used in calculations.

Report Line Set

The Report Line Set is the window where you define the data that will appear as lines in your report.  Generally this will be Accounts, Products or Business Partner, but it could be any dimension available for a given Organization.  To open this window, click on Report Line Set from the Main Menu. The icon in front of the menu item indicates that it is a window.

The Report Line Set Tab defines and identifies the lines of a Financial Report.  Click on the New Record button to create a Report Line Set. 


 
Enter a Name and a Description if you like. 

The Copy Lines button allows you to copy columns from an existing Report Line Set. You may choose this option if you are creating a new Report Line Set that is similar to an existing one.  When you select the Copy Lines button you will be prompted to select an existing Report Line Set from which to copy. 

Save your record prior to moving to the Report Line Tab.

The Report Line Tab defines the lines for the report.  Enter a Name and a Description which will both appear on your report. 

The Sequence entered will determine the order in which the the lines will display. 

Select a Line Type of either Calculation or Segment Value. If Calculation is selected, the Calculation, Operand 1, and Operand 2 fields display allowing you to define the type of calculation and the lines to use in the calculation. If Segment Value is selected then the Posting Type and Amount Type fields display.  Generally these fields would be left blank.  You would select values here if your report was to display amounts as line items as opposed to columns.

Select the Is Printed check box if you want this line to print on your report.  This allows you to suppress the printing of lines used in calculations. 

Save your record prior to moving to the Report Source Tab.

The Report Source Tab defines and identifies the source values to be used in a Financial Report. 

Click on the New Record button to create a Report Source. 

Enter a Name and a Description if you like. 

Select a Type.

Note: The list of values will be those valid dimensions for an Organization. 

The Type selected will determine the remaining field on this tab.  For example, if Business Partner is selected as the Type, then a field for selection of a Business Partner will display.  If Account is selected as the Type, then a field for selection of an Account will display.  Both Child and Parent (or Summary) values are valid selections.

Report Hierarchy

In Compiere you can define more than one Hierarchy for any element selected in your Accounting Schema. This allows you to report on different structures or roll ups of your Organization, Projects, Business Partners, etc. Perhaps you have the following Organization structure.

With this hierarchy you could report on Direct Sales which would include City Store and Country Store, or Direct Sales which would include those two as well as Direct Sales HQ.

What you could not accomplish with this structure would be to report on only Store Sales (City Store and Country Store). To achieve this simply define a new hierarchy.

Your alternate hierarchies may be just a subset of the prime hierarchy but all posting level or leaf nodes must be defined first on the primary hierarchy.

To use Hierarchies in Financial Reports define a Reporting Hierarchy. To open this window, click on Reporting Hierarchy from the Main Menu. The icon in front of the menu item indicates that it is a window.

Enter a Name for this Reporting Hierarchy.

Enter a Description and Comment if desired.

Select the Active check box to indicate this Reporting Hierarchy is active.

Select the Trees to be used for each Element.

Note: If an Element is not used for the Accounting Schema defined for the Financial Report, it is ignored.

Financial Report

Financial Report is the window where you select the Report Column Set and Report Line Set that will be used to generate your Financial Report.  To open this window, click on Financial Report from the Main Menu. The icon in front of the menu item indicates that it is a window.

The Financial Report window defines the high level parameters for a Financial Report as well as the columns and lines.  Click on the New Record button to create a Financial Report.


 
Select an Accounting Schema and Calendar from the list boxes.  This will provide the high level parameters for your Financial Report. 

Enter a Name to appear at the top of your report.  Enter a Description if you like.

Select a Report Line Set and Report Column Set from the drop down list boxes.

Select the List Sources check box if you want to list the sources for each line.  If you have chosen summary level entities as your sources in the Report Line Set then selecting this check box will display all child entities.  De-selecting this check box will show just the summarized information.

If you have selected the List Sources check box you can also select the List Transactions check box. This will list the individual transactions that were used to generate the source amounts.  Generally this would be used only for investigating anomalies.

Finally, click the Create Report button to generate your report.  You will be prompted to enter additional parameters for your report.

You may select any parameters. They will limit what appears on your report. Compiere also allows you to make a more general report and then customize for a specific purpose using parameters. For example, you can define a generic report for all Business Partners and then generate the report for a specific Business Partner by selecting it in the parameters window.

Select the Details/Source First check box if you have selected List Sources for this financial report and you want the source lines to print before the summary line. The default is to print the summary line before the source lines.

Select the Update Balances check box if you have transactions that were recently posted and you want to ensure they are included in the report.

Select a Reporting Hierarchy. If this field is left blank it will use the Primary Trees defined for the Tenant.

Click the OK button to create the report.

Your report is displayed in the Report Viewer. A Print Format is automatically generated the first time a Financial Report is generated.  You can modify the print format by selecting the Customize Report button. 

For more information on Customizing Reports, refer to the previous section in this chapter.

Financial Reporting Hints and Tips

When defining your line and column sets, leave spacing between sequence numbers so lines or columns can be easily inserted at a later time.

If you select a Posting Type in both the line set and column set make sure they are not mutually exclusive.  Records must meet all selections to be included.  For example if your line set has a Posting Type of Actual and your column set has a Posting Type of Budget then no records will be selected.

If you select a Line Type of Calculation in Report Lines then the Report Source would be blank.

You can create a heading with a blank line in a report by entering a Name and Sequence No in the Line Type and leaving the remaining fields blank.  Again, no Report Source is entered.

If you do not select a Period in the Parameter window, the current period is used.

Any Parameters entered will appear at the top of the report.

The Print Format is generated the first time a report is run.  You can modify it to make cosmetic changes to your report.  The Print Format will be re-created when the Line Set or Column Set changes.

If there have been recent postings select the Update Balances check box to insure that all transactions are included.

TRIAL BALANCE

A Trial Balance allows you to see your current status for and Organization, Business Partner, Product, Project or any combination of the elements defined in your accounting schema. The Trial Balance displays the beginning balance and the period activity for each account. The Trial Balance uses a print format so you can modify it and create the desired display for the report.

To create a Trial Balance Report in Compiere, open Trial Balance from the Main Menu. The icon in front of the menu item indicates that it is a report.

Select the OK button to display the parameters dialog.

Select an Account Schema for this Trial Balance.

Select a Period, if desired, for this Trial Balance. If no Period is entered, the current period is used.

Enter an Account Date range. This will over-ride any Period entered.

Select an Organization for this Trial Balance or select blank to create the report for all Organizations in this Tenant.

Select any combination of Account, Account Key range, Business Partner, Product, Project, Activity, Sales Region, and Campaign to restrict the date displayed in the Trial Balance. The fields available will depend upon the elements defined for this Accounting Schema.

Select a Posting Type to indicate the balances to display in this Trial Balance.

Select a Reporting Hierarchy. If this field is left blank it will use the Primary Trees defined for the Tenant.

Select the OK button to generate the Trial Balance.

The Trial Balance is displayed. The Parameters selected print at the top of the report.

The first line displays the Beginning Balance (in this example, the Beginning Balance is the ending balance of September because October is the current period). A single opening balance line is printed. If a single account (or summary account) is selected, it will use that account's account type to calculate the opening balance (e.g. year to date for income or expense account or life to date for asset or liability accounts). If no account or an account range is specified the opening balance will be calculated as life to date.

All accounts are displayed (as we did not limit the report by account in the parameter selection). The total lines appear because we have modified the print format for the Trial Balance. By default, the Trial Balance will display all possible fields with no sorting or totaling. Refer to the previous section for information on modifying Print Formats.

The following is the last page of this Trial Balance.

The final totals for HQ and the total Trial Balance indicate that our Organization is in balance. (Again, these totals appear based on modifications made to the Print Format.

The report will reflect all transactions for the selection criteria and date range entered in the parameters.

STATEMENT OF ACCOUNT

The Statement of Account Report displays the beginning balance, transactions and ending balance for an account for a specific period. It displays the document which the transaction refers to as well as the date. It can be used for account analysis to determine how amounts have moved in and out of an account.

To create a Statement of Account, click on Statement of Account from the Main Menu. The icon in front of the menu item indicates that it is a report.

Select the Start button to begin the report creation process. The following dialog appears for the entry of the Statement of Account parameters.

Select an Accounting Schema to define the Currency and Account structure use.

Select a Posting Type to indicate the balances to be used.

Select a Period or Account Date range for the Statement of Account. If no Period or Account Date range is entered the current period is used. If a Date Range is entered, any Period entered is ignored.

Select an Organization, Account, Business Partner, Product, Project, Activity, Sales Region, and Campaign as desired to restrict the data returned in the Statement of Account.

Select the Update Balances check box to ensure that any recent postings are included.

Select the OK check box to generate the Statement of Account.

Labels
  • None