Setting material cost and markup through the API

[alexydm]

Hi,

Is there a way to set the material cost so the materials markup can be calculated. When we set the SellPrice and BasePrice for the job cost centre catalog item via the API (as shown below), the Materials Cost field on the simPRO UI shows 0.

Code: Select all

job_cost_center_catalog_item = Simpro.create_job_cost_center_catalog_item(company['ID'], job_id, section['ID'], job_cost_center['ID'],{
        Catalog: simpro_catalog['ID'],        
        SellPrice: price.round(2),
        Total: {Qty: item.quantity}        
        Total: {Qty: item.quantity},
        BasePrice: simpro_nett_price || 0   
      })

[Muqeet]

Wasn't able to reproduce the issue.

I set the Base and Sell price of cost center catalog item through rest api, the UI then showed BasePrice in Price column and SellPrice in Sell Price column and markup automatically calculated and displayed accordingly.

Code: Select all

https://{build-url}/api/v1.0/companies/{companyID}/jobs/{jobID}/sections/{sectionID}/costCenters/{costCenterID}/catalogs/

Code: Select all

{
	"Catalog": {CatalogID},
	"BasePrice": 9,
	"SellPrice": 10,
	"Total": {
		"Qty": 1
	}
}

[alexydm]

It doesn't seem to appear on the summary for the Job Cost Centre or in the Job Summary itself. I'm not sure where those UI fields that you mentioned are.

[Muqeet]

I was referring to the Parts and Labour tab on a cost center page. Didn't realise you were talking about summary table actual and estimate fields.

In UI, a catalog can be added to cost center which does not have to be in stock. When a catalog is added, only estimate in summary table will be updated and actual will be 0. This is supported in rest api through cost center catalog endpoint.

The other way in UI is to use an item for a cost center from inventory. When a stock item is added, actual amount will be updated as well. Adding items from inventory is not yet supported in rest api.

[alexydm]

Hi Muqeet,

Thanks for the clarification. So are you saying that the summary tables on the Job and Job Cost Centre will not show the actual Materials Cost, not even as an estimate? At the moment, even the estimate is not showing the right number. Does it change even someone manually assigns inventory to the job once it has been created via the API first? That is the plan at the moment...

[alexydm]

Correction: the estimate is appearing to be correct in my test