DEVELOPER CENTER
Hi there,
I've made tool that pulls order info using the API. One part of It I'm trying to tighten up is PO Spend. The tool currently matches the spend breakdown in a job in SimPRO just fine, but something I'm struggling to match through the API is where PO's are assigned across multiple jobs.
In a Purchase order breakdown under order details, you can see all the jobs that a purchase order is assigned to, but I can't find an endpoint that shows this.
E.g. PO 302785 is assigned to job 21214, and 21215
GET /api/v1.0/companies/0/vendorOrders/302785 - response only shows a single job in the header:
"AssignedTo": {
"Job": 21214
}
GET /api/v1.0/companies/0/vendorOrders/302785/catalogs/ - correctly returns the item rows and prices, but it does not include any job or cost centre assignment information to match up to.
GET /api/v1.0/companies/0/jobs/21214/sections/9207/costCenters/10904/catalogs/ - returns the catalog items used by the job, but there is no reference back to the Vendor Order (VendorOrderID).
Is there an API endpoint or field that exposes the link between Vendor Order items and the job/cost centre they are allocated to?
Any guidance / help is greatly appreciated.
Ben
API - Vendor Order allocations across multiple Jobs
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.
-
BP-APSUKLTD
- Posts: 2
- Joined: Tue Nov 18, 2025 2:51 pm
-
SimproAPITeam
- Posts: 831
- Joined: Wed May 01, 2024 2:31 am
Re: API - Vendor Order allocations across multiple Jobs
Hi Ben,
For vendor orders they can only be assigned to one job/cost centers when created. But it does not show where the stock is allocated later.
I think you are very close to getting the information you are after, in the vendor orders catalog endpoint you tried you can get individual id's and it should give you the allocations for that catalog.
https://developer.simprogroup.com/apido ... f7f145202b
Another option that might be better is our stock allocations endpoint where you can query results based on the specific vendor order receipt ID.
https://developer.simprogroup.com/apido ... f2cfef72e9
I hope this helps.
Regards
For vendor orders they can only be assigned to one job/cost centers when created. But it does not show where the stock is allocated later.
I think you are very close to getting the information you are after, in the vendor orders catalog endpoint you tried you can get individual id's and it should give you the allocations for that catalog.
https://developer.simprogroup.com/apido ... f7f145202b
Another option that might be better is our stock allocations endpoint where you can query results based on the specific vendor order receipt ID.
Code: Select all
/stockAllocations/?Source.ID={ID}&Source.Type=ReceiptI hope this helps.
Regards
Simpro API Team | Simpro Software Group