Histórico da Página

...

Through the combination of destination-type register, for each accounting entity, the amount of detail rows, accounting entities used and their respective apportionments percentage can be defined.

Intercompany is a field for control of detail rows of off-line apportionment register in which you define whether entry rows generated by the apportionment execution shall have the entry export mark for the processing of routine InterCompany.

...

Registration of the first apportionment group:

Group	000001
Entity	Ledger Account
Row 001	CTA0001
Row 002	CTA0002
Row 003	CTA0003

Registration of the second apportionment group:

Group	000002
Entity	Cost center
Row 001	CDC0001
Row 002	CDC0002
Row 003	CDC0003

Combination of entities of both apportionment registers:

Line	Ledger Account	Cost center
001	CTA0001	CDC0001
002	CTA0001	CDC0002
003	CTA0001	CDC0003
004	CTA0002	CDC0001
005	CTA0002	CDC0002
006	CTA0002	CDC0003
007	CTA0003	CDC0001
008	CTA0003	CDC0002
009	CTA0003	CDC0003

Nine (9) rows of combination of entities of both apportionment groups are generated, considering the following:

...

“Smallest entity” refers to that of the lowest hierarchical level considering that:

Level 01	Ledger Account
Level 02	Cost center
Level 03	Accounting Item
Level 04	Value class

Example 01:

Registration of the first apportionment group:

Group

000001


Entity	Ledger Account	Percentage
Row 001:	CTA0001	50%
Row 002:	CTA0002	50%

Registration of the second apportionment group:

Group

000002


Entity	Cost Center	Percentage
Row 001:	CDC0001	25%
Row 002:	CDC0002	25%
Row 003:	CDC0003	25%
Row 004:	CDC0004	25%

Combination of entities of both apportionment registers:

Line	Ledger Account	Percentage Register	Cost Center	Percentage Register	Converted factor	Percentage Apportionment
001	CTA0001	50%	CDC0001	25%	1	12.5%
002	CTA0001	50%	CDC0002	25%	1	12.5%
003	CTA0001	50%	CDC0003	25%	1	12.5%
004	CTA0001	50%	CDC0004	25%	1	12.5%
005	CTA0002	50%	CDC0001	25%	1	12.5%
006	CTA0002	50%	CDC0002	25%	1	12.5%
007	CTA0002	50%	CDC0003	25%	1	12.5%
008	CTA0002	50%	CDC0004	25%	1	12.5%


			Rows of the register	04	08	100%

Example 02:

Registration of the first apportionment group:

Group

000001


Entity	Ledger Account	Percentage
Row 001:	CTA0001	50%
Row 002:	CTA0002	50%

Registration of the second apportionment group:

Group

000002


Entity	Cost Center	Percentage
Row 001:	CDC0001	10%
Row 002:	CDC0002	20%
Row 003:	CDC0003	30%
Row 004:	CDC0004	40%

Combination of entities of both apportionment registers:

Line	Ledger Account	Percentage Register	Cost Center	Percentage Register	Converted factor	Percentage Apportionment
001	CTA0001	50%	CDC0001	10%	0.4	05%
002	CTA0001	50%	CDC0002	20%	0.8	10%
003	CTA0001	50%	CDC0003	30%	1.2	15%
004	CTA0001	50%	CDC0004	40%	1.6	20%
005	CTA0002	50%	CDC0001	10%	0.4	05%
006	CTA0002	50%	CDC0002	20%	0.8	10%
007	CTA0002	50%	CDC0003	30%	1.2	15%
008	CTA0002	50%	CDC0004	40%	1.6	20%


			Rows of the register	04	08	100%

...

Combination between factors:

...

“Smallest entity” refers to that of the lowest hierarchical level considering that:

Level 01	Ledger Account
Level 02	Cost center
Level 03	Accounting Item
Level 04	Value class

Example 01:

Registration of the first apportionment group:

Group

000001


Entity	Ledger Account	Factor
Row 001:	CTA0001	1
Row 002:	CTA0002	1

Registration of the second apportionment group:

Group

000002


Entity	Cost Center	Factor
Row 001:	CDC0001	0.4
Row 002:	CDC0002	0.8
Row 003:	CDC0003	1.2
Row 004:	CDC0004	1.6

Combination of entities of both apportionment registers:

Line	Ledger Account	Factor Register	Cost Center	Factor Register	Factor Apportionment	Percentage Apportionment
001	CTA0001	1	CDC0001	0.4	0.4	05%
002	CTA0001	1	CDC0002	0.8	0.8	10%
003	CTA0001	1	CDC0003	1.2	1.2	15%
004	CTA0001	1	CDC0004	1.6	1.6	20%
005	CTA0002	1	CDC0001	0.4	0.4	05%
006	CTA0002	1	CDC0002	0.8	0.8	10%
007	CTA0002	1	CDC0003	1.2	1.2	15%
008	CTA0002	1	CDC0004	1.6	1.6	20%


				Totals:	08	100%

...

Combination of origin and destination apportionment groups

The combination of origin and destination apportionment groups is made to generate off-line apportionment registers through the combination of Cartesian products of each group, individually.

...

Origin apportionment group– Ledger Account

Group	000001
Entity	Ledger Account
Row 001:	CTO0001
Row 002:	CTO0002

Origin apportionment group– Cost Center

Group	000002
Entity	Cost Center
Row 001:	CCO0001
Row 002:	CCO0002
Row 003:	CCO0003
Row 004:	CCO0004

Destination apportionment group– Ledger Account

Group	000003
Entity	Ledger Account
Row 001:	CTD1001
Row 002:	CTD1002

Destination apportionment group– Cost Center

Group	000004
Entity	Cost Center
Row 001:	CCD1001
Row 002:	CCD1002
Row 003:	CCD1003
Row 004:	CCD1004

Step 2: Combination of two groups of same type (origin - destination)

Combination of origin groups

Line	Ledger Account	Cost Center
001	CTO0001	CCO0001
002	CTO0001	CCO0002
003	CTO0001	CCO0003
004	CTO0001	CCO0004
005	CTO0002	CCO0001
006	CTO0002	CCO0002
007	CTO0002	CCO0003
008	CTO0002	CCO0004
Total of apportionments		08

Combination of origin groups

Line	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004
Total of apportionment rows		08

Step 03: Generation of apportionments with the combination between origin and destination:

Apportionment	000001
Header	Ledger Account	Cost Center
001	CTO0001	CCO0001
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

Apportionment	000002
Header	Ledger Account	Cost Center
001	CTO0001	CCO0002
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

Apportionment	000003
Header	Ledger Account	Cost Center
001	CTO0001	CCO0003
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

Apportionment	000004
Header	Ledger Account	Cost Center
001	CTO0001	CCO0004
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

Apportionment	000005
Header	Ledger Account	Cost Center
001	CTO0002	CCO0001
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

Apportionment	000006
Header	Ledger Account	Cost Center
001	CTO0003	CCO0002
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

Apportionment	000007
Header	Ledger Account	Cost Center
001	CTO0004	CCO0003
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

Apportionment	000008
Header	Ledger Account	Cost Center
001	CTO0005	CCO0004
Rows	Ledger Account	Cost Center
001	CTD1001	CCD1001
002	CTD1001	CCD1002
003	CTD1001	CCD1003
004	CTD1001	CCD1004
005	CTD1002	CCD1001
006	CTD1002	CCD1002
007	CTD1002	CCD1003
008	CTD1002	CCD1004

...

Páginas filhas

Versões comparadas

Versão antiga 1

Nova versão Atual

Chave