Skip to Content
0
Former Member
Jan 13, 2012 at 09:04 AM

Logic

24 Views

								
		Applications						
Dimensions	Type	Finance	GM	Opex	HCM	Rate		
Account	?	x	x	x				
Entity	?	x	x	x	x			
Category	?	x	x	x	x	x		
Time	?	x	x	x	x	x		
Product	?		x	x				
R_Entity	?					x		
CostCenter	?			x	x			
Employee	?				x			
HCM_Account	?				x			
R_Acct	?					x		
RptCurrency	?	x	x	x	x			
InputCurrency	?					x		
DataSrc	?	x	x	x				
								
								
								
							
								
								
 the Script Logic for the Above Calculation ?								
Source Application: Opex								
Account	Entity	Category	Time	CostCenter	DataSrc	Product	Amount	
AA1	CO1	Plan	2012.JAN	CC1	INPUT	Non_Product	10000	
AA2	CO1	Plan	2012.JAN	CC1	INPUT	Non_Product	100	
								
								
Reference Application: HCM								
HCM_Account	Entity	Category	Time	CostCenter	DataSrc	Employee	Amount	
AA3	CO1	Plan	2012.INP	CC1	Input	E1	0.5	
								
								
Result Formula=	4=1*3/2							
Account	Entity	Category	Time	CostCenter	DataSrc	Product	Amount	
AA4	CO1	Plan	2012.JAN	CC1	INPUT	Non_Product	50	
								
								
								
Script logics to move data from 1.HCM->Opex and  2.GM and Opex->Finance Application	?							
Script Logic to Copy data from Actual to Plan from Current year to Next year in GM Application	?							
Script Logic to Lookup Rate Application and Perform Currency Translation	?							
Script logic to Allocation Expenses in Opex Application to All Products assuming expenses are posted at Non_Product but at CostCenter Level using Account GrossSales in GM application as reference ?