Open Forum

Expand all | Collapse all

lot numbers not being added during inventory reconcile

  • 1.  lot numbers not being added during inventory reconcile

    TOP CONTRIBUTOR
    Posted Jun 25, 2021 04:01 PM
    Everyone,
    My client has an inventory item for which they cannot select lot numbers in SOP.
    I look in the historical POP lot number table for that inventory item, and the lot numbers are there for the items on hand. (POP30330).
    But I look for them in the GP Item Inquiry windows, and there are not lot numbers.  (IV00300).

    What is odd is I ran Inventory Reconcile and these lot numbers were not added.
    So I figure, go to Inventory transactions, increase the QTY on hand with lot numbers, and decrease it without lot numbers, but GP does not let you enter the decrease.

    So I suppose I just need to write a SQL query adding the POP30330 data to IV00300 if it is missing there.\

    Does anyone have any other ideas or explanations for this?

    Thanks,
    Bruce​

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Paradise GP Consulting, Inc.
    Sunrise FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: lot numbers not being added during inventory reconcile

    TOP CONTRIBUTOR
    Posted Jun 28, 2021 02:56 PM
    More clues, this is an inventory transfer function, I see the lot data in the proper files, IV00300, POP30330 (original trx), IV30400, etc
    Dr Google tells me that people have had this problem in the past, how to fix it is unclear,
    other than the standard recommendation to run inventory reconcile and check links.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Paradise GP Consulting, Inc.
    Sunrise FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


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