Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Add-ins issue when filtering purchase order date

 1 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
SCMaster-jk2
Veteran Member
Posts: 100
Veteran Member
7/18/2016 5:50 PM

    Hey everyone, I'm trying to put together a custom PO History report but I'm having an issue with the PO Date field. 

    I'm getting most of the data from the POLINE table. Current fields are

    PO-Number

    LINE-NBR

    POVAGRMTLN.BASE-COST

    POVAGRMNTLN.UOM

    PURCHORDER.PO-DATE

     

    When I use criteria selection on PO-DATE >= 06/01/2016, nothing comes up. When I use an "=" sign, I get records. 

    When I limit the amount of records to 10 and use the >= sign, I get some records with a PO-Date of 1/15/2015 which makes no sense. 

    Any ideas?

    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    7/18/2016 5:56 PM
      PO Date is formatted weirdly - I've never been able to get it to behave in AddIns - so 'me-too' ing this question.