Income Report by material

[Former Member]

Hi experts,

I wonder if anyone can tell me how or where I can generate accounts receivable reports which show income by material?

Your help will be very much appreciated. Thanks in advance

Ciara

[Former Member · Accepted solution]

Use transaction KE5Z. When you execute this report, you can pull in the values for Customer and Material.

[Former Member · Accepted solution]

Thanks Peter, fits my needs exactly!!

[Former Member]

Ciara,

The tables that hold the AR Open and Closed Item details are BSAK and BSIK. If you go to fbl5n and then select the data for your query and then look at the display and change the display, you could be able to do that. If you don't see that field at all, i guess then you might have to go for a custom report where in you have to use this table as well as some Material Table and use document number as key ( not sure what the key would be though).

Hope it helps - Let me know if it doesn't or if you need anything.

Thanks,

N

[Former Member]

Hi Nandita,

thanks for your helpful response. I had already tried FBL5N and customising the display. unfortunatlely Material is not available as a column. the next response I got from Peter Okay actually solved teh problem. I used KE5Z and customised the layout to include Material.

Thanks for taking the time to help me, I did try to award you points but because I'd already awarded Peter the thread did not allow this.

Kind regards

Ciara