This function is used to view the detail of the postings made to an analytical dimension.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

The inquiry is performed on a screen. Enter in the header:

  • the company, company group or site group.
  • the ledger type,
  • the dimension type,
  • the specific dimension (you can still view all the dimensions for the same analytical dimension type by using the radio buttons),
  • the date range for the inquiry.

Once the criteria are entered, click Search to launch the inquiry. Click Next and Return to browse through the data pages.

The balance that appears in the header is displayed in company currency. You can inquire the details of this balance by period in the Balances tab.

Using the Actions icon available on lines, you are provided direct access to:

  • the accounting entry (for all entry types); access to this function is granted in view but also creation and modification modes,
  • the BP invoice (for the Invoice and Credit memos type entries),
  • the open items (for the Invoice and Credit memos entry types).

Tab Dimension

You can define the filter and display criteria. Depending on the entered criteria, the list of entries related to the dimension is displayed.

You can then position the cursor on a line and zoom as required using the Actions icon:

  • the accounting entry - for all entry types - (you can still view all the dimensions for the same analytical dimension type by using the radio buttons),
  • invoice (for the Invoice and Credit note entry types),
  • open items (for the Invoice and Credit note entry types).

Criteria entry

Click Header, Line and Analytical to enter additional criteria in the form of combining conditions. These conditions can respectively call on all the fields in tables GACCENTRY (Entry header), GACCENTRYD (Entry lines) and GACCENTRYA (Analytical Entry lines) as well as to the operators equal, greater than, less than, different and to constant values.

When using the criteria definition function, click Memo to save the modified parameters. A window opens where you can enter the memo code identifying the saved parameters.
Click Recall to enter a memo code and recall the criteria related to this code.
When you access the account inquiry function, the parameters stored with the STD code are recalled by default.

If the criteria are not saved in a STD memo, the default values proposed are the default financial site for the user (and the corresponding company), the date range corresponding to the last open fiscal year.

Tab Balance

For each accounting period end included in the inquiry date range, the debtor and creditor balances as well as the total for the transactions in the period are displayed, either in transaction currency (if a selection of the currency has been made in the inquiry header) and in the local currency amount of the company currency, or in company currency (currency code = blank). 
Information is displayed in a "grid" or "graph".
 This button is used to switch from graph mode to table mode.

Balances and totals by period

Balance amounts are displayed in this grid. These are the account or dimension balance sheet amounts at each period end on the header's selection header.
Only criteria specified in header are taken into account for the calculations.

Selection criteria for totals

The Debit total, Credit total and Balance are calculated on the basis of additional filters specified by clicking the Criteria button (in the action panel).

SEEWARNING For a group of companies with different start and end date, the Balances tab is not loaded.

Reports

By default, the following reports are associated with this function :

  GLANA2 : Analytical ledger/dimension

This can be changed using a different setup.

Specific Buttons

Criteria

Click Criteria to refine the inquiry parameters.
A new window opens and suggests the following selection criteria:

  • The company code and the site code
  • The ledger type
  • The date range
  • The transaction currency, if you require only the entries saved in a given currency (if not, this field must remain empty)
  • The nature
  • The account of the chart of accounts linked to the selected ledger
  • Select multiple check boxes to include specific entries like carry-forward, closing, or simulations, in the inquiry

This window also suggests criteria for the display of information:

  • A choice for the sort order for the journals displayed (by accounting date, matching or due date)
  • The screen code used to display the entries.  If you select a screen code that has been set up to display Source and Source transaction, you will see those columns for each journal entry in the results grid.
  • (see the prerequisites explanation)
  • The structure used to view the accounting entries if a tunnel is used to zoom to the entries. Warning, when an entry has been created under a particular structure, it will only be possible to view it with this structure.

A Filter button is available in this window. It is used to enable an advance selection of the elements to be viewed from the fields in the account posting header file.

You can save selections by assigning a memo code to them by clicking Memo.
To display a saved selection, click Recall and enter the Memo code.
To clear a saved selection, click Delete memo and enter the Memo code.

SEEINFO 

Balance

The button Balance is present and replaces the Balances tab when the CNT activity code is set to No.
For each accounting period end included in the inquiry date range, the debtor and creditor balances as well as the total for the transactions in the period are displayed, either in transaction currency (if a selection of the currency has been made in the inquiry header) and in the local currency amount of the company currency, or in company currency (currency code = blank).
Information is displayed in a "grid" or "graph".
 This button is used to switch from graph mode to table mode.
The transaction totals are expressed in the following currencies:

  • in the transaction currency (1st column),
  • in ledger currency (2nd column if present).

Limits

Matching or unmatching Fiscal Years

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, i.e. with the same fiscal year start and end dates.

The following rules should be followed:

  • the ledger type chosen must have the same book-keeping currency for each of the companies in the group (the currency of the ledger type is determined at the level of the account core model setup),
  • the inquiry must concern a same chart of accounts,
  • the breakdown of the fiscal years must be identical for all the companies contained in the group.

 

Examples:

  • Group 1:
    • Company 1 has a first fiscal year date on 01/01/2008 and calendar fiscal years (from January to December).
    • Company 2 has a first fiscal year date on 01/01/2010 and calendar fiscal years (from January to December).

The group 1 can be inquired from the 01/01/2008 on.

 

  • Group 2:
    • Company 1 has a first fiscal year date on 01/07/2008. Its first fiscal year starts on 01/07/2008 and ends on 30/06/2009.
      Its second fiscal year goes from 01/07/2009 to 31/12/2009 and the following fiscal years are calendar ones (from January to December).
    • Company 2 has a 1st fiscal year date on 01/01/2009 and calendar fiscal years (from January to December).

Until the 01/01/2010, the inquiry obeys the rules related to the company groups with shifted fiscal years.
From the 01/01/2010 on, the inquiry obeys the rules related to the company groups with homogeneous fiscal years.

Second case:the inquiry concerns a group of companies with shifted fiscal years, that is with different fiscal year start and end dates.

The same rules have to be respected.

Remember: when the inquiry concerns a group of companies with shifted fiscal years:

  • the accounting balance, in the header, is not calculated/displayed
  • the Balances tab is not populated.
  • Examples:

    • Company 1 has a first fiscal year date on 01/01/2008 and calendar fiscal years (from January to December).
    • Company 2 has a 1st fiscal year date on 01/09/2009 and fiscal years from September to October.

    It has been requested to inquire the period ranging from the 01/01/2010 to the 30/06/2010.
    The result displays, for the requested account, the detail of entries related to an analytical account for the requested period. The header accounting balance and the tab Balances are not loaded.

    Limits related to access codes

    In the case where the inquiry applies to an analytical dimension with an access code, the behavior is as follows:

    If the access code is set up at user level, with viewing rights, all entry lines allocated to the dimension are displayed even if the entry type, journal, or linked account are not authorized for the user.

    If you use the Jump to action, Sage X3 does not take into account the access code set up on the entry type or account but uses the access code set up on the journal.

    Examples:

    If the entry line allocated to the dimension is linked to an unauthorized entry type or account while the journal is authorized, then Sage X3 authorizes the use of the Jump to action.

    If the entry line allocated to the dimension is linked to an authorized entry type or account while the journal is not authorized, then Sage X3 does not authorize the use of the Jump to action. The following message is displayed: XXXX Journal not authorized

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    You must enter a company or a site

    Entry of at least one of these two fields is mandatory.

    No exchange rate XXX => YYY

    No exchange rate is defined to convert currency XXX (either the company currency or reporting currency) and currency YYY (that requested in the display).

    Incorrect date

    The start and end dates must belong to the defined fiscal years.


    Other than generic messages, the following error messages can appear when using this tool:

    Inconsistent ledger between the companies of the group for this ledger type

    The requested inquiry is on a group of companies with different ledgers. No inquiry is possible.

    All companies do not have the same currency for this ledger

    The requested inquiry concerns a group of companies which currencies set up for the ledgers attached to the selected type of ledger are different. No inquiry is possible.

    Periods incompatible between the companies of the group

    The requested inquiry concerns a group of companies which fiscal year periods are broken down differently.
    For instance, for company 'A' the fiscal year starts on the 01/01/2010; as a result, the periods start on the first day of each month. For company 'B', the fiscal year starts on 15/01/2010; as a result, the periods start on the 15th of each month.
    No inquiry is possible.

    Tables used

    SEEREFERTTO Refer to documentation Implementation