Lookup code to check company's method in ownership model

[Former Member]

Hi All, I am looking for some help to check the method in ownership model for companies & Trading Partner and then do specific calculation.

Please check the below.

1. In consolidation model, check company’s method in ownership model (Lookup).

2. If method code of company =1, delete data in consolidation model (Value = 0 )

3. In same data set in consolidation model, check trading partner’s method in ownership model (Lookup).

4. If method code of trading Partner =1, delete data in consolidation model (Value = 0 )

Eg.

Consolidation Model

Row No: Company TPartner Account      Data

1             A                I_Z       Account 1    100

2             B                I_Z       Account 1    100

3             C                I_A       Account 1    100

4             D                I_B      Account 1     100

Ownership Model:

Company     Method

A                   1

B                   2

C                   2

D                   2

Expected results:

- Delete value of Row 1 in consolidation model (Reason: Method of company =1 )

- Delete value of row 3 in consolidation model (Reason: Method of Trading partner =1)

Can we use lookup for this as we are checking actual transactional data in ownership model.

Appreciate if you can include sample code.

Please let me know if you need any clarification on this.

Thanks in Advane

[Former Member]

Hi Anil,

you should be able to use an eliminations and adjustments business rule for this. You can set up a method based multiplier according to your table above and then create a new rule that does the calculation for you.

Might be easier than writing a script.

BR,

Arnold