Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Report to get the Historical Balances for item/Lot

Posted on by 295

Hi,

I need a report for the inventory balance as of  any past period(31st Dec 2009) with all the items  lot number and expiry dates.


Thanks in Advance,


Nagesh

*This post is locked for comments

  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Re: Re: Report to get the Historical Balances for item/Lot

    if it's something you need on an ongoing basis, you could put a trigger on the inventory history table and update your own more detailed table whenever that table is updated....

  • Nagesh Boppana Profile Picture
    Nagesh Boppana 295 on at
    Re: Re: Report to get the Historical Balances for item/Lot

     Thanks for you inputs Toni. I have felt the same about this report.

     

     

  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Report to get the Historical Balances for item/Lot

    This information is not stored in detail in SL, so a custom report would have to be written, and would be VERY difficult and take a long time to run (it would have to rebuild the innventory from the start, I think, for each item.)

     

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans