simPRO API Forum

Hi,

The following resource "/api/v1.0/companies/{companyID}/storageDevices/{storageDeviceID}/stock/{catalogID}" has a field "DaysInInventory".
Can I ask what data is used to calculate this value, please? Is it calculated from the last date a stock item has been added to the storage device or a last date it has been assigned from the storage device to a job?

Could you also advice which resources I could use to find out when the stock was added to the storage device and date stock has been assigned from a storage device to a job, please?

Thanks in advance for your help

Grace

Hi,

'DaysInInventory' shows the total of days the item has been in the storage device.

'DateModified' in the job item endpoint shows the date which the stock has been assigned from a storage device to a job.

Reference Links
https://helpguide.simprogroup.com/Conte ... in%20stock
https://developer.simprogroup.com/apido ... 104383c8f5

Thanks Robbertcha for the reply and the links,

Can I further unpick the information in the below response, please?
"'DaysInInventory' shows the total of days the item has been in the storage device."
Is that counted from the first date an item has been added to the storage device or the last received date?
For example if some quantities on an item are being added to the storage at the beginning of each month and only partially assigned to jobs or never assigned to jobs, will DaysInInventory restart counting after each new receipt date or count from the first receipt date?

Is there an endpoint which I can use to pull all dates when a stock item has been assigned to a storage device?

Thank you i advance for your time looking into this

Hi,

'DaysInInventory' is counted from the first date an item has been added to a storage device, but there is no an endpoint to check the log of the item at the moment, I will move this topic to our feature request section. Please follow our release notes for updates on new functionality that is being implemented.

API Release Update
viewforum.php?f=3