Report - Sales Orders for an Item

poppinspoppins Member Posts: 647
edited 2015-04-26 in NAV Three Tier
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 :mrgreen:

Comments

  • SavatageSavatage Member Posts: 7,142
    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?
  • poppinspoppins Member Posts: 647
    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...
  • sunnyksunnyk Member Posts: 276
    Use salesline and group by item no.
Sign In or Register to comment.