Expenses
Use this function to manage the set of expenses. These expenses can be recorded from:
- Entering directly
- Validating purchase invoices or supplier BP invoices
- Entering and/or Validating MO-type entries
- Generating a discount in Payment entry
- Posting Miscellaneous stock issue movement
- Creating linked expenses in Expense creation
- Importing expenses entered in another application
It is also used in certain conditions to create, change, or delete an expense and to print the expense journal. See Other conditions) for details.
When expenses can be capitalized, you can select them to construct fixed assets using the Capitalize button in the Fixed assets function.
Prerequisites
Refer to documentation Implementation
Screen management
The entry screen is made up of a header displaying the expense identification information and one to three tabs, according to the level of detail required and the entry screens set up in the Job object transactions.
The three standard tabs are the following:
- The Main tab contains the different characteristics as well as the valuation and account allocation information for the expense.
- The Allocations tab is used to enter the geographical, analytical, economic and budgetary allocations for the expense.
- The Other info tab is for free fields.
The left list contains several lists:
- Expenses displays the list of all the existing expenses or those corresponding to the selection carried out,
- Grouped expenses only displays the expenses that have been grouped with the expense currently being viewed, in order to construct a fixed asset,
- Capitalized expenses displays all the expenses available to generate an asset.
Header
The header contains the expense identification information, such as the financial site to which it is allocated, its reference, its line number, and its description.
Block number 1
Company (field CPY) |
This field displays the company for the financial site. |
Financial site (field FCY) |
This mandatory field is used to enter the financial site to which the expense belongs. The choice of the financial site is subject to management and authorization rules given to the user. If the user is limited to a single site, the financial site is automatically loaded and cannot be modified. |
Events (field EVTLIST) |
Block number 2
Reference (field CODLOF) |
Line no. (field LINLOF) |
Description 1 (field DES) |
Description for the expense. When you link an expense from the Expense creation utility, it is noted here automatically. |
Description 2 (field DES2) |
Complementary description for the expense. |
Tab Main
The main tab is used to enter:
- Descriptive information including the object of the expense: the references for the supplier, product, order, date, types and invoice references as well as the transaction currency,
- The accounting group as well as the info linked to VAT management: activity sector as well as the various coefficients used to infer the deductible VAT coefficient.
Note: for companies which are not subject to the French legislation, only the deductible VAT coefficient is used and thus displayed. - The valuation amounts for the expense expressed in the transaction currency and converted into the company currency.
- The account allocation of the expense in the CoA plan and if it is managed, in the IFRS plan. The CoA plan is used to specify the allocation retained in the company accounts (national accounting standards). The IFRS plan is used to specify the allocation retained in the consolidated accounts (IAS/IFRS).
In the case where the Field associations are set up for the Expense object, the Group can determine the different field values, including the account allocations.
Acquisition
Supplier (field BPR) |
This field is used to enter the supplier. |
Order (field ORDBUY) |
This field enables the user to precise the description of the order. |
Product (field ITMREF) |
This field enables the user to specify the reference of the purchased item. |
Unit (field UOM) |
Product management unit. It is in this unit where the quantity is expressed. |
Quantity (field QTY) |
Product quantity. |
Invoice type (field TYPVCR) |
This field enables the user to specify the type of the supplier invoice originating the expense. The default value is 1 - Invoice. If the type is: 2 - Credit Memo, the positive amounts will turn into negative amounts, and vice versa for the other types of invoices (except for the Invoice type, which can have a negative amount). |
Invoice (field BPRVCR) |
This field enables the user to specify the reference of the supplier invoice originating the expense. |
Invoice date (field DATVCR) |
This field enables the user to precise the date of the supplier invoice originating the expense. This date automatically fills in the Account posting date if it is not filled in. |
Transaction currency (field CUR) |
This field enables the user to define the currency in which the expense was made. |
Rate type (field CURTYP) |
This field enables the user to define the exchange rate type to be used when the expense is expressed in a currency different from the company currency. When the transaction is expressed in the company currency, this field is not available. |
Currency rate (field RATCUR) |
This field enables the user to define the exchange rate type used when the expense is expressed in a currency different from the company currency. This field cannot be accessed when the transaction currency is the same as the company currency. |
Characteristics
Family (field ACGGRP) |
This field is used to enter the accounting Group. |
Taxes
VAT segment (field ACT) |
The VAT sector must be previously defined, for the company, in the Activity sectors setup function. It is used to determine the taxation and liability coefficients that play a role in the determination of the expense deduction coefficient. |
VAT segment description (field SACDES) |
Activity sector description. |
Validated (field FLGVAL) |
This check box is only displayed when the following conditions are met: It is used upon creation of an expense via validation of an invoice or document. Then, the user can validate the VAT coefficients allocated by default to the expense created, after having updated them, if necessary. This validation is mandatory in order for the expense to be capitalizable. |
Adjust coeff (field ASJCOE) |
The liability coefficient only appears when the company is submitted to the French legislation . |
Taxation coeff (field TAXCOE) |
The taxing coefficient illustrates the following principle: concerning taxable operations, only the tax on expenses used for operations allowing deduction can be deducted |
Admission coef. (field ADMCOE) |
The liability coefficient only appears when the company is submitted to the French legislation. |
Deduction coef (field DEDCOE) |
This field displays the Annual deduction coefficient. Its value, automatically calculated, corresponds to the multiplication of liability, taxation and admission coefficients, rounded with 2 decimals higher. |
Valuations
Transaction currency (field DEVTRA) |
Transaction currency |
Amount - tax (field AMTNOTCUR) |
This field displays the expense amount ex-tax, expressed in the transaction currency. If the invoice is of the type Credit memo, any positive amount entered will be automatically changed to a negative amount. |
Invd VAT rate (field RATVAT) |
This field displays the rate of applied VAT. |
VAT invoiced (field AMTVATCUR) |
This field displays the invoiced VAT amount, expressed in the transaction currency. It is automatically calculated based on the ex-tax amount and invoiced VAT rate. The amount then calculated can be modified by the user (except if the expense comes from the entry of a MO-type document). The entry of a VAT amount equal to 0 is allowed. In that case, the rate is automatically set to 0. |
Recovered VAT (field RATVATREC) |
The VAT recovery rate cannot be entered. It is loaded with the deduction coefficient. |
VAT recovered (field AMTVATRCUR) |
This field contains the recovered VAT amount in transaction currency. It is automatically calculated based on the invoiced VAT amount and the collection rate. The amount thus calculated can be modified by the user only if the collection rate is different from 0% and lower than 100%. |
Company currency (field DEVSOC) |
Company Currency |
Amount - tax (field AMTNOTCPY) |
The amount ex-tax of the expense in the company currency. This amount is automatically calculated based on the expense amount ex-tax in the transacton currency and the rate of the transaction currency. |
VAT invoiced (field AMTVATCPY) |
The invoiced VAT amount expressed in the company currency. This amount cannot be entered. It is automatically calculated based on the VAT amount in the transacton currency and the rate of the transaction currency. |
VAT recovered (field AMTVATRCPY) |
The collected VAT amount expressed in the company currency. This amount cannot be entered. It is automatically calculated based on the collected VAT amount in the transacton currency and the rate of the transaction currency. |
Asset
Reference (field AASREF) |
Asset link (field FLGLIKAAS) |
Tick box non modifiable, automatically activated when the expense is linked to a financial asset. |
Principal expense (field FLGLOFMAI) |
Tick box non modifiable, automatically activated during the capitalisation operation of the expense if it has been designed as Principal expense. |
Improvement (field KMDRFLG) |
This flag, that cannot be entered, is reserved to the Polish legislation and submitted to the KPL activity code. |
Accounting allocations
Date (field DATIMP) |
This field contains the expense posting date. Entering a date less than the invoice date is not authorised. When this field is not filled in, it is automatically filled in with the invoice date. |
CoA nature (field GACACN) |
This field contains the accounting nature: fixed asset in process, fixed asset in service, cost, other. |
General account (field GAC) |
This field displays the CoA account, i.e. the accounting classification of the expense towards the national norms. |
Source CoA (field GACORI) |
The original CoA account is systematically equal to the CoA account as long as the expense is not capitalised. When linking to an asset, the CoA account of the expense has the value of the asset CoA account. The original CoA account stays unchanged and enables the user to keep a trace of the initial posting. |
Journal (field JOU) |
This field contains the journal in which the expense is recorded. It is loaded, by default, with the journal code entered at the level of the DDEFJOU parameter. |
IFRS nature (field IASACN) |
This field displays the nature of the IAS/IFRS account. |
IFRS account (field IASACC) |
This field displays the IAS/IFRS account, i.e. the accounting classification of the expense towards the IAS/IFRS national norms. |
Source IFRS (field IASACCORI) |
The original IFRS account is systematically equal to the IFRS account as long as the expense is not capitalised. When linking to an asset, the IFRS account of the expense has the value of the asset IFRS account. The original IFRS account stays unchanged and enables the user to keep a trace of the initial posting. |
Tab Allocations
This tab is used to enter the different allocations for the expenses:
- Geographical allocations by specifying the site and location.
- Analytical allocations by describing the recipient of the expense and, either the distribution key that determines these allocations, or directly the analytical sections for the defined axes.
- IAS/IFRS allocations by entering the UGT as well as both IFRS sectors on which the expense is allocated.
- Budgetary allocations. These allocations can be specified for information purposes.
- Subsidies: it is possible to specify is the expense is subsidized. In this case, when the investment project, which the expense is posted to, benefits from one or several grants, the grant amount allocated to the expense is filled automatically by the Grant calculation processing. When the expense is linked to a financial asset which subsidy depreciation plan was closed and the Reconsideration of the previous subsidy is prohibited (GRTPRVUPD parameter to No), the process of the fiscal year closing of the Accounting and fiscal contexts activates the forcing flag of this amount in order to prohibit its update (and the update of the depreciation base of the asset on the subsidy plan).
- Otherwise, the Source section specifies if the expense comes from a supplier BP invoice, purchase invoice, or stock issue, in which case the button is used to go to the management function of the element from which the expense creation originated.
Analytical
Distribution (field DSP) |
This field is used in creation mode to enter an analytical distribution key, previously defined in the Analytical allocations function (GESDSP). Click the Jump-to icon in the field to access this function. Entering a distribution key disables the entry of analytical sections. |
Dimension type code (field DIE) |
Analytical dimension (field CCE) |
An Analytical dimension is a part of the analytical general ledger accounts. It is divided into Analytical dimension types where each dimension type constitutes a particular breakdown of the company into a set of analytical payment attributes. The entry of analytical dimensions can be set to mandatory using the setup carried out at the level of the Company (Accounting tab). |
Block number 1
Destination (field USRDEN) |
This field is used to enter the recipient of the purchase. |
Economic
UGT (field IASCGU) |
This field is used to specify the treasury generating unit to which the expense is posted. |
Source
Additional info (field CPMCREORI) |
This field, which cannot be entered, is loaded only when the expense is created by an invoice validation or by the entry or validation of an accounting entry. It displays the type of document which originated the expense. |
Detail line (field LIGORI) |
This field, which cannot be entered, is loaded only when the expense is created by an invoice validation or by the entry or validation of an accounting entry. It displays the line number of the invoice or entry. |
Analytical (field ANALIGORI) |
This field, non enterable, is loaded only when the expense is created by an invoice validation. It is displaying the analytical invoice line number. |
Entry type (field TYPORI) |
This field, which cannot be entered, is loaded only when the expense is created by an invoice entry or validation. It displays the type of entrybeing used. |
Subsidy
Subsidized (field FLGGRA) |
This indicator enables the user to precise if the expense is subsidised; in that case, it is mandatory to fill the reference of an investment project which at least one subsidy with the Pending nature is linked to. |
Sub strgth (field FLGAMTGRA) |
This forcing flag can be activated: |
Subsidy amount (field AMTGRA) |
The subsidy amount corresponding to the expense is automatically calculated through the Subsidy calculation processing. |
Budget
Fiscal year (field FIYBUD) |
This field is used to specify the budget financial year in which the expense has been planned. |
Project (field PLNINV) |
This field is used to specify the reference for the investment project for which the expense has been planned. |
Budget (field BUDINV) |
This field is used to specify the investment budget reference for which the expense has been planned. |
Request (field DEMINV) |
This field is used to specify the investment request reference for which the expense has been justified. |
Contract (field CONNUM) |
This field is used to specify the market number in which the expense is registered. |
Tab Other info
This tab is dedicated to the management of free fields. The number of free fields managed, their titles, the miscellaneous tables assigned to the control of the Code-type free fields and the currency for each Amount-type free field depend on the setup carried out at Free field properties level.
These free fields are to be used according to the management requirements, to store the data not covered by the Main and Allocationtabs.
It also displays information useful to the expense tracking: origin of the creation (transaction entry, import or split, etc.), code of the user at the origin of the creation followed by the creation date, and finally the code of the user who carried out the last modification followed by the date of this modification.
A button displays a window presenting the journal of the events generated for the expense.
Codes
field USRFLDA1 |
Enter an alphanumeric value that can be linked to a miscellaneous table. |
Amounts
field USRFLDM1 |
Enter an amount, expressed in a currency based on the Free field properties settings. |
Coefficients
field USRFLDC1 |
Enter a value for the coefficient type. |
Dates
field USRFLDD1 |
Enter a value for the date type. |
Record tracking
Entry origin (field CREORI) |
This field displays the origin of the record. |
Creation (field CREUSR) |
This field displays the user who created (entered) the record. |
Date (field CREDAT) |
This field displays the creation (entry) date of the object. |
Modification (field UPDUSR) |
This field displays the user that made the last modification on the recording. |
Date (field UPDDAT) |
This field displays the date of the last modification entered for the object. |
Events (field EVTLIST) |
Click the Events icon to display the event log for the object.
From the Action icon menu on a line, select Detail to view the event content, detailed over several tabs: |
Other conditions
Creation
- When the company is submitted to the French legislation, the direct creation of an expense is authorized only if the CREDIRLOF - Expenses : direct creation parameter (AAS chapter, FAS group) is set to 'Yes'.
Update 8.0.0 and higher: this alternative is available for all companies and no longer reserved to companies subject to the French legislation. - The terms of the expenses automatic creation are detailed at the level of each function concerned:
- Validation of purchase invoices,
- Validation of supplier BP invoices
- Entry and/or Validation of MO-type entries,
- Payment entry or Automatic proposal, in case of discounts generation,
- posting of a Miscellaneous stock issue movement.
Modification
- The expense data attached to a financial asset is no longer modifiable, with the exception of the data in the free fields.
- For an expense from the validation of a purchase invoice, a supplier BP invoice or an import, only headings which are not from the invoice or not loaded through import can be accessed. After entry and validation, this information can not be modified.
Deletion
The deletion of an expense is prohibited in the following cases:
- it is capitalized (linked to a financial asset).
- it is taken from another module (validation of a purchase invoice, a supplier BP invoice etc.) or an import.
To be able to correct potential errors, the ADMIN user and any other authorized user can still deleted an expense (if not capitalized) taken from another module.User authorization is set up using the user parameter LOFDELAUT - Expense deletion authorization (AAS chapter, AUZ group).
Preset queries
The following preset queries are available as standard in the reference folder:
Code |
Title |
Contents |
ICGIFRS |
Expense variance CG-IFRS / Ex |
List of the expenses for which the allocation in the individual accounts is different from the allocation in the consolidated accounts |
ICPT23 |
Expenses posted "in progress" |
List of the expenses posted on a capitalization account in progress. |
INOTA7 |
Expenses not capitalized |
List of the expenses unlinked to a financial asset. |
Reports
By default, the following reports are associated with this function :
LISLOF : Expense journal
This can be changed using a different setup.
Specific Buttons
Add Line |
This button is used to copy the expense currently being displayed. Its reference remains the same, only the line number is incremented. |
Menu Bar
|
This option gives access, via tunnel, to the inquiry function Entry traceability that makes it possible to visualize and browse into the hierarchy of original entries or coming from the document. |