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
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
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....
Thanks for you inputs Toni. I have felt the same about this report.
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.)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156