Prev
Next
Forums Financial Management Lawson S3 Financials

PO31.1 Vendor Return

 2 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
mikekask
Basic Member
Posts: 10
Basic Member
5/12/2011 4:54 PM
    I'm trying to do an SQL extract of data related to the PO31 form and PO231 report. In particular, the Reason code. I'm not just talking about a list of Reason codes, but the data associated with this form; like Company, Return number, Vendor, Reason Code. I'm looking to isolate the records with a Reason code of "WCR". I need the table locations of this data. Any help would be greatly appreciated. Thank you.
    Ruma Malhotra
    Veteran Member
    Posts: 412
    Veteran Member
    5/12/2011 6:15 PM
      The reason codes come from a table called MAREASONCD. The rest of the fields comes from PORETURNHD PORETURNLN.
      mikekask
      Basic Member
      Posts: 10
      Basic Member
      5/12/2011 7:10 PM
        Thanks! This is just what I was looking for.