Data Calculations and Transfers > Internal Data Transfer (IDT)

Examples of unit conversion and related checks in internal data transfer

Top unit

9020

9021

9022

9023

9024

9030

9031

9032

9033

9033a

9033b

Table 20: Data type connections and user rights

Unit	Sub-Unit	Sub-Unit	Data Type Connection		Unit Rights
			ACT	BUD	User 1	User 2
TOP unit			x	x
9020			x	x (input)
	9021		x (input)
	9022		x (input)
	9023		x (input)
	9024		x (input)
9030			x	x (input)	x	x (not inheritable)
	9031		x (input)		x	x
	9032		x (input)		x	x
	9033		x		x
		9033a	x (input)		x
		9033b	x (input)		x

User needs 'read' rights to the source units if source data is not deleted, or 'write' rights if data is deleted.

User needs 'write' rights to target units.

Internal data transfer options

•Unit: 9030

•Source data type: ACT

•Target data type: BUD

Units retrieved from the source data: 9031, 9032, 9033a, 9033b

Table 21: Example 1

Source Unit	Target Unit
9020	9020
9030	9030

No conversion table is needed in this case. When the sub-units are not input units in the target structure, data is transferred automatically from the sub-units to the parent unit.

Transfer execution:

•User 1: Transfer succeeds.

•User 2: Transfer fails, because the user does not have rights to all source units (9033a, 9033b).

Table 22: Example 2: Unit conversion table

Source Unit	Target Unit
9020	9020
9033	9030

Table 23: Conversion table expanded to show the mapping of source units to target units in input level

Source Unit	Target Unit
9021	9020
9022	9020
9023	9020
9024	9020
9033a	9030
9033b	9030

Table 24: Conversion rows for the transfer

Source Unit	Target Unit
9031 (not included in conversion table)	9031
9032 (not included in conversion table)	9032
9033a	9030
9033b	9030

Transfer execution:

•User 1: Transfer succeeds. Units 9031 and 9032 are not input units in the target and their data is transferred to parent unit 9030.

•User 2: Transfer fails because user does not have rights to units 9033a and 9033b.

Example: The actual amounts of a month are copied to the estimate data type. The estimate is then updated manually.

Table 25: Example 1: Transferring periodical amounts Internal data transfer options

Option	Source	Target
Data type	ACT	EST
Year	2014	2014
Organization	(DIM00) TOP	no conversion (or each company separately after completing the actuals)
Periods	0,1,2	no conversion
Accounts	INCOME,ASSETS,LIABIL	AccConvTable2
Document series	All	no conversion
Type of data	Periodical	Periodical
Factor	-	1
Delete source data	-	No

Table 26: AccConvTable2 conversion table

Source Account	Target Account
SUM1	SUM1

Table 27: Relevant account properties

Account

Cumulative

Account Type ACT

Account Type EST

SUM1

Yes

Sum

Input

INPUT1

Yes

Input

- (sub-account of

SUM1)

INPUT2

Yes

Input

Transfer run result:

Figure 102: Transfer run result

The full year estimate changes due to a difference in the previous estimate and actual for February.

Table 28: Example 2: Transferring cumulative amounts Internal data transfer options

Option	Source	Target
Data type	ACT	EST
Year	2014	2014
Organization	(DIM00) TOP	no conversion
Periods	0,1,2	no conversion
Accounts	INCOME,ASSETS,LIABIL	AccConvTable2
Document series	All	no conversion
Type of data	Cumulative	Cumulative
Factor	-	1
Delete source data	-	No

Table 29: AccConvTable2 conversion table

Source Account	Target Account
SUM1	SUM1

Table 30: Relevant account properties

Account

Cumulative

Account Type ACT

Account Type EST

SUM1

Yes

Sum

Input

INPUT1

Yes

Input

- (sub-account of

SUM1)

INPUT2

Yes

Input

Transfer run result:

Figure 103: Transfer run result

The full year estimate does not change. March periodical estimate is adjusted due to a difference in the February actual compared to the previous estimate.

Example 1

Data type EST has an account used for manual estimates that is not connected to data type ACT. In ACT, this information is recorded on a more detailed level to several accounts.

Table 31: Replacing target data

Source data type	Source account	Value	Target data type	Target account	Value	Result in EST after transfer
ACT			EST			Replace target data not selected:	Replace target data selected:
	101	250		100	600	600	0
	102	300		101	0	250	250
	103	150		102	0	300	300
				103	0	150	150

•If Replace target data is not selected, the data in the target account 100 remains because the account is not connected to ACT.

•If Replace target data is selected, the data in the target account 100 is deleted.

Example 2

When Replace target data is selected, data is replaced for all selected accounts/units that exist in the target structure, including sub-accounts/units that do not exist in the selected source structure.

Table 32: Replace target data conversion table

Conversion table
101	201

Table 33: Result in BUD after transfer when Replace target data selected

Source data type	Source unit	Value	Target data type	Target unit	Value	Result in BUD after transfer when Replace target data selected
ACT	100		BUD	100
	101	150		101	50	101	0
	102	200		102	50	102	200
				103	50	103	0
				104	50	104	0
				105	50	105	0
				200
				201	300	201	150

•Data is replaced (deleted) from units 103, 104, and 105, which are sub-units of 100 and are not connected to the source data type.

•The data of unit 201 is replaced with data from the source unit 101 based on the conversion table.