Skip to main content
Solved

Sales Order PO on Ship List (15.2)

  • Jul 4, 2022 12:33 PM UTC
  • 2 replies
  • 65 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.

 

View original

    2 replies

    Phil Seifert
    Ultimate Hero (Employee)
    Forum|alt.badge.img+24
    • Phil Seifert
    • Ultimate Hero (Employee)
    • Answer
    • Jul 4, 2022 1:03 PM UTC

    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.

     

    Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.
      bskallerud
      Hero (Customer)
      Forum|alt.badge.img+12
      • bskallerud
      • Author
      • Hero (Customer)
      • Jul 4, 2022 2:26 PM UTC

      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

        Terms & ConditionsAccessibility statement