Resetting Adjustment On Cost Center When Modifying SellPrice Of One Off

[Mike_Roberts]

Hey team simPRO, I'm hoping you can help! Thanks in advance.

Issue

We need to reset the calculated total of a job cost centers containing one offs. Specifically we need to remove the 'Adjusted' value. This doesn't appear to be working as expected.


According to the API this is possible:

Code: Select all

const resetCostCenterResponse = await patchRequest({
      Total: {
        // Set the value to null to reset/remove adjusted price.
        ExTax: null,
      }
    }, costCenterUrl);

Expected result: Adjusted amount is no longer present.

Actual result: Adjusted amount remains.

Our tooling currently does the following:

- PATCH Unlocks the cost center

Code: Select all

{ ItemsLocked: false }

(Response: 204)
- PATCH Updates OneOff SellPrices to correct values (Response: 204)
- PATCH Reset total of the CostCenter (as above) (Response: 204)

I've tried different variations:

- ExTax: null
- IncTax: null
- Both set to null (errors - you can only set one to null)

The result is always the same - the adjusted value is retained and the total is incorrect as a result.

How can we removed this adjusted value and get the correct total?

Observation

- When I click unlock on the Job cost center in the UI of simPRO the adjustment is removed and the total is correct.

Background

We're cleaning up an issue where on a sample of jobs sell price of one offs was incorrectly calculated. These jobs happen to have been programatically converted from quotes. We previously had no trouble fixing the values on the quotes and are now fixing the jobs.

Our expectation was that if we modified the sell price of a cost center one off, as we had done on the source quote, that the total of the quote and the job would match. What has happened is that an 'adjustment' has been added to the cost center which sees the total of the job and the total of the quote now incorrect.

[Sindre]

Hi Mike,
Thank you for reporting this.

Can you send me a private message with your build details and some examples jobs with the expected values and the result you are getting today and we can do some more investigation to see what is happening.

Regards

[Mike_Roberts]

Hey Sindre, I've sent you a DM. Cheers for the follow up!

[Mike_Roberts]

Hey Sindre,

Any news or updates? Cheers.