Skip to Content
avatar image
Former Member

Max no. of line items reached in FI

Hi Everyone,

My client does billing through a batch job and the program used SDBILL which is assigned to TCode VF04 in Table TSTC.

There are invoices where the line items is fixed at 999.Could somone please tell me how to automatically split invoices whenever the line item exceeds the permissible no. of line items which 999.

Regatrds

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 29, 2011 at 11:58 AM

    An invoice can have only upto 500 line item maximum since for each line item, there will be two line items in accounting document. Hence, you need to split the invoice per 500 for which, you can go with relevant billing exit or add this logic to your existing routine assigned in VTFL for the field "Data VBRK/VBRP".

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2011 at 12:12 PM

    Hi

    Try with summarization. See SAP Note 36353 - AC interface: Summarizing FI documents.

    I hope this helps you

    Regards

    Eduardo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2011 at 04:16 PM

    Hi,

    under Billing ->Billign Document -> Country specific features-->Maintian maximun no of Billing Items

    Apart from this you have to change copy control Routine in copy control at item level has to changed to 006. Data VBRK/VBRP

    Rgds,

    Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2011 at 11:25 AM

    Hello,

    The lines in accounting documents will depend up on the different items for posting, like revenue, tax, provisions ....etc .

    Check for your accounting document and findout how many line items appear in the accounting document for each line item in the invoice. Then you can set a invoice split routine in the copying control (Data VBRK/VBRP), else as Lakshmipathi suggested you can use the userexits to split the billing document if the line item crosses XXX.

    SAP suggests using the split invoice method, or the note 36353. But this notes will summarise the accouting document line items with the field specified in OBYC (table TTYPV). This can have an adverse effect, if the FI dept use line item wise clearing OR the data transfers to external systems (BW/reporting systems).

    Regards,

    SAM

    Add comment
    10|10000 characters needed characters exceeded