Not Taken
Export combined stock quantities
Mark Aldous
said
about 6 years ago
Due to the nature of this kind of data the potential load can be extremely heavy when implemented as an automated report.
For example if you have 100,000 items and 10 locations the this results in checking 1,000,000 records to retrieve the combined levels for the items.
If you then put this on an automated export running every 10 minutes I am sure you can image the potential unwanted load this can have and therefore the impact on your database.
These is the basis for the logic in not adding this to the automated exports
However it is possible to retrieve this data on an Adhoc basis via the following method
- Dashboards > Query Data
- Select Stock Levels - Combined as the query type
- Click Generate Report
- Click Download CSV to save a local copy of this data
Documentation
Mark Aldous
Head of Implementation
Linn Systems Ltd
Tom Gibson
said
about 5 years ago
I have been trying to achieve this as well for an integration with FLUBit.
It seems to me that as there is already a location called "Combined stock" that this data already exists in this location. So if it was possible for this location to be exported this would achieve the result.
Is this not the case?
How is data in the Combined stock location handled if a user goes to this location and browses the inventory. Surely the data base cannot be adding the stock up all the time at each view?
Steve B
It seems to me that as there is already a location called "Combined stock" that this data already exists in this location. So if it was possible for this location to be exported this would achieve the result.
Is this not the case?
How is data in the Combined stock location handled if a user goes to this location and browses the inventory. Surely the data base cannot be adding the stock up all the time at each view?
Steve B
Tom Gibson
said
about 5 years ago
I have been trying to achieve this as well for an integration with FLUBit.
It seems to me that as there is already a location called "Combined stock" that this data already exists in this location. So if it was possible for this location to be exported this would achieve the result.
Is this not the case?
How is data in the Combined stock location handled if a user goes to this location and browses the inventory. Surely the data base cannot be adding the stock up all the time at each view?
Steve B
It seems to me that as there is already a location called "Combined stock" that this data already exists in this location. So if it was possible for this location to be exported this would achieve the result.
Is this not the case?
How is data in the Combined stock location handled if a user goes to this location and browses the inventory. Surely the data base cannot be adding the stock up all the time at each view?
Steve B
Gareth Claydon
2 people like this idea