https://netsuiteprofessionals.com logo
Join Slack
Powered by
Does any one know if it is possible to pull a save...
# suiteanalytics
g
Does any one know if it is possible to pull a saved search or report of serialized inventory numbers on hand with an as of date? for example i want to know what serialized inventory I had on hand o as of January 15 th,2022. I can run it for the item quantity overall with no issue but i need to know what specific serial numbers we had on hand for that date.
k
You asked this on reddit didn't you?
The short version is this is a shit show to pull off.
The slightly less short version is you need a transaction search that shows you all of the numbers as they are added and removed, and a date filter of history of the account until the desired date.
If you have any real volume in your account - it won't work.
unless you filter it down to specific items to get below the maximum results.
Either way - I'd tell them to pound sand on the request.
g
Hi Kevin, i haven't asked on reddit yet. i was trying to use Tim's SuiteQL to grab the info but it was taking to much time, So i was ewondring if someone had run into this scenario before
We do have.a large volume of transactions and serial numbers so that may be why my query was taking forever. Thanks for your insight
k
Yeah, it's a common request that the normal answer is "how much is it really worth to you"
r
do you have ODBC?
if so you can run tim's query on your own data store and it wont time out
also you can index the hell out of the replicated store and it will run lightning fast
also can do dirty reads in your own data store as you can control refresh times
there are native script solutions as well. just takes some scripting. you just need a true date value such as beginning of time or todays inv count. you can create a map reduce and parse into custom record each days changes in the pst as well as scheduled script each day to true up yesterdays transactions. then the sql script will be fast
j
In Satori Reporting we can snapshot inventory on a daily basis so that you can have that history build and retained over time. This is a good prospective solution that we've helped other NS customers with.
g
Thanks for the ideas @redfishdev i will try
Open in Slack
PreviousNext
Powered by