Adding Marketing Document field to Pool Report

Rick

Hello all,

I am trying to add a column in our "Pool Report" that would display the PO number (ORDR.NumAtCard) of the associated Sales Order.  Can someone please show or point me in the right direction to accomplish this?

Thank you very much in advance!

Comments

4 comments

Date Votes
  • Comment author
    Martin Heigl

    Do you work with or without reservation system?

    0
  • Comment author
    Rick

    We are not working with reservation system Martin.

    0
  • Comment author
    Martin Heigl

    Insert template

     

    (select "NumAtCard" from "ORDR" where "DocEntry"="BEAS_FTPOS"."DocEntry")

    0
  • Comment author
    Rick

    Martin,

    Thank you very much!  That worked perfectly! 

    Have a great day!

    0

Please sign in to leave a comment.