In which table are quantities located?
I'm building a spreadsheet which shows our retail items and their locations. Using st_biz_managed_resource and st_ivt_storage_location, I've got what I need for locations. I can't find what table the rental and retail quantities are found in. Which one might that be?
Thanks,
Norm
-
Hi Norm!
It's been a while since I've personally dug through that part of the database, but IIRC quantities aren't just listed in a table somewhere. Or there may be some quantities listed, but it's not the whole picture? I think it may require joining a few different tables together to achieve the outcome you're looking for.
If you would like some assistance with Flex custom reports, contact the Square Wave team at hello@squarewave.com.au - our report developers are experts at projects like this.
Cheers,
Bigs
Square Wave
Endorsed Flex consultant
www.squarewave.com.au -
Hi Norm,
Bigs is correct. The non-serialized items are tracked in `st_ivt_qty_matrix`, to which you'll need to join `st_ivt_inventory_item` and `st_biz_resource_type`. If you need serial quantities, those are just `st_ivt_serial_number`, but you'll probably need some information out of `st_biz_managed_resource` and `st_ivt_inventory_item` in order for that to be useful.
As he stated, Bigs can help with custom reports. Our support team doesn't generally provide assistance with these kinds of queries, but having a leg-up from this post, if you need to clarify anything, reach out and ask for our Level 3 techs; they have quite a bit of database knowledge, as well as a direct line to me, if needed.
Please sign in to leave a comment.
Comments
2 comments