Share
ReportIs there a way or a query to run to find the historical on hand on a specific date. For Example How can I know the on hand qty on an older date.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is there a way or a query to run to find the historical on hand on a specific date. For Example How can I know the on hand qty on an older date.
*This post is locked for comments
RMS, like most accounting & inventory control programs, does not save minute by minute inventory counts.
The way it is done is to see what you have now, add what you bought and subtract what you sold going back to that date. OnHand - TotalSold + TotalBought.
Hope that helps. I've done this in Access & asp.net.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (