how to post all condition values to a single gl ac as a single line item

[Former Member]

Dear Experts,

I have 4 conditions zpr1, zpr2, zpr3, zpr4 with  the same acount key erl going to the same gl ac. This is posting as four different line items,  But my client wants the total of all condition values to post as a single item in to Gl ac. Please do suggest.

Regards

yezdevan

[eduardo_hinojosa · Accepted solution]

Hi

In my opinion it sounds to a question related with FI summarizing. Please, see SAP Note 36353 - AC interface: Summarizing FI documents and revert if it's useful.

Check also SAP Note 310837 - Simulation for document summarization in FI for an analysis step.

I hope this helps you

Regards

Eduardo

[neeraj_lal]

yezdevan vasudevan

I will add only below point  in solution given by other experts.

Before making any such changes in Account Key, please check with your BI team that how they are fetching data from sales document pricing details for reporting purposes.

This is very important as in some case they need more detail  and any changes in condtion type  should also be addressed from BI point of view.

Regards

[former_member182378]

Neeraj,

Thank you for your post!

In my opinion, the teams to consult (or the drivers) would be the client, the SAP FI team.

The BI team would "follow" (or do the necessary changes for the new setup).

Would you agree?

[neeraj_lal]

You are right TW. When we are implementing new solution FI and SD team has to take lead and BI team needs to create accordingly logic to fetch data  .

But when we are making such changes in existing system, then we should also think from reporting part and consider BI perspective.

Otherwise Report which are as importatnt as Finance data will have wrong information. In this case we are removing account key from  exsiting condtion types which may have  impact on existing report.

Regards

[former_member182378]

Neeraj,

Thank you for your post!

For discussion sake, if for report(s), the values of condition types ZPR1 to ZPR4 are picked from billing document, line item level (table KONV); then even if the above change is done (condition types made statistical), there would be no change in the report (output).

But if the values are picked from the accounting document (of these condition types), then certain changes in the picking / extract logic has to be incorporated.

[neeraj_lal]

Yes... Perfectly

Regards

[jpfriends079]

One of the way can be, where you can place a new condition type under these 4 condition type with desired account key, to pas summation of all to account via that condition type.

Say,

Steps	Condition Type	From	To	Condition Value	Account Key
10	zpr1			100
20	zpr2			200
30	zpr3			250
40	zpr4			350
50	ZPRT	10	49	100%	ERL

Thanks, JP

[former_member182378]

JP,

If ZPR1 to ZPR4 are not marked as statistical (in the pricing procedure), then if the value of each of these condition types do not find G/L accounts there would be Accounting Errors and creation of Accounting document would not be possible!

If you make ZPR1 to ZPR4 as statistical, and ZPRT non-statistical then it might satisfy the requirement.

But I do not know if business would like to mark ZPR1 to ZPR4 as statistical.

[Former Member]

Hi

Your suggestion will give me ac determination error as no ac keys are assigned to the above conditions.

yezdevan

[jpfriends079]

yezdevan

As rightly pointed out by TW and thing I missed out in my post was "statistical" indicator. Assign statistical indicator and try.

Step	Cond Type	From	To	Condition Value	Statistical	Reqt	Account Key
10	zpr1			100	x
20	zpr2			200	x
30	zpr3			250	x
40	zpr4			350	x
50	ZPRT	10	49	100%		2 - Item with pricing	ERL

I hope that helped you.

Thanks, JP