Line items are not summarized due to taxes

[Former Member]

Hi Friends,

According to note no:36353,I maintained settings in OBCY and sales revenues,deductions are summarized if my billing document(VF01) having above 999lineitems.But if my customer is liable for taxes, then revenues,deductions are not summarizing in accouting document if line items are more than 999 and I am unable to release it to accounting(VF02).

Can some one please advice me.

regards,

Seetaram

[Former Member]

Hi Seetaram,

Not sure whether you are still looking for answers to this thread, we were able to resolve the issue by implementing below notes. Now the items that has tax codes were also summarized.

1009374 - NewGL: Prevent split of taxes if calculated line-by-line

1051914 - No document summarization due to field TAXPS

1070206 - BSEG summarization missing because of TAXPS

Good luck!

[Former Member]

We have the same issue, but worse. I tried adding all possible fields into TTYPS and TTYPV table, as long as there is tax code, same items (the items used to determin the tax bases) will be split and show on the FI document one line per SD billing item.  If i create a billing document without tax code, then the summarization works perfectly. This has nothing to do with GL account settings. I don't think there is a way around... because i can't imagine that we don't need tax code at billing...We will need to figure out how we can resolve this for our business as well.

[Former Member]

At issue is on hold.

regards,

Seetaram

[ravichandran_iyer]

Check the tax lines in BSEG table. There might be some fields for these lines, which have unique values. You'll need to enter that field in the TTYPV table to delete them from being transferred to FI. Once this is done, summarization happens.

But take caution in doing this. SAP advice to delete only those fields given in the note 36353.

Ravi.

[Former Member]

Hi Ravi,

Thanks for your reply, let me work on your advice.

regards,

Seetaram

[Former Member]

Hi Friend,

I tried with profit center,tax code field, but unable to summarize the line items in accounting document.Any other hint?

regards,

seetaram

[Former Member]

Hi Friends,

Other than note no:36353 (already implemented)and any other notes are available to summarize sales revenues&deductions&tax lines if more than 999 items in accounting document? or any other solution?

Someone can please advice me?

regards

Seetaram

[ravichandran_iyer]

As far as I know, that is the note that speaks about summarization. Did you also add '*' in OBCY after adding all those fields mentioned in note 36353?

Ravi.

[Former Member]

Hi Ravi,

When I am adding * in table column as well as field column, otherwise in table column BSEG and in field column *, but system is throwing error message.

regards,

Seetaram

[Former Member]

Hi Friend,

I need to maintain ' * ' entry in TTYPS table, let me maintian that and check and I want to see whether summarization is taking place or not.

regards,

seetaram

[Former Member]

Hi Friends,

I maintained * in OBCY for object VBRK, still line items above 999 are not summarized if tax line items are there in billing document. Someone can please advice me.

regards,

Seetaram

[Former Member]

Hi,

I dont know about the SAP NOTE but when ever you are going to maintain the seperate tax codes for seprate taxes it will show you in the seperate GL irrespective of your GL Account

if you want the taxes to be summarized you will have to maintain the same tax code for all the taxes which is not practical or not advicable

Best Regards,

Ravi Reddy

[Former Member]

HI,

In my billing document (customer is liable for taxes)I have two tax condition types, one is JR1 & UTXJ, but both conditon type values are ZERO.So zero value is not posted to any G/L account.But my issue is when these two conditon types are appearing in billing document, I am unable to release billing document (VF02)to Accounting if more than 999 line items are there.

If above two conditon types are not there ( it customer is not liable for taxes)in billing document, I am able to release billing document to accounting if line items are more than 999.

someone please advice me.

regards,

Seetaram