Skip to main content
Solved

Sales Order PO on Ship List (15.2)

  • July 4, 2022
  • 2 replies
  • 49 views

bskallerud
Hero (Customer)
Forum|alt.badge.img+12

Question from my crew: is it possible to get the Sales Order PO on a Ship list? I cannot see the sales order added to the data query used for the report, but I may have overlooked something

Best answer by Phil Seifert

Hi Bjørn,

I looked at the Ship Report Header query and do not see a reference so you would not be able to add this to the report unless you customize the report with a new DAL to add an outer join to the sales order and then pick up the Sales Order PO number.

 

2 replies

Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • 1388 replies
  • Answer
  • July 4, 2022

Hi Bjørn,

I looked at the Ship Report Header query and do not see a reference so you would not be able to add this to the report unless you customize the report with a new DAL to add an outer join to the sales order and then pick up the Sales Order PO number.

 


bskallerud
Hero (Customer)
Forum|alt.badge.img+12
  • Author
  • Hero (Customer)
  • 214 replies
  • July 4, 2022

Since Ship Lists are used for different type of orders, I find it best to create a reference field as part of address, and add any PO or other info the customer needs there. Or I thhink it can get messy real quick