Skip to Content
0
Former Member
Oct 03, 2013 at 08:09 AM

BPC 7.5 N/W Inter Company Accounts with DR CR Indicator Data Loads Issue

47 Views

On Thu, Oct 3, 2013 at 8:51 AM, NarsiP <narsi.siri@gmail.com> wrote:

Hi Guys Good day

Issue:Inter Company Accounts with DR CR Indicator Data Loads Issue

Now I am trying to load the data into BPC System its BPC 7.5 NW. But it’s rejected some accounts. The reason is all these rejected accounts are Inter Company accounts. For example Please have a look on the below account

Entity Time Period Account Amount DR/CR Indicator

6000

2013

12

176020

-1416152.69 CR

6010

2013

12

176020

  1. 1416152.69 DR

In the Account structure we have A176020 if it is an Asset and L176020 if it is a Liability Account. What it should do is when I load the data if the Account 176020 data is Positive it must go to A176020(Asset) and if it is negative data it must go to L176020( Liability).

To resolve this I am trying with the below syntax in the conversation file.

ACCOUNT=*if(ACCOUNT.AL_TYPE=”A” Than(*if(DR/CR Indicator = *str(DR) then *str(A)) + *COL(4); DR/CR Indicator= *str(CR) then *str(L) + *COL(4); *COL(4)))

Guys anyone got this issue before, if you have a solution please pass it me.

One expert suggested that we can try with JAVA or VB script in conversation file. But I never did JAVA or VB Script before

Please help me with solution

0 ,A140619,SAP_DATALOAD,ACTUAL,CC_4725,LC,DEFAULT,F99,I_NONE,2011.JUN,491662.5400000- Line0 :Duplicate record 0 ,A140619,SAP_DATALOAD,ACTUAL,CC_4710,LC,DEFAULT,F99,I_NONE,2011.JUN,491662.5400000 Line0 :Duplicate record 0 ,A140617,SAP_DATALOAD,ACTUAL,CC_4720,LC,DEFAULT,F99,I_NONE,2011.JUN,40000000.0000000- Line0 :Duplicate record 0 ,A140617,SAP_DATALOAD,ACTUAL,CC_4710,LC,DEFAULT,F99,I_NONE,2011.JUN,40000000.0000000 Line0 :Duplicate record 0 ,A140610,SAP_DATALOAD,ACTUAL,CC_4720,LC,DEFAULT,F99,I_NONE,2011.JUN,5642232.2700000- Line0 :Duplicate record 0 ,A140610,SAP_DATALOAD,ACTUAL,CC_4710,LC,DEFAULT,F99,I_NONE,2011.JUN,5642232.2700000 Line0 :Duplicate record 0 ,A140604,SAP_DATALOAD,ACTUAL,CC_4730,LC,DEFAULT,F99,I_NONE,2011.JUN,27958812.1800000- Line0 :Duplicate record 0 ,A140604,SAP_DATALOAD,ACTUAL,CC_4710,LC,DEFAULT,F99,I_NONE,2011.JUN,27958812.1800000 Line0 :Duplicate record 0 ,A140602,SAP_DATALOAD,ACTUAL,CC_4730,LC,DEFAULT,F99,I_NONE,2011.JUN,12870293.2900000 Line0 :Duplicate record 0 ,A140602,SAP_DATALOAD,ACTUAL,CC_4720,LC,DEFAULT,F99,I_NONE,2011.JUN,12870293.2900000- Line0 :Duplicate record

Thanks

Regards

Narsi

--
You received this message because you are subscribed to the Google Groups "CQS Performance Solutions" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cqs-performance-soutions+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.