Report - Sales Orders for an Item

poppins

Hi everyone,

I have to create a report that looks in Sales Lines, displays a list with different items and in front of each item, the list of Sales Orders including that item.
Example:
Item1 Order1, Order3, Order4
Item2 Order2
Any suggestions on how to do that?

Thanks in advance

Savatage

Two things you need to think about.
1) I would use item ledger entries table not sales lines.
2) what if there are hundreds of orders? How are you going to list all those order numbers in front of the item number?

poppins

Savatage wrote:

Two things you need to think about.
1) I would use item ledger entries table not sales lines.
2) what if there are hundreds of orders? How are you going to list all those order numbers in front of the item number?

Thanks for your answer.
1)The orders are not posted yet, so no items ledger entries, I have to use the sales lines.
2)I don't think there are hundreds of orders, we are talking about just one day and there are filters on the orders to consider...

sunnyk

Use salesline and group by item no.