Sage 100

 View Only

  • 1.  Master Purchase Orders and Sales Orders

    Posted 06-04-2021 11:35
    Client inquired on options for displaying master PO/SO information on tab one of the IM maintenance/inquiry tab.  This is for display purposes only, would not impact any calculations (e.g. available).

    Looked in the IM_ItemWarehouse table.  there are no fields for master quantities.  So I am assuming I am SOL for a quick fix.

    Any outside the box thoughts?

    In the meantime, I suggested they run the Open SO by item report for master orders

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: Master Purchase Orders and Sales Orders

    Posted 06-04-2021 12:19
    Script to query open Master SO/PO then dynamically update a button text description value (Post-Read)... which works for Inquiry screens (so better than updating a UDF, which would be blocked in inquiry).
    Link.
    I did it a couple days ago to show values in Customer Maintenance / Inquiry and the technique works nicely.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Master Purchase Orders and Sales Orders

    Posted 06-04-2021 16:02
    @Kevin Moyes - To clarify, client is looking for the open MO quantities​ to display along with the other Qty's in the IM warehouse display.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: Master Purchase Orders and Sales Orders

    Posted 06-04-2021 16:41
    Edited by Kevin Moyes 06-04-2021 16:41
    I don't know of any tricks to get values into that grid.  It has to be a UDF in IM_ItemWarehouse, which AFAIK can't be updated automatically by script.  Overnight VI imports would work though, if the numbers don't update frequently.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Master Purchase Orders and Sales Orders

    Posted 06-04-2021 16:39
    I have a customer that has a similar setup.  Since they don't have work order, we used the WO real estate in the inquiry window to display the "On MO" quantity for each item / warehouse.  This company imports everything from China to the Chicago warehouse.  They enter all Pos as master orders.  When they are notified that the goods shipped from China (go on the water) they create a standard PO and draw down on the master PO.  Using this process, they always have visibility into what POs haven;t shipped and what POs are on the water.  This method helps them more accurately predict when inventory will arrive at their dock.  Certipro did the mod for us.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    Assistant to the Traveling Secretary
    ------------------------------



  • 6.  RE: Master Purchase Orders and Sales Orders

    Posted 06-04-2021 21:27
    You could use a button script to launch an Excel workbook with a Pivot table against against the ODBC using the ItemCode as a parameter ('www.VBForums.com' has about 25 line of code to handle a generic parameter).

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    ------------------------------

    Original Message


  • 7.  RE: Master Purchase Orders and Sales Orders

    Posted 06-07-2021 04:46
    Edited by Dan Burleson 06-07-2021 10:52

    @Jeff Schwenk Would something like this work? (not much data in ABC company)

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 8.  RE: Master Purchase Orders and Sales Orders

    Posted 06-07-2021 10:58
    It has potential but like many client "quick" questions, I am trying to get to the root issue.  it is evolving to something completely different than the initial question.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content