Open Forum

Expand all | Collapse all

Serial Number History Report

  • 1.  Serial Number History Report

    Posted 14 days ago
    Hello -

    Does anyone have a script/report that would produce what serial numbers for a specific item were on hand for a specific location and date (including Sales and adjusted that day)?  I've seen some blogs and articles, but nothing resembling a historical stock status report with serial and lot number details.

    Thanks in advance!
    Bob




    ------------------------------
    Bob O'Malley
    Lead, Business Analyst
    Stanley Healthcare
    Waltham MA
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Serial Number History Report

    GPUG ALL STAR
    Posted 10 days ago
    @Bob O'Malley,

    Sounds like you're outlining a Historical Inventory Serial Number Trial Balance! I'm sorry that I don't have a solution for you... I'm just admiring the possibility!

    It seems ​to me that, since receipts and shipments of serial-numbered products would include the serial numbers, one could construct such a report... but it would be tricky. I cannot even build a prototype because we don't deal with serial-numbered products.

    Sincerely,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Serial Number History Report

    Posted 9 days ago
    @Steve Erbach ​- thank you for the response!  I was able to put together something that I think will do the trick.

    Best regards,

    ------------------------------
    Bob O'Malley
    Lead, Business Analyst
    Stanley Healthcare
    Waltham MA
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Serial Number History Report

    GPUG ALL STAR
    Posted 9 days ago
    @Bob O'Malley,

    Well, that sounds like the perfect thing to share with the Forum, eh? Do tell! How'd you do it?

    Sincerely,​

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role