Sage 100

 View Only

  • 1.  Is there any want to import into a table without a business object? ("SO_SalesOrderPrint") V/I nor BOI allows this natively.

    Posted 07-05-2022 18:10
    I am needing to add "Print Picking Sheet" type records to "SO_SalesOrderPrint".

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


  • 2.  RE: Is there any want to import into a table without a business object? ("SO_SalesOrderPrint") V/I nor BOI allows this natively.

    Posted 07-05-2022 18:15
    If I'm not mistaken, setting the print picking sheet field to "Y" via the SO_SalesOrder_Bus will create that record.  Same thing for when you need to print a sales order.  I haven't checked yet for that particular table but if there isn't a _bus object then the only way to create that record without the _bus object would be to use ProvideX

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: Is there any want to import into a table without a business object? ("SO_SalesOrderPrint") V/I nor BOI allows this natively.

    Posted 07-05-2022 18:22
    Edited by Dan Burleson 07-05-2022 18:45
    Thanks @David Speck II I had already tried setting the PPS field to "Y" and that doesn't do it, it only sets that field to "Y". Nothing else.

     I posted here about how I am also trying to use the SO_PickingSheetPrinting_UI object's method "SelectOrder", but I'm not understanding how to code the parameters.

    My ProvideX skills are nil and I will likely have to create my own picking sheet form if I can't get this to work.
    ​


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

    Original Message


  • 4.  RE: Is there any want to import into a table without a business object? ("SO_SalesOrderPrint") V/I nor BOI allows this natively.

    Posted 07-06-2022 00:23
    Edited by Dan Burleson 07-06-2022 00:24
    @David Speck II you are NOT mistaken. I am. Thank you AGAIN. I was testing the presence of the "SO_SalesOrderPrint" records based on whether the picking sheets were printing, but they weren't printing because of a bug in the form and not because the records weren't being added. The picking sheets weren't printing because of a failed criteria, but of course the system thought they had printed and removed the "SO_SalesOrderPrint" records. Thus the egg on my face...

    ​


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

    Original Message


Related Content