Search found 12 matches

by Grace
Tue Aug 13, 2024 8:52 am
Forum: General Discussion
Topic: Stock Item history
Replies: 3
Views: 4892

Re: Stock Item history

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 e...
by Grace
Fri Aug 09, 2024 4:29 pm
Forum: General Discussion
Topic: Stock Item history
Replies: 3
Views: 4892

Stock Item history

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/st...
by Grace
Wed Aug 07, 2024 3:23 pm
Forum: Feature Requests
Topic: Date Stock Assigned to Job
Replies: 8
Views: 71172

Re: Date Stock Assigned to Job

Hi Simpro Team,

Is there any update on this feature request?
It's something my company also would find extremely useful.

Kind regards,

Grace
by Grace
Mon Jul 08, 2024 10:04 am
Forum: General Discussion
Topic: Multi-company issue with GETing CostCenters in contractorInvoices endpoint
Replies: 3
Views: 3321

Re: Multi-company issue with GETing CostCenters in contractorInvoices endpoint

Hi, Thanks for getting back to me. I checked with our colleagues who process the invoices and they said that they don't actually manually change the default cost center on Simpro UI for contractor invoices. I agree that that this is not a bug in Simpro, it was actually a bug in our requests after we...
by Grace
Wed Jul 03, 2024 9:46 am
Forum: General Discussion
Topic: Multi-company issue with GETing CostCenters in contractorInvoices endpoint
Replies: 3
Views: 3321

Multi-company issue with GETing CostCenters in contractorInvoices endpoint

Hi, We moved to a multi-company setup and noticed that GET from the API endopoint `api/v1.0/companies/{company_id}/contractorInvoices/{invoice_id}` stopped returning "CostCenters" as it used to in a single company setup. Below is snippet of what we currently receive: ``` "CostCenters&...
by Grace
Fri Mar 24, 2023 9:18 am
Forum: General Discussion
Topic: ETL tool
Replies: 2
Views: 8398

Re: ETL tool

Hi, As it's unusual on this forum to wait for a reply for longer than a day or two, I guess this query is a hot potato? If this is not in your team's remit, can you maybe point us in the direction of who we should ask about your "hight volume data extraction" that is mentioned in the API d...
by Grace
Wed Mar 22, 2023 9:58 am
Forum: General Discussion
Topic: ETL tool
Replies: 2
Views: 8398

ETL tool

Hi, We need to fetch all records for certain resources but running such queries takes very long and despite retries strategy implemented we often get disconnect errors from the server. This bulk data is needed for bespoke reports that are not easily available through UI (users would need to click hu...
by Grace
Tue Dec 13, 2022 12:11 pm
Forum: Feature Requests
Topic: DaysInInventory
Replies: 3
Views: 11509

Re: DaysInInventory

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 la...
by Grace
Wed Nov 23, 2022 5:44 pm
Forum: Feature Requests
Topic: DaysInInventory
Replies: 3
Views: 11509

DaysInInventory

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 stora...
by Grace
Thu Mar 17, 2022 11:03 am
Forum: General Discussion
Topic: Contactor Jobs Completed flag
Replies: 5
Views: 4194

Re: Contactor Jobs Completed flag

Hi @robbertcha, I don't think you have any more information for me, do you? My guess is that the simpro tables available for BI report SQL queries are not 1-2-1 copies of the underlying database, but perhaps views of the database, where not all columns are included, is my guess correct? I see that A...