Expense journal
This report restores the list of expenses that meet the selection criteria specified when submitting the report.
The expenses are presented, sorted by company, financial site and CoA account with a sub-aggregation to each shortage on one of these criteria.
It is also possible to obtain a synthetic report showing only the sub-aggregations by accounting code, financial site and company.
A global total is displayed in the case of a multi-company print.
Prerequisite
Access to the report
This report can be accessed from the report menu of the group Fixed Assets - Fixed assets.
It is also called by default from the following functions :
Fixed assets > Fixed assets > Expenses
List of criteria
Parameter | Parameter title | Type |
|---|---|---|
cpydeb | Company limit | |
fcydeb | Financial site range | |
accdeb | General account ranges | |
accifrsdeb | IFRS" account range | |
datimpdeb | Allocation date range | D4 |
actdeb | Activity code range | |
acggrpdeb | Family range | |
bprdeb | Supplier range | |
axe | Analytical dimension type | |
secdeb | Dimension range | |
ugtdeb | UGT range | |
plndeb | Invest projets range | |
buddeb | Invest budgets range | |
condeb | Market range | |
joudeb | Journal range | |
detail | Report detailed by expense (Local menu No, Yes) | |
impselections | Print selections (Local menu No, Yes) |
Comments
The data is filtered by site according to the rights granted to the user on the function GESLOF (Expenses).
Miscellaneous
1/ Entering values for the selection setups is not mandatory. The default values displayed are those entered in the Report dictionary.
2/ When values are entered, any existence control is carried out. In the case where they are inexistent or inconsistent, any print is carried out.Description of the report
The expenses are presented, grouped and sorted in ascending order according to the following criteria:
Grouping/sorting criteria and aggregation
- Company Aggregation by company with page break
- Financial site Aggregation by financial site with page break
- CoA account Aggregation by account with page break
- Expense reference
Restored information
The content of the report varies according to the value entered for the setup: Detailed report by asset (or Synthesis report).
- Header
The header recalls the following information:
- Company reference
- Financial site reference
- No. of CoA account
- Detailed report
This report displays 3 lines by selected expense.
On the 1st line:
Information | Loaded from the fields | Table |
Reference | CODLOF | LAYOUTFAS |
Line no. | LINLOF | LAYOUTFAS |
Description 1 | DES | LAYOUTFAS |
Supplier | BPR + BPRNAM | LAYOUTFAS + BPARTNER |
Invoice date | DATVCR | LAYOUTFAS |
Activity sector IFRS | SCT1 | LAYOUTFAS |
Activity sector | ACT | LAYOUTFAS |
Ex-tax amount | AMTNOTCPY | LAYOUTFAS |
On the second line:
Information | Loaded from the fields | Table |
Description 2 | DES2 | LAYOUTFAS |
Order Ref. | ORDBUY | LAYOUTFAS |
Posting date | DATIMP | LAYOUTFAS |
Geographic sector IFRS | SCT2 | LAYOUTFAS |
Collected VAT amount | AMTVATRCPY | LAYOUTFAS |
Invoiced VAT amount | AMTVATCPY | LAYOUTFAS |
On the 3rd line:
Information | Loaded from the fields | Table |
Invoice reference | BPRVCR | LAYOUTFAS |
Account IFRS | IASACC | LAYOUTFAS |
Pro-rata recovery of VAT | RATVATREC | LAYOUTFAS |
Amount inc tax | Calculated: | LAYOUTFAS |
Then, are displayed the aggregation lines identical to those displayed below for a synthesis report.
- Synthesis report
This report displays:
- 3 aggregation lines by shortage on CoA account, Financial site and Company.
- 3 lines of general total are also displayed in the last page, if the report concerns several companies.
On the 1st line :
- Total ex. tax amount
On the 2nd line :
- Total collected and invoiced VAT amounts
On the 3rd line:
- Total tax inc. amount