Sage 100

 View Only

  • 1.  2017 advanced. In SO Entry there is a binoculars

    Posted 08-09-2018 08:18
      |   view attached
    2017 advanced. In SO Entry there is a binoculars icon that can be clicked to display ""Item / Customer last Purchase History"". What table or tables are used to accumulate this data?


  • 2.  RE: 2017 advanced. In SO Entry there is a binoculars

    Posted 08-09-2018 08:31
    the SO_LastPurchaseHistory is what I think your looking for


  • 3.  RE: 2017 advanced. In SO Entry there is a binoculars

    Posted 08-09-2018 08:33
    just to elaborate, it keeps two records for each item/customer one for invoice DcoumentType=""I"", and one for the sales order DocumentType=""O


  • 4.  RE: 2017 advanced. In SO Entry there is a binoculars

    Posted 08-09-2018 08:38
    Thanks @DavidOverholt ! That's the data I was looking for for 30 minutes!


Related Content