cancel
Showing results for 
Search instead for 
Did you mean: 

accounting statement for a particular invoice range of dealer

Former Member
0 Kudos

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.

Siddharth

Accepted Solutions (0)

Answers (2)

Answers (2)

Lakshmipathi
Active Contributor
0 Kudos

Dear Siddharth

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

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi Laxmi

The T-code FBL5N dose not provide the information for a particular item.

I want the accounting statement of a customer for a particular material code.

Jelena
Active Contributor
0 Kudos

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.

Jelena
Active Contributor
0 Kudos

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...

Former Member
0 Kudos

We have created seperate Sales order type,bill type,and invoice number range which is to be used only for that materuial.

Is therre is any way to get seperate accounting stataemnet for the customer by taking his credit/debit and advance ammount into consideration,by using the above parameters.

Thanks

Former Member
0 Kudos

Hi,

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

For customer statements check F.27 .

Regards,

Chandra