Open Forum

Expand all | Collapse all

Lot Tracking Report

  • 1.  Lot Tracking Report

    Posted 19 days ago
    Our business is looking for a report that will make it easier for tracking product when their is a recall. Is their a can report in GP that would provide this functionality?

    The output data would need to be something like the below,

     

    PRODUCT                                           

    LOT #     QTY LOT # PRODUCED    QTY LOT # ON HAND      

    This would give the amount of each lot # produced and the amount of each lot # still in warehouse.                                       

                                                   

    LOT #     INVOICE #           QTY OF LOT # ON INVOICE           CONSIGNEE (SHIP TO)

    This would give us the customers that received the affected products by lot #.



    Thanks!

    George

    ------------------------------
    George Sheppard
    IT Manager
    Newfoundland and Labrador Liquor Corporation
    St. John's
    ------------------------------


  • 2.  RE: Lot Tracking Report

    GPUG ALL STAR
    Posted 18 days ago
    Hi @George Sheppard,
    I don't believe any such report exists in GP.. but you may want to start with @Victoria Yudin 's blog post about Item list with Serial Numbers.
    https://victoriayudin.com/2012/06/04/dynamics-gp-sop-line-items-with-serial-numbers-and-comments/
    ​​

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



  • 3.  RE: Lot Tracking Report

    TOP CONTRIBUTOR
    Posted 17 days ago
    @George Sheppard check out the template downloads through eOne. There are a couple lot related SLB and ERB templates available through their site (for free). Even if they aren't exactly what you're looking for, they may give you a good head start in the right direction to customizing from there. ​

    ------------------------------
    Aleiha Hanson
    Royal Basket Trucks, Inc - IT Manager
    GPUG Milwaukee WI Chapter Leader
    ahanson@royal-basket.com
    ------------------------------



  • 4.  RE: Lot Tracking Report

    Posted 16 days ago
    Hi George,

    In terms of the first request and the amount of each lot # still in the warehouse.  That would just be the Inventory Stock Status report.  There is an option to print serial/lot information on that report.  We have also modified that report to include lot attributes for other customers in the past, otherwise you will see total quantity on hand and then the individual lot numbers and lot quantities that make up that item's total quantity on hand.

    For the amount of each lot# produced/sold and the the customers that received the affected products by lot #, that is ​​just the standard GP Serial/Lot Trace Inquiry from the inventory inquiry menu.  Take a look at that report as there are a variety of report variations from that serial/lot trace inquiry.

    If that is not enough, then you can also look into Horizons International's Quality Essentials Suite that has expanded features for Lot Management and Lot Attributes.


    ------------------------------
    Steve Plitzner
    HOOPS Inc.
    Eau Claire WI
    ------------------------------



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