Limit the number of lines in billing document

[former_member575219]

Hi Experts,

The billing document has 359 line items and while going for accounting each line is added with three accounting lines and causing problem of more than 999 lines.

The billing is created based on combination of delivery documents. The deliveries are created based on Scheduling Agreement.

There is a logic built already to restrict the number of lines.

where else I can check like any code is written to restrict the number of lines in billing document??

1. Have checked Country specific features but there is no limit maintained.

2. Checked copy controls, there also no logic written to restrict the number of lines.

Thanks

Geetha

[VeselinaPeykova]

Even for a billing document with a single item you can encounter the limit of 999 FI items (I know because I have done it in the past just to prove it). In a normal business scenario this is extremely unlikely, of course.

It does not matter that the problem occurred just for one of your company code, you still need to address the issue.

I am unable to understand what you mean by: "As per client the logic kind is already available for other company codes except one and not sure where exactly that logic is built.". Which logic? Do you mean that for other organizations you have introduced billing split based on the maximum number of billing items? If yes - then check the copy control settings, especially the VOFM routines - this is the most likely place to introduce the logic. If you meant that you do not encounter the problem of 999 FI items - as I mentioned, this depends on a combination of factors: the number of billing items, the applied conditions.

If you are looking for an easy way to find where a certain custom logic is written - you can try transaction PRCAT or program SNIF. As an alternative, you can ask one of your local developers for assistance; there are some very useful guides in the wiki for billing document creation and for release of billing document o accounting and my personal favorite-General Information About SD-FI Interface. Another viable option is to look for some functional design documentation, development specifications and solution proposal documents for your project.

Please do not use answer instead of comment for providing additional information! When you do this, the participants do not receive notifications for the update, which decreases your chances of getting help. And it increases the workload of our moderators who have to correct each post manually.

[thanga_prakash]

Veselina Peykova PRCAT transaction is new to me, Thanks for sharing, learnt something new for the day.

[former_member276251]

Maybe it is useful to read the following SAP notes:

- Accounting Interface: Summarization of FI documents

- 545137 - FAQ Interface - summarization

[VeselinaPeykova]

I suppose that you meant the restriction of 999 line items in the FI document. If I misunderstood you - please clarify.

The restriction of 999 line items is not a result of customizing, you won't find any node in SPRO to increase this limit.

The limitation is due to the definition of the field for FI document item in the data dictionary. BSEG-BUZEI is defined as numeric with length 3. This means that you cannot have more than 999 items in the FI document.

I would recommend reducing the number of line items in the billing document via a VOFM routine that reads the value specified in Country-specific functions for Maintain Maximum Number of Billing Items (the node where you already checked) and triggers invoice split.

It is difficult to suggest the most suitable value for maximum number of billing items as it depends on how you company operates, how your pricing looks like, etc. Use BW or whatever reporting tool you have available to figure out what should be the maximum value for billing items in your processes.

[former_member575219]

Hi,

Thank you very much for the reply.

The problem I am facing here is that, the billing document has only 359 line items.

While posting to accounting each line item is adding with credit, debit and Tax details.

As 359 lines with each 3 additional lines, causing the more than 999 lines.

This issue is happening only for one company code.

As per client the logic kind is already available for other company codes except one and not sure where exactly that logic is built.

[Lakshmipathi]

When you post a query and give further updates, please add the content under "Comments" and not under "Answer" as you were not answering to a query but only providing additional informations as asked by the members. Also, when you add the text under Comments, it will be intimated to the person to whom you are responding whereas, if you add the text under Answer, the member will not be intimated. By the way, your above answer has been converted as comment by me.

[former_member220028]

Hi,

i didnt get ur question completly.

ist not like there is a wanted limitation. the problme is the pos-numer in the billing document is only of length 3 and has a rollover at 999 starting again at Pos 1 for the 1000th entry. so this leads to an error.

u now most likely have to add a "split-logic" forcing the FI-System to write the positions into different FI-document.

i dont remember where to add the split Logik (its some Kind of CU/Userexit), but im sure u will find out.

Regards Stefan Seeburger