Use this function to manage the set of expenses. These expenses can be recorded from:
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.
Refer to documentation Implementation
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 left list contains several lists:
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. |
The main tab is used to enter:
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. |
This tab is used to enter the different allocations for the expenses:
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. |
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: |
The deletion of an expense is prohibited in the following cases:
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).
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. |
By default, the following reports are associated with this function :
LISLOF : Expense journal
This can be changed using a different setup.
|
Add Line |
This button is used to copy the expense currently being displayed. Its reference remains the same, only the line number is incremented. |
|
|
|
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. |
In addition to the generic error messages, the following messages can appear during the entry :
No specific message is listed. See generic messages.
Refer to documentation Implementation