B104

Account Reconciliation
Input 1 workflow

Properties source
Sources: prospetto

Code
B104
Description
Account Reconciliation
Web opening
NV
Type flags
Input
Groups
B1 Legal Entity Close

Structure source
Sources: prospetto_xml

Form parameters
4
▾
Dimension Hierarchy Parameter
PERIODO
Period 		› — › $PER_P
AZIENDA
Entity;fr=Entité 		› 010
All Entities 		› 03
Choose an Entity
SCENARIO
Scenario 		› $
Scenarios 		› SCE_ACT
Scenario for Actuals
CONTO
Account;fr=Compte 		› 010
All Accounts - BS, PL & Statistical Accounts 		› $VOC_010_P
Form filters
3 dims
▾
PERIODOPeriod 1
▾
$PER_P
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_ACT param
Account Status
Template00 · 1 matrix
▾
Account Status CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
Rows
CATEGORIACategory 2
▾
Hierarchy / FST Item Type TGKML
— › 130 Subledger data for reconciliation fixed
— › 010 Original Data fixed
DEST5Miscellaneous;it=Miscellaneous 3
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
— › ACC_REC_1 Statement Date fixed
— › ACC_REC_2 Reference to external documentation fixed
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
— › TIP_O fixed
Cols
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › $VOC_010_P param
Account Reconciliation
Template01 · 5 matrices
▾
Journal Need CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
Rows
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
LI_20 Acc. Rec. Line Items › ACC_REC_4 Submit Journal for Review ? fixed
Cols
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › $VOC_010_P param
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 130 Subledger data for reconciliation fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
SubGL Reconciliation CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
Rows
DEST5Miscellaneous;it=Miscellaneous 3
▾
Hierarchy / FST Item Type TGKML
LI_20 Acc. Rec. Line Items › 10 fixed
LI_20 Acc. Rec. Line Items › 20 fixed
LI_20 Acc. Rec. Line Items › 30 fixed
Cols
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › $VOC_010_P param
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 130 Subledger data for reconciliation fixed
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
— › TIP_O fixed
GL Reconciliation CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
Rows
DEST5Miscellaneous;it=Miscellaneous 3
▾
Hierarchy / FST Item Type TGKML
LI_20 Acc. Rec. Line Items › 10 fixed
LI_20 Acc. Rec. Line Items › 20 fixed
LI_20 Acc. Rec. Line Items › 30 fixed
Cols
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › $VOC_010_P param
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 030 Generic Adjustments fixed
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
— › TIP_O fixed
GL Task Completion CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
Rows
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
LI_20 Acc. Rec. Line Items › ACC_REC_3 Declare Task as completed fixed
Cols
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › $VOC_010_P param
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 030 Generic Adjustments fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
SubGL Task Completion CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
Rows
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
LI_20 Acc. Rec. Line Items › ACC_REC_3 Declare Task as completed fixed
Cols
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › $VOC_010_P param
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 130 Subledger data for reconciliation fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed

Queries 1 source
Sources: prospetto_xml

Yes No List
SQL 010
▾ 
Select 'Yes' as YesNo
union select 'No' as YesNo

Used in Workflows 1 source
Sources: RACCOLTA_AZIENDA_WFM, WFM task list

Workflow Phase Task list Task description
ACT Close & Consolidation Workflow 001 Trial Balance 01 Trial Balance Reconcile Accounts