DaysInInventory

Wish the API had something it doesn't? Post here!
Forum rules
  • Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
  • No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
  • Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
  • Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
  • Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
  • Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
  • Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
  • Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
Post Reply
Grace
Posts: 12
Joined: Wed Mar 09, 2022 9:56 am

DaysInInventory

Post by Grace » Wed Nov 23, 2022 5:44 pm

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
Top
robbertcha
Posts: 416
Joined: Thu Apr 15, 2021 10:07 pm

Re: DaysInInventory

Post by robbertcha » Wed Nov 23, 2022 10:27 pm

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
Robbert
API Developer | simPRO Software Group
Top
Grace
Posts: 12
Joined: Wed Mar 09, 2022 9:56 am

Re: DaysInInventory

Post by Grace » Tue Dec 13, 2022 12:11 pm

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
Top
robbertcha
Posts: 416
Joined: Thu Apr 15, 2021 10:07 pm

Re: DaysInInventory

Post by robbertcha » Tue Dec 13, 2022 11:03 pm

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
Robbert
API Developer | simPRO Software Group
Top
Post Reply

Return to “Feature Requests”