Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

expiration date item - like food

Posted on by Microsoft Employee

I am trying to find a way to record item exiration dates for items in RMS inventory which we purchase from suppliers. We would like to report on items coming close to exiration so we can reduce the price and eventually remove from the shelves.

*This post is locked for comments

  • Suggested answer
    eliud mugo Profile Picture
    eliud mugo 1,440 on at
    RE: expiration date item - like food

    Retail realm has this module to control lot items why don't you give it a try.

    www.rrdisti.com/.../rr-rms-utilities-headquarters-hq

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: expiration date item - like food

    If you have received two PO's for the same item, how do you distinguish them on the shelf to know which is the older of the two.  Do you have a date on the packaging?  

    I understand the need for the report and I like the idea,  How would you know which is the older product without checking the physical inventory?

    And yes, Sometimes the addons from Retail Realms are free, but not all the time.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: expiration date item - like food

    There is an inexpensive (and free in some cases) Lot Expiry module from Retail Realm.

  • Sad Profile Picture
    Sad 650 on at
    RE: expiration date item - like food

    Hi,

    using sub description 3 will not help, that expiration date is related to PO`s receiving date.

    because :

    if we received tow POs for item "XXX" with tow deferente expiration dates, how can we recognize them  on sales in POS.

    thanks

  • Bennykendy Profile Picture
    Bennykendy 840 on at
    RE: expiration date item - like food

    Please I need help.

    There is anyone who can write a report that will show the following fields:

    ItemlookUp Code   Opening Quantity     Transfer In     Transfer Out     Closing Stock

    I want the report to generate information concerning the above mentioned fields.

    Any help, please?

    Thank you

  • Bennykendy Profile Picture
    Bennykendy 840 on at
    RE: expiration date item - like food

    How do you run the report  of expiry date if you decide to take a sub field description 3 as text field for date?

  • Bennykendy Profile Picture
    Bennykendy 840 on at
    RE: expiration date item - like food

    I think I appreciate the idea. But how do you run the report?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: expiration date item - like food

    There is a full Lot Expiry mod for RMS.

    MikeH@retailtechnologyexperts.com

  • TODD TARTALIA Profile Picture
    TODD TARTALIA 740 on at
    Re: expiration date item - like food

    Would be an extremely helpful feature, perhaps configurable during receive process.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: expiration date item - like food

    Thanks, this is what the MSFT support said. I have him looking into other options within RMS

    - using the lookup code to include expiry date, this will help reduce the right inventory count for multiple dated items

    - other fields that might be date formatted to contain the information

    I will enter an enhancement request, as i believe others would find a proper solution helpful.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans