Skip to Content
avatar image
Former Member

accounting statement for a particular invoice range of dealer

Hello friends

I would like to discuss one requirement ,in which I am facing problem

ISSUE: My client has decided to sale new material, with separate bill numbers.

we have completed the sales process,and we are getting the different bill number for the new material

Now he wanted to get the accounting statement confined to that particular new material for particular time period.

I am not able to work out ,how one can get the accounting statement for that particular material ,for a particular time period. It should also consider the advance payment, credit/ debit amount.

I will be thankful to him if some one can help me out.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 20, 2009 at 09:20 PM

    There seems to be a bit of a mix-up here. There are sales documents, billing documents and accounting documents. Sales and billing documents are part of SD module, accounting documents are a part of the FI module. Material number is usually not relevant for FI and, therefore, it's not part of the accounting document. Customer (account) number, however, "crosses the line", so to say, between SD and FI.

    If the client wanted a consolidated accounting statement, then some other criteria than the material number should have been used (a specific document type or number range, etc.). There is no standard functionality to provide an accounting statement for certain material only. If the customer buys only one material, then just disregard the material requirement and run the statement by customer number(s).

    Otherwise you may try writing a custom ABAP report (to look at both SD and FI data), but, as you've correctly pointed out, the accounting statement should also include payments, etc., and I don't even know how those could be possible separated by material correctly.

    Looks to me that the requirement and design review is in order here...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      Try this report S_ALR_87012160. We have material line items and customer line items also.

      For customer statements check F.27 .



  • Jan 21, 2009 at 05:17 AM

    Dear Siddharth

    Have you checked in FBL5N where you can see the entire history of a particular customer ??


    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

    • Look at one of the accounting documents that was created for the invoice - does it have the material number anywhere? If not, then you won't get such customer statement anywhere in standard SAP. You'll need an ABAP report for that.