0

Listing all sales lines with Sales order No. header

Jet Reports Historic Posts

June 06, 2013 16:07

None

Follow

I've been experimenting with Table Builder and cannot seem to figure out how list out all of the sales lines on a sales order.

The attached report appears to retrieve one sales line and the total for that sales line as well as the order total.

I've added filters to only show qty to ship >0 and to not include No. with our freight accounts.

Any help would be appreciated…I'm just not certain how to get the rows of sales lines to appear for each sales order.

Thanks! Jen

• open sales orders 6-5-13.xlsx

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts June 12, 2013 06:22 Official comment

  I believe the correct way to do that would be
  
  <>65701&<>65801&<>31820&<>31825
  
  Best regards
  Søren

• 0
  
  Jet Reports Historic Posts June 07, 2013 07:59

  Have u tried making the table from Sales lines, and linking those to the sales header?
  then u would get all the lines from a order, and then have them linking to the same header.
  
  Hope that helps.
  
  -Søren

• 0
  
  Jet Reports Historic Posts June 11, 2013 20:58

  Thank you! That was helpful…. Only one issue left….
  I have a filter set for the No. on the sales line not to include 65701|65801|31820|31825, but lines 160 and 212 display No. 31820 and line 227 displays 31825.
  
  Any ideas why these lines would still appear in the report even though I've filtered them out?
  
  See attached….Thanks!!

  • latest open sales order attempt 6-11-13.xlsx
• 0
  
  Jet Reports Historic Posts June 12, 2013 13:22

  Thank you so much! That did the trick!