Accounts
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
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.
Selection
Company (field CPY) |
When this field is populated with a company code, the inquiry is filtered in order that only those data concerning the selected company are displayed. |
Site (field FCY) |
When this field is populated with a site code, the inquiry is filtered in order that only those data concerning the selected site are displayed. |
Ledger type (field LEDTYP) |
The ledgers types available from this field are:
|
Selection currency (field CURSEL) |
Optional field used as filter for the transaction currency. If the field is blank, all the entries will be displayed in the company currency. |
Ledger currency (field CURLED) |
The specified ledger currency depends on the type of ledger selected. |
Start date (field DATDEB) |
Accounting date range. Ranges are included. |
End date (field DATFIN) |
Accounting balance (field LIBSOL) |
Balance of the account in company currency, matching the currency in which the main general ledger is kept, on the inquiry end date. For a group of companies having fiscal years with different end and start dates, the accounting balance is not calculated/displayed. |
field DEVISE |
Account balance currency. It is always the company currency. |
Other criteria
Chart of accounts (field COA) |
This field reminds the chart of accounts linked to the company (or to the group of companies or the group of sites) and to the selected ledger type. |
Account (field COMPTE) |
It is used to select the account to be viewed. It must be of normal type. This account belongs to the chart of accounts selected in the current record. |
Control (field COLLEC) |
It is used to perform a selection on a specific collective account. |
Control group (field GROUPE) |
It is used to perform a selection on a specific collective account group. |
BP (field TIERS) |
Field used to select a BP. |
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).
The fields described below can be set up from the screen.
Grid Details
Date (field ACCDAT) |
Date on which the transaction is posted. The fiscal year and the accounting period are determined starting from this date. |
Type (field TYP) |
Each accounting journal entered is linked to a given type. The journal type corresponds to the nature of the entered posting: customer invoice, miscellaneous operations, cash receipt, etc. This information comes with management rules relating to VAT, reminders, etc. It is one of the key elements of the journal entry. The setup of the selected journal type determines if you can open or close the propagation to the manual ledgers. The journal type prevails and interrupts the propagation to the other ledgers of the company of the entry site. |
Document no. (field NUM) |
This field represents the unique identifier of a journal in a journal type. |
Debit (field DEBIT) |
Amount expressed in the transaction currency. |
Ledger debit (field DEBLED) |
Debtor amount expressed in the currency in which the ledger is kept. |
Credit (field CREDIT) |
Creditor amount expressed in the transaction currency. |
Ledger credit (field CDTLED) |
Creditor amount expressed in the currency in which the ledger is kept. |
Line description (field DES) |
This is a free field, designed to explain the posting of this entry By using " / ", the account title is displayed by default ; and with "=", the previous line description is copied. |
Due date (field DUDDAT) |
Open item payment due date. If the MAXPD - Maximum period (companies) activity code is activated, a blocking message is displayed if the last due date is greater than the period specified, depending on the case, at the level of the following parameters or of the Contractual period possibly specified at the BP level.
|
Value (field VALDAT) |
Value date. |
Co. (field CPY) |
Enter the company code or use the Look up tool to search for and select the code. |
Site (field FCYLIN) |
Specifies the code of the site concerned by the processing. |
Ctrl. (field SAC) |
This field specifies the code of the collective account group if the inquiry concerns a BP. |
Match letter (field MTC) |
This field stores the match letter that characterizes the matching group.
|
Matching date (field MTCDAT) |
This field stores the date of the day on which the journal line was matched. |
Maximum date (field MTCDATMAX) |
This field stores the maximum accounting date of the journals in the matching group. |
Status (field STA) |
Use this field to select the journal status: Temporary or Final. When set to Final, the only modifications you can make on a journal are for informational purposes only or if they concern the analytical postings. The date, amounts, accounts, VAT code, and other purely accounting information can no longer be modified. |
Journal (field JOU) |
Journal code attached to the document. |
Reference (field REF) |
This field contains the journal reference. |
Curr. (field CUR) |
Code used to identify the transaction currency of the journal. |
Ledger currency (field DEVLED) |
Offset (field OFFACC) |
This field is used to indicate the contra account.
If left blank, it will be initialized upon journal posting. |
Partner (field CSLCOD) |
This field is available depending on the inquiry screen setup selected in the Inquiry screens function GESGTC. This field is only available if the CSL - Consolidation activity code is active at the folder level. This is a display-only field that is populated according to the following: The value can default from the setup of the corresponding Journal entry transaction (GESGDE). There is no default value for this field when a journal entry is created from an automatic journal entry or manually. However, you can define a default value for this field when you create an automatic journal entry using the Automatic journal variables function (GESGVG). For example, on a sales invoice, to create a default value for the partner field on duty free and VAT lines, use the syntax [ F: SIH ] BPR. The automatic journal field is then populated with the partner code charged on TTC line of the sales invoice. The field can also default to the partner for the Extraction for Consolidation (BALCONSO) if the option Free criteria is selected. |
Partner (field CSLBPR) |
Flow (field CSLFLO) |
Flow code coming from the account if the flow code management has been chosen for the account. Flow initialization: The initialization rule only applies to accounts with Optional or Mandatory flow management selected and only for the first ledger defined in the journal entry transaction whose consolidation management is selected. When creating or posting a journal entry, the journal entry line flow code defaults as follows: If a flow code is parameterized on the journal, it defaults to that value. If there is no flow code on the journal, the flow code defaults to the value defined on the account. The flow depends of the direction on the journal entry line.
Note: When the journal entry transaction has several ledgers with consolidation management selected, the flow initialized on the first ledger is propagated to the other consolidated ledgers. If for any reason no flow has been initialized on the first ledger but is mandatory on another ledger, you receive a blocking error message that flow management is mandatory for the current account. |
Distribution (field DSP) |
Defined here are the allocation methods for the line amount on the different dimensions of each dimension type. These methods are defined as follows:
For instance: For these two later cases, it is possible to pre-initialize the allocation with an already existing key. The final display will be " $ ". |
field CCE1 |
Ledger amount (field AMTLED) |
Amount expressed in ledger currency. |
Amount in currency (field AMTCUR) |
Amount expressed in the transaction currency. |
Declared tax (field AMTVAT) |
Declared amount (basis or amount depending on the account type) in the tax declaration |
Quantity (field QTY) |
On analytical inquiry, the quantity of non-financial units is displayed. |
Mark (field CHK) |
This field is used to perform the reconciliation of the banking operations that are actually listed on the hardcopy bank statement. |
Statistic 1 (field STT1) |
These fields store the three possible statistical families of the accounting journal. |
Tax (field TAX) |
When the account on the line is subject to tax, the tax field is accessible for entry. It is initialized with the tax code associated with the account. According to the context, it is necessary to verify that this tax code corresponds to the tax actually applicable, or it should be modified. The tax code defines the rate, the rules, and the terms for the deduction applicable to the operation. If the Control type field is set to Inactive for the Account, you can enter any value on the line. If the Control type field is set to Authorization for the Account, you can only enter a code listed in the Tax control grid on the Management tab in the Account. Otherwise, you receive a blocking message. If the Control type field is set to Restriction for the Account, you can only enter a code that is not listed in Tax control grid. Otherwise, you receive a blocking message. |
Unit (field UOM) |
On analytical inquiry, this field determines the non-financial unit linked to the displayed account. |
Entry date (field ENTDAT) |
Module (field ORIMOD) |
It identifies the source module of the accounting journal. A journal coming from a module other than the accounting cannot be deleted. |
Source (field ORIGIN) |
Source transaction (field ORICOD) |
Source document (field BPRVCR) |
The 'source document' and 'document date' fields respectiveley correspond to the reference (journal number) and date of the BP journal. |
Document date (field BPRDATVCR) |
Transaction (field DACDIA) |
Code of the entry transaction used for the posting. |
Multiplying rate (field RATMLT) |
Dividing rate (field RATDIV) |
Reminder (field FLGFUP) |
Pay approval (field FLGPAZ) |
This field is only accessible upon creating or duplicating a journal. It is initialized according to the NIVBONPAYE parameter data. |
Created (field CREDAT) |
Creation author (field CREUSR) |
Change date (field UPDDAT) |
Change author (field UPDUSR) |
Reconciliation date (field CHKDAT) |
Journal site (field FCY) |
The site code for the operation is initialized with the site associated with the user code. It can be modified on the condition that it is chosen in the list of authorized sites. |
Category (field CAT) |
The category is set up in the journal type. Actual:
Active simulation/inactive simulation: Off balance sheet: Template: |
Header description (field DESVCR) |
Entering a value to enable the header description for the journal postings. |
Interbank code (field BANCIB) |
The interbank code is used by all the banks to specify the bank transaction type on the lines of the bank statements that are sent to their customers. |
Marking (field MRK) |
No help linked to this field. |
Chronological number (field CHRNUM) |
Free reference (field FREREF) |
Final number (field FNLPSTNUMW) |
Final date (field FNLPSTDAT) |
Project (field PJTLIN) |
Cost type (field PCCCOD) |
Basic Product Management |
The following actions can be available depending on the context. They are used to directly access the base object:
|
Transactions by Date |
This action, which is available for entries originating from the stocks management module, provides an upstream access to the inquiry of stock movements. |
WIP Cost Inquiry |
This action, which is available for entries originating from the Manufacturing module, provides an upstream access to the WIP cost inquiry. |
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.
For a group of companies with different start and end date, the Balances tab is not loaded.
Grid Balances and totals by period
Date (field DAT) |
Period end date. |
Debit balance (field SOLDEB) |
This field specifies, if the selection currency having been entered, the debit balance of the period in the selection currency. |
Credit balance (field SOLCRE) |
This field displays the credit balance of the period in the selection currency. |
Debit transactions (field TOTDEB) |
This field specifies, in the event of the selection currency having been entered, the total of the debtor movements over the period in the selection currency. |
Credit transactions (field TOTCRE) |
This field specifies, in the event of the selection currency having been entered, the total of the creditor movements over the period in the selection currency. |
Ledger debit balance (field CTVSOLDEB) |
This field specifies the account debtor balance, on the period date end, in the ledger keeping currency. |
Ledger credit balance (field CTVSOLCRE) |
This field specifies the account creditor balance, on the period date end, in the ledger keeping currency. |
Ledger debit movements (field CTVTOTDEB) |
This field specifies the sum of the debtor movements over the period in the ledger keeping currency. |
Ledger credit movements (field CTVTOTCRE) |
This field specifies the sum of the creditor movements over the period in the ledger keeping currency. |
Total of selection criteria
Debit in ledger currency (field DEBLOC) |
Total of the debtor movements in the ledger keeping currency for all periods inquired. |
field DEVLOC |
Currency in which the debit total is expressed in ledger keeping currency. |
Credit in ledger currency (field CRELOC) |
Total of the creditor movements in the ledger keeping currency for all periods inquired. |
field DEVLOC2 |
Currency in which the credit total is expressed in ledger keeping currency. |
Balance in ledger currency (field SOLLOC) |
Balance of the movements, in ledger keeping currency, for all the selected periods. |
field SNSSOL |
Sense of the balance. |
Debit in selection currency (field DEBCUR) |
If the selection currency has been entered, this field displays the total of the debtor movements in the selected currency for all periods viewed. |
field DEVCUR |
Selected currency. |
Credit in selection currency (field CRECUR) |
If the selection currency has been entered, this field displays the total of the creditor movements in the selected currency for all periods viewed. |
field DEVCUR2 |
Balance in selection currency (field SOLCUR) |
Balance, expressed in the selection currency, calculated on those movements whose currency is identical to the selection currency. |
field SNSSOL2 |
Code of the selected currency. |
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
Several actions are available to you which are not detailed specifically below: |
Click Criteria to refine the inquiry parameters. |
The button Balance is present and replaces the Balances tab when the CNT activity code is set to No. |
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:
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.