165
I'm am trying to find a report for inventory valuation that can be quantified by date. Every report I've found for item valuation and count is as of the date the report is run. There doesn't seem to be a date filter. Help, please!
*This post is locked for comments
Umar, I need that report. if there is option of specify the date.
Thanks for the help. I have forwarded your response on to our programmers (smarter than I am) and am sure they can work this out for our customer.
Claire, the data is in the Microsoft RMS system and is easy to get at because of the SQL database. There is an Item Movement History table (that is not the real schema name) that stores the ins and outs. As you are aware, the current On Hand Qty is stored as well. With a little bit of programming experience, a modification of an existing report can be made to account for the ins and outs, starting with current balance, back to whatever date you run it for using the Item History data. End result: you choose a date, run report, you will see the balances, values etc at that time. You can contact us at: http://www.syssolutionsllc.com/
I make some custom reports for inventory valuation. If you need that reports you directly contact with me on my personal email address. (umar@kidskingdomco.com). Through this after reconcile you will achieve the right figure according to any date.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (