Stock Item history

Posts about the simPRO API. Help/support/how-to etc.
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

Stock Item history

Post by Grace » Fri Aug 09, 2024 4:29 pm

Hi,
I am looking for an endpoint that would allow us to get a history of Stock Item, like assignments to jobs from a storage device with the date and a link to purchase order and a receipt. Basically something that can programmatically deliver data from History tab available to GUI user via staff/stockItem.php?stockItemID={ID}
We need to build a report where we link every stock item used for a job to their receipts within specified time period as it's contractually required by our client.
Is there anything like that available already?
What I tried so far:
I can get information about stock Items assigned to a job/{job_id}/sections/{section_id}/costCenters/{cost_Centre_ID}/stock/, but no the date it was assigned or a reference to the original purchase order.
I can also get receipts details from vendorOrders/{vendor_order_id}/receipts/ containing the storage device and sometimes jobs, but `AssignedTo` field in the response seems to be only populated when the purchase order was made for the job, and it's not populated when a stock item is moved from storage to a job.

Any pointers would be greatly appreciated

Thanks in advance

Grace
SimproAPITeam
Posts: 831
Joined: Wed May 01, 2024 2:31 am

Re: Stock Item history

Post by SimproAPITeam » Mon Aug 12, 2024 12:25 am

Hi Grace,

Unfortunately the history of a stock item is unavailable via the API endpoints. Our team will consider your request and evaluate if to implement it in the future.

Regards
Simpro API Team | Simpro Software Group
Grace
Posts: 12
Joined: Wed Mar 09, 2022 9:56 am

Re: Stock Item history

Post by Grace » Tue Aug 13, 2024 8:52 am

Hi @SimproAPITeam.

Thank you for a quick reply.

I would greatly appreciate if this feature was implemented as even your BI reports do not allow me to join stock items assigned to jobs with their purchase orders, receipts and invoices.
With hundreds or thousands items in a large project clicking on every individual stock item history is extremely time consuming and error prone for a GUI user.

Kind regards,

Grace
SimproAPITeam
Posts: 831
Joined: Wed May 01, 2024 2:31 am

Re: Stock Item history

Post by SimproAPITeam » Tue Aug 13, 2024 11:30 pm

Hi Grace,

Thanks for posting the request and an internal ticket has been raised to evaluate.

Regards
Simpro API Team | Simpro Software Group
Post Reply