Sage 100

 View Only
  • 1.  Sage v2017 ADV - Client needed to change ship to c

    Posted 03-14-2018 15:10
      |   view attached
    Sage v2017 ADV - Client needed to change ship to codes from two character to four character to comply with customer's internal codes. So I changed open SO's, AR Invoice History Header and SO history ship to codes. Now there is an issue with ship to history accessed via item maintenance history tab and drilling down to the customer ship level from there. See attached. While I have waded into it deeply, I suspect that this table is summarized by item, customer, ship to, year and month. If so, I am envisioning a complete rebuild of the tables. Can someone confirm this? What table(s) are in play here? TIA.


  • 2.  RE: Sage v2017 ADV - Client needed to change ship to c

    Posted 03-15-2018 05:26
      |   view attached
    IM_ItemCustomerHistoryByPeriod


  • 3.  RE: Sage v2017 ADV - Client needed to change ship to c

    Posted 03-15-2018 05:35
    @BethBowers - Is your new headshot from your recent stage performance??


  • 4.  RE: Sage v2017 ADV - Client needed to change ship to c

    Posted 03-15-2018 05:37
    Sorry, I was so awe struck by the new you that I forgot to say ""Thank you""!


  • 5.  RE: Sage v2017 ADV - Client needed to change ship to c

    Posted 03-15-2018 05:41
    You dared me to use it - did you really think I was too wimpy to take that dare?


  • 6.  RE: Sage v2017 ADV - Client needed to change ship to c

    Posted 03-15-2018 05:44
    That dang bootleg video. Next year, we are going to hire a professional. Just like a dance recital. And anyone who took center that night is certainly NOT a wimp!


  • 7.  RE: Sage v2017 ADV - Client needed to change ship to c

    Posted 03-19-2018 15:32
    LOL