Cost center totals per invoice/jobs

[gavynj]

We use the deprecated endpoint

Code: Select all

/api/v1.0/companies/{companyID}/jobs/{jobID}/invoices/{invoiceID}

in order to export each cost center's current amount per job per invoice.

A couple of questions:

1) Some calls to that endpoint return an error: "Job cost center labor item was not found in this cost center.". Do you have any insight into what causes this, or if there's anything a user in Simpro should be doing (or not doing) to avoid this?

2) The reason we use this endpoint is to get a cost center breakdown for each invoice. For each one, we can access 'Claimed.Current.Amount', returning the amount assigned to this invoice/job. This is particularly useful for progress claims, where the total amount may be spread across multiple invoices, but we're only interested in one particular invoice. Without using this deprecated endpoint, it's not obvious how I can fetch the same data. For example, if I use the main invoices endpoint (/api/v1.0/companies/{companyID}/invoices/{invoiceID}), it lists all the jobs with their total values (not the values listed on this particular invoice or progress claim), and it lists all the cost centers, but there's no way to know which ones apply to this invoice (only links to the job ID, which may be associated with multiple invoices in the case of a progress claim).

Does that make sense? I can PM you specific examples if you would like.

Thanks,
Gavyn

[robbertcha]

Hi,

1) Do you mind to send us your build details and the invoice ID via private message? we can check it for you;

2) Please create a post on "Feature Requests" section regarding to this request, so our engineers will follow up.

thank you.

[aijuy]

Hi,

1) Do you mind to send us your build details and the invoice ID via private message? we can check it for you;

2) Please create a post on "Feature Requests" section regarding to this request, so our engineers will follow up.

thank you.

Hi, we are having the same question about the claimed cost center for individual progress claim invoice dataset.

We are aiming to identify which cost center is paid via the specific individual progress claim, but the API returned data are always listing all the cost centers.

Does Simpro have any solution/API update for this one?

Thanks for your checking in advance!

[SimproAPITeam]

Hi aijuy,

You do get the claim amount/percent on the response from the invoice endpoint : https://developer.simprogroup.com/apido ... 55f63584ea

You can check the isPaid column if the invoice is fully paid.

Hope that helps

[aijuy]

Hi aijuy,

You do get the claim amount/percent on the response from the invoice endpoint : https://developer.simprogroup.com/apido ... 55f63584ea

You can check the isPaid column if the invoice is fully paid.

Hope that helps

Hi, thanks for providing the link!
I checked again and cannot see the invoice endpoint is returning data that identify which cost centers are included in this specific payment.
Same as Gavyn mentioned, if use the main invoices endpoint (/api/v1.0/companies/{companyID}/invoices/{invoiceID}), it lists all the jobs cost centers with their total values (not the values listed on this particular invoice or progress claim), and it lists all the cost centers, but there's no way to know which ones apply to this invoice..

If there's a way we can contact you to check this one further if still not clear?
Thanks!

[SimproAPITeam]

Hi,
Unfortunately I don't think it's broken down fined than this in the API. Payments will be related to a an invoice which is again related to a job and related cost centers.

Regards