Item lot missing Expiration date

This question is not answered

Hi all,

I'm using Dynamics GP 10 sp5 and use lots for inventory. When an item/lot has been received and is then consumed, why is it that if I receive or positively adjust qty on that same item/lot the information is lost on Expiration date, manufactured date?

This is causing problems because of expired items potentially going to production.

Example:
A) An item is not found in warehouse and the clerk request that this item/lot qty be removed from inventory.

B) A month later, they find the item/lot qty somewhere in the warehouse and request to bring it back to inventory.

C) The first transaction is a negative adjustment of the qty to remove. This will remove the item from GP. Then the second transaction is a positive adjustement of the same item/lot qty.

D) The expected behaviour would be the have that item/lot receive the properties it once had when it was in the system, but this is not the case.

All Replies
  • Hello Jason

    Instead of doing two transactions (one to take stock out of one warehouse and another to bring in stock into another warehouse), try doing an Inventory Transfer, which will ensure that the expiry date of the lot in one warehouse is maintained when moving it into another warehouse.

    Let us know if you need further assistance.

    Let us know if you need further assistance.

    Thanks & Regards

    Siva - Dynamics GP MVP (2010 - 2012)

  • Hi Sivakumar,

    Thanks for taking the time to reply to my post. I would like to specify that we are not trying to transfer from one warehouse to another. Actually, what happens is that the clerk sometimes cannot find an item/lot in the warehouse and requests that we remove it from our inventory, since according to him, the item is no longer in our possession. Then, after a certain time, the clerk finds the item/lot randomly between two boxes in the warehouse and requests that the item/lot be added back into inventory.

    Of course, this is simply an example of a situation that requires us to do so in the system. I have another example that has the same end result. We use multi-bin and stock count to verify inventory. When we start Stock count, it takes an image of our inventory an example in Bin A35 there is an item ABC of qty 100. When the clerk verifies Bin A35, there is nothing in that Bin and then he gets to Bin A37 and there is our ABC qty 100 item. The stock count will generate two adjustments, one -100 ABC in Bin A35 and another +100 ABC in Bin A37. This will have the same end result where i loose Expiration Date and Manufacture Date on my item/lot.

    Thanks for your help.

    Jason Chung

  • Hi Jason

    Thanks for explaining the scenario.

    As in your case, you will not be able to store the Lot Number Attributes since they are 2 distinct transactions (one outward and one inward, which are not related in the system).

    However, you can try to customize this functionality based on your requirements.

    Let us know if you need further assistance.

    Let us know if you need further assistance.

    Thanks & Regards

    Siva - Dynamics GP MVP (2010 - 2012)

  • So i understand that the Expiration Date and Manufacture Date cannot be retained as pertinent information related to the item/lot combination as it is already the case with LotAttribute1-2-3-4-5.

    What i will probably try doing is to transfer the exp date from IV00300 to IV00301 within lot attribute 4 or 5 since these are datetime fields and GP does not get rid of them even if Qty levels are at 0.

    Thanks for your help.

    Jason

  • Jason

    Thanks for the update. Let us know if you need further assistance.

    Let us know if you need further assistance.

    Thanks & Regards

    Siva - Dynamics GP MVP (2010 - 2012)

  • Hi Siva,

    Lot expiration and manufacturing dates are greyed out when entering a Purchase Receiving transaction but are available for Inventory transactions, any idea how this can be fixed?

    RL