Sage 100

 View Only

  • 1.  Does anyone have an idea how to import or BOI write to BM_ComponentReportSelection?

    Posted 10-12-2023 15:44

    I have a client that want to pre-load the BM_ComponentReportSelection, but this table has neither a VI entry nor a Business Object that I could program load. Are there any other options?



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    ------------------------------


  • 2.  RE: Does anyone have an idea how to import or BOI write to BM_ComponentReportSelection?

    Posted 10-12-2023 15:53

    Curious about this, as well.  Pre 4.40 you used to be able to import into the file.  You could export SO info, summarize, and import in, creating a little MRP.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 3.  RE: Does anyone have an idea how to import or BOI write to BM_ComponentReportSelection?

    Posted 10-13-2023 10:08

    Had this issue several years ago. DSD was going to write a business object for the table at a very reasonable price (at the time). 

    After it was marked up by the reseller I was working with, the customer rejected the cost. 

    We ended up using MacroExpress to read a text file of demands created by a script to populate the grid. 

    Worked fine in testing, but not very stable in the user environment (users have various adaptive solutions for visual impairment.) 



    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------

    Original Message


  • 4.  RE: Does anyone have an idea how to import or BOI write to BM_ComponentReportSelection?

    Posted 10-13-2023 12:46

    Thanks @Eric Lunceford, I'm thinking that a UI script on post load of the panel could prompt the user for whether to read a CSV file and populate the grid. I've had good luck with Shell SendKeys in a panel and surprised it didn't lose focus. That also may be more than the client wants to spend. Maybe @Beth Bowers client will want to contribute!



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    ------------------------------

    Original Message


Related Content