Setup > Financials > Accounting forms > Contra account extraction 

This function is used to define the counterpart extraction rules.

It is used to:

  • define te journals involved in the extraction (all the journals impacting a list of accounts),
  • aggregate the amounts mentioned on these journals in the ledger keeping currency onto total lines that can be set up.

The following postings, because of their nature, are not a part of the extraction:

  • entry templates,
  • inactive simulations,
  • Carry-forward or closing entries.

The extract function has been originally designed to calculate the funds flow statements (extraction of those journals having an impact on the financial accounts, and total of their counterparts, to enable the analysis of the cash flows by origin (customer cash receipt, supplier cash disbursement, bank expenses, etc.). it can also be used for any other type of analysis based on this principle.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    This function is used to define a counterpart extraction rule.

    It is composed of:

    • a header defining the rule, as well as the accounts to be analyzed,
    • a grid, available to set up the aggregation rules of the counterpart amounts.

    Entry screen

    Fields

    The following fields are present on this tab :

    Identification

    • Extraction code (field CODANY)

    This code identifies the extraction rule.

    • Active (field ENAFLG)

    This box is used to specify if the tax determination rule must be activated or not:

    • if this box is checked, the tax determination rule is used in other records (documents, setup, etc.) or during mass processing,
    • if it is not checked, the tax determination rule is considered to be inactive and it cannot be selected.
    • Description (field DESTRA)

    Common title of the current record.

    • Movement type (field TYPMNT)

    Enter the type of movement you wish to export. You can, for instance, export movements only or both movements and carry-forwards.

    • Short description (field SHOTRA)

    The short description replaces the standard description when display or print constraints require it.

    By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
    You can add your translation in another language using the Translation function:

    • Click Translation from the Actions icon in the corresponding field.
    • In the Translation window, add a new language code with the translation in this language.

    A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

    SEEINFOThe connection language must be defined as a default language for thefolder.

    • Accounts to be analyzed (field FRM)

    This field will store the accounts that represent cash or bank deposits. The calculation will only be done for entry journals including such accounts.

    The setup principles are the following:

    Formula
    Meaning

    70

    Accounts starting with root 70

    -70

    Accounts starting with roo 70, with the sense of the amount reversed.

    70..72

    All the accounts starting with root 70 to 72 inclusive

    70(5)

    All the accounts starting with root 70 except those starting with root 705

    701 704

    All the accounts starting with root 701 to 704

    C and D

    Placed at the start of the expression, these letters make it possible to only extract the accounts where the balance is creditor or debtor.

    For instance: C70

    All the accounts starting with root 70 to 72, creditor.

    Option

    • Include rate deviations (field RATDEVFLG)

    This field will give the user the possibility of diferenciating the booking of the rate deviations or not. So, the behaviour is as follows:

    • If the field is ticked, the amounts concerning rate deviations will be posted at the level of the transaction BP account;
    • If the field is unticked, the amounts concerning the rate deviations will be posted according to the set up of the rate deviations accounts.

    The rate deviations accounts are triggered from the chart of accounts associated to the core model and ledger defined previously.

    Grid Setup

    • Original account (field ORIFRM)

    This 250-character field is used to define the accounts to be processed.

    The setup principles are the following:

    Formula
    Meaning

    70

    Accounts starting with root 70

    -70

    Accounts starting with roo 70, with the sense of the amount reversed.

    70..72

    All the accounts starting with root 70 to 72 inclusive

    70(5)

    All the accounts starting with root 70 except those starting with root 705

    701 704

    All the accounts starting with root 701 to 704

    C and D

    Placed at the start of the expression, these letters make it possible to only extract the accounts where the balance is creditor or debtor.

    For instance: C70

    All the accounts starting with root 70 to 72, creditor.

    • Code (field COD1)

    The amounts are aggregated onto lines that can be set up. The code and sub-code define each line in a unique manner. Descriptions and a formula are associated with it.

    • Subcode (field COD2)

     

    • Description (field LIBEL)

    Enter the description of the relevant record.

    This long description is used as a title in screens and reports.

    Close

     

    Reports

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

     P-CASHFLO : Cash flow analysis

    This can be changed using a different setup.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation