Sage 100

 View Only

  • 1.  MasterOrderLineKey

    Posted 03-18-2020 11:30
    I am trying to link Sales Order History to Master Orders in SO, and have run across something very strange.  In SO_SalesOrderHistoryDetail, the MasterOrderLineKey field for some orders seems to be an ever increasing number, not one that links to the LineKey in SO_SalesOrderDetail LineKey for the Master Order.  
    Is there some other place this links to?  Any ideas what might have cuased this?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 2.  RE: MasterOrderLineKey

    Posted 03-18-2020 11:40
    Also, the MasterOrderLineKey is blank on numerous SO_SalesOrderHistoryDetail records which came from Master Orders

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 3.  RE: MasterOrderLineKey

    Posted 03-18-2020 11:48
    Is all this "fresh", or could some orders have been migrated, or master-order changed?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 4.  RE: MasterOrderLineKey

    Posted 03-18-2020 11:59
    My newly created orders have order-history-master-linekey correct.

    --

    Friendly Systems, Inc.

    Sage 100 (Mas90/200), Sage 300 (Accpac), SageCRM, xTupleERP
    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog



    ------Original Message------

    Is all this "fresh", or could some orders have been migrated, or master-order changed?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------


Related Content