P/L amount on sale of schedule
This report restores, for the current FY or period f a depreciation plan, the amount of P&L amount on sale for assets issued in a FY or specific period.
Assets issued are displayed, sorted first by company and then by two sorting criteria specified by the user with a sub-aggregation at each shortage on one of these criteria.
It is also possible to obtain a synthetic report showing only the sub-aggregations by sorting criteria and by 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.
List of criteria
| Parameter |
Parameter title |
Type |
|---|---|---|
|
cpydeb |
Company limit |
|
|
fcydeb |
Financial site range |
|
|
ccptdeb |
Accounting code range |
|
|
accdeb |
General account ranges |
|
|
accifrsdeb |
IFRS" account range |
|
|
refdeb |
Asset range |
|
|
plan |
Depreciation plan (Local menu Accounts, Finance, Minimum, Source, Reevaluation 76...) |
|
|
situation |
FY or period (Local menu Financial year, Period) |
|
|
datdeb |
Date range |
D4 |
|
detail |
Detailed status by asset (Local menu No, Yes) |
|
|
tri2 |
Classification criterion 2 (Local menu Financial site, Accounting code, CoA account...) |
|
|
tri3 |
Classification criterion 3 (Local menu Financial site, Accounting code, CoA account...) |
|
|
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 GESFAS (Assets).
Miscellaneous
1/ Entering values for the selection setups is not mandatory. The default values displayed are those entered in the Report dictionary.
When values are entered, any existence control is carried out. In the case where they are inexistent or inconsistent, any print is carried out.
2/ Entered date ranges for the following setup: Datdeb : Date ranges must correspond exactly to the start and end date of a FY or a period.
Description of the report
Implicit Selection:
Are automatically excluded:
- Non issued assets.
- The fixed assets which depreciation start date is greater than the fiscal year or the selected period end date specified by the date ranges entered in setup.
- Fixed assets which issue date is not included in the specified period or FY.
- Inactive fixed assets.
Grouping/sorting criteria and aggregation
The assets are presented, grouped and sorted in ascending order according to the following criteria:
- Company. Aggregation per company with page break
- 2nd classification criterion: by default, the financial site. Aggregation per criteria, with page break
- 3rd classification criterion: by default, the Accounting code. Aggregation by criteria without page break
- Fixed asset reference
The Sort criteria 2 and 3 have to be chosen among the values contained in the local menu 3265; it can come, for example, from the Financial site, from the Geographic site, from the Accounting code, from the CoA account or IAS/IFRS, from the Group, from an Analytical distribution key, from an Analytical dimension type, from anIFRS segment, from a TGU.
Restored information
The content of the report varies according to the value entered for the setup: Report detailed by asset (or synthesis report).
- Header
The header recalls the following information:
- Company reference
- Current fiscal year start and end date of the selected plan.
- Current period start and end date of the selected plan.
- Detailed report
This report displays 3 lines by selected fixed asset.
On the 1st line:
Information | Loaded from the fields | Table |
Reference | AASREF | IMPAIRM |
Description 1 | AASDES1 | FXDASSETS |
Depreciation start date | STRDPRDAT | IMPAIRM |
Issue date | ISSDAT | FXDASSETS |
Balance sheet value | DPRBAS | IMPAIRM |
Residual value | RSDVAL | IMPAIRM |
Sale amount | ISSAMT | FXDASSETS |
Short term gain or loss amount | SHOGAL | FXDASSETS |
Amount of tax on sale | ISSVATAMT | FXDASSETS |
On the second line:
Information | Loaded from the fields | Table |
Depreciation write-off | ENDDPRDAT | IMPAIRM |
Issue reason | ISSTYP | FXDASSETS |
Net value | NBV | IMPAIRM |
Gain or loss on sale | GAL | FXDASSETS |
Long term gain or loss amount | LNGGAL | FXDASSETS |
Additional VAT deduct amount or CoA or IAS, depending on the chosen plan | ACGCPLDED, if plan of the accounting and financial context | FXDASSETS |
On the 3rd line:
Information | Loaded from the fields | Table |
PCG | GAC | FXDASSETS |
Buyer | BUY | FXDASSETS |
Intra-group gain or loss amount | GRUGAL | IMPAIRM |
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 Accounting code, 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 balance sheet value
- Total residual value
- Sale amount total
- Total of amount gain or loss CT value
- Total amount of tax on sale
On the second line:
- Total net value
- Gain or loss value total amount
- Gain or loss value total amount LT
- Total deduction amount of additional VAT
On the third line: intra-group gain or loss amount