Need help on FD10N open item warning

[1_abhinav]

Hello,

User is trying to generate a customer report in F.27 but the report which gets generated only has 4 open items which in-turn shows incorrect balances. 

While checking the balances in FD10N I get an warning that "A large number of line items were selected" "Recommended: Only display open items. Do you want to display open items only?"

We have two options for above warning "yes or no". 

When 'Yes' is selected, I can see 39 open items.

When 'No' is selected, I can see only 4 open items. 

What is the reason behind this issue and how can we solve this? 

How can user generate the report with 39 open items which in-turn would be the correct data? 

Kindly help on this issue, Thanks.

[RaymondGiuseppi]

Can you debug the generation of selection criteria when calling line item report from FD10N

• form CALL_LINE_ITEM_REPORT of function group FDBL (include LFDBLF02) - set breakpoint at "PERFORM GET_ALL_OR_OPEN"
• Look for values of LT_COSEL and LT_SELTAB to compare with direct FBL5N execution

[1_abhinav]

Hi Raymond,

We have tried testing in TST system but everything seems to be working fine and the customer statement generated has correct number of open items. 

Can you kindly help on how to figure out the issue?

Regards,
Abhinav L

[Jeremy_Deo]

Hello again dear user,

Can you please provide either screenshots or a Word file with explicit description so I can keep going with the analysis ?

Thank you for your cooperation.

Best regards,

Jeremy

[Jeremy_Deo]

Hello dear user,

I think that the difference that you notice is due to the selection of open items.

If you don't get the same number of open items, it might be because one of the selection include special G/L transactions linked to the customer.

Could you please check this ?

Best regards,

Jeremy 

[1_abhinav]

Hi, Thanks for the reply.

But I cross checked with flb5n open items too, all the 39 items are normal items only. No parked or special gl items. 

How can we proceed further?