Sage 100

 View Only

  • 1.  Group by vendor on P/O ROG/ROI Registers, but realized data is incompletely writing to wrk file

    Posted 03-15-2019 17:17

    So a v2015 client asks if I can change the existing standard P/O ROG Register and ROI Register reports to sort/group by Vendor.  Sure, no problem, should be pretty straight-forward.  Turns out I wasn't getting the expected data, e.g. some records weren't picking up the vendor/name and other data.  I was at my wit's end after not being able to determine why the heck that was happening.  I eventually realized (via DFDM) it had to do with how P/O ROG/ROI writes to the ROG/ROI wrk file.  For some reason, not all records are populated the same way, e.g. it seems like just the first received item on a given Receipt populates the wrk file correctly/completely.  The rest are missing vendor #, etc.  And it's the same in v2018. 
    Res: So I then created a BO UDF in the wrk file for vendor # and that took care of it (although I probably could have also just linked in the PO receipt header file).  Man, that was driving me absolutely nuts.



    ------------------------------
    - Brett
    ------------------------------


  • 2.  RE: Group by vendor on P/O ROG/ROI Registers, but realized data is incompletely writing to wrk file

    Posted 03-15-2019 19:42
    Thanks for the workaround and more important, testing it!  Odd how some tables write after all these years.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 3.  RE: Group by vendor on P/O ROG/ROI Registers, but realized data is incompletely writing to wrk file

    Posted 03-15-2019 20:15
    Poor programming design.  It's a work file.  There's no good reason not to populate the fields on every record.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 4.  RE: Group by vendor on P/O ROG/ROI Registers, but realized data is incompletely writing to wrk file

    Posted 03-16-2019 13:14
    Good luck in ever getting that changed.  I am forever amazed at how bad design is impossible to fix.  WAD - Gotta love it!

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 5.  RE: Group by vendor on P/O ROG/ROI Registers, but realized data is incompletely writing to wrk file

    Posted 03-16-2019 15:02
    LOL... We'd be fortunate for someone to be courteous enough to return an email. A programming change would be a miracle.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


Related Content