Items with no purchase history

 7 Replies
 3 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
    What tables would I use to get a list of all the items we have with no purchase history?
    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
      I have a Crystal report that shows all active stock and nonstock and pulls in last date for receipt activity. Any items that have no receipts show the po number and receipt date as blank. Since I can't upload files to the forum, send me your email in a private message and I'll send it to you.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Bev Edwards
      Veteran Member
      Posts: 366
      Veteran Member

        Private Message will not open for me. Getting an error (not displayed.)

        Here is my email: bedwards@gbmc.org

         

        Thank you very much!!

        Bev

        Bev Edwards
        Veteran Member
        Posts: 366
        Veteran Member

          Object doesn't support this property or method is the error when trying to use Private Message.

           

          John Henley
          Posts: 3353
            Send message via Private Message should now be working.
            Thanks for using the LawsonGuru.com forums!
            John
            Bev Edwards
            Veteran Member
            Posts: 366
            Veteran Member
              Thank you John!!
              Stephanie
              Veteran Member
              Posts: 86
              Veteran Member

                Hi Jon,

                 

                Would you be willing to share this with me as well?

                Stephanie.kowal@bhs.org

                Thanks!

                Stephanie Kowal

                Baystate Health

                Stephanie Kowal | skowal@rpic.com
                Patti D
                Basic Member
                Posts: 10
                Basic Member

                  Hi Jon,

                   

                  Would you be willing to share this with me as well?

                  demaske@utwn.org

                   

                  Patti Demaske

                  Uniontown Hospital

                  thanks