Method Community

 

Report Filtering - Sales Order Line Items

Last post 11-29-2012 12:52 PM by Method_Adam. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-29-2012 11:30 AM

    Report Filtering - Sales Order Line Items

    I need to generate a Sales Order report given a particular SO RecordID but I need to only display certain selected Sales Order Line Items. How do I specify both the SO RecordID for the report as well as filtering for certain Line Item IDs?

    Thanks

    Blake C
  • 11-29-2012 12:44 PM In reply to

    Re: Report Filtering - Sales Order Line Items

    Answer

    I wound up just hacking a report solution by putting a PrintMe flag on SalesOrderLineItems and setting this flag to True based on what was selected in the grid on the screen. After generating the report, I update the flag back to False again.

    I got this idea from another post on the forum (can't find the link at the moment).

    I don't like mixing reporting concerns with data like this on the same record, but this particular feature isn't large enough to warrant an entirely different reporting table structure at this time. 

    Blake C
  • 11-29-2012 12:52 PM In reply to

    Re: Report Filtering - Sales Order Line Items

    I'd have to really dive into this to see if there's another way.  I'm glad you found a solution that worked for you.  :)

    - Adam

    Adam Lyons
    Manager of Support
    Method Integration
    a.lyons@method.me
Page 1 of 1 (3 items)