Expense journal

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	CPY
fcydeb	Financial site range	FCY
accdeb	General account ranges	GAC
accifrsdeb	IFRS" account range	GAC
datimpdeb	Allocation date range	D4
actdeb	Activity code range	ADI
acggrpdeb	Family range	FAM
bprdeb	Supplier range	BPR
axe	Analytical dimension type	DIE
secdeb	Dimension range	CCE
ugtdeb	UGT range	ADI
plndeb	Invest projets range	ADI
buddeb	Invest budgets range	ADI
condeb	Market range	ADI
joudeb	Journal range	JOU
detail	Report detailed by expense (Local menu No, Yes)	M1
impselections	Print selections (Local menu No, Yes)	M1

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: AMTNOTCPY + AMTVATCPY	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

Tables concerned

The data extracted from the following tables are processed by the report LISLOF :

Table	Table description
AFCTFCY [AFF]	Site profile function
COMPANY [CPY]	Company
FACILITY [FCY]	Sites
GACCOUNT [GAC]	Accounts
LAYOUTFAS [LOF]	Expenses