Financials > Inquiries > Balance sheet inquiry 

Use this function to produce a balance sheet with the grouping level that matches the pyramids you have created. You can query this balance sheet with as many groups as setup for the chosen pyramid. You can query the balance sheet for one general ledger at a time. You also can query the balance sheet by multiple levels (linked to a pyramid) on the general ledger. Without this function, you are not able to query general ledgers by grouping levels.

Search based on specific criteria. 

The following are mandatory:

  • Company
  • Date ranges
  • Ledger
  • Pyramid code

Option criteria include:

  • Detail
  • Level
  • Multilevel
Outcomes when selecting different option combinations

Multilevel + Detail:

No Level entered: The query returns all levels and the movement accounts (normal and collective).

Level entered: The query returns all levels above the entered value and the movement accounts (normal and collective.

Multilevel + No Detail

No Level entered: The query returns all levels and no movement accounts (normal and collective).

Level entered: The query returns all levels above the entered value and no movement accounts (normal and collective.

No multilevel + no detail

Level entered: The query returns only the level requested.

No multilevel + detail

No Level entered: The query returns only the movement accounts (normal and collective).

Level entered: The query returns the level requested and the movement accounts (normal and collective).

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Fields

    The following fields are present on this tab :

    Selection

    Enter a company or a company group.

    Enter a site.
    • Ledger type (field LEDTYP)
    Select the general ledger from the drop-down menu.

    Enter a currency. The query only returns amounts where the original transactions were in this currency.

    If you do not enter a currency, the query returns journal entries in the ledger currency.

    • Start date (field DATDEB)
    Enter a date range to filter the query. The end date must be the end of a period.
    • End date (field DATFIN)

     

    Enter the chart of accounts.
    • Control (field SAC)

    This field is optional. Once you enter a Control account the following fields are not available:

    Account pyramid, Level, Multilevel, Include zero amounts, and Detail.

    • Filter (field CPDEB)
    Use this field to limit the balances displayed to those where the account corresponds to the filter for the general balances, and to the BPs for the auxiliary balances.

    Enter a currency to include only those entries recorded in the selected currency. The local currency amount columns in company currency are also displayed.

    If you do not enter a currency, the query includes all totals regardless of the currency in which they are entered. The columns in the transaction currency are not entered. The local currency amount columns in company currency are displayed.

    • Divisor (field DIVISE)
    Enter the code for the selected currency.

    Display

    This field defaults to the account pyramid defined in the chart of accounts, if it exists.
    • Detail (field DETAIL)

    If you select this check box, the movement (normal and collective) accounts display. If not, movement accounts (normal and collective) are not included in the query.

    If you select this check box and the Multilevel check box, you also see all levels or the levels about any value entered in the Level field.

    This field is not available if a Control account is entered.

    • Level (field LEVEL)
    Select the group level you want to search for. If blank, all levels display in the query results.
    • Multilevel (field MULLEV)

    If you select this check box and if you entered a Level, everything above that level displays.

    If you select this check box and the Detail check box, you see the movement accounts (normal and collective) in addition tothe levels.

    If no level is entered, all levels display.

    This field is not available if a Control account is entered.

    • Include zero amounts (field VOIVAL)

    If you select this check box, all the accounts are displayed even if they have no amount. This option is only available if the Detailcheck box is selected.

    This field is not available if a Control account is entered.

    • Out of the pyramid (field OUTPYR)

    Select this check box to include accounts in the chart of accounts but not in the selected Account pyramid. This option is only available if the Detail check box is selected.

    This field is not available if a Control account is entered.

    Close

     

    Tab Balance

    Fields

    The following fields are present on this tab :

    Grid Details

    • Level (field LEV)
    This field displays the level.
    • Account (field COMPTE)

    This field displays the account number.

    • Description (field INTIT)

    Title of the account.

    • Beginning debit balance (field ANTDEB)

    This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

    For a company, a site, or a group of companies with the same fiscal year start and end dates:

    The field is loaded if the amount of credit and debit movements displays a debit balance between the start date of the fiscal year and the start date of the inquiry.

    The carry forward amounts are included per the criteria selections.

    If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

    For a group of companies with staggered fiscal years, i.e. with different fiscal year start and end dates:

    Earlier balances are not displayed.

    • Beginning credit balance (field ANTCDT)

    This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

    For a company, a site, or a group of companies with the same fiscal year start and end dates:

    The field is loaded if the amount of credit and debit movements displays a debit balance between the start date of the fiscal year and the start date of the inquiry.

    The carry forward amounts are included per the criteria selections.

    If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

    For a group of companies with staggered fiscal years, i.e. with different fiscal year start and end dates:

    Earlier balances are not displayed.

    • Period debit (field DEB)

    This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

    For a company, a site, or a group of companies with the same fiscal year start and end dates:

    The field is loaded by the total of debit movements carried out during the inquired period.

    The carry forward entries are never included.

    The closed postings are included per the selection criteria and if the end date of the inquiry corresponds to the fiscal year end date.

    If the inquiry concerns several fiscal years, the intermediary closed postings are not included.

    For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

    The carry-forward entries and the closed entries are not included.

    • Period credit (field CDT)

    This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

    For a company, a site, or a group of companies with the same fiscal year start and end dates:

    The field is loaded by the total of credit movements carried out during the inquired period.

    The carry forward entries are never included.

    The close postings are included per the selection Criteria and if the end date of the inquiry corresponds to the fiscal year end date.

    If the inquiry concerns several fiscal years, the intermediary closing postings are not included.

    For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

    The carry-forward entries and the closed entries are not included.

    • Period debit balance (field SOLDEB)

    This field specifies, if the selection currency having been entered, the debit balance of the period in the selection currency.

    • Period credit balance (field SOLCDT)

    This field displays the credit balance of the period in the selection currency.

    • Period balance (field SOLPER)
    This field display the period balance in the selection currency.
    • Ending debit balance (field FINDEB)

    This field displays the amount expressed in original currency and loaded if the selection currency is entered.

    This field displays an amount if the actual accounting balance is a debit based on the total credit and debit movements from the selected and previous periods.

    • Ending credit balance (field FINCDT)

    This field displays the amount expressed in original currency and loaded if the selection currency is entered.

    This field displays an amount if the actual accounting balance is a credit based on the total credit and debit movements from the selected and previous periods.

    • Ending balance (field SOLFIN)

    This field displays the amount expressed in original currency and loaded if the selection currency is entered.

    • Ledger beginning debit balance (field ANTDEBLED)

    This field displays the amount expressed in the ledger currency depends on the following situations:

    For a company, a site, or a group of companies with the same fiscal year start and end dates:

    The field is loaded if the amount of credit and debit movements displays a debit balance, between the start date of the fiscal year and the start date of the inquiry.

    The carry forward amounts are included per the selection criteria.

    If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

    For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

    The earlier balances are not displayed.

    • Ledger beginning credit balance (field ANTCDTLED)

    This field displays the amount expressed in the ledger currency depends on the following situations:

    For a company, a site, or a group of companies with the same fiscal year start and end dates:

    The field is loaded if the amount of credit and debit movements displays a credit balance, between the start date of the fiscal year and the start date of the inquiry.

    The carry forward amounts are included per the selection criteria.

    If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

    For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

    The earlier balances are not displayed.

    • Ledger period debit (field DEBLED)

    This field displays the amount expressed in the ledger currency depends on the following situations:

    For a company, a site, or a group of companies with the same fiscal year start and end dates:

    The field is loaded by the total of debit movements carried out during the inquired period.

    The carry forward entries are never included.

    The close postings are included per the selection criteria and if the end date of the inquiry corresponds to the fiscal year end date.

    If the inquiry concerns several fiscal years, the intermediary closing postings are not included.

    For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

    The carry-forward entries and the closing entries are not included.

    • Ledger period credit (field CDTLED)

    This field displays the amount expressed in the ledger currency depends on the following situations:

    The field is loaded by the total of credit movements carried out during the inquired period.

    The carry forward entries are never included.

    The close postings are included per the selection criteria and if the end date of the inquiry corresponds to the fiscal year end date.

    If the inquiry concerns several fiscal years, the intermediary closing postings are not included.

    For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

    The carry-forward entries and the closing entries are not included.

    • Ledger period debit balance (field SOLDEBLED)

    This field specifies the debit balance for the period in the ledger currency.

    • Ledger period credit balance (field SOLCDTLED)

    This field specifies the credit balance for the period, in ledger currency.

    • Ledger period balance (field SOLPERLED)

    This field specifies the period balance in the ledger currency.

    • Ledger ending debit balance (field FINDEBLED)

    This field displays the amount expressed in the ledger currency.

    This field displays an amount if the actual accounting balance is a debit based on the total credit and debit movements from the selected and previous periods.

    • Ledger ending credit balance (field FINCDTLED)

    This field displays the amount expressed in the ledger currency.

    This field displays an amount if the actual accounting balance is a credit based on the total credit and debit movements from the selected and previous periods.

    • Ledger ending balance (field FINSALLED)

    This field displays the amount expressed in the ledger currency.

    Close

     

    Reports

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

     BSEINQ : Balance sheet inquiry

    This can be changed using a different setup.

    To create a user-friendly output, a specific report is available for this query so you can print the current display. The layout and the execution type is similar to BALANA. The is read directly from the temporary table that stores the loaded screen data.

    Specific actions

    The following fields are included on the window opened through this button :

    Selection

    • Active memo (field MEMO)

     

    Use this fields to select additional criteria for a more refined query.

    You can save these criteria by clicking Memo and assigning a Memo code. Click Recall and enter the Memo code to reload the same criteria. You can create multiple memo codes for different sets of criteria.

    Selection block

    Company: Enter a company or group of companies (mandatory).

    Site: Enter a site for a single company. This field is not available for a group of companies.

    Ledge type: Enter a ledger for the query. It can only be a general ledger.

    Date ranges: Enter a date range to limit the query. The start date cannot be a peiord start and the end date must be a period end.

    Carry forward: Select this check box to include carry-forward entries.
    SEEWARNINGBeware of the rules for taking into account carry-forward entries.

    Closing: Select this check box to include entries for the period close.
    SEEWARNINGBeware of the rules for taking into account carry-forward entries Y/N, for the group of companies.

    Off-balance-sheet: Select this check box to include entries for account not on the balance sheet.

    Pyramid block

    Account pyramid: Enter the account pyramid defined in the chart of accounts.

    Detail: If you select this check box, the movement (normal and collective) accounts display. If not, movement accounts (normal and collective) are not included in the query.If you select this check box and the Multilevel check box, you also see all levels or the levels about any value entered in the Level field.This field is not available if a Controlaccount is entered.

    Level: Select the group level you want to search for. If blank, all levels display in the query results.

    Multilevel: If you select this check box and if you entered a Level, everything above that level displays. If you select this check box and the Detail check box, you see the movement accounts (normal and collective) in addition to the levels.If no level is entered, all levels display.This field is not available if a Control account is entered.

    Include zero amounts: If you select this check box, all the accounts are displayed even if they have no amount. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

    Out of the pyramid: Select this check box to include accounts in the chart of accounts but not in the selected Account pyramid. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

    Display block

    Currency: Enter the exchange currency into which the balance is converted. The converted amounts are displayed in the Conversion column. If no currency is entered, the Conversion columns are blank.

    SEEWARNING The entered currency is not used as a filter but as a conversion data. The recovery grid displays all the transactions for the selected period, irrespective of their original currency.

    The conversion is performed based on the type of exchange rate entered for the CNSTYPCUR - Inquiry exchange rate parameter (TC chapter, CUR group).

    Based on the screen code, ( set up in the GESGTC function), you can display the amounts in the original currency, in ledger currency, and in conversion currency.

    Screen code: The preset screen codes (via the GESGTC function for the BAF code) are selected.

    On entering the account inquiry function, the parameters stored with code STD(the whole columns are displayed) are recalled by default.

    If the criteria are not stored in an STD memo, the submitted default values are the default accounting site for the user (and the corresponding company), the date range matching the last open fiscal year, and the default currency of the company.

     

    • Ledger type (field LEDTYP)

     

    • Start date (field DATDEB)

    Use this fields to select additional criteria for a more refined query.

    You can save these criteria by clicking Memo and assigning a Memo code. Click Recall and enter the Memo code to reload the same criteria. You can create multiple memo codes for different sets of criteria.

    Selection block

    Company: Enter a company or group of companies (mandatory).

    Site: Enter a site for a single company. This field is not available for a group of companies.

    Ledge type: Enter a ledger for the query. It can only be a general ledger.

    Date ranges: Enter a date range to limit the query. The start date cannot be a peiord start and the end date must be a period end.

    Carry forward: Select this check box to include carry-forward entries.
    SEEWARNINGBeware of the rules for taking into account carry-forward entries.

    Closing: Select this check box to include entries for the period close.
    SEEWARNINGBeware of the rules for taking into account carry-forward entries Y/N, for the group of companies.

    Off-balance-sheet: Select this check box to include entries for account not on the balance sheet.

    Pyramid block

    Account pyramid: Enter the account pyramid defined in the chart of accounts.

    Detail: If you select this check box, the movement (normal and collective) accounts display. If not, movement accounts (normal and collective) are not included in the query.If you select this check box and the Multilevel check box, you also see all levels or the levels about any value entered in the Level field.This field is not available if a Controlaccount is entered.

    Level: Select the group level you want to search for. If blank, all levels display in the query results.

    Multilevel: If you select this check box and if you entered a Level, everything above that level displays. If you select this check box and the Detail check box, you see the movement accounts (normal and collective) in addition to the levels.If no level is entered, all levels display.This field is not available if a Control account is entered.

    Include zero amounts: If you select this check box, all the accounts are displayed even if they have no amount. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

    Out of the pyramid: Select this check box to include accounts in the chart of accounts but not in the selected Account pyramid. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

    Display block

    Currency: Enter the exchange currency into which the balance is converted. The converted amounts are displayed in the Conversion column. If no currency is entered, the Conversion columns are blank.

    SEEWARNING The entered currency is not used as a filter but as a conversion data. The recovery grid displays all the transactions for the selected period, irrespective of their original currency.

    The conversion is performed based on the type of exchange rate entered for the CNSTYPCUR - Inquiry exchange rate parameter (TC chapter, CUR group).

    Based on the screen code, ( set up in the GESGTC function), you can display the amounts in the original currency, in ledger currency, and in conversion currency.

    Screen code: The preset screen codes (via the GESGTC function for the BAF code) are selected.

    On entering the account inquiry function, the parameters stored with code STD(the whole columns are displayed) are recalled by default.

    If the criteria are not stored in an STD memo, the submitted default values are the default accounting site for the user (and the corresponding company), the date range matching the last open fiscal year, and the default currency of the company.

    • End date (field DATFIN)

     

    • Carryforwards (field ANOUV)

     

    • Closing (field CLOTURE)

     

    • Off-balance-sheet (field HBILAN)

     

    Pyramid

    Use this fields to select additional criteria for a more refined query.

    You can save these criteria by clicking Memo and assigning a Memo code. Click Recall and enter the Memo code to reload the same criteria. You can create multiple memo codes for different sets of criteria.

    Selection block

    Company: Enter a company or group of companies (mandatory).

    Site: Enter a site for a single company. This field is not available for a group of companies.

    Ledge type: Enter a ledger for the query. It can only be a general ledger.

    Date ranges: Enter a date range to limit the query. The start date cannot be a peiord start and the end date must be a period end.

    Carry forward: Select this check box to include carry-forward entries.
    SEEWARNINGBeware of the rules for taking into account carry-forward entries.

    Closing: Select this check box to include entries for the period close.
    SEEWARNINGBeware of the rules for taking into account carry-forward entries Y/N, for the group of companies.

    Off-balance-sheet: Select this check box to include entries for account not on the balance sheet.

    Pyramid block

    Account pyramid: Enter the account pyramid defined in the chart of accounts.

    Detail: If you select this check box, the movement (normal and collective) accounts display. If not, movement accounts (normal and collective) are not included in the query.If you select this check box and the Multilevel check box, you also see all levels or the levels about any value entered in the Level field.This field is not available if a Controlaccount is entered.

    Level: Select the group level you want to search for. If blank, all levels display in the query results.

    Multilevel: If you select this check box and if you entered a Level, everything above that level displays. If you select this check box and the Detail check box, you see the movement accounts (normal and collective) in addition to the levels.If no level is entered, all levels display.This field is not available if a Control account is entered.

    Include zero amounts: If you select this check box, all the accounts are displayed even if they have no amount. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

    Out of the pyramid: Select this check box to include accounts in the chart of accounts but not in the selected Account pyramid. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

    Display block

    Currency: Enter the exchange currency into which the balance is converted. The converted amounts are displayed in the Conversion column. If no currency is entered, the Conversion columns are blank.

    SEEWARNING The entered currency is not used as a filter but as a conversion data. The recovery grid displays all the transactions for the selected period, irrespective of their original currency.

    The conversion is performed based on the type of exchange rate entered for the CNSTYPCUR - Inquiry exchange rate parameter (TC chapter, CUR group).

    Based on the screen code, ( set up in the GESGTC function), you can display the amounts in the original currency, in ledger currency, and in conversion currency.

    Screen code: The preset screen codes (via the GESGTC function for the BAF code) are selected.

    On entering the account inquiry function, the parameters stored with code STD(the whole columns are displayed) are recalled by default.

    If the criteria are not stored in an STD memo, the submitted default values are the default accounting site for the user (and the corresponding company), the date range matching the last open fiscal year, and the default currency of the company.

    • Detail (field DETAIL)

     

    • Level (field LEVEL)

     

    • Multilevel (field MULLEV)

     

    • Include zero amounts (field VOIVAL)

     

    • Out of the pyramid (field OUTPYR)

     

    Display

     

     

    Close

    Menu bar

    Browsing menu

    Accounts

    Click this button to browse the related accounts.

    Jounal entry

    Click this button to browse the related Journal entry.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation