Open Forum

Expand all | Collapse all

Serial Number Master

  • 1.  Serial Number Master

    Posted 14 days ago
    Does anyone know why serial numbers would show up in the transaction tables, but not in the Serial Number Master Table?
    Dynamics GP2018.
    Some transactions may have been posted to items that did not have the "Maintain History" checkboxes populated.
    Would this have an effect on the Serial Number Master Table?

    ------------------------------
    Glenda Homan

    ------------------------------
    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 2.  RE: Serial Number Master

    TOP CONTRIBUTOR
    Posted 5 days ago
    What type of transactions are you referring to (IV, SOP, etc.)? When a serialized item is brought into GP the s/n is recorded in the IV00200 (serial master) table, once that item is no longer in inventory (adjusted out, sold, etc.) then it would no longer be in the IV00200. Hence you'd be able to see the serial in the related transaction that took it out of inventory but not the serial master table.

    ------------------------------
    Matthew Arp
    Business Systems Developer
    Hunton Group
    Houston TX
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 3.  RE: Serial Number Master

    Posted 5 days ago
    @Matthew Arp  Thank-you so much for clearing that up.
    I haven't been able to find anything that would tell me what SHOULD be in the master table.
    I wrongly ASSUMED (!) that the MASTER meant that EVERY serial number that's ever been through the system would be held in that table.

    I learn something new about GP every day!

    Thanks again,
    Glenda​
    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


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