web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item lot missing Expir...
Microsoft Dynamics GP (Archived)

Item lot missing Expiration date

(0) ShareShare
ReportReport
Posted on by Jason Chung 1,110

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.

*This post is locked for comments

I have the same question (0)
  • veeyeskay Profile Picture
    veeyeskay on at
    Re: Item lot missing Expiration date

    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.

  • Jason Chung Profile Picture
    Jason Chung 1,110 on at
    Re: Item lot missing Expiration date

    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

  • veeyeskay Profile Picture
    veeyeskay on at
    Re: Item lot missing Expiration date

    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.

  • Jason Chung Profile Picture
    Jason Chung 1,110 on at
    Re: Item lot missing Expiration date

    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

  • veeyeskay Profile Picture
    veeyeskay on at
    Re: Item lot missing Expiration date

    Jason

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

  • Community Member Profile Picture
    Community Member on at
    RE: Item lot missing Expiration date

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans