Sage 100

 View Only

  • 1.  Sales Order History - No Product Line????

    Posted 07-09-2019 15:48
    Maybe I'm missing something but why is the product line NOT included in SO_HistoryDetail????

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: Sales Order History - No Product Line????

    Posted 07-09-2019 15:51
      |   view attached
    What version?  I see it in v5.4.

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



  • 3.  RE: Sales Order History - No Product Line????

    Posted 07-09-2019 15:53
    Not Sales History but Sales ORDER History.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 4.  RE: Sales Order History - No Product Line????

    Posted 07-09-2019 15:53
    Edited by Doug Higgs 07-09-2019 15:56
    Never mind.  Wrong table.  You mean SO_SalesOrderHistoryDetail.  You are correct.  It is not in there.  Strange.  Join SO_SalesOrderHistoryDetail to CI_Item and CI_Item to IM_ProductLine?

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



  • 5.  RE: Sales Order History - No Product Line????

    Posted 07-09-2019 15:56
    Yes, I know but they have misc. items as well so it would have to be LOJ.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 6.  RE: Sales Order History - No Product Line????

    Posted 07-09-2019 15:58
    Oops, my bad. CI_Item has all items (except special items).

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


Related Content