Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Community Member Profile Picture
    Community Member Microsoft Employee 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

  • 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.

  • 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

    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

    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

    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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans