IC Booking Issue

[Former Member]

Dear Experts,

Below is my test scenario on IC Booking;

Step 1) Upload transaction data with LC

Step 2) Currency conversion run

In currency conversion we are using force close. So F99 flow entries created automatically.

Step 3) IC Booking

With Debit1, debit2, credit1, credit2 entries got created.

Step 4) IC Matching

Below is the script logic we are using

*RUN_PROGRAM ICBOOKING

CATEGORY = %VS_CATEGORY_SET%

CURRENCY = %VS_RPTCURRENCY_SET%

TID_RA = %VS_TIME%

ENTITY = %VS_ENTITY_SET%

SUBTABLES = %VS_FLOW_SET%

TYPE = 'I'.

*ENDRUN_PROGRAM

In Data Manager also we have added flow dimension in the selection prompt.

Now the problem is, In the IC Matching program (CL_UJP_ICBOOKING) flow is not considered for selection criteria. Hence the IC DIFF (250 AUD) is posting once for Flow F15 and then for F99 also.

Its doubling the IC DIFF.  250 of F15 flow + 250 of F99 flow

Point 1) Why the flow dimension is not considered in the RUN_ICBOOKING method in the program.

Point 2) What is the work around for this issue.

Please let me know for any clarification.

[Former Member]

Hello Khokan,

F15 flow where I upload the data. after currency conversion F99 flow value creates automatically by force closing.

When I run IC matching, F15 line difference 250 it is posting once to F95 (as per business rule) and then again taking F99 flow line difference 250 and posting to F95.

Account	Flow	Flow Description	Signed Data
AR	F15	Variation	1550
AR	F99	Closing	1550
AP	F15	Variation	1300
AP	F99	Closing	1300

Final result screen shot for your reference

Raja

[Former Member]

What about your F95 flow,use only closing flow in business rule.The differentiate value by default posted to closing value if you use another flow then it posted doubled up in two different flow.

Khokan

[Former Member]

That is not the issue here right. F15 and F99 is going for the calculation of IC Booking and value is getting double.

Got my point ? for the calculation itself is getting doubled not at the out put time. business rule is fine. no issue in that.

Raja.

[Former Member]

Hi Raja,

I am not understand one think,you run currency translation with target flow F99, but when you run IC_Booking with target flow F95,why you use two different flow what logic behind this?

Khokan

[Former Member]

Yes tried that also, but no luck...

Raja

[Former Member]

Are you getting doubled valued in F99 closing flow.I cant see F15 flow in IC_Booking business rule.You say f15 flow Its doubling the IC DIFF.  250 of F15 flow + 250 of F99 flow.

[Former Member]

Now We found that Flow dimension in the script logic & DM is immaterial. because in the program itself flow is not there in the selection criteria. thats why it is picking all the flow transaction data.

Even I have removed the flow from DM and script....same result.

So lets move the discussion to force close check mark.... we are using this to calculate the closing balance (Opening + changes = F99).

I need F99 flow for the closing balance figure.

Regards,

Raja

[Former Member]

Raja,

which logic you are applied which is applicable for fixed assets item not intercompany transaction.Try to use same flow in debit flow and credit flow  in IC_booking business rule.

Khokan

[former_member186338]

The following line is also in question:

SUBTABLES = %VS_FLOW_SET%

Move it to OTHER

Vadim

[former_member186338]

Something like:

*RUN_PROGRAM ICBOOKING

CATEGORY = %VS_CATEGORY_SET%

CURRENCY =  %VS_RPTCURRENCY_SET%

TID_RA = %VS_TIME%

OTHER = [VS_ENTITY=%VS_ENTITY_SET%;VS_FLOW=%VS_FLOW_SET%]

*ENDRUN_PROGRAM

[Former Member]

Hello Vadim,

Move it to OTHER means ?

Even though we are giving flow in the DM and script logic, But in the IC Booking program Flow is not considered in the selection criteria...that is the main problem...

I have debugged and checked the program.

Raja

[former_member186338]

Look at my sample!

"SUBTABLES = %VS_FLOW_SET%" - incorrect!

[Former Member]

Don't use flow option in logic script.The flow is automatic processing through business rule and also removed flow selection from data manager package.

[former_member186338]

Yes, FLOW is specified in the rule...

[Former Member]

Hi Raja,

Removed Type=I from your script this line we are use in IC_Matching.

Khokan

[Former Member]

Hi,

Same result. Any other work around ?

[Former Member]

Could you share business rule screen short.

Khokan

[Former Member]

Hi,

IC Booking rule

[Former Member]

If you applied forced closing in currency translation then record should always double up.leave the option blank and then run the program.

Khokan