This function is used to view the detail of the entries carried out on an account. This function can be called from the balance inquiry.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The default inquiry screen for the account is associated with the account in the Screen codes tab of the chart of accounts.

Header

The inquiry is performed on a screen. In the header, first enter one of the following information group:

  • a company, company group or site group,
  • a ledger type among those attached to the previously defined entity and set to the General accounting type,
  • a selection on the transaction currency is available provided that you only need to filter entries posted in a given currency (otherwise, this field must remain empty),
  • a date range to limit the inquiry,
  • an account belonging to a chart of accounts having the General tracking management option checked, and attached to the ledger selected in the current record,
  • or the control account and the individual account (BP) to be viewed (if you only want to view the entries of an individual account on a given control account),
  • or a group of control accounts and the individual account to be viewed (if you only want to view the entries of an individual account on a given list of control accounts, identified by a group of control accounts),
  • or only an individual account, if you want to view all the control accounts altogether.

The balance displayed in the header is always expressed in the company (or local) currency, in other words the general ledger currency of the company.
In the case of a group inquiry, the main social ledger currency must be the same for all companies.

Tab Account

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

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

  • the accounting entry (for all types of entries). Access to this function is provided in view mode but also in creation and modification modes.
  • invoice (for the Invoice and Credit note entry types),
  • the 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. The default currency comes from the company (if no balance with local currency amount management) or the requested general account/business partner (if balance with local currency amount management).

SEEINFO The fields described below can be set up from the screen.

Tab Balances

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).

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 based on the additional filters specified when clicking Criteria from the actions 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 :

  GLGRPAUX : Auxiliary general ledger

  GLGRP : GL journal account details

This can be changed using a different setup.

This function is only associated with the two legal reports listed above, GLGRPAUX - Auxiliary general ledger and GLGRP - GL journal account details. You cannot change these reports using a different setup as only these two reports are fixed for this inquiry in the code.
Only one of these reports can be printed for the current inquiry. The assigned report is determined by the value of the Account (COMPTE) and BP (TIERS) fields, as follows:

  • GLGRPAUX can be printed when the current inquiry is run for a business partner, that is, the BP field (TIERS) in the Home section contains a BP code.
  • GLGRP can be printed when the current inquiry is run for an account, that is, the Account field (COMPTE) in the section contains an account code.

Specific actions

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 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 account 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 account are displayed even if the entry type or linked journal 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 but uses the access code set up on the journal.

    Examples:

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

    If the entry line applied to the account is linked to an authorized entry type while the journal is unauthorized, 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 :

    Full grid

    This message is not strictly an error message. For technical reasons, the maximum number of lines loaded in the inquiry screen is set to 500. If more than 500 lines match the criteria this message is displayed, and only the first 500 lines can be viewed. It is then necessary to enter more restrictive criteria in order to obtain fewer lines in the grid.

    You must enter a company or a site

    In criteria entry, the company and site fields are both empty (which is not authorized).


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

    All companies do not use the same chart of accounts for this ledger type

    The requested inquiry concerns a group of companies whose charts of accounts attached to the type of ledger are different. 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